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?
*This post is locked for comments
I have the same question (0)
