---
sourceDocument: Yokohama ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/platform-administration

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# FX Currency values in import and export

# FX Currency values in import and export {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

In general, currency values crossing the boundaries of the platform represent whatever
is returned by `getDisplayValue`. Usually this currency value is the default as
entered by a user into an FX Currency field for a transaction.

## FX Currency import {#fx-currency-values-import-export__section_qmq_1lv_5jb}

If using the default `setDisplayValue()` import method, FX Currency works in
manner similar to the standard currency field. It imports a value such as
`USD;1,234.56` as
`setDisplayValue("USD;1,234.56")`. It then parses the value as
a three letter ISO currency code, followed by a semi-colon, followed by a number formatted in
the locale of the user. This method should work for most use cases.

Defaults for other Currency Instance fields come from FX Currency field configuration you
defined in System LocalizationFX Currency Configuration. To explicitly set these fields, you can use a custom import script that sets
those fields to desired values, possibly using values from another import column.  
There are various ways to import FX Currency data.{#fx-currency-values-import-export__table_vqg_pmv_5jb__entry__2}

| Method | Description |
|-|-|
| Importing data into custom rate tables | Main method for importing custom rates, other than editing rates directly. When you modify existing rates, existing currency values that use that rate aren't updated. Note: This is specific for importing only. |
[ ]

{#fx-currency-values-import-export__table_vqg_pmv_5jb}

## FX Currency export {#fx-currency-values-import-export__section_xlq_dlv_5jb}

There are various ways to export FX Currency data.{#fx-currency-values-import-export__table_rx3_mlv_5jb__entry__2}

| Method | Description |
|-|-|
| Show XML | Shows an XML file with instance records for each FX Currency field bundled inside the XML payload. |
| Export to XML | Shows an unload XML with unloads for all instance records. |
| Export to Excel/PDF | Uses the default method of exporting data that extracts data from fields using `getDisplayValue()`. For FX Currency fields, using this method returns a formatted currency string of the form $1,234.56. To access specific information inside an FX Currency field directly without any transformations, simply export that column using dot walking. |
[ ]

{#fx-currency-values-import-export__table_rx3_mlv_5jb}

*[\>]: and then