Rate conversion table

[Tarasingh26]

Hi,

I have used currency conversion API var conv = new sn_currency.GlideCurrencyConverter(). It is converting fine but which table it is using for conversion (rate conversion).

Thanks,

Tara Singh

[sampath6]

By default it will use fx_system_rate table to convert currencies unless if you are custom exchange rate (must extends to fx_conversion_rate table).

Thanks,

Sampath.

[Rajesh_Singh]

@Tarasingh26 

The GlideCurrencyConverter() function in ServiceNow GRC utilizes the "fx_rate" table to manage currency conversions. The "fx_rate" table stores the conversion rates between different currencies. When you use the GlideCurrencyConverter() function, it retrieves the conversion rates from this table to perform the required currency conversion.

You can view or update the exchange rates in the "fx_rate" table by navigating to "System Currency > Currency Exchange Rates" in your ServiceNow instance. Keep in mind that the exchange rates need to be updated manually or through a scheduled job that periodically imports updated rates from an external source, as they are not updated automatically.