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 :
Finance | Project Operations, Human Resources, ...
Unanswered

Consolidation in D365 FO (MR)

(0) ShareShare
ReportReport
Posted on by

The consolidation (D365 FO) in Management reporter doesn't show transactions or report. The report generate 

Consolidation is setup as below:

1 – A consolidation Legal entity is created in the system for reporting purpose. this company doesn't contain posted transactions.

2 – Setup Chart of Accounts (the same COA of subsidaries) , number sequence, fiscal period, currency for the newly created legal entity

3- Creating in Management reporter : report definition with row and column definition and a reporting tree 

pastedimage1646144999645v2.png

but when generating the report it shows

pastedimage1646144820212v1.png

Also the trial balance doesn't show any transaction. 

My question : what is missing to have  transactions and a report with consolidated informations

thanks in advance for your help

Abir

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,627 Moderator on at

    Are you trying to generate a report against the Consolidation company?  Did you execute the 'Consolidate online' process in F&O?

  • Community Member Profile Picture
    on at

    Hello Frank,

    Thank you for your reply

    I choose to do consolidation with MR so I did setup of a report definition (row, column and reporting tree) and I tried to generate reports in a new consolidation company without executing on line consolidate.

    But I don't understand what is missing to consolidate transactions in subsidaries to a consolidated report in the consolidation company

    BR,

    Abir

  • ThangNguyen Profile Picture
    184 on at

    Hi Abir,

    Could you please share your reporting tree setup?

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!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans