Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Seeing Doubles in Management Reporter

Posted on by 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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans