web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter - ...
Microsoft Dynamics GP (Archived)

Management Reporter - Balance Sheet Rounding

(0) ShareShare
ReportReport
Posted on by Tim Foster 8,515

I have a migrated Balance Sheet report that is misbehaving.

The Row Definition is what you would expect a Balance Sheet to look like.  There are two particular rows (Cash and Taxes) that are non-printing (NP) with following rows with formulas to position those amounts in Assets or Liabilities, depending on their balance.  Balance Sheet Rounding is setup.

The Column Definition is A-Actual YTD, B-YTD Budget, C=B-A (Variance), D=C/B (Variance Percentage).

When the Report is run, Column A and B are fine.  In Column C the Balance Sheet Rounding sees the CAL Rows (Cash and Taxes) differently from the Linked Rows and assigns their value to the row specified in the Balance Sheet Rounding Setup creating a huge variance.  The report does not foot row-wise.

This report worked fine in FRx.  Has anyone else faced this problem in MR?  Suggestions?

Thanks

Tim Foster

*This post is locked for comments

I have the same question (0)
  • Tim Foster Profile Picture
    Tim Foster 8,515 on at

    Bump!

  • Suggested answer
    April Olson Profile Picture
    April Olson on at

    Hello Tim,

    Can you verify you are running Management Reporter SP2? There was a rounding issue fixed with CAL rows with SP2 and it sounds like you are running into it. To clarify, the client and the provider both need to be on SP2.

    Thanks,

    April

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at

    April,

    I am on MR SP2.  Client is 2.0.1700.31 (SP2).  Provider is 11.0.4 (SP2).

    Your response led me to look at the Management Reporter for Microsoft Dynamics ERP Installs and Service Packs Overview page.  It looks like you're up to 2.0.1700.66 as of October 19.  Is that where the "fix" you're talking about is?  (I'm downloading now.)

    Thanks.

    Tim

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at

    Update:

    I am now on MR SP2 (October Update).  Client is 2.0.1700.66.  Process Service is 2.0.1700.66.  Application Service is 2.0.1700.66.  Provider on Application Service and Application Service is 11.0.4 (freshened with SP2 October).

    Sadly, the results are the same.  No improvement.

    Tim

  • April Olson Profile Picture
    April Olson on at

    Hello Tim,

    I do not see any other known issues and I don't think the calcualtion priority would address it. I would suggest contacting support at this point so they can hands on see the issue and help troubleshoot it.

    Thanks,

    April

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at

    April,

    The patch and a change in calculation priority did address it.  The original calculation priority was:

    1. Rollup values in reporting tree
    2. Apply rounding
    3. Perform calculations

    This was the way the report was migrated from FRx.

    This morning, I changed it to:

    1. Rollup values in reporting tree
    2. Perform calculations
    3. Apply rounding

    It worked! 

    We had tried calculation priority on the previous patch (31), but it had no effect.

    Thanks for your help.

    Tim

  • April Olson Profile Picture
    April Olson on at

    Well, that's great news!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans