How to set currency from dollars to yen

[Prachi Gajbhiye]

As I have bill column in my target table and i need to show the currency in JPY (￥) but by default  currency is showing in dollars($). Can anyone help me how to set currency to (￥)?

[Shruti Khaire]

Hello @Prachi Gajbhiye ,

Solution Proposed:

As stated in the "Session and reference currency" product documentation:

When users view a currency value, they can see the value as entered or in the session-currency format. The format contains the: - Currency symbol - Value converted to the session currency and shown in a localized number format. The user's locale determines the session currency format

As stated in the "Default currency values in forms" product documentation:

A combo box provides a list of currencies available in the system. The user's locale determines its format. When entering or changing the numeric value, format the value in the format specified by the user's locale. In the form for a new record, the combo box with the list of currencies has the reference currency selected, and the numeric value set to zero.

The only way to meet requirement, through supported means, is to set a user or system locale that corresponds to a default currency that you want users to have selected for currency fields.

For example, if you set your instance's system locale (it's "glide.system.locale" system property value) to "ja.JP", the Japanese Yen will be selected as every currency field's initial/default currency - for every user. If the "glide.system.locale" system property has no value set on the system properties table, its value will default to "en.US", thus, US Dollars will be the default currency for all users.
You can set a specific user's locale via their sys_user record's "country" and "language" field - which will be used to determine their locale. The default currency will be based on the user's locale (instead of the system's locale) if they have a locale set via the aforementioned fields.

To learn more about system locales, please reference the following product documentation:
Product Documentation - Locale settings

I hope this helps, thank you!

[Dr Atul G- LNG]

Hi @Prachi Gajbhiye 

Here are good information:

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/currency/refere...

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/currency/concept/cu...

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/currency/concep...