To cater for automatic translation in consolidation reporting involving subsidiaries using different financial year/periods patterns, the period mapping functionality is used to link a division’s periods to the periods of its reporting entity(s). The following needs to be taken into account when mapping periods:
Go to Financial/Setup/General/Financial years / Periods. Select a division and click Show. Then, click a link under the Period mapping column and click Map.
To map financial periods, function right 195 - Maintain years/periods is required. Users with the Controller role have this function right.
For more details on what you can do with function rights or levels, go to System/Setup/Security/Function rights, select the required module, and then click on the relevant ID. To find out the functions you can perform with a particular role, go to System/Setup/Security/Roles, type in the description, click Refresh, and then click the required link under the Role column.
Click this to map the period(s) selected from the division to its reporting entity. If the frequency (monthly, yearly, half-yearly, and others) is different between the division and its reporting entity, you can still map the periods by selecting the relevant periods from the division and reporting entity.
Note: You can link a single period of a division to a single period of a reporting entity or a number of periods of a division (that has a monthly frequency for example) to a single period of a reporting entity (that has a quarterly frequency for example).
Click this to map all periods from the division to its reporting entity having the same frequency. You do not need to make any selection before clicking this button.
Click this to exit.
The division selected is displayed. Click this to go to the division card. For more information, see Creating Division.
The year selected is displayed. For more information, see Creating Financial Year.
Type or select a reporting entity to display the periods in the financial year selected.
Note: The relationship between the reporting entity and its divisions has to be defined at the division card first. For more information, see Overview of Linked Divisions.
Select a year to display the periods. For more information, see Creating Financial Year.
Four columns are displayed in both the Division and Reporting entity sections:
After mapping, the screen below will be displayed. In the example, it shows four periods of a division mapped to 1 period of a reporting entity. You can click Delete to delete the mapped periods.