Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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 + "";