Adjust Exchange Rates Batch Job

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 using the exchange rate that is valid on the posting date 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 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 or 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 or Vendor Entries

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

Bank Accounts

For bank accounts, the batch job adjusts the currency using the exchange rate that is valid on the posting date specified in the batch job. The batch job calculates the differences for the individual bank account that has a currency code and posts the amounts to the general ledger account specified in the Realized Gains Acc. field or the Currency 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 calculates one entry for each 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.

General Ledger 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.

Exchange rate adjustments can be made several times, and the rates will always be adjusted with regard to the rate that is used in the previous adjustment.

Options

Field	Description
Starting Date	Enter a date to specify the beginning of the period for which entries will be adjusted.
Ending Date	Enter the last date for which entries will be adjusted. This date is typically the same as the posting date in the Starting Date field.
Method	Select the valuation method. Methods include Standard, Lowest Value, and BilMoG (Germany). Important German companies must select the BilMoG option.
Valuation Reference Date	Specify the base date that is used to calculate which entries are short-term entries.
Short term liabilities until	Specify the date that is used to separate short-term entries from long-term entries.
Posting Description	Enter the text for general ledger entries that will be 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 will be posted. This date is usually the same as the ending date in the Starting Date field.
Document No.	Enter a document number that will appear on the general ledger entries created by the batch job.
Adjust Customers	Specify if you want to adjust customers for currency fluctuations.
Adjust Vendors	Specify if you want to adjust vendors for currency fluctuations.
Adjust Bank Accounts	Specify if you want to adjust bank accounts for currency fluctuations.
Adjust G/L Accounts for Add.-Reporting Currency	Specify 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.
Post	Specify if you want to post the adjustments.
Adjust VAT exch. rate	Specify if you want to adjust the VAT exchange rate. This option is available for Switzerland only.

Choose the Print button to start the batch job.

See Also

Reference

Adjust Exchange Rates G/L

Other Resources

Currency Exchange Rates
Currencies