Skip to main content

Notifications

Community site session details

Community site session details

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

MR Migrations from FRx prints zeroes for all consolidations

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

I just migrated 5 very complex financials reports from FRx to MR. On every report the consolidated section print zeroes for all rows but when you examine each branch there is data on each row. When I run these reports side by side in FRx the consolidated sections show the accumulated sums. What can I examine to see what is causing this?

Categories:
  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: MR Migrations from FRx prints zeroes for all consolidations

    I agree. This is why I need to discuss this with them and find out exactly what it is they are trying to do. FRx did not have a dimension column so MR is producing different results for the same report as opposed to FRx.

  • Verified answer
    Greg Byer Profile Picture
    2,586 on at
    RE: MR Migrations from FRx prints zeroes for all consolidations

    You don't normally have a dimension on the summary level of a tree.  If they are trying to pull data for dimension 000, it should be a child level.  The summary level should not have a dimension so that the children under it can roll up correctly.  

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: MR Migrations from FRx prints zeroes for all consolidations

    All validation errors were corrected. On all there reports the first line on the try is called Consolidated and in the dimension column is 000. If I remove this entry and run the report I see numbers. I think what they really want this row to show is roll up.

  • Greg Byer Profile Picture
    2,586 on at
    RE: MR Migrations from FRx prints zeroes for all consolidations

    Hi Richard,

    If you create a test tree in MR and use it, do you get data on the summary level?  Have you corrected all the migration/validation errors that were on the tree definition?

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 >

Product updates

Dynamics 365 release plans
Liquid error: parsing "/blogs/post/?postid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.