Adjust Exchange Rates
Adjustment of exchange rates, or balance sheet valuation means the recalculation of open customer, vendor entries and amounts collected on cash desk and bank accounts based on exchange rates that are valid on the day when the balance sheet was calculated. This calculation should be performed at least once a year. The following improvements have been implemented within Polish Localization:
the possibility of running the Adjust Exchange Rates batch job separately for receivables, payables and bank accounts;
the possibility of posting detailed entries or entries aggregated by a currency exchange rate by running the Adjust Exchange Rates batch job;
the possibility of running the Adjust Exchange Rates batch job in the test mode, only for simulation purposes (without postings resulting from recalculations).
Running the Adjust Exchange Rates Batch Job
To run the Adjust Exchange Rates batch job to use Polish Localization functional improvements:
Choose the icon, enter Adjust Exchange Rate, and then select a related link.
On the Options FastTab, fill in the following fields:
Starting Date - Specifies the starting date for the period during which exchange rate adjustments are made. If the field is empty, all entries from the period preceding the end date or equal to the date defined in the Ending Date field are adjusted.
Ending Date - Species the ending date for the period in which exchange rate adjustments are made. If the field is left empty, all entries with the date after the date specified in the Starting Date field are adjusted.
Posting Description – Specifies the description which will be entered into general ledger entries when the batch job is run. This field is filled in automatically by the system, but it can be modified manually, if needed.
Posting Date – Specifies the date which is used to post entries when the batch job is run. This field is filled in automatically by the system with the ending date. If needed, the date can be changed manually.
Document No. – Specifies the document number which is used to post entries when the batch job is run.
Adjust Bank Accounts – Specifies that the batch job is to adjust amounts on the bank and cash accounts.
Reverse Adjust Bank Accounts - Specifies that the Adjust Bank Accounts batch job is to automatically reverse all adjustments made on bank accounts and cash desk accounts on the date following the date when these adjustments were posted.
Note
The Reverse Adjust Bank Accounts function is also available as an action on the Bank Account Ledger Entries page.
Adjust G/L Accounts for Add.-Reporting Currency –Select this field, if the batch job is to adjust amounts in G/L accounts for an additional reporting currency.
Adjust Customer – Specifies that the batch job is to adjust open customer ledger entries.
Adjust Vendor – Specifies that the batch job is to adjust open vendor ledger entries.
Summarize Entries – Specifies that posting entries which have resulted from the batch job processing are to be summarized based on a currency. If this field is not selected, the batch job creates detailed ledger entries.
Test Mode – Specifies that the batch job is to be run in the test mode, only for simulation purposes. If this field is not selected, the batch job posts adjusted currency exchange rates.
Note
The batch job cannot be run in the test mode, if the Summarize Entriesfield is selected.
On FastTabs such as: Currency, Customer, Vendor, Bank Account, it is possible to set up filters to limit the scope of data to be adjusted.
Select Print to run the batch job and print or select Preview to run the batch job and preview data on the screen.