Setting Up, Using, and Reporting on Consolidations in Business Central
In this how-to video, UG Expert Jo deRuiter explains how to set up, use, and report on consolidations in Dynamics 365 Business Central.
Agents & Copilots are defining the future of Dynamics, CRM, Power Platform, Azure, Fabric, and more. Register for Community Summit NA 2025, running October 19-23 in Orlando, FL, to explore and discover what this means to you.
Highlights
00:18 — For the example, Jo creates two sample companies — Cronus US and Cronus USA Inc — to demonstrate how to consolidate them. The setup of one of the source companies will be similar to a Chart of Accounts level. Additionally, in her setup, the G/L account of the source company should match the G/L account of the consolidating company. Lastly, she notes that the setup of the Chart of Accounts for all accounts you wish to roll into the consolidating company.
03:29 — Next, follow the process of consolidations, which the system will guide you through. There are different parameters per consolidation, and different fields indicating various aspects.
06:07 — The data import aspect is highly important for consolidations, explains Jo. Once the source company matches the consolidation company, it’s time to run the consolidation. Once the process has run through, Business Central will let you know if the consolidation was successful, and users can run the consolidated trial balance.
