Adding Rates to the Currency Exchange Rates List

In the Currency Exchange Rates list, you can specify an exchange rate between each base currency and each foreign currency. These exchange rates are applied to transactions.

This topic includes instructions to add the currency exchange rate manually. You can also integrate with rate providers to get automatic currency exchange rates. For information, see Currency Exchange Rate Integration.

To set the exchange rate for two currencies manually:

  1. Go to Lists > Accounting > Currency Exchange Rates > New.

  2. In the Base Currency field, select the base currency for this exchange rate.

    If you use NetSuite OneWorld, you can select the base currency for any subsidiary that you can access. If you do not use NetSuite OneWorld, this field displays your base currency.

  3. Select a foreign currency in the Currency field.

    For example, if you are setting the exchange rate for the Euro to your base currency, the U.S. dollar, select the name of your base currency, USA in the Base Currency field and then select Euro in the Currency field.

    If the Currency list does not include the currency that you need, you can define a new currency. For more information, see Creating Currency Records.

  4. If you have multiple currency exchange rate types, in the Exchange Rate Type field, select the rate type.

    This field appears on the page only when the Currency Exchange Rate Types feature is enabled. For information, see Currency Exchange Rate Types.

  5. In the Exchange Rate field, enter the exchange rate compared to the base currency.

    The exchange rate is the number of base currency units that equal one foreign currency unit. For example, if you want to set the value of a Euro to 1.357 U.S. dollar, enter 1.357 in the Exchange Rate field.

    You can enter a number with up to 15 digits to the left of the decimal or up to 8 digits to the right of the decimal. For more information see Exchange Rate Field Limitations.

    For comparison purposes, this page also displays the current (previous) exchange rate and the date that rate became effective.

  6. Set the date this exchange rate becomes effective in the Effective Date field.

  7. Click Save or Save & New.

You can go to a transaction page (for example, an Invoice page) or the Currency Revaluations page to see the impact of an exchange rate change on the value of a transaction.

Related Topics

General Notices