Skip to main content

Notifications

Community site session details

Community site session details

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

Multiple localization Production Tenant and then consolidate the Financial Reports

(0) ShareShare
ReportReport
Posted on by

Hi!

Does anybody know what the best way is to consolidate Financial Data from multiple localzation production tenants?

My case:

  1. three environments with different localization's
  2. in each environment we have one company (CH, CH Company, FR, FR Company, IT, IT Company)

Is there a way  to use the company consolidation functionality over multiple tenants ?

Should we use Power BI and create a consolidate report with the available API's ?

Thank you so much for your help

Best regards

Selina

  • Suggested answer
    Dallefeld Profile Picture
    175 User Group Leader on at
    RE: Multiple localization Production Tenant and then consolidate the Financial Reports

    The consolidation lets to consolidate to companies within one database AND it lets you consolidate from various tenants or databases. When you run consolidation for your situation, you need to make sure the Company Name matches from you other tenant, the field is editable and you do not have to pick from the list of companies. Next, use Actions, Functions and do Export File. In your receiving tenant, use the Actions, Functions, Import File.

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

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

Featured topics

Product updates

Dynamics 365 release plans