web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

(0) ShareShare
ReportReport
Posted on by LLSSysAdmin 245

Hi,

I am recreating a Balance Sheet that was used in FRx with Management Reporter and everything works fine except for the calculation of Comprehensive Income (Loss) in the row format.

In FRx, it reads:  

(40000 TO 90000), /Y

so I have created a row in MR that reads:

 Account Modifier=[/Y]   +Segment2 = [40000:90000]

But the amounts don't match for the month selected.

Can someone tell me what I'm doing wrong?

Thanks in advance,

Lori 

*This post is locked for comments

I have the same question (0)
  • JoshP Profile Picture
    JoshP on at
    RE: Management Reporter

    Hello Lori,

    1. Verify the balance is the same in FRx. If new balances were entered for a period, MR will be reading new data that a static FRx report may not reflect. Re-generate the FRx report to confirm the most recent data is used.

    2. Please verify that the balance for the account range 40000:90000 returns the same balance in MR that is displayed in Dynamics GP when the /Y modifier is not being used in MR.

    3. If the range of accounts does not return the same balance, determine which account/accounts are incorrect in the report. Try putting those accounts on their own row in a test report to see if the behavior is different.

    4. The MR report definition may be set to exclude inactive accounts. Open the report definition, click the Settings tab, click the button labeled "Other...", click the Additional Options tab. Verify the setting for the "Exclude inactive accounts" option. Try unchecking it and generating the report again.

    5. You may also want to verify the MR 2012 version being used, and if on a really old version an upgrade would be recommended. MR 2012 CU12 is the most recent version. You can check the version number under Help | About Management Reporter. You can use the number to compare to the list of versions here:

    Management Reporter feature and version number summary

    blogs.msdn.com/.../management-reporter-feature-and-version-number-summary.aspx

    Please let me know if you continue to have a problem.

    Thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter

    If the column is setup for YTD you may not need the row modifier /Y.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans