Skip to main content

Notifications

Announcements

No record found.

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

Management Reporter for Analytical Accounting

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello All,

I have deployed the Management Reporter for more than 20 customers so far with a very big satisfaction rate, however I noticed many issues when using the product with Analytical Accounting, I never been able to get correct figures when having AA loaded into the reports.

We have recentely activate the management reporter for one of our customers, who is using Analytical Accounting to distirbute and manage cost centers accounting and to manage budget for each cost ceter.

We have installed Management Reporter, with SP1 then installed AA Hot Fix then installed FP and SP2, unfortunately non of them been able to bring correct analytical accounting figures.

1. The customer is using Analytical Accounting Budgeting to distribute budget for each cost center over each account, specifying the budget combinations not pulling the budget for the AA code over the selected account.

2. In row format when you specify a combination between Account and AA, figures were not calculated correctly.

3. When you use the account code in Row and use the AA filter in "column" figures are not being pulled correctly.

4. After applying SP2, clicking the "Generate Report" button is taking 30 seconds to be released.

Any body been into such an issues before?

Regards,

Mohammad R. Daoud

*This post is locked for comments

  • Khurram Atif Sattar Profile Picture
    Khurram Atif Sattar 20 on at
    RE: Management Reporter for Analytical Accounting

    Have you gotten your results? Because we are facing same sort of issue.

    Khurram A. Sattar

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter for Analytical Accounting

    Thanks, I will check and get back to you.

  • Cory Severson Profile Picture
    Cory Severson 695 on at
    Re: Management Reporter for Analytical Accounting

    Hello,

    MR is more restrictive than FRx and we expect this to change in the future.  The one problem is MR looks for matches in the CURRENCYID between the GL tables.  If you run the following scripts and get results with any of them there are mismatches that need to be updated.

    /*

    Finds records in the Open AA tables where the Currency ID does not match the Open GL tables.

    */

    SELECT a.CURNCYID, *

    FROM   AAG30001 a

          JOIN AAG30000 b

            ON a.aaGLHdrID = b.aaGLHdrID

          JOIN GL20000 c

            ON b.JRNENTRY = c.JRNENTRY

               AND b.GLPOSTDT = c.TRXDATE

               AND b.aaGLTRXSource = c.TRXSORCE

               AND a.ACTINDX = c.ACTINDX

               AND a.CURNCYID <> c.CURNCYID

    /*

    Finds records in the Open GL tables where the Currency ID does not match the Open AA tables.

    Data found should be the same as the script above.

    */

    SELECT c.CURNCYID, *

    FROM   GL20000 c

          JOIN AAG30000 b

            ON b.JRNENTRY = c.JRNENTRY

               AND b.GLPOSTDT = c.TRXDATE

               AND b.aaGLTRXSource = c.TRXSORCE

          JOIN AAG30001 a

            ON a.aaGLHdrID = b.aaGLHdrID

               AND a.ACTINDX = c.ACTINDX

               AND a.CURNCYID <> c.CURNCYID      

    /*

    Finds records in the History AA tables where the Currency ID does not match the History GL tables.

    */

    SELECT a.CURNCYID, *

    FROM   AAG40001 a

          JOIN AAG40000 b

            ON a.aaGLHdrID = b.aaGLHdrID

          JOIN GL30000 c

            ON b.JRNENTRY = c.JRNENTRY

               AND b.GLPOSTDT = c.TRXDATE

               AND b.aaGLTRXSource = c.TRXSORCE

               AND a.ACTINDX = c.ACTINDX

               AND a.CURNCYID <> c.CURNCYID

    /*

    Finds records in the History GL tables where the Currency ID does not match the History AA tables.

    Data found should be the same as the script above.

    */

    SELECT c.CURNCYID, *

    FROM   GL30000 c

          JOIN AAG40000 b

            ON b.JRNENTRY = c.JRNENTRY

               AND b.GLPOSTDT = c.TRXDATE

               AND b.aaGLTRXSource = c.TRXSORCE

          JOIN AAG40001 a

            ON a.aaGLHdrID = b.aaGLHdrID

               AND a.ACTINDX = c.ACTINDX

               AND a.CURNCYID <> c.CURNCYID

    If you see differences the following will update your AAG tables to match the GL tables.

    /*

    Updates records in the Open AA tables

    Sets the Currency ID and Currency Index to match the GL Open tables

    */        

    UPDATE a

    SET    a.CURNCYID = c.CURNCYID,

          a.CURRNIDX = c.CURRNIDX

    FROM   AAG30001 a

          JOIN AAG30000 b

            ON a.aaGLHdrID = b.aaGLHdrID

          JOIN GL20000 c

            ON b.JRNENTRY = c.JRNENTRY

               AND b.GLPOSTDT = c.TRXDATE

               AND b.aaGLTRXSource = c.TRXSORCE

    /*

    Updates records in the History AA tables

    Sets the Currency ID and Currency Index to match the GL History tables

    */            

    UPDATE a

    SET    a.CURNCYID = c.CURNCYID,

          a.CURRNIDX = c.CURRNIDX

    FROM   AAG40001 a

          JOIN AAG40000 b

            ON a.aaGLHdrID = b.aaGLHdrID

          JOIN GL30000 c

            ON b.JRNENTRY = c.JRNENTRY

               AND b.GLPOSTDT = c.TRXDATE

               AND b.aaGLTRXSource = c.TRXSORCE

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter for Analytical Accounting

    Thanks Cory for your prompt reply, the SP 2.0 is already applied and the customer still have issues, I will do a fresh installation to double check and confirm back to you.

    I am more concerned about the AA differences, the figures in the report does not match the actual and AA budgets when used to combine AA codes with accounts are not shown in the report, any ideas how to get this checked?

    Worth to mention that I have activated the FRx with AA and managed to get the same report to operate as expected.

  • Cory Severson Profile Picture
    Cory Severson 695 on at
    Re: Management Reporter for Analytical Accounting

    Hello Mohammad,

    Here are the answers to your questions.  I guess first, I would make sure you have applied SP 2 to the installation.

    There are also a few issues where MR is more restrictive on the values it pulls and there are some scripts we can provide to ensure the currency id's are the same between the GL and AAG tables.

    Actually, after reading your post the latest SP 2 will hopefully resolve your issues.  The latest fix also resolved the generate report issue.

    Give that a try and let me know what you see after that.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans