Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Hi Brains Trust,
After a week of dealing with issues with MR, I have finally come here to seek guidance.
We are on AX2012 R3 CU13 and MR2012 Version 2.12.16000.17 CU16.
Have 3 companies set up in AX2012. Shared COA and Fin Dims, which include Business Units/Entity.
A consolidation report in MR which has been running fine is now showing double and strange numbers for Co.2. We were also missing numbers. In the last few days, I have run rebuild balances and update balances in AX multiple times. I have also rebuilt the Data Mart 6 times. Not easy since it takes 3 hrs or so to integrate. I have had our support partner consultants looking at the DB, DM and MR. I have even had Microsoft on the line for 4 hrs. We have studies the report design. I have recreated a report from scratch. Nothing has helped.
The only change we have had is an addition of 2 new BUs. 1 in Co.1 and 1 in Co.2. We have also added about 8 new Main accounts. This prompted us to go and update the reports. The biggest change was in this consol report as it shows all accounts in rows and all our entities in columns, split under the 3 companies. Co.1 and Co.3 are in AUD. Co2 is in NZD, reporting currency is AUD. All other reports are running with correct results after our DM rebuilds but this report is giving us (by which I mean me) sleepless nights.Am I missing something? Any real-life similar experience out there? How did you resolve it?
What do you mean by saying that ... This prompted us to go and update the reports?
What has been done?
Has somebody manipulated the posted transactions and added the BUs and/or the new accounts?
Can you elaborate on that?
Many thanks and best regards,
Sorry for the really late reply. What I meant by that was that we have had to go into the reports and add the new accounts and BUs to our current row and column definitions.
In the last month since I posted this question, we have escalated this to our support partner and they are yet to solve the issue. Looking at Co.2, I have tried to make sense of the numbers, to see how these numbers are being calculated and to my dismay, they are all over the shop and make no sense whatsoever. I have looked at the exchange rates in Co.2 and they are there and up-to-date. The rates are entered as AUD to NZD, even if the local currency for Co.2 is NZD... Is this correct? I went back and checked the history and it seems it has always been entered this way.
We are well and truly stuck.
As you already tried resetting the datamart there is not much that you can do from a end user / AX client perspective.
What can also be tried is setting up the MR from scratch again (after you backed up your existing reports).
You will need technical help for that as you cannot do this from the AX client.
If your partner has not been able to get this fixed yet, try to get the MS support involved here.
They also have MR experts that might take a look into the application and setup and provide some help.
Business Applications communities