Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Management Reporter Consolidated Statements return zeroes for values

(0) ShareShare
ReportReport
Posted on by 75,848 Moderator

I just migrated a series of reports from FRx to Management Reporter. All reports use a reporting tree. When I print a consolidated report all values returned are zero. However, if I print a report for any of the branches of the tree there is the data.What is causing this and how do I correct this? This is MR CU 16 with GP 2018 R2.

Categories:
  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Management Reporter Consolidated Statements return zeroes for values

    I think I see what is going on. MR has Dimension Sets and FRx does not. In the tree for the consolidated row it is set to DIVISION = [000]. If I print out a trial balance for that segment there are hundreds of journal entries and the debits equal the credits for a balance of zero. There is also a Financial Dimensions Link column and they are all populated with GL1. I have no idea what that means. I would appreciate any insight on this and if I am on the right track. I need to research what the Dimensions and Financial Dimensions Link columns do.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans