How to prevent automatic conversion to USD during CSV import for Software Entitlement data

[MATHIVANANK]

Hi everyone,

I’m facing an issue while importing a CSV file into the Software Entitlement (alm_entitlement) table in ServiceNow.

When I import cost-related fields (for example, amounts in Yen (JPY) or Pounds (GBP)), the system automatically converts all the values into USD. I noticed that the reference currency field always defaults to USD, even though the currency column in my import file specifies JPY or GBP.

I want to keep the imported cost values in their original currencies (Yen or Pounds) and not have them converted into USD automatically.

Could someone please guide me on how to:

• Stop automatic conversion to USD, or

• Change the reference currency to match the imported currency (e.g., GBP, JPY)?

Thanks in advance!

 

This is Happening.

[Ricardo26]

Hi,

This is probably happening because your values are not in the servicenow expected format.

Create a transform map script to the total cost field and format the value of the csv to the following patter:
currency;value. Ex: EUR;1.234,56.
You can have more details here: Default currency values in import and export

If it's useful, please mark it as correct

[Ankur Bawiskar]

@MATHIVANANK 

the user who is importing must be having USD as currency in user's session

Did you check by changing your country to United Kingdom and then refresh the list?

The list should show values in GBP.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏