BeyondERP.Newsletter
Menu

Setup step on the Consolidate online page · Consolidations

Run the online consolidation

Use this page to consolidate daily balances for selected accounts and dimensions into the consolidation company, and to review, rerun or reverse earlier consolidation runs.

Business process
Consolidate and eliminate financials
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic page in the consolidation company where you run online consolidations of legal entities and keep a history of each run.
What you do hereUse this page to consolidate daily balances for selected accounts and dimensions into the consolidation company, and to review, rerun or reverse earlier consolidation runs.
ExampleFor example, BEAT's consolidation company runs a template that consolidates its two subsidiaries for 1 to 31 October 2026 with Rebuild balances on, and the Consolidation history tab then shows one line for each of the two legal entities.
Consolidate online 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.

Setup steps on this page

Run the online consolidation

Use this page to consolidate daily balances for selected accounts and dimensions into the consolidation company, and to review, rerun or reverse earlier consolidation runs.

Steps from Microsoft

  1. Go to Consolidations > Consolidate online.
  2. On the Action Pane, select Perform consolidation.
  3. In the From and To fields, enter the date range for the consolidation.
  4. In the Template field, select the consolidation template.
  5. Optionally set Rebuild balances during consolidation process to Yes and edit the Description.
  6. To run the consolidation as a batch job, set Batch process to Yes.
  7. Select OK, then review the new record on the Consolidation history tab.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
TemplateThe consolidation template that holds the accounts, dimensions, legal entities, eliminations and currency translation for the run.Microsoft Learn BEAT-GROUP
From / ToThe date range that the consolidation covers.Microsoft Learn 10/1/2026 to 10/31/2026
Rebuild balances during consolidation processRebuilds account balances for the consolidation period once the run completes.Microsoft Learn Yes
DescriptionText for the run; defaults to the template name.Microsoft Learn October 2026 group consolidation
Batch processRuns the consolidation as a batch job.Microsoft Learn Yes
NotesFree-text notes about a run or its review, editable until the record is marked Reviewed.Microsoft Learn Reviewed with the auditors
ReviewedMarks a consolidation record as reviewed, after which notes can no longer be entered.Microsoft Learn Yes
Show reversedIncludes reversed consolidation records in the grid.Microsoft Learn No

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
The trial balance doesn't show the consolidated balancesRun Rebuild balances for the consolidation period, or set Rebuild balances during consolidation process to Yes when you perform the consolidation. Microsoft Learn
The trial balance of the consolidation company shows doubled balances after a consolidation stopped part-wayRun Consolidations > Detect and recreate missing consolidation transactions for that period, then review and remove the incomplete transactions on Consolidation transactions. Microsoft Learn
Consolidation templates can't be selected on Perform consolidationTurn on the Consolidate online using templates feature in Feature management, then set up the templates from the Action Pane of Consolidate online. Microsoft Learn
Opening balances are missing in the consolidation companyOnly operating balances are consolidated. Run the year-end close in the consolidation company to get opening balances there. Microsoft Learn

Test checklist

  1. In the consolidation company, select Perform consolidation, pick the template and a one-month From/To range, and set Rebuild balances during consolidation process to Yes.
  2. Check that the Consolidation history tab shows one line per legal entity with the template and dates.
  3. Open Transactions > Actuals for one line and compare the total with that company's trial balance for the month.
  4. Select Reverse transaction on a test run and check Show reversed lists it with a Reversed date/time.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the online consolidationRun one template per consolidation company and period, with Rebuild balances during consolidation process set to Yes, and mark each run Reviewed after checking it.The rebuild limited to the From and To dates keeps the trial balance right, and Reviewed records closes the notes for audit while Reverse transaction stays possible.Consolidate online or with Financial reporting?Closing the subsidiaries' periods before the consolidation is complete, or forgetting the rebuild so the trial balance looks wrong.Test: Online consolidation matches the source

Feature management and licence

Feature to turn onConsolidate online using templates (Needed for templates)Performance enhancement for large consolidations (Optional, for batch runs)
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 accountant runs the consolidation and marks it Reviewed; the controller reviews it.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyAcross legal entities: it runs in the consolidation company and collects the legal entities named on the template, each with its ownership percentage. Microsoft Learn
Can it be undoneReversible: Reverse transaction removes a run's transactions, even for reviewed records; Rerun consolidation reprocesses it.
If you change it laterConsolidated balances do not follow source changes automatically; you must run the consolidation again whenever the source legal entities change, and a rerun removes and reprocesses the earlier run's transactions. Microsoft Learn
Developer

6Developer

Data migrationLoad order: Consolidate online has no data entity in Data management, so it can't be loaded from a file or a configuration template. Consolidated balances are results, not master data: run the consolidation again in the new environment after the source companies' balances are there.Checked in Dynamics 365
Everyone

7Sources