Small and medium business | Business Central, N...

Consolidation company dimensions mapping when different from subsidary dimensions

(6) Share

Report

Posted on by CU23101632-0

In a Consolidation company, I am attempting to map Dimensions from various subsidiary companies into one dimension value in the consolidation company.

For example, the subsidiary dimension values might be Wales, England, Scotland but in the Consolidation company I want this to be Great Britain. It's not clear where to map this in BC.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Teagen Boll 1,013 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

I don't know of a method to translate dimensions in a consolidation but you can perform dimension corrections after the consolidation as an extra step. You can take all dimension values that show Wales, England and Scotland and change them to Great Britain.

The links below describe how to correct them:

Troubleshoot and correct dimensions - Business Central | Microsoft Learn

Big Changes Are Coming: Dimensions in Dynamics 365 Business Central

You could run this for all entries at once too, it wouldn't have to be one by one.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 10,875 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Business Central does not map dimensions automatically during consolidation.

To map multiple subsidiary values (Wales, England, Scotland) into one consolidated value (Great Britain), use:

“Dimension Value Mapping”

This lets you define:

Subsidiary dimension value → Consolidation dimension value

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,292 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Namaste @CU23101632-0

Business Units are important part for consolidation

. GLs are mentioned in Chart of Accounts which need to be mapped .

dimensions are not auto mapped as feature of consolidation .

For mapping Dimensions if there is variance , kindly use " Intercompany Dimension Values Mapping"

Best Practice

Keep Standardization of Dimensions .

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,666 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

In Business Central, dimension mapping for consolidation is done in the Business Unit Card under the Dimensions section, where you manually link each subsidiary dimension value (e.g., Wales, England, Scotland) to a single consolidated value (e.g., Great Britain) in the consolidation company.

This mapping ensures that when you run the consolidation process, all entries from subsidiaries post with the correct consolidated dimension values, but note that BC does not automatically group values—you must define each mapping explicitly.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,935 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

This is supported with standard functionality. If you personalize the Dimensions page, you can add the Consolidation Code field, and the same applies to the Dimension Values page. You can set up your mapping directly there.

There’s no need for any extra steps during consolidation, the system handles it automatically.

More information here - Set up company consolidation - Business Central | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No