Skip to main content
Post a question

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Management Reporter Issue

Like (0) ShareShare
ReportReport
Posted on 15 Sep 2020 17:20:34 by

Dear All,

I have a management reporter Installation whereby when I Print report MyCompany-Curr I get the correct amount on one my GL account as at June 2020 compared to GP but when I print MyCompany-AA, I get an incorrect balance on this GL account.


I really think that they should give the same figure. This GL account am using as a sample doesn't have AA analysis. The reason am using Datamart/MyCompany-AA is that my expense GL accounts have AA data.

What could be the issue??.

RomRyan

Categories:
  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on 18 Sep 2020 at 14:30:36
    RE: Management Reporter Issue

    Thanks Greg for the details.

    I might have overseen this for many years as I never had to bother about AA until recently only.. :-), at which point it became an important topic to me too..

  • Greg Byer Profile Picture
    Greg Byer 2,586 on 18 Sep 2020 at 13:57:48
    RE: Management Reporter Issue

    The AA company with the Legacy provider was introduce when we added the data mart in RU3.  When the data mart was added, the Legacy provider add the -CURR and -AA companies.  

    The integration guide for GP has some information about this.  In the Adding Companies section of the guide, it has this note:

    Companies with Analytical Accounting are imported differently depending on the type of integration. For data mart integrations, only one entry is imported per company. For integrations with the legacy data provider, two entries are imported per company.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on 18 Sep 2020 at 12:40:33
    RE: Management Reporter Issue

    Hi Greg,

    Thanks for pointing out the use of the -AA connector.. I was under the impression that the Legacy connector was not support Analytical Accounting and that this company extension belonged to the DM connector.. When was this introduced ? is there any technical documentation to support the details of the connectors setup ?

    I've worked quite my shares of troubleshooting thru MR since it was released (back in the days of 2.0), and tried to keep up to date with the features, but not much as been updated in the documentation since many years..

    Thanks in advance.

  • Greg Byer Profile Picture
    Greg Byer 2,586 on 18 Sep 2020 at 12:09:43
    RE: Management Reporter Issue

    MR has has two options for the integrations.  You can have the Legacy integration or the Data Mart integration.  With the Legacy, each GP company will have two Legacy companies in MR:  company-CURR and company-AA.  With Data Mart, you'll just have one:  company.

    The company-CURR will read from the GL tables only.

    The company-AA will read from the AAG tables.

    The Data Mart company will read from both GL and AAG tables.

    If the AA data in GP is incorrect, you'll get incorrect data on reports generated from the data mart company and the -AA company.  Both of these are reading from the AAG tables and picking up the incorrect table therein.  

    When you generate a report from the -CURR company, the reports will show the correct data since it is only reading from the GL tables.  It doesn't read from the AAG tables and does not pick up the incorrect data.

    Rebuilding the data mart will not fix this, since the data mart will still be reading the incorrect data in the AAG tables. You'll need to correct the data in the AAG tables in order for you reports to be correct in the data mart and -CURR companies.  

    You can identify where the AA data is incorrect by going through the steps in KB 2910626.

    support.microsoft.com/.../2910626

    Support can then assist with providing the fixes, based on the results of the KB article.

  • Romryan Profile Picture
    Romryan on 17 Sep 2020 at 19:59:42
    RE: Management Reporter Issue

    Thank you so much Greg and Beat for the responses, I think I didn't come clear on MyCompany (DataMart Company). This company is also giving the wrong results just like MyCompany-AA. While I expected both of them to have parity with the MyCompany-Curr which is correct as per GP.

    I have rebuilt the DataMart twice with no success.

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on 17 Sep 2020 at 14:39:24
    RE: Management Reporter Issue

    Hi RomRyan,

    using a company in MR with a -Curr suffix means that you're pulling the GP data from the "Legacy" connector in MR.. the Legacy connector doesn't support AA data from GP.. thus getting different results when using the other connection -AA

    As you have a company setup with -AA lets me believe that you also have the DataMart connector setup, which means you shouls also see a company name without any suffix (MyCompany).. this would be the one you should use..

    BTW, there is a reason why Micrsoft creates 2 connectors in the DataMart setup, as -AA requires specific table connections to retrieve the proper data from AA.. You won't see that GP data without using that -AA connector..

    PS: if you get different results when running a report against GL using the -Curr & DM connector, then it's because you may have to rebuild the DataMart at some point.. The -Curr Legacy connector always pulls the GL data straight from the GP tables.. whereas the DM connector relies on a separate DM database which consolidates GL financials from all the companies into a single location.. sometimes the DM content gets out of sync with the real GP financials and you need to rebuild it.

  • Greg Byer Profile Picture
    Greg Byer 2,586 on 17 Sep 2020 at 12:13:37
    RE: Management Reporter Issue

    If you get incorrect amounts when generating a report from the AA company, it's a sign that there is bad data in the AAG tables.  It doesn't matter that the accounts do not use AA dimensions or codes.  When you have AA enabled, everything is entered in both the GL and AAG tables.  If they are not in sync, it will show in MR.  When you generate a report from the AA company in MR, it is reading from the AAG tables.  When you generate a report from the CURR company, it is reading from the GL tables.  

    You'll want to go through the steps in KB 2910626 to identify where the problem is at.  You'll need to open a support case to resolve the issues.

    support.microsoft.com/.../financial-reports-from-management-reporter-do-not-match-the-general-le

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

Kudos to all of our 2024 community stars!

Meet the Top 10 leaders for December!

Congratulations to our December super stars!

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,579 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans
Loading started