Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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