Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Management Reporter. ...
Microsoft Dynamics AX (Archived)

Management Reporter. Do you need to run the consolidation in AX in order to pulll the elimination amounts in Management Reporter?

(0) ShareShare
ReportReport
Posted on by lmai 2,436

Hi All,

If MR pulls all of its numbers directly from GL, how come GL shows Intercompany receivable of $1,000,000.00 and MR shows zeros in the Elimination columns?  Could someone please shed some light to this?  Is there a subsequence relationship between running a consolidation in AX and ability to pull elimination amounts in MR? 

Also, when I ran the consolidation in AX, it stated "Distribution do not balance.  The Elimination rule failed during processing". How to you make it balance so that I can go on with the consolidation process?  

 

Thanks so much!

 

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter. Do you need to run the consolidation in AX in order to pulll the elimination amounts in Management Reporter?

    Hello Kim,

    The last point you mention (CTA) is - in my opinion - one of the pain points of AX/MR consolidations. I found a similar post for People using Dynamics GP (community.dynamics.com/.../178712). Maybe this one helps or does at least give you some additional insights.

    Best regards,

    Ludwig

  • lmai Profile Picture
    lmai 2,436 on at
    RE: Management Reporter. Do you need to run the consolidation in AX in order to pulll the elimination amounts in Management Reporter?

    Ludwig,

    I discovered that 2 things had caused MR not able to pull the elimination amounts:

    1.  New Intercompany GL account is added; therefore, it needed to be included in the Row Definitions.  It is now able to pick up the elimination amount

    2. In Intercompany Payable, for some reasons it hidden under Other Current Liability.  So I broke it out and put the Intercompany Payable in a separate row.  MR, now, able to pick up the elimination amount.  

    Quite interesting.  

    Oh, by the way, do you happen to have the instruction on how to calculate currency translation adjustment (CTA)?  Thanks

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter. Do you need to run the consolidation in AX in order to pulll the elimination amounts in Management Reporter?

    Hi Kim,

    I am still not sure what you recorded in AX and how you setup your MR consolidation report. The decision to do the consolidation in MR rather than in AX is an "either-or" decision. Either you do the financial consolidation in AX or you do it in MR. If you take a look at the AX TechNet sites you will see that Microsoft recommends doing the consolidation in MR. The major difference is that (a) you do not get consolidation vouchers created and (b) that you have to calculate the consolidation column yourself by setting up specific calculations in MR.

    Probably have a look at the following sitte that describes how to run a financial consolidation in MR only (blogs.msdn.microsoft.com/.../consolidations).

    Hope this helps,

    Ludwig

  • lmai Profile Picture
    lmai 2,436 on at
    RE: Management Reporter. Do you need to run the consolidation in AX in order to pulll the elimination amounts in Management Reporter?

    Hi Ludwig,

    Thank you for your response.  Yes, I've included the IC receivable account in my  Dimension Filter column in Column Definition.  It has been a couple days now, and I rerun the MR.  The Elimination column still show zeros.

    I consolidated everything.  The main error is at the Elimination rule when AX generate "Elimination rule is failed during processing".  There are only a few intercompany transactions.  They are all Intercompany receivable and Intercompany payable.  No any other Intercompany transactions.    

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter. Do you need to run the consolidation in AX in order to pulll the elimination amounts in Management Reporter?

    Hello Kim,

    For part 1 of your question: Can you check your MR report setup and check whether you included the IC receivable account into your row definition? The transfer of the GL data to MR typically take approx. 1 Minute. Maybe you run your MR report to early?

    For part 2 of your question: Have you managed consolidating anything in AX? What transactions are you trying to consolidate and are foreign currency transactions involved? If so how have you setup foreign currency translation?

    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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans