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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Dimensions into Consolidation Company

(3) ShareShare
ReportReport
Posted on by 32
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.
 
 
I have the same question (0)
  • Verified answer
    Sohail Ahmed Profile Picture
    11,150 Super User 2025 Season 2 on at
    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.
     
     
  • Verified answer
    Mansi Soni Profile Picture
    8,911 Super User 2025 Season 2 on at
    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

     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,962 Super User 2025 Season 2 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,116

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 764 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 635 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans