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 / Microsoft Dynamics AX (Archived) / Consolidated Trial Bal...
Microsoft Dynamics AX (Archived)

Consolidated Trial Balance

(0) ShareShare
ReportReport
Posted on by accountinguser2018 151

Hello,

I'm trying to pull a trial balance for 2 entities, with one tab on the output Excel workbook showing the entities consolidated (each account from all entities has a separate row) and also a column specifying which entity the account and balance pertains to. In other words, I'm trying to eliminate some manual work. Is this possible?

Thank you.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,706 Super User 2026 Season 1 on at

    Hi accountinguser2018,

    I don't know all details of Management Reporter in depth. Usually, consolidated reporting is done from within a consolidation company. Have you considered using the standard features for a consolidation company?

  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at

    Thanks for your reply. I am unsure which standard features you're referring to.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    It should be possible to show the data from the different legal entities in separate columns.

    This can be achieved e.g. by making use of a reporting tree that has the different companies included and by referencing the tree elements in the column definition.

    You can find a couple of examples on this blog

    [View:https://blogs.msdn.microsoft.com/dynamics_financial_reporting/]

    Best regards

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello accountinguser2018,

    I am wondering whether you have been able to get this issue resolved?

    Would be great if you could keep us updated here.

    Many thanks and best regards,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans