The CreatorCon Call for Content is officially open! Get started here.

How do I modify the default currency symbol?

salvadormarchan
Kilo Guru

Hi,

I was able to modify the symbols to distinguish Australian Dollar (A$), Canadian Dollar, (C$), Singapore Dollar (S$) and American Dollar ($) ...BUT it is defaulting to American Dollar for now. How can I change it to, let's say, Singapore Dollar?

Thanks,

Dor

22 REPLIES 22

Mike Allen
Mega Sage

I actually was able to affect it.   I enabled the Singapore dollar, changed it to S$, added the Singapore locale to the country code choice list (with value as SG) and added en.SG to the default currency field in the system localization in demo017.   Now, when I go to create a contract or a catalog item, the default currency is S$.   You can log into demo017 as the admin and see.



If you have done all this, then go to HI.


Thank you so much Mike!!!!!


I have also tried modifying the locale properties but It was not working.


Let me simulate again here.


roweco
Tera Contributor

Hi there,



There is another piece to this Currency puzzle - the Locale [sys_locale] table.


The Service Catalog seems to work out if a user has a country code set then display prices in the user's currency e.g. if they are in France show an item price in Euros.


However for standard forms (Assets etc) entries in the Locale table can be used to map which countries use which currencies.


This infers if you have users in EU countries using Euros then you'll need sys_locale entries for all countries where you have EU users - France , Germany, Spain etc.


Otherwise the system defaults to the Instance locale setting for users viewing standard forms and lists.


Note the Locale [sys_locale] table is not documented.


LocaleCapture.PNG


Thanks Courtenay, could you please pass me an XML file copy of the record for Canada. I want to use that as my guinea pig?


Thanks again, Dor


Hi Salvador,



There is a convenience module "Load Locales" available to load example Locale records. It actually sets language based locales like Chinese and English Singapore.  


It is disabled by default.


Note my earlier example records use the ISO country code for Country not the Country name.



To reiterate, to default the system currency on a new system just go to System Properties -> System Localisation and update the property "glide.system.locale" e.g. "en.SG"


As long as the chosen Currency [fx_currency] (e.g. Singaporean dollar) is enabled and and the symbol updated , once a user logs out and in again, they will see S$ unless their user profile country has been set to something other than the default country and multiple countries are in use i.e. glide.i18n.single_currency is false.



Capture local.JPG