Country+locale=currency question

[Fitz4]

So not sure if this is the right place to ask this, but reviewing the many posts on Community and elsewhere regarding currency.  I've implemented multiple currencies on our platform and understand the nuances.  There is one thing eluding me however.  I seem to have found (but now lost) a table which determines what currency is mapped to which combinations of country and locale.  For example, default currency is USD, but Canadian dollars are enabled -  if I have an english-speaking Canadian user who speaks English and a Canadian user who speaks French and both want to see currencies in Canadian dollars - what determines this?  Am I misremembering or does this table exist somewhere?

Thanks in advance.

[fknell]

Hi @Fitz4,

ServiceNow uses two locale concepts (Src: Standard currency fields)

- System locale (glide.system.locale): determines the reference currency

- User locale: determines the session currency

The user locale is resolved in this order:

1. User record where country and optionally language are set

2. System locale (glide.system.locale)

3. Browser locale

For your example the evaluation is done as follows:

• English-speaking Canadian user:
• Country = Canada, Language = English: locale like en.CA → session currency CAD
• French-speaking Canadian user:
• Country = Canada, Language = French: locale like fr.CA → still CAD, just French formatting

Hope this helps!

[Fitz4]

Thank you @fknell, but this is still missing my question, and perhaps a better example would be 

- Country=India, Language=Hindi, currency in Indian Rupee

- Country=India, Language = English, but wants currency in USD.  

How can I make this happen?  I thought there was a place where the various combinations of country+language=currency were located.

[fknell]

Hi @Fitz4,

The first example can be done with updating the user record to hi_IR. I doubt the second example can't be done ootb, the underlying Java local is hardcoded to INR for en_IN.

Either you set everybody to USD or create workarounds for your second scenario like setting the country to United States and language to EN for your respective users. I wonder from where you will get that data to set it.