Open the Adjust Exchange Rates window.
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 about how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For more information about how to find specific pages, see Search. |