MR Migrations from FRx prints zeroes for all consolidations

(0) Share

Report

Posted on by Richard Wheeler

75,788 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:

Microsoft Dynamics GP

All responses (4)

Answers (1)

Richard Wheeler 75,788 Moderator on at

Like (0)

Report

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 2,586 on at

Like (0)

Report

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 75,788 Moderator on at

Like (0)

Report

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 2,586 on at

Like (0)

Report

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?