Importing different currency

[Nik Amy]

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

[tony_barratt · Accepted solution]

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

[Nik Amy]

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]

[pennieturner]

Hi

I have tried this, but it just doesnt work

Do you have any other ideas to get this working?

[Nik Amy]

Have you written that in Onbefore transformation script.

Can you paste the code here.