Advanced consolidations AE081

General description #

The main function is the modification of the Run Consolidation... action on the Business Units page.

When running the consolidation from the parent company, the subsidiary GL entries are aggregated based on the Consolidation Code and are posted to the accounts which are set in the Consolidation Setup.

New consolidation codes can be defined on the Consolidation Index page. On this page, the description can be specified and codes can be synchronized to subsidiary companies. It is also possible to block the index here, which deletes the Consolidation Setup entries using this index in subsidiary companies and will prevent this index from being used.

The following fields, which are used by the subsidiaries, were added to General Ledger Entries:

  • Consolidation Code
    • During posting its value is assigned from the Consolidation Setup based on the account number and dimensions in the line. If the code cannot be unambiguously assigned, an error is raised.
  • Consolidation Code Description
    • Assigned from the consolidation index based on the consolidation code.

Mapped Accounts #

Action Show account mapping was added to the Chart of Accounts, G/L Account Card, Consolidation Index and Consolidation Setup pages.

Running this action displays the mapped accounts from the parent and subsidiary companies which are related to the given entry. For example, running this action from consolidation index page in parent company will display the list of accounts in subsidiary companies which are mapped using this index. Likewise, running this action from the chart of accounts in subsidiary company will display the accounts from parent company to which this account is mapped.

Unmapped Accounts #

Action Show unmapped accounts was added to the Chart of Accounts and Consolidation Setup pages. This action displays a filtered chart of accounts where only the accounts, that are not mapped using the consolidation setup, are visible.

Central Dimension Management #

Values of the dimensions, which are specified in General Ledger Setup as the consolidation dimensions, are made uneditable in the subsidiary companies. To complement this, when the dimension values are added, modified, renamed or deleted in the parent company, this change is synchronized to the subsidiary companies. If the value cannot be deleted, because it is already used, then the field Blocked of this value is set.

Action Synchronize Dimensions was added to Dimensions page. This action performs a one-time synchronization of consolidation dimension values. The dimension values that are present in a subsidiary company but not in the parent company are not deleted.

Setup #

New Consolidation section is added to the General Ledger Setup. It contains the following fields:

  • Business Unit Type
    • Specifies whether the current company is parent or subsidiary.
  • Advanced Consolidation
    • When enabled, it is possible to add multiple consolidation units within one company.
    • Can be enabled only if the Consolidation Mapping Source is set to Consolidation Setup.
    • Can be set only for subsidiary company.
  • Consolidation Mapping Source
    • Specifies the source of getting the consolidation mapping index.
    • Entries - Consolidation index is calculated during the posting and stored in the subsidiary G/L entry.
    • Consolidation Setup - Consolidation index is calculated during the consolidation process based on the current consolidation setup.
    • Can be set only for subsidiary company.
  • Consolidate per Subsidiary G/L Account
    • If enabled, subsidiary G/L entries are consolidated per subsidiary G/L account and dimension combination, the consolidation index is only used to assign the correct G/L account of the parent company. The original G/L account of the subsidiary company is shown in the consolidated entry
    • Can be set only for a parent company.

Consolidation Setup #

Fields on the Consolidation Setup differ depending on the business unit type in General Ledger Setup

  • Parent
    • Consolidation Index Code
    • Account No.
    • Description
  • Subsidiary
    • Account No.
    • Income/Balance
    • <Value of the Consolidation Dimension 1 Code field from General Ledger Setup> - <Value of the Consolidation Dimension 8 Code field from General Ledger Setup>
      • If Income/Balance is "Balance", then these fields must be empty, otherwise the first of these fields must not be empty.
    • Consolidation Index Code
    • Description

Consolidation Setup Import #

It is possible to import consolidation setup in bulk, via the Consolidation Setup Import page. This page contains 3 groups of actions:

  • Process
    • This group contains action Import. this action imports list of consolidation setups to our page. Everything can be freely modified, and, if needed, deleted.
  • Send
    • This group contains actions Send(Update Existing) and Send(Delete Existing). Both actions are used to import consolidation setups to relevant subsidiary companies, which are specified by relevant Business Units.
    • Action Send(Update Existing) looks at the current consolidation setups of subsidiary companies and imports only those consolidation setups that are not alreadz present. No data is modified in the process, meaning, the current consolidation setups are not modified or tinkered with in any way.
    • Action Send(Delete Existing) deletes entire lists of present consolidation setups for the relevant subsidiary companies, and imports all the data previously imported from the excel file. This process is irreversible and is only secured by a confirmation. Use with caution.
  • Find
    • This group contains actions Change consolidation index code and Delete combination.
    • Action Change consolidation index code finds specific consolidation setups and updates the consolidation index. In case of a combination not being found a log is created, which is displayed at the end of the process. The log shows all the combinations that weren't found in the database.
    • Action Delete combination finds specific consolidation setups and deletes them. This action is irreversible and is only secured by a confirmation. Use with caution. ¨

Detailed consolidation G/L entries #

It can be determined if the G/L account is consolidated in detail. It means, all the original G/L entries for the account are also transfered into parent company.

  • On the G/L Account Card and in thr Chart of Accounts page the field Detailed G/L Entry Consolidation

    • If enabled, detailed consolidation G/L entries are generated for this account during the consolidation process.

  • Page Detailed consolidation G/L entries

    • Shows the detailed consolidation G/L entries that correspond with the original G/L entries of the subsidiary company.
    • The page is available using the search bar or using the action Detailed consolidation G/L entries on General Ledger Entries page.
    • Contains matching fields with General Ledger Entries.