web
You’re offline. This is a read only version of the page.
close
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,438

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

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • lmai Profile Picture
    lmai 2,438 on at

    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.    

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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,438 on at

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans