Relational Exch. Rate Amount Field, Currency Exchange Rate Table
Specifies the amounts that are used to calculate exchange rates for the foreign currency on this line. This field is used in combination with the Exchange Rate Amount field. The amount you enter in this field is relevant for the currency in the Relational Currency Code field.
The following example shows two ways of entering exchange rate amounts in the Currency Exchange Rates window. Note that the blank code in the Relational Currency Code field indicates LCY:
| Currency Code | Relational Currency Code | Exchange Rate Amount | Relational Exch. Rate Amount |
|---|---|---|---|
USD |
None |
100 |
64.8824 |
DEM |
EUR |
1.9829 |
1.0 |
In this example, the exchange rate for USD to LCY is defined as 64.8824 LCY for 100 USD. The exchange rate for DEM to EUR is defined as 1.9829 DEM for 1.0 EUR. On invoices and journal lines, the program converts foreign currency amounts to LCY using the information in the Currency Exchange Rates window.
The date in the Starting Date field on this line determines when the exchange rate comes into effect. The exchange rate on this line will be effective from the starting date on this line until the date in the Starting Date field on the next line.
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 requisition), 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.
Important
If you post in an Additional Reporting Currency, you must retain all the exchange rate amounts you enter in this field for this currency.
To post exchange rate gains and losses, you must run the Adjust Exchange Rates batch job.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Currency Exchange Rate Table | General Ledger |
| Currency Exchange Rate Table | General Ledger |