Microsoft Dynamics AX (Archived)

Seeing Doubles in Management Reporter

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Seeing Doubles in Management Reporter

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Seeing Doubles in Management Reporter

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.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Seeing Doubles in Management Reporter

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