BeyondERP.Newsletter
Menu

Setup page · Consolidations

Additional consolidation accounts

Mappings that assign main accounts from an existing chart of accounts to a consolidation account group, with a consolidation account value and name.

Used by
Accounts payable manager, Budget clerk, Budget contributor and 8 more roles
Business process
Consolidate online in Dynamics 365 Finance
Menu item
MainAccountConsolidateAccount
Main table
MainAccountConsolidateAccount
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 isMappings that assign main accounts from an existing chart of accounts to a consolidation account group, with a consolidation account value and name.
What you do hereUse this page to map each main account to the consolidation account and name that appear on consolidation inquiries and reports.
ExampleFor example, in BEAT the chart of accounts BEAT maps main account 610100 (procurement expense) to group BEAT-CONS with consolidation account G6100 Group operating expenses.
Additional consolidation accounts 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 Additional consolidation accounts1 screen

Use this page to map each main account to the consolidation account and name that appear on consolidation inquiries and reports.

  1. Screen 1

    Map the main account to a consolidation account

    Go to General ledger > Chart of accounts > Accounts > Additional consolidation accounts

    1. Select the chart of accounts
    2. Select New
    3. Enter the main account, consolidation account group and consolidation account
    1Main account610100
    Chart of accountsBEAT
    Consolidation account groupBEAT-CONS
    Consolidation accountG6100
    Consolidation account nameGroup operating expenses
    Map the main account to a consolidation account (zoomed on the outlined fields)
    Show the full screenMap the main account to a consolidation account
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Consolidations > Setup > Additional consolidation accounts.
  2. Select New.
  3. In the Main account field, select the main account to map.
  4. In the Consolidation account group field, select the group.
  5. In the Consolidation account field, enter the account value to consolidate to.
  6. In the Consolidation account name field, enter a name.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Main accountThe main account from the selected chart of accounts that is being mapped; its name fills in automatically.Microsoft Learn 610100MainAccountId
Consolidation account groupThe group the account is added to.Microsoft Learn BEAT-CONSId
Consolidation accountThe value the account consolidates to; it doesn't have to exist in any chart of accounts.Microsoft Learn G6100ConsolidationMainAccount
Consolidation account nameThe account name shown on inquiries and reports.Microsoft Learn Group operating expensesName
SAT levelUsed to report account statements to the Mexican tax authorities.Microsoft Learn 0STULevel_MX
Chart of accountsThe chart of accounts whose main accounts are mapped; the Main account lookup shows its accounts.Microsoft Learn BEAT

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. Select the chart of accounts, then add a line with Main account, Consolidation account group, Consolidation account and Consolidation account name.
  2. If you consolidate in more than one way, add the same main account to each consolidation account group you use.
  3. Run Consolidate online with that group selected.
  4. Check the consolidation account name appears on the consolidation inquiries for the mapped main account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Additional consolidation accountsMap every main account that must consolidate into each consolidation account group you consolidate withEach mapping assigns a main account to one group with a consolidation account and name; if you consolidate in more than one way, the same main account must be added to every group used.Map every account or only some?Mapping an account into one group only and then consolidating with another group, so that account has no consolidation account in the second consolidation.Test: Mapping shows on consolidation

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 maintains the mappings. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the mappings belong to a chart of accounts and a consolidation account group; their entities are shared by all companies in Data management. Checked in Dynamics 365
Can it be undoneReversible: Mappings can be changed at any time and are used when the group is selected in the next Consolidate online run; rerun an earlier consolidation to reprocess it with the new mapping. Microsoft Learn
If you change it laterMappings are used when the group is selected in Consolidate online; changes apply from the next run, and the consolidation account name shows on inquiries and reports. Microsoft Learn
Technical architect

6Technical

Menu itemMainAccountConsolidateAccount Checked in Dynamics 365
FormMainAccountConsolidateAccount Checked in Dynamics 365
TableMainAccountConsolidateAccountShown as “MAIN ACCOUNT CONSOLIDATION ACCOUNT” in Record infoChecked in Dynamics 365
Data entitiesLedgerConsolidateAccountGroupEntityConsolidation groups and accounts Microsoft data model LedgerConsolidateAccountGroupV2EntityConsolidation main accounts Microsoft data model
Who can open itPrivilegesMaintain main account consolidation accounts MainAccountConsolidateAccountMaintainView main account consolidation accounts MainAccountConsolidateAccountViewDutiesInquire 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=MainAccountConsolidateAccount
Integrate withLedgerConsolidateAccountGroupEntity data entity Microsoft data model
Data migrationLedgerConsolidateAccountGroupEntity (Consolidation groups and accounts): shared; chart of accounts, main account, group, consolidation account and name, SAT level.LedgerConsolidateAccountGroupV2Entity (Consolidation main accounts): shared; the same mapping with main account type and category.Load order: Microsoft's template 020 - GL Shared loads Consolidation groups and accounts at execution unit 1, level 20, sequence 30, after the chart of accounts and main accounts.Load first: Chart of accounts, Main accountsChecked in Dynamics 365
Table definitionMainAccountConsolidateAccount columns and relations Microsoft data model
Everyone

8Sources