Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Management reporter not show accurate values

Posted on by Microsoft Employee

Hello,

I noticed that if I run management reporter report it doesn't show correct value with what I have on gp.

Note that I selected the same period. And am also looking at the same GL account number on management reporter and on GP .

Please how do I resolve this.

Thank you

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter not show accurate values

    Hi Funmilayo,

    if the above suggestion from any of the post resolves your issue, please mark that answer as verified. so that it may help the others to solve the same issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter not show accurate values

    @Nataraj

    Thanks I have rebuilt the datamart and its fine now.

    God bless you

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter not show accurate values

    I have seen some cases with one of my customers who has AA installed that some records are missing the "Currency Index" field in GL20000 table and AAG, you might to check this if you have Analytical Accounting installed.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter not show accurate values

    Hi Funmilayo,

    I guess this has to be done to proceed further.

    Take a complete backup & export all the reporting blocks. re-built the data mart & re import all the reporting blocks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter not show accurate values

    @Nataraj Thanks for response.

    One of the solutions says I should re-build my Data mart. if I do that will I lose the reports already designed and redesigned all over again.

    Thank you

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter not show accurate values

    Hi FUNMILAYO,

    have you find the issue using Drill through Dynamics option by clicking the amount value in MR report?

    please find the attached community forum link that may give some idea related to this.

    community.dynamics.com/.../103611.aspx

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans