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 &a...
Microsoft Dynamics GP (Archived)

Management Reporter & AA

(0) ShareShare
ReportReport
Posted on by Lisa Sorensen 380

Client recently did a test migration from FRx to Management Reporter using AA. In validating the data, the Balance sheet figures tied out correct. The Income Statement balances did not. The balance does not tie to the data in the GL or in FRx.

We ran the report in FRx and the balance ties to Dynamics GP but in MR, the balance is incorrect and when drilling down to the transaction level, there are several JE transactions that are not included in the balance. None of the accounts in question have AA codes related to them, just basic JE transactions.

I validated that the 'Dynamics GP with AA' option was set for the company but every time I got back to the Company Setup wizard, it shows that 'Dynamics GP' is the option set, as if the 'Dynamics GP with AA' was not set. I checked the Event Logs and there are no errors related to running the report so it is a data issue. But again, the reports run fine in FRx, it is just MR that is not pulling all the data.

Even if I create a basic TB report with a new row and basic column layout, I still don't have the information for GP being pulled into the report.

I know there were a lot of bugs fixed in SP2 related to AA, but they are running MR 2.00.1700.66 on the test server, and I validated that the Provider, Server, and Client are all running the same version.

I thought about running checklinks in GP for the GL, but I know there are issues with running Checklinks for AA in GP 2010 so I am not sure what the next steps would be.

Anyone encounter this before

*This post is locked for comments

  • Funmi Profile Picture
    Funmi on at
    Re: Management Reporter & AA

    Thanks a lot Lisa. I'm presently out of my office, but would run the script as soon as I get back .

    Thanks again!

  • Lisa Sorensen Profile Picture
    Lisa Sorensen 380 on at
    Re: Management Reporter & AA

    Here is the script I was given:

    There is a bug in MR where it is too restrictive on certain items between the GL and AAG tables, specifically the currency code.

    Please run the following against your GP company databases to make sure your codes match.  What the scripts will do is update your AAG to match the GL.

    MAKE A BACKUP OF THE DB's FIRST.

    /*

    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

    The following queries will tell you if there are mismatches.

    /*

    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 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

  • Funmi Profile Picture
    Funmi on at
    Re: Management Reporter & AA

    Hi Lisa, I came across this while I was searching the internet for a solution to a challenge that's exactly as the one you had.

    Please how do I go about getting the script to resolve the issue?

    Thanks.

  • Suggested answer
    Lisa Sorensen Profile Picture
    Lisa Sorensen 380 on at
    Re: Management Reporter & AA

    Hi Ryan, It was the third issue that you discussed related to the bug in MR and currency isn't posting correctly. Another MS Support Technican sent me the script and it resolved the issue.

  • Verified answer
    Ryan Sandness Profile Picture
    Ryan Sandness on at
    Re: Management Reporter & AA

    Hi Lisa,

    There is an issue in the GP Company Wizard where the GP Financials vs. AA option doesn't stay selected when you re-enter. However if you set it previously it will stay selected. A few things for you to check:

    1. Try comparing GP Financials in MR to FRx (non-AA). Confirm it is only the AA values that are off.

    2. I don't believe running checklinks is recommended. I would hold-off on that. if you wanted to be sure, maybe create a test company with a GP company back-up and try there.

    3. There is an active bug in MR that we are restrictive on some transactions in that we require the correct currency on AA transactions for us to pull data. There is a bug in GP where the currency isn't posted correctly. Support has a script to look for these transaction and you can update them without any issue.

    If you can't find where they are pulling I would recommend working with support and they can help narrow down what in your data could be preventing these trx from showing.

    Thanks

    Ryan

  • cgust Profile Picture
    cgust on at
    Re: Management Reporter & AA

    Have you contacted Support to see if they can help with 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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans