Notifications

137 views

Description

Exported currency is always showing in $ though the current displayed currency in user's session is in Euro. Even though the below properties were set as follow.

glide.excel.fixed_currency_usd=false
glide.excel.convert_to_user_currency=true
glide.i18n.single_currency=false

 

Release or Environment

All the releases 

Resolution

Currency name is taken from the fx_currency table and currency conversion will be done based on fx_rate.

Conversion rates are stored in the fx_rate table. Each record contains the conversion rate from a given currency to the Euro. The rates are updated daily from the ECB website by a scheduled job called ECB Exchange Rate Load.

A currency conversion from one currency to another involves two rates

Rate to convert from the first currency to Euro
Rate to convert from Euro to the second currency

Below properties will control the currency export. If the user wants to export all the currency values in $ then set the "glide.excel.fixed_currency_usd" to true. If the user wants the currency displayed in user session then set the glide.excel.convert_to_user_currency=true.

Country code set on user profile will also having control on which currency is applicable while exporting the currency fields. If the user country code is set to "null" then exported currency filed will be set to default currency $.

Inorder to export the currency field in other than $ then make sure that country code set in sys_user record is set to respective country code.

 

Article Information

Last Updated:2019-12-07 22:05:17
Published:2019-12-08