Adjust Exchange Rates Batch Job

Article
09/15/2014

Adjusts general ledger, customer, vendor, and bank account entries to reflect a more updated balance if the exchange rate has changed since the entries were posted.

Customers and Vendors

For customer and vendor accounts, the batch job adjusts the currency by using the exchange rate that is valid on the posting date that is specified in the batch job. The batch job calculates the differences for the individual currency balances and posts the amounts to the general ledger account that is specified in the Unrealized Gains Acc. field or the Unrealized Losses Acc. field in the Currency table. Balancing entries are automatically posted to the receivables/payables account in the general ledger.

The batch job processes all open customer ledger entries and vendor ledger entries. If there is an exchange rate difference for an entry, the batch job creates a new detailed customer or vendor ledger entry which reflects the adjusted amount on the customer or vendor ledger entry.

Dimensions on Customer/Vendor Entries

The adjustment entries are assigned the dimensions from the customer/vendor ledger entries, and the adjustments are posted per combination of dimension values.

Bank Accounts

For bank accounts, the batch job adjusts the currency by using the exchange rate that is valid on the posting date specified in the batch job. The batch job calculates the differences for each bank account that has a currency code and posts the amounts to the general ledger account that is specified in the Realized Gains Acc. field or the Realized Losses Acc. field in the Currency table. Balancing entries are automatically posted to the general ledger bank accounts that are specified in the bank account posting groups. The batch job calculates one entry per currency per posting group.

Dimensions on Bank Account Entries

The adjustment entries for the bank account's general ledger account and for the gain/loss account are assigned the bank account's default dimensions.

G/L Accounts

If you post in an additional reporting currency, you can have the batch job create new general ledger entries for currency adjustments between LCY and the additional reporting currency. The batch job calculates the differences for each general ledger entry and adjusts the general ledger entry depending on the contents of the Exchange Rate Adjustment field for each general ledger account.

Dimensions on G/L Account Entries

The adjustment entries are assigned the default dimensions from the accounts they are posted to.

Important

Before you can use the batch job, you must enter the adjustment exchange rates that are used to adjust the foreign currency balances. You do so in the Currency Exchange Rates window, which is a subtable to the Currencies window.

Exchange rate adjustments can be made several times, and the rates are always adjusted in relation to the rate that was used in the preceding adjustment.

Options

Field	Description
Starting Date	This field is usually left blank, but you can enter a date to specify the beginning of the period for which entries are adjusted.
Ending Date	Enter the last date for which entries are adjusted. This date is usually the same as the posting date in the Posting Date field.
Posting Description	Enter a text for the general ledger entries that are created by the batch job. The default text is Exchange Rate Adjmt. of %1 %2 in which %1 is replaced by the currency code and %2 is replaced by the currency amount that is adjusted. For example, Exchange Rate Adjmt. of DEM 38,000.
Posting Date	Enter the date on which the general ledger entries are posted. This date is usually the same as the ending date in the Ending Date field.
Document No.	Enter a document number that will appear on the general ledger entries created by the batch job.
Adjust Customer, Vendor and Bank Accounts	Select if you want to adjust customer, vendor and bank accounts for currency fluctuations.
Adjust G/L Accounts for Add.-Reporting Currency	Select if you post in an additional reporting currency and you want to adjust general ledger accounts for currency fluctuations between LCY and the additional reporting currency.

Tip

For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.

Share via