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!