Importing different currency

Nik Amy
Tera Contributor

Hey Guys,

On the contract form, I have a currency field.

I need to import the currency values which i get through excel sheet and they come in different currencies like 10 USD, 20 EUR, 20 GBP etc.

When i tried importing them, all the values are coming as USD values since my instance is set to that.


How do I import them using the actual given currency values?

TIA currency.JPG

1 ACCEPTED SOLUTION

tony_barratt
ServiceNow Employee
ServiceNow Employee

HI Nikh,


Can you import 2 columns, one with the numeric value and the other with the currency code?



Transform Mapping Currency Field



Best Regards



Tony


View solution in original post

5 REPLIES 5

tony_barratt
ServiceNow Employee
ServiceNow Employee

HI Nikh,


Can you import 2 columns, one with the numeric value and the other with the currency code?



Transform Mapping Currency Field



Best Regards



Tony


Thanks tony barratt it was of great help!!!



Also is servicenow currency toggle happening real time?


Because when I toggled for big numbers, the results varied.


Ex: in servicenow its showing as $ 1,000.00 = [SEK 8,285.85]


whereas as on today $ 1,000.00 = [SEK 8297.35]


Hi



I have tried this, but it just doesnt work



Do you have any other ideas to get this working?


Have you written that in Onbefore transformation script.


Can you paste the code here.