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.
Important
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 component of the Currencies window.
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). .gif "Dn267759.Important(en-us,NAV.90).gif") 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.
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.