You’re offline. This is a read only version of the page.
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
Hello Satrangi,
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.
Best regards,
Ludwig
Hi Ludwig,
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.
Hello Satrangi,
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,
Ludwig
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...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (