Adjust Exchange Rates Batch Job

The Adjust Exchange Rates batch job can be used to adjust G/L, 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 G/L 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/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 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 G/L account specified in the Realized Gains Acc. field or the Realized Losses Acc. field in the Currency table. Balancing entries are automatically posted to the G/L 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 G/L 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 G/L entry and adjusts the G/L entry depending on the contents of the Exchange Rate Adjustment field for each G/L account.

Dimensions on G/L Account Entries

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

Attention

Before you can use the batch job, you must enter the adjustment exchange rates that will be 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 will always be adjusted in relation to the rate used in the preceding adjustment.

You can define what is included in the batch job by setting filters. You can set additional fields on the tab by clicking the Field field, and then clicking the AssistButton that appears to the right. You can also determine how the batch job is processed by filling in the fields on the Options tab. Fill in the fields as follows:

Currency

Code: Enter the currencies for which balances will be adjusted. To see the existing currency codes, click the Filter field, and then click the AssistButton that appears to the right.

Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the table.

Options

Starting Date: This field is normally left blank, but you can 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 normally the same as the posting date in the Posting Date field.

Posting Description: Here you can enter a text for the G/L 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 G/L entries will be 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 G/L entries created by the batch job.

Adjust Customer, Vendor and Bank Accounts: Place a check mark in this field if you want to adjust customer, vendor and bank accounts for currency fluctuations.

Adjust G/L Accounts for Add.-Reporting Currency: Place a check mark in this field if you post in an additional reporting currency and you want to adjust G/L accounts for currency fluctuations between LCY and the additional reporting currency.

Click OK to start the batch job. If you do not want to run the batch job now, click Cancel to close the window.



© 2009 Microsoft Corporation. All rights reserved.