BeyondERP.Newsletter
Menu

Setup page · Consolidations

Consolidation account groups

Groups of accounts used to consolidate data.

Used by
Accounts payable manager, Budget clerk, Budget contributor and 8 more roles
Business process
Consolidate online in Dynamics 365 Finance
Menu item
LedgerConsolidateAccountGroup
Main table
LedgerConsolidateAccountGroup
Data entity
LedgerConsolidateAccountGroupEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isGroups of accounts used to consolidate data.
What you do hereUse this page to create account groups, each with an identifier and name, that are selected in the Consolidate online process.
ExampleFor example, BEAT uses group BEAT-CONS for group reporting and maps main account 610100 to consolidation account G6100 in it on Additional consolidation accounts.
Consolidation account groups page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Consolidation account groups1 screen

Use this page to create account groups, each with an identifier and name, that are selected in the Consolidate online process.

  1. Screen 1

    Create the consolidation account group

    Go to General ledger > Chart of accounts > Accounts > Consolidation account groups

    1. Select New
    2. Enter the group code BEAT-CONS and its name
    NameGroup reporting
    Create the consolidation account group (zoomed on the outlined fields)
    Show the full screenCreate the consolidation account group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Consolidations > Setup > Consolidation account groups.
  2. Select New.
  3. In the Consolidation account group field, enter a unique ID for the group.
  4. In the Name field, enter a name.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Consolidation account groupA unique ID for a group of accounts used to consolidate, often a government-mandated chart of accounts.Microsoft Learn BEAT-CONSId
NameThe name of the consolidation account group.Microsoft Learn Group reportingName

Common errors and fixes

MessageWhat to do
The consolidation stops with an error because account numbers don't correspondWith a shared chart of accounts set Use consolidation account to No; otherwise set the Consolidation account on each subsidiary main account, or use a consolidation account group, and set Use consolidation account to Yes. Microsoft Learn

Test checklist

  1. Create a group with a unique identifier and a name, for example one for the statutory chart of accounts.
  2. Map main accounts to it on Additional consolidation accounts.
  3. Select the group in the Consolidate online process and run a consolidation for one month.
  4. Check the consolidated transactions use the consolidation account values of the group.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Consolidation account groupsOne group per target chart, typically a government-mandated chart of accounts or the chart defined by group headquartersLearn describes a consolidation account group as typically representing a government-mandated chart of accounts, or a mapping to a chart that headquarters defines.Consolidation account on the main account, or groups?Creating the group and mappings but not selecting the group when you run Consolidate online, so the consolidation doesn't use the mapping.Test: Group drives consolidated accounts

Feature management and licence

Licence or add-inConsolidations is part of General ledger in Dynamics 365 Finance. In this system Accountant, Accounting manager, Accounting supervisor, Chief financial officer and Financial controller hold the consolidation duties. The controller defines the groups. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: both consolidation group entities are shared by all companies in Data management, and the group is chosen on each consolidation template. Checked in Dynamics 365
Can it be undoneReversible: Groups can be added or renamed at any time. A group is selected when you run Consolidate online, so a change takes effect on the next run; earlier runs can be rerun to reprocess their transactions. Microsoft Learn
If you change it laterA group is selected on the consolidation template; changing its mappings changes where balances land on the next run, and earlier runs must be rerun to follow. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerConsolidateAccountGroup Checked in Dynamics 365
FormLedgerConsolidateAccountGroup Checked in Dynamics 365
TableLedgerConsolidateAccountGroupShown as “CONSOLIDATION ACCOUNT GROUP” in Record infoKey field: IdChecked in Dynamics 365
Data entitiesLedgerConsolidateAccountGroupEntityConsolidation groups and accounts Microsoft data model LedgerConsolidateAccountGroupV2EntityConsolidation main accounts Microsoft data model
Who can open itPrivilegesMaintain consolidation account groups LedgerConsolidateAccountGroupMaintainView consolidation account groups LedgerConsolidateAccountGroupViewDutiesInquire into chart of account master LedgerChartOfAccountsInquireMaintain chart of accounts master LedgerChartOfAccountsMaintain
11 security rolesBudget clerk BudgetBudgetClerkBudget contributor BudgetBudgetContributorBudget manager BudgetBudgetManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerTo use itAccountant LedgerAccountantChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerBudget clerk BudgetBudgetClerkBudget manager BudgetBudgetManagerGive people one of these roles. On this system, 11 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=LedgerConsolidateAccountGroup
Integrate withLedgerConsolidateAccountGroupEntity data entity Microsoft data model
Data migrationLedgerConsolidateAccountGroupEntity (Consolidation groups and accounts): shared by all companies, in Microsoft's default template 020 - GL Shared.LedgerConsolidateAccountGroupV2Entity (Consolidation main accounts): shared by all companies.Load order: Microsoft's default template 020 - GL Shared loads Consolidation groups and accounts at execution unit 1, level 20, sequence 30. Lower levels load first, and entities at the same level load in sequence order.Load first: Chart of accounts, Main account, the default templates at lower levels (System setup to Global address book)Microsoft Learn
Table definitionLedgerConsolidateAccountGroup columns and relations Microsoft data model
Everyone

8Sources