Consolidation Module Control

---

Access this form from the System > Consolidations menu. The Consolidation Module Control is system-wide - settings apply to all companies using the consolidation function.

Percentage ownership

This is set to 100, and is read-only.

Elimination Level

Eliminations can be set up to occur at either a general ledger account level, a transaction tree level, or both.

GL Account

Select this option if eliminations are to occur at a general ledger account level. If you select this option, you must nominate an elimination general ledger accounts.

Transaction Tree

Select this option if eliminations are to occur at a transaction tree level.

Elimination Tree

If the transaction tree option is selected, you must select the transaction tree to use when processing eliminations. You can only assign one tree in Greentree as the elimination tree. The elimination tree settings become read only once you set up a consolidation code with elimination tree mappings.

Period Mapping

The period mapping feature enables you to map financial periods from one calendar to periods in another calendar. This allows companies using different general ledger calendars different financial periods) to be consolidated into a single company.

Reference

Enter a unique reference, up to 12 characters, to identify the mapping.

Description

Enter a description to identify the mapping.

Source calendar

Select the map FROM calendar.

Destination calendar

Select the map TO calendar.

You must save the header information and recall the mapping by reference to continue the process.

Map year from

Select a year from the source calendar. Source periods updates to the mapping table using the year selected. Click Create Default Mapping to populate period detail to the mapping table. Source periods are read-only, using the selected mapping year, and they cannot be changed. However, you can select a different destination period from a dropdown list, based on the mapping you want to create.

The default mapping updates to the table based on these rules:

• If the start and end dates for a source period match the start and end dates for a destination period, map the periods 1:1.
• If the start and end dates for a source period fall within a destination period, map to that period.
• If the start and end dates for a source period do not fall entirely within a destination period, map to the period into which the end date falls.

Years that are mapped subsequent to the initial mapping will be inserted into the correct order within the mapping table. For example, a subsequent year will be appended and a prior year will be inserted in front of existing years.

Mapping Rules:

• The selected period in the destination column must be after the selected period in the previous line.
• All periods in the source calendar must be mapped.
• Multiple source periods can be mapped to a single destination period.
• A single source period may not be mapped to multiple destination periods.
• Periods can map across financial years, for example, Source Period 1 in 2018 (July) may map to Destination Period 7 in 2017.

If the subsidiary and consolidation company do not use the same GL calendar, you must specify the period mapping to be applied when the relationship is set up in Consolidation Company Mapping Maintenance.

• GL Account Maintenance

---