How to change the display format of currency fields?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-06-2022 01:46 AM
I want to display the currency field with minus(-), how to change the format? Please help me!!!
Now, my status↓
From layout
List layout
I hope↓
-¥88,888,888,880
- Labels:
-
Multiple Versions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-06-2022 01:54 AM
Hi,
I have tried this in past by setting negative currency; it shows in negative on form but not on list.
regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2022 02:21 AM
Thank you for your answer!
There is a solution from my colleagues. The Value of system property [glide.system.locale] is added with [ja.JP] in table [sys_properties] , currency field display with minus(-). However, it has some risks and disadvantages, please use caution when using it.
-------------------------------------------Description------------------------------------------------
Locale code to use for localization. Format is [language code].[country code] (e.g. en.GB for Britain fr.FR for France, de.DE for Germany, or ja.JP for Japan).<br/>
<br/>
NOTE: Do not change this value once a system has gone into production. If a user's locale must be changed, update the "Country code" field on the user record.<br/>
<br/>
The value of this property determines the system's default currency into which all prices are automatically converted before other sums or conversions are performed.<br/>
Changing this property after any price or currency fields have been given a value (for Service Catalog items, Assets, Project Tasks, etc.) may result in improper conversion or prices that sum incorrectly.