Currency is getting converted to USD even the original record has it in euros

MercBuilding
Giga Guru

Hello All,

   I have service catalog which is fetching values from custom table which has the currency in Euros but when we select it on the catalog it is is converting to $. On the form i have a field called 'Model' Once model is selected it is fetching the price from the custom table but it is converting it to $.

Variable on Form:

find_real_file.png

The same price in custom table:

find_real_file.png

 

Client script:

find_real_file.png

 

Script Include:

find_real_file.png

 

Can anyone help me in getting the value in Euros.

 

Thanks!

1 REPLY 1

Shane41
ServiceNow Employee
ServiceNow Employee

Hi there,

In your script include when iterating the getItemNumber records should it not be an if statement instead of a while loop, I assume you only want to return 1 value and not multiple objects

If you have multiple records in your custom table that reference the same model, the value on your catalog item will be set by the last record in the list (value gets overwritten each time by the while loop)

I recreated your scenario in my test instance and was able to get the correct currency value using getValue or getDisplayValue

Hope this helps,

Shane