Multi company budgets and Management Reporter?

(0) Share

Report

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

I have the same question (0)

All responses (9)

Answers (0)

Mariano Gracia on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

oysteindg on at

Like (0)

Report

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

Was this reply helpful? Yes No
JanineAX 60 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

oysteindg on at

Like (0)

Report

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]

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No