How to change the display format of currency fields?

LI QD
Tera Contributor

I want to display the currency field with minus(-), how to change the format? Please help me!!!

Now, my status↓

From layout

find_real_file.png

List layout

find_real_file.png

I hope↓
-¥88,888,888,880

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

I have tried this in past by setting negative currency; it shows in negative on form but not on list.

regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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.

find_real_file.png