Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Management Reporter Reporting Tree

Posted on by 410

We're stumped.

Have just migrated FRx 6.7 to MR 2.12.16003.25 (CU16).  We initially chose "Data Mart Only" instead of Legacy, but after we noticed this problem, we added Legacy.  ALL is working well, with this *one* exception:

In our Balance Sheet, we have a Row for Year-To-Date Net Income.  When we print it, EVERY DOLLAR AMOUNT on the BS matches our previous FRx report EXCEPT the one row which defines Year-To-Date Net Income (i.e. 4000:9999).   We deleted the row, and re-entered it with the same results.

We created a new Report Definition called Test, and just inserted one row - The Net Income 4000:9999.  When we run this new report WITHOUT using the Reporting Tree, it calculates correctly;  if we run it WITH the Reporting Tree, it gives us a bogus number.

We've looked at the Reporting Tree for hours, but don't see anything wrong with it.  And it would "appear" to be a non-corrupt Reporting Tree since every other line on the Balance Sheet matches to the penny.  It's just this one summary line 4000:9999, both in our original BS and in our Test:  if we use the Reporting Tree it gives a bogus number;  if we do not use the Reporting Tree, it's correct.  


We need some help identifying the problem with our Reporting Tree, but it looks just fine to us.  Suggestions, please!

*This post is locked for comments

  • Trenton Profile Picture
    Trenton on at
    RE: Management Reporter Reporting Tree

    Create a new Row Definition utilizing Edit > 'Insert Rows from Dimensions'.

    Select the Start 4000 & End 9999 for the Main Account dimension.

    Associate this row with your Report and generate the report.

    Comparing these results to the FRx to GP account values should give you a better representation of what account is not as expected.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans