web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / Multi company budgets ...
Microsoft Dynamics AX (Archived)

Multi company budgets and Management Reporter?

(0) ShareShare
ReportReport
Posted on by Community Member

I previously had 4 AX companies, and just one 'group' budget set up in AX (entered in one of the companies).  The only way I can see the 'book code/attribute' of that budget model from within Management Reporter is the set my default company to that where the budget is entered.  Reporting was just done as a 'group' only.

Following a year end, I now have separate company budgets to get into AX, but I cannot work out how Management Reporter will be able to 'see' these as there is only one 'book code/attribute' filed to be selected in the column definition.

I need to be able to access each companies budget, so that I can use the reporting tree to view separate, or rolled up Group P+L accounts.  Or maybe I have to have separate reports for each company, which defeats the point of having a flexible dynamic reporting tree (and creates multiples of each report which is difficult to maintain).

*This post is locked for comments

  • Mariano Gracia Profile Picture
    Mariano Gracia on at

    Management reporter does not support merging data from different companies, I hope it will be possible in the future

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi AXfinance,

    Is the budget model the same value in each company?

    If it is then i think you should be able to see the separate company and rolled up budget figures using the single report.

  • Community Member Profile Picture
    Community Member on at

    thank you, I have worked out how to set up individual budgets in MR  (budget model doesn't have to be the same) but I cannot now make adjustments for inter-company eliminations when the subsidiaries are rolled up into the group report.

  • Suggested answer
    oysteindg Profile Picture
    oysteindg on at

    Just for reference for others that might have the same issue.

    The solution to view budgets for all companies is described here: www.erpsoftwareblog.com/.../how-to-add-and-consolidate-multiple-company-budgets-in-management-reporter-mr

  • JanineAX Profile Picture
    JanineAX 60 on at

    Our budget is 1 single report over multiple companies. The way we exclude inter-company from our figures is by using customer group to identify that the account is inter-company. This simply then allows us to filter inter-company out of our report.

    You will find the customer group under the general heading within the customer account.

  • Community Member Profile Picture
    Community Member on at

    Thanks Janine, but I don't understand.  Our budgets are GL based, so not sure where the customer group comes in to this.  Also the GL accounts are not identifiable as being either fully 'inter-company' or not.  I just have figures of 'X' that are intercompany as part of a larger total in the GL account.

  • Community Member Profile Picture
    Community Member on at

    yes this is the set up I have used, which works other than being able to do any inter company eliminations.  Thank you

  • Suggested answer
    oysteindg Profile Picture
    oysteindg on at

    Hi AXfinance.

    Microsoft blog have a good example on how to eliminate intercompany transactions in Management Reporter here:

    [View:http://blogs.msdn.com/b/dynamics_financial_reporting/archive/2012/01/10/creating-consolidated-financial-statements-using-management-reporter-using-management-reporter-for-eliminations-part-6-of-7.aspx]

  • Community Member Profile Picture
    Community Member on at

    Janine probably has a dimension set up called Customer Group in the GL. Whenever she budgets she uses that dimension to be able to distinguish.

    And this gets to the root of your problem: you need to have an identifier that MR2012 can see in order to be able to filter out your intercompany.

    How do you do this currently for your actuals?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans