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... / Designing a Scalable I...
Small and medium business | Business Central, N...
Active Discussion

Designing a Scalable Intercompany Framework in Business Central for Multi-Entity Consolidation?

(2) ShareShare
ReportReport
Posted on by alivedean
Hi Experts,
I’m currently working with Microsoft Dynamics 365 Business Central in a multi-entity environment and exploring best practices for building a scalable intercompany framework.
Our requirements include:
  • Handling multi-entity consolidations across subsidiaries
  • Managing currency fluctuations and exchange rate differences
  • Enabling real-time or near real-time financial reporting
  • Maintaining system performance and data integrity at scale

I’d like to understand:

  1. What architectural approaches or configurations work best for intercompany transactions in Business Central?
  2. How do you handle currency revaluation and consolidation adjustments efficiently?
  3. Are there recommended patterns for integrating reporting tools like Microsoft Power BI without impacting performance?
  4. What are common pitfalls or limitations when scaling intercompany setups?
Any insights, real-world experiences, or recommended design patterns would be highly appreciated.
Thanks in advance!
Categories:
Dynamics 365 Business Central
  • Suggested answer
    AndrewThomas81 Profile Picture
    AndrewThomas81 2,717 Super User 2026 Season 2 on at
  • Suggested answer
    Teagen Boll Profile Picture
    Teagen Boll 3,868 Super User 2026 Season 2 on at
    You really have two approaches for intercompany and consolidation setup in BC. You can opt to go for an out of the box approach or use a multi-entity management solution such as Central Path or Binary Streams. Some considerations and hopefully some answers for your questions for each:
     
    Feature/Comment Out of the Box ISV Solution
    Legal Entity Setup All Separate Companies One Company using a global dimension to separate by entity
    Master Data Management Separate per entity, can sync with BC Master Data Management tool if required (I find this tool a bit clunky) All master data is shared across all entities
    Currency Revaluation Can use a daily currency feed from Float Rates or other services (I use bank of canada) and each entity will have its own currency table One feed and one currency table for easier reconciliation
    Consolidation Adjustments 2 options: (1) - use consolidation functionality in BC and consolidate GL data and then prepare elimination entries in BC or (2) - create consolidated financial statements outside of BC using Power BI, Excel or some other reporting tool All data is inherently consolidated and these tools have processes for elimination entries if needed. 
    Intercompany postings Would need to use standard BC processes which have some limiations but you can sync invoices, journals and some other transactions between each. Automatic IC postings on the fly based on dimension usage in documents.
    Limitations/Pitfalls Once you pass a certain amount of entities it can be harder to manage transactions and data because each legal entity needs to be a separate container (company) in business central Additional licensing costs per user. Data security and user access.
    Reporting Tools Can easily integrate with Power BI but all data sources and reports need to be essentially duplicated based on the number of entities. Can just pull data from one company and filter on the global dimension for each entity quickly and easily.
     
    As someone who has implemented multiple solutions for multi-entity scenarios I almost always go through an analysis process to determine if companies need a multi-entity management tool. There are great tools out there these days that may take some extra setup but unlock a lot of functionality. In my experience you usually want to start exploring these tools as soon as you exceed even 6 or so entities. It will depend on your operations and setup. BC does have some nice tools out of the box but when i've worked with clients who need to manage 100+ legal entities it can be extremely cumbersome to do basic things with standard functionality.
     
    Hopefully that gives you a starting point!
    Teagen Boll, CPA
    Social: LinkedIn
     
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 19,350 Super User 2026 Season 2 on at
    Hello ,
    For a scalable Business Central intercompany setup, I’d keep the design boring and controlled: use separate companies/business units, standard Intercompany for operational IC documents/journals, and a dedicated consolidation company for group reporting; define IC partners, common G/L mapping, dimensions, currencies, and elimination accounts early, because messy mappings are the main source of pain later. For currency, maintain exchange rates properly and use the consolidation setup’s average/closing rates, then post consolidation adjustments/eliminations in the consolidation company rather than touching subsidiary books. For near real-time reporting, Power BI should read through APIs/OData or preferably a reporting layer/data warehouse pattern, not heavy live queries directly against large operational tables all day. Main pitfalls: over-customized IC flows, inconsistent charts/dimensions, weak ownership of exchange rates, no reconciliation process, and expecting consolidation to fix bad subsidiary postings. 
    Regards,
    Oussama Sabbouh

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
AndrewThomas81 Profile Picture

AndrewThomas81 390 Super User 2026 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 386 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans