The following describes how to update the reporting currency amounts for historic transactions. The first step shows you how to activate the system balance type 304, for reporting currency amounts, in Work with system balance type definitions. While running this routine the balances in reporting currency will also be created/rebuilt.
The computation of reporting currency amounts for historic transactions will always be based on a fixed exchange rate even for companies using a variable exchange rate for the reporting currency.
Prerequisites
- Define the reporting currency as fixed in Work with currencies.
- Enter a fictive fixed exchange rate for the reporting currency in the Exchange rate table, i.e.:
- Time level
- Enter an asterisk (*).
- Medium
- Enter the valid exchange rate.
- Run the Calculate reporting currency from system currency routine, see step 4 below.
- Define the reporting currency as variable in Work with currencies.
- Enter the correct exchange rate in the Exchange rate table for the time and level defaults defined in the G/L control file.
- Select the Work with system balance type definitions menu item.
- You access Work with system balance types. Select the balance type 304 (Reporting currency amounts).
- You access the detail panel. The following fields apply:
- Decimals to display
- Enter the number of decimals you want to be displayed in the enquiry program for the reporting currency value.
- Base level
- Enter the base level for this balance type. Once you have assigned a base level to a balance type, and the system begins storing statistics based on it, you cannot change the level.
- Active
- Set to YES.
- Use total no of per
- Indicate if the total number of periods should be used in the G/L control file.
- Select the Calculate reporting currency from system currency menu item.
- You access Calculate reporting currency. Caution: No one should update transactions to the General Ledger when you run this routine. Click OK to start the update. The system will inform you when the update has completed by sending the following message: “Job CAL_R_CURR completed normally“.
Click OK. Now, you can continue with updating the reporting currency amounts.