Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter no...
Microsoft Dynamics GP (Archived)

Management Reporter not Accepting Range

(0) ShareShare
ReportReport
Posted on by Kelly Top 2

I have a Row Definition that is setup with Department [000:300] and Main Account [50000:59999].  When I generate the report with this row, it only displays the GL combinations for main account 50000.  However, when I create a second row (i.e. Department [000:300] and Main Account [50000:59999], Department [000:300] and Main Account [50010])  then both the GL combinations for main account 50000 and 50010 displayed in the report.  

It looks like MR isn't accepting the main account GL range.  But when I break out the main accounts, it will then display in the report.  I have refreshed Data Mart and this didn't resolve the issue.  Is there anything else to check? 

*This post is locked for comments

  • Verified answer
    Kelly Top Profile Picture
    Kelly Top 2 on at
    RE: Management Reporter not Accepting Range

    Thanks everyone for their suggestions and feedback.  The fix was to apply the CU15 Microsoft hot fixes.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter not Accepting Range

    Hi Anonymous,

    Have you tried entering the other segments? (e.g. Company and Business Unit).

    Also, which version of Management Reporter are you using?

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Management Reporter not Accepting Range
    Hi, Please try to reconcile financial and try again.
  • Kelly Top Profile Picture
    Kelly Top 2 on at
    RE: Management Reporter not Accepting Range

    Hi Micki,

    I am not including all departments.  I'm only including some.  Each row is meant for a different department.  I really thought rebuilding Data Mart would work but it didn't.   Any other thoughts?

    Thanks again

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter not Accepting Range

    If you're including all departments, don't include them here - maybe that'll give you what you need

  • Kelly Top Profile Picture
    Kelly Top 2 on at
    RE: Management Reporter not Accepting Range

    Thanks Micki for the response!  Please see the screenshot below:

    10_2D00_24_2D00_2016-4_2D00_05_2D00_03-PM.png

    If I just leave the first row of 50000:59999, it will only displays GL 50000 and all the department combinations.  However, when I add in the second row, it will display 50010.  However GL 50010 should be captured in the first row.  I have checked and there are GLs with the main account 50010 and all the departments in my range specified.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter not Accepting Range

    A screenprint could help us see this

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans