Consolidated Exchange Rates Import
You can import consolidated exchange rate updates using CSV import if your organization:
-
Uses NetSuite OneWorld.
-
Has multiple subsidiaries with different base currencies.
-
Maintains a table of consolidated exchange rates. The Consolidated Exchange Rates table is available at Lists > Accounting > Consolidated Exchange Rates. For more information, see Consolidated Exchange Rates.
To import updated consolidated exchange rate data, in the Import Assistant, set the Import Type to Accounting and the Record Type to Consolidated Exchange Rate. Only the Update data handling option can be selected for the import.
The fields that you can map and update are:
-
Average exchange rate
-
Current exchange rate
-
Historical exchange rate
The import also requires an external ID or internal ID. For information about using external and internal IDs, see Select Reference Types. The import updates successfully if the period is not closed, is not derived, and does not include an elimination subsidiary.
For more details about how consolidated exchange rates are handled in NetSuite, you can review the Lists > Accounting > Consolidated Exchange Rates page, and see Consolidated Exchange Rates.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.