Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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... / Dimensions into Consol...
Small and medium business | Business Central, N...
Answered

Dimensions into Consolidation Company

(2) ShareShare
ReportReport
Posted on by MikeyintotheBusines... 8
Hi Folks,
 
I am new to Consolidation, and I have check out all the available material over forum and Microsoft learn but am not getting the suitable answer.
 
My request it to do the consolidation - for which I have two companies where the Intercompany Transactions will takes place and there is one Holding Company where the consolidation process takes place.
Both the companies are having common Chart of Accounts as well as Dimensions & Dimension Values.
 
1) I would like to know what to do the to bring over the dimensions & its values into Holding Company ?
Do I need to create the Dimensions & Dimension values in the Holding Company and configure it in General Ledger Setup, similar to subsidiary companies.
 
2) What is "Consolidation Code" in Dimension & Dimension Value page and how does it affect my consolidation process if I do not configure it.
 
 
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 17,377 Super User 2025 Season 1 on at
    Dimensions into Consolidation Company
  • Verified answer
    Mansi Soni Profile Picture
    Mansi Soni 3,391 on at
    Dimensions into Consolidation Company
    Hello,

    1) How to bring over the dimensions and their values into the Holding Company:

    To bring Dimensions and their values into the Holding Company in Business Central, you must manually create the same Dimensions and Dimension Values that exist in your subsidiary companies. Even though all companies use a common structure, Business Central treats each company as a separate entity, meaning data like Dimensions and Values are not automatically shared or replicated. Once created, configure the relevant Dimensions in the General Ledger Setup in the Holding Company to ensure proper filtering and analysis during the consolidation process.

    2) What is Consolidation Code in the Dimension and Dimension Value pages and its impact:

    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.

    Hope this will help you!

    Regards,
    Mansi Soni

     
  • Verified answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 3,297 on at
    Dimensions into Consolidation Company
    Maybe this will help you move forward.
     
    1. Bringing Dimensions into the Holding (Consolidation) Company
     
    Yes, you need to manually create the same Dimensions and Dimension Values in the Holding Company, and configure them in General Ledger Setup, just like in the subsidiaries. Business Central does not automatically copy dimensions during consolidation — it only transfers dimension codes and values that match in both companies.
     
    So:
     
    Ensure dimension codes and values are identical (case-sensitive).
     
    Setup must be done before you run the consolidation.
     
     
    2. What is “Consolidation Code”?
     
    The Consolidation Code in the Dimension and Dimension Value pages is used to map dimension values between companies when they differ.
     
    Use this if your subsidiary and holding companies use different dimension codes or values, but you want them to consolidate correctly.
     
    If dimension values are the same across companies, you don’t need to set this field.
     
     
    If not configured, BC assumes the values are already matching. If they don’t, those dimensions won’t be included in the consolidation.
     
    Mark below checkbox to make this answer Verified if it helps you. Let me know if you need help setting up the consolidation mapping.
     
     

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans