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
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..
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.
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.
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.
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.
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,556
Super User 2024 Season 2
#2
Martin Dráb
228,625
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (