Currency field value on a table is not exported via XML export - Support and Troubleshooting

Currency field value on a table is not exported via XML export Description  Currency field value on a table is not exported via XML export

Problem After export, the record from any table contains currency field to XML file. When modifying the currency value in the XML file and import gain, the currency field value does not update.

Symptoms 1. Open the core_company table. 2. Open company ACME Africa , and set profit to $1234.00 .

3. Export the record to XML file. The profit is shown on the XML file.

4. Modify the value for Profit , a currency field, to $1000.00 . Save the record.

5. Import the XML file saved from step 3.

Note that the currency field value did not update.

Cause The XML export feature is designed to work for exporting records from a table as is (raw data), without dependents such as currency records. This behavior is as intended.

Resolution Export/Import of currency fields should be done through other methods such as Excel/Csv/Import sets where the value of the currency field is exported and imported.

Any method involving direct web services or XML has to separately transfer the fx_currency_instance table records first, and then the parent records (thus wanted record).