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

Hi



I managed to get it working as the source needed to have u before the field:



target.cost = "" + source.u_currency + ";" + source.u_cost + "";