Currency Exchange Rate Table

Specifies how you want to register exchange rates for foreign currencies and to specify from which dates the exchange rates are valid. For example, you can enter daily exchange rates, monthly exchange rates or quarterly exchange rates for each foreign currency.

You can register exchange rates for each of the codes in the Currencies window. In the Currencies window, click Exch. Rates. The Currency Exchange Rates window appears for the relevant currency.

When you post a foreign currency transaction, the program uses the posting date on the invoice or journal line and the information in the Currency Exchange Rate table to find the relevant exchange rate. If a posting date is not specified (for example, on a purchase requistion), the program uses the work date to find the corresponding exchange rate.

If you post in an additional reporting currency, the program also uses this table to find the appropriate exchange rate to calculate additional-currency amounts on G/L entries.

Note that in order to post exchange rate gains and losses, you must run the Adjust Exchange Rates batch job and register the adjustment exchange rates that will be used by the batch job. You register the adjustment exchange rates by filling in the Adjustment Exch. Rate Amount field and the Relational Adjmt. Exch. Rate Amt. field.

Important

If you post in an additional reporting currency, you must retain all the currency-related information you enter in this table for the currency used as the additional reporting currency.

List of Fields in the Table

Field Location
Starting Date Field, Currency Exchange Rate Table General Ledger
Currency Code Field, Currency Exchange Rate Table General Ledger
Relational Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Fix Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Relational Sett. Rate Amount Field, Currency Exchange Rate Table New Zealand Local Functionality
Settlement Rate Amount Field, Currency Exchange Rate Table New Zealand Local Functionality
Adjustment Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Starting Date Field, Currency Exchange Rate Table General Ledger
Currency Code Field, Currency Exchange Rate Table General Ledger
Relational Adjmt Exch Rate Amt Field, Currency Exchange Rate Table General Ledger
Relational Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Fix Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Relational Currency Code Field, Currency Exchange Rate Table General Ledger
Relational VAT Exch. Rate Amt Field, Currency Exchange Rate Table Switzerland Local Functionality
VAT Exch. Rate Amount Field, Currency Exchange Rate Table Switzerland Local Functionality
Adjustment Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Starting Date Field, Currency Exchange Rate Table General Ledger
Currency Code Field, Currency Exchange Rate Table General Ledger
Relational Adjmt Exch Rate Amt Field, Currency Exchange Rate Table General Ledger
Relational Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Fix Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Relational Currency Code Field, Currency Exchange Rate Table General Ledger
Adjustment Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Relational Adjmt Exch Rate Amt Field, Currency Exchange Rate Table General Ledger
Relational Currency Code Field, Currency Exchange Rate Table General Ledger
Adjustment Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Starting Date Field, Currency Exchange Rate Table General Ledger
Currency Code Field, Currency Exchange Rate Table General Ledger
Relational Adjmt Exch Rate Amt Field, Currency Exchange Rate Table General Ledger
Relational Exch. Rate Amount Field, Currency Exchange Rate Table General Ledger
Fix Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Exchange Rate Amount Field, Currency Exchange Rate Table General Ledger
Relational Currency Code Field, Currency Exchange Rate Table General Ledger

See Also

Reference

Adjustment Exch. Rate Amount
Additional Reporting Currency
Currency Exchange Rates
Change Exchange Rate

Other Resources

Adjust Exchange Rates
How to: Change Exchange Rates when you Post