- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2020 10:17 PM
How to make currency format to be European (420.000,00 instead of 420,000.00)
Solved! Go to Solution.
- Labels:
-
Financial Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2020 11:56 PM
Hi Surya
Can you confirm that no matter what browser your using the format is always the same ?
Because i have been delimiters change depending on Browsers (Chrome vs Firefox)
You can also open the Developer tool in your browser and (F12) and under "HTML" search for "g_user" or "separator" to check the separator in the current browser
There are plenty of similar questions on the community about the same
Quote:
1. Changing the system property locale to e.g. de.DE or nl.NL does not 😞 change my behavior for decimal fields to dot vs comma notation. It still presents 12,000 vs the expected 12.000
2. Add the fields Country Code and Language to a user record and e.g. supplying Dutch values (so Country Code = NL; Language = nl) DOES 😄 change my decimal notation to dot-notation
So try chaning the Country code and Language on the given user and check if the decimal and grouping separator changes accordingly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2020 10:40 PM
Hi Surya,
You can make
GlideCurrencyConverter API
These link will help you.
some addtional :
Mark helpful and correct if it helps.
Thanks,
CB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2020 11:56 PM
Hi Surya
Can you confirm that no matter what browser your using the format is always the same ?
Because i have been delimiters change depending on Browsers (Chrome vs Firefox)
You can also open the Developer tool in your browser and (F12) and under "HTML" search for "g_user" or "separator" to check the separator in the current browser
There are plenty of similar questions on the community about the same
Quote:
1. Changing the system property locale to e.g. de.DE or nl.NL does not 😞 change my behavior for decimal fields to dot vs comma notation. It still presents 12,000 vs the expected 12.000
2. Add the fields Country Code and Language to a user record and e.g. supplying Dutch values (so Country Code = NL; Language = nl) DOES 😄 change my decimal notation to dot-notation
So try chaning the Country code and Language on the given user and check if the decimal and grouping separator changes accordingly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2020 12:22 AM
Irrespective with browser, Notations stays same. my locale setting also set to german, still no change.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2020 01:08 AM
ServiceNow tries to discover the correct Locale to use from the user Language and Country Code settings. As Simon has also hinted at above.
Unfortunately, these fields are not by default exposed in the UI. And the way they discover the locale - and what they do with undefined locales - is a bit..... weird.
If you add Country Code and Language to the user list, you can set them both to "German" or "Germany". That will make ServiceNow put together the locale "DE_de", which it knows maps to German separators, formats, etc.
You *need* to change both fields. If you don't change the language, the system comes up with "DE_en" (or something like that) and this does not match a sensible locale, therefore the defaults are applied.
The whole handling of locales, languages, formats, and currencies could really do with a MAJOR overhaul, IMO.