Currency field type shown correctly in a list view but shown as USD inside the record

[Alon Grod]

Hi,

I have a field of type Currency (Invoice Amount, Outstanding Amount).
When Im in a list view they show the currect currency(€40,445.48)
But when I enter inside the record the currency change to $46,415.2328 (convert to USD instead of staying as €40,445.48).
In my widget im using gr.getDisplayValue in order to show the value.
How can I prevent the convert when entering the record

 

[Tanushree Maiti]

Hi @Alon Grod 

Probable Cause:

1. List View: Shows the value in the Session Currency (based on your browser locale or sys_user record). If your user profile is set to a European country, you see €.
2. Form View: Displays the currency that was originally entered, or it defaults to the system's Reference Currency (often $ or USD) if the field is empty, read-only, or if the form is rendering the base system currency.

Probable Solution:

  1. Update User Profile ->Country as per your requirement 

   Note: You may need to log out and back in for this to take effect

2. In fx_currency table 

      Ensure the Euro (EUR) is Active.

1. Refer: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727944

2.  https://www.servicenow.com/community/ham-forum/currency-field-change-currency-type-display/m-p/32132...

3. https://www.servicenow.com/community/in-other-news/set-up-currency-properties-correctly/ba-p/2274498...

[Ankur Bawiskar]

@Alon Grod 

I think on list it shows the currency as per user's locale setting but on form it defaults to currency value in which they were entered

Default currency values in forms 

In Service Portal list, all the currency values are showing in $ even though they are suppose to sho... 

I think you might have to use a custom widget and convert the values using FX Currency conversion table

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

[Alon Grod]

@Ankur Bawiskar its the opposite, in the list view they can see all currencies but when they enter the record they will see the currency in each their country code belong to (on sys_user table you have the country code field, if its empty the default is USD).

so for example if your country code is FR(France) then on the list view u can see a value in USD but when you enter the record it will convert the value automatically to EUR.

The question is if there is any way to override this so you will always see the same value as you see in the list view without convert according to your country code

[Alon Grod]

@Tanushree Maiti