The Currency Exchange Rates page at Lists > Accounting > Currency Exchange Rates always displays the latest exchange rate for a currency pair and effective date for the date you select in the As Of filter. The default is today’s date. To display past rates, change the As Of filter.
Use the export icons at the top of the list to export the complete list to a CSV file or a Microsoft Excel file.
The Currency Exchange Rates list page includes the following columns:
-
Base Currency – The base currency of the company (or subsidiary if you have NetSuite OneWorld.
-
Source Currency – The foreign currency to convert to base currency.
-
Exchange Rate – The rate used to convert the source currency to the base currency. The calculation is Base Currency equals Source Currency multiplied by Exchange Rate.
-
Effective Date – The date to begin using the exchange rate for conversions.
If you have multiple currency exchange rate types, the filters include an Exchange Rate Type filter, and the list includes an Exchange Rate Type column.
Additional Columns for Currency Exchange Rate Integration
If you use the Currency Exchange Rate Integration feature, this page displays two additional columns:
-
Rate Provider – The name of your exchange rate provider.
-
Method – The method by which the rate was obtained.
The method options are:
-
Direct - Rate comes directly from the provider.
-
Triangulation – Rate calculated by NetSuite using triangulation.
-
Inverse – Rate based on the direct rate used by another NetSuite account.
-
Manual – Rate entered manually or by CSV file import. Rates of this method type are not updated by rate providers.
-
N/A – Rate automatically calculated when a new currency is added.
-
If you click a link in the Method column, a window opens with specific details for how that exchange rate was derived. Details include the exchange rate ID, base or anchor currency, source currency, direct rate, source date, rate used, rate provider, and rate method. The ID is a link to the Exchange Rate record.
Exchange Rate Field Limitations
You can enter exchange rates with up to 15 digits before the decimal point, or up to 8 digits after the decimal point. The maximum number of digits that can be entered in this field in any combination of integers and decimal fractions is 17. Exchange rate numbers can range from 123,456,789,012,345.12 (15 digits to the left of the decimal point and 2 digits to the right of the decimal point), to 12,346,789.12345678 (9 digits to the left of the decimal point and 8 digits to the right of the decimal point) to accommodate exchange rates related to large currencies and currencies with high decimal precision.
Note
A different set of exchange rates is used for consolidated reporting in OneWorld accounts. These exchange rates are stored in the Consolidated Exchange Rates table.
To view historical currency rate updates for your account, go to Lists > Accounting > Currencies, and then click History. The Exchange Rate History page provides the date on which an update was recorded in the system, effective date of the update, and the date on which the update was changed at the source. This page also provides the name of the user who made the change and the rate before and after the change.