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

Dimensions on Intercompany transactions to aid Consolidation eliminations

(6) Share

Report

Posted on by Curator

287

Hello all

Can somebody help me identify a process whereby you can set intercompany dimensions on the intercompany partner or on the customer/vendor card of the intercompany partner and use that in the consolidation company for performing GL eliminations? I believe this is a process that can be used to quickly identify transactions for eliminations. If yes, it would be great if somebody has a documented process or a helpful process as to how this could be setup on both the subsidiary and consolidate companies in Business Central.

The preference is on a real world experience rather than an AI generated answer, please.

Many thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

OussamaSabbouh 12,808 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

BC doesn’t auto-carry “intercompany dimensions” into consolidation.

The real-world method is:

1. Subsidiary companies:

Add a dimension like ICPARTNER = SUB1 / SUB2

Put it as a Default Dimension on the IC Customer/Vendor

Make it mandatory with Dimension Rules

→ every IC invoice/journal gets tagged.

2. Consolidation company:

Import G/L entries with dimensions

Use that dimension to filter elimination entries.

That’s the actual process most companies use.

Regards,

Oussama Sabbouh

Was this reply helpful? Yes No
Curator 287 on at

Like (2)

Report
Copy link

Link copied!

There is a dimension code on the IC Partner which could be set as default - has anybody used that? Because with IC vendor or customer, it will not default on an interco journal for example.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

Namaste @Curator

We have implemented same dimension code in all companies . We created Business units and maintained same standard dimension in all companies . hence we never used below mapping

https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/page/microsoft.intercompany.dimension.ic-dimensions

Warm Regards

Pallavi Phade

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Intercompany Transactions

Mapping equal dimensions between companies in Intercompany - Dynamics 365 Business Central

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

Hello,

To streamline intercompany eliminations in Business Central, set up intercompany dimensions and map them across all companies, assign intercompany partner codes on Customer/Vendor cards, and enable “Include Dimensions” in the consolidation setup so dimension tags flow into the consolidated company.

Use the IC Partner dimension to identify intercompany transactions, then post elimination entries manually (or automate via custom AL code). This ensures consistent dimension tagging for reporting and simplifies identifying balances for elimination during consolidation.

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/intercompany-how-setup

https://archerpoint.com/using-consolidations-in-microsoft-dynamics-365-business-central/

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,157 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Typically you’d use G/L accounts for intercompany eliminations rather than dimensions. Are your intercompany G/L accounts set up correctly? In many cases, if all the intercompany accounts are set up properly, their balances should net to zero and you might not even need to post any eliminations.

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Curator 287 on at

Like (2)

Report
Copy link

Link copied!

Thanks Valetin

You are correct in that the Interco transactions should net to zero (but some do not - different corporate structures, etc) but you always want to be sure and check when it comes to eliminations. Thus, the suggestion of the use of the IC partner dimension code - should it not cover all documents from GL journals to purchase and Sales docs, saving having to input manually on journals and having to set up config for the intercompany partners as customers and vendors with default dimensions. I am seeking an optimum way of identifying (and setting up for identification) such transactions.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

As far as I know, the standard cannot achieve this; you can consider customization.

Thanks.

ZHU

Was this reply helpful? Yes No