How is fx_system_rate records updated/populated?

[Fer Ortiz]

Hi all, I'm trying to understand how fx_system_rate records are updated o inserted. Basically, I am trying to make a currency convertion between some currencies (USD,EUR, etc) to MXN. 

I'm using  GlideConverter class to make this convertion, here's and example: 

I noticed that call that API creates a record on that table, but ¿where is the initial rate stored in servicenow?

I tried to look for that value in fx_rate table: but the latest value value does not match with the value used for GlideCurrencyConverter or GlideConverter :

Thanks in advance

[Marcos Kassak · Accepted solution]

Hi @Fer Ortiz.,

These records are maintained by the system. Please check the below ServiceNow Support article that also explains a little bit about conversions:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0751553

The fx_rate table will hold all exchange rates. As an example the system would convert the AUD value to EURO then EURO to USD to set the reference currency.

(Entered Amount / Exchange rate for Currency entered) * Exchange rate currency for the system locale

Please see the following documentation for further information regarding currency conversions

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

If you found my answer helpful or correct in any way, please don't forget to mark it to help future readers! 👍

--

Kind regards,

Marcos Kassak
Solution Consultant  🎯