web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Companies having diffe...
Small and medium business | Business Central, N...
Suggested Answer

Companies having different Dimensions in Business

(6) ShareShare
ReportReport
Posted on by Revan Jaunt 375
Hi everyone,
I have a few queries about consolidating a company in Business Central.
There are two companies. I want to consolidate company A and B.
In Company A, Global Dimension 1 and 2 are Branch and Department, respectively, and there is also a Shortcut Dimension 3 called Product.
But in Company B, Global Dimension 1 is Department, Global Dimension 2 is Product, and Shortcut Dimension 3 is Branch.
I have also created a consolidation company where the GD1, GD2, and SD3 are configured as in company A.
Now, my worry is if I consolidate company A and B, including dimensions, will my G/L account balances consolidate by picking up the right values related to GD1, GD2, and SD3 from company B? Or will there be any inconsistency?
Please help.
Thanks.
Categories:
Dynamics 365 Business Central
Microsoft Dynamics NAV
I have the same question (0)
  • Suggested answer
    Andrés Arias Profile Picture
    Andrés Arias 5,168 Super User 2026 Season 1 on at
    Hello,

    According to Business Central standard, it does not do it automatically. It works according to each dimension.
     
    I hope the following links can help:
     
     
    I hope I can help.
     
    Regards,

    Andres
     
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    Jeffrey Bulanadi 9,116 Super User 2026 Season 1 on at
    Hi Revan

    Since Company B uses a different dimension structure than your consolidation company, you’ll need to use Consolidation Codes to make sure the dimension values line up properly

    Here’s what you can do
    • In Company B, go to each Dimension Value and fill in the Consolidation Code field with the matching value from Company A’s setup
    • This tells Business Central how to translate the dimension values during consolidation so they align with the consolidated company’s GD1, GD2, and SD3
    • Without this mapping, the system will try to consolidate based on raw values, which could lead to mismatches or missing dimension data
    • You can preview the consolidation before posting to make sure the mappings are working as expected

    There’s a helpful guide that walks through this setup step by step Set up company consolidation - Business Central

    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,132 Super User 2026 Season 1 on at
  • Suggested answer
    Mansi Soni Profile Picture
    Mansi Soni 9,069 Super User 2026 Season 1 on at
    Hello @Revan Jaunt,

    The Consolidation Code in the Dimension and Dimension Value pages is used to map Dimension Values across multiple companies during consolidation, especially when the values differ in naming or structure between subsidiaries. This field allows you to define a unified code that the Holding Company will use to aggregate and align data coming from different sources. For example, if one subsidiary uses Dept-Sales and another uses DPT-S for the same department, you can assign a common Consolidation Code like SALES to both. This ensures that during the consolidation process, Business Central recognizes these as the same value and consolidates them correctly. If you do not configure the Consolidation Code and your Dimension Values vary between companies, the system may fail to align them properly, leading to incomplete or inaccurate consolidated reports. However, if your Dimension Values are exactly the same across all companies, using the Consolidation Code is optional, as Business Central will naturally map matching values without additional configuration.

    https://community.dynamics.com/forums/thread/details/?threadid=90715e34-b837-f011-8c4e-7c1e52588498

    Hope this answer will help you!

    Regards,
    Mansi Soni

     
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 26,108 Most Valuable Professional on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,957 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 956 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 645 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans