Introduction - Run the Adjust Exchange Rates batch job
To update LCY amounts for posted entries, you can run the Adjust Exchange Rates batch job. The batch job adjusts customer, vendor, and bank account entries to reflect updated amounts when the exchange rate changes after entries are posted.
Your first task is to enter the Adjustment Exchange Rate on the Currency Exchange Rates page. You can either update the existing line or create a new line (manually or automatically through the external exchange rate service).
Next, you'll run the Adjust Exchange Rates batch job by following these steps:
Select the Search for Page icon in the top-right corner of the page, enter Currencies, and then select the related link.
On the Currencies page, select Home > Adjust Exchange Rate.
Fill in the following fields on the Adjust Exchange Rates batch job page:
Starting Date - Identifies the first date to use for locating and adjusting transactions. Generally, this field is left blank so that all transactions are adjusted.
Ending Date - Identifies the last date to use for locating and adjusting transactions. This date is typically the same as the Posting Date. Use the Ending Date field to retrieve the adjustment exchange rate for the batch job on the Currency Exchange Rates page.
Posting Description - Describes the general ledger entries that are created by the batch job.
The default text is Adjmt. of %1 %2, Ex. Rate Adjust. When you post the entries, the %1 is replaced by the currency code and %2 is replaced by the currency amount that is adjusted. This method results in, for example, Adjmt. of EUR 38,000 Ex.Rate Adjust.
Posting Date - Specifies the date on which the adjustment entries are posted.
Document No. - Identifies the document number that appears on the general ledger entries that are created by the batch job.
Adjust Customers – Adjusts customer ledger entries for currency fluctuations.
Adjust Vendors – Adjusts vendor ledger entries for currency fluctuations.
Adjust Bank Accounts – Adjusts bank account ledger entries for currency fluctuations.
Adjust per Entry - Specifies whether you want a detailed posting to the general ledger by entry, or a summarized posting by currency.
Preview Posting - Preview the effect that an exchange rate adjustment will have on posting before you actually post.
Dimension Posting - Specify how the adjustment will handle dimensions for unrealized gains and losses postings by choosing one of the following options:
Source Entry Dimensions: G/L entries for unrealized gains and losses will have dimensions values transferred from the entry you're adjusting.
No Dimensions: G/L entries for unrealized gains and losses won't have dimensions values.
G/L Account Dimensions: G/L entries for unrealized gains and losses will have dimensions values transferred from the unrealized gains and losses G/L account's dimension settings source entry.
Place a filter on the currency codes if you want to adjust one currency only or a selection of currencies.
Place a filter on the customers if you want to adjust the customer ledger entries of a specific customer or a selection of customers.
Place a filter on the vendors if you want to adjust the vendor ledger entries of a specific vendor or a selection of vendors.
Place a filter on the bank accounts if you want to adjust the bank account ledger entries of a specific bank account or a selection of bank accounts.
Watch this video for a demonstration on adjusting exchange rates.