How to avoid data export converting currencies?

rightpalava
Mega Expert

‎11-28-2014 02:32 AM

We have a table of records, with a few currency fields.   The vaules are in GBP, USD and other currencies, but when an export is run (simple Excel export) the currencies are all converted to default GBP.   The customer wants the currencies to remain as they are shown in the table within ServiceNow.

 

Any ideas folks?

0 Helpfuls
  • 2,262 Views
5 REPLIES 5

Alfredo6
Tera Expert
In response to Raju Koyagura

‎12-18-2017 08:25 AM

Hi!


In Helsinki this issue wasn't present to us. We just upgraded to Jakarta and this issue appeared. Those properties from the wiki didn't work in our instance even though the glide.excel.fixed_currency_usd appears in the Jakarta wiki. Is there any fix or workaround in Jakarta? Creating string fields is not an option as we have multiple currency fields and we won't have the table grow that much. What property or user preference can we use to avoid exporting currency fields in one currency?


Thanks!


0 Helpfuls