Management Reporter - Reporting Tree to consolidate business units across multiple companies

(0) Share

Report

Posted on by Rochelle Mausteller

769

I am trying to create a report that consolidates expenses by restaurant where expenses are reported in two GP companies. Payroll is processed in one company, and Sales and A/P are processed in the other company.

The companies use the same chart of accounts. The third segment is what identifies each restaurant.

I have created a reporting tree that looks like this:

The report will not consolidate. When you click on Food and Beverage Admin it only includes the $$ from whichever company you have set as the default company in MR. The Children lines display the correct $$. It just doesn't consolidate correctly. Does anyone have any recommendations please?

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Rochelle Mausteller 769 on at

Like (1)

Report

Management Reporter - Reporting Tree to consolidate business units across multiple companies

Thank you Lisa, this worked!
Suggested answer

Lisa at AonC.com 698 on at

Like (0)

Report

Management Reporter - Reporting Tree to consolidate business units across multiple companies

Just a guess on this one based on the information in your question: Remove the Dimension from Row 2 and Row 5 in Column D. (If it is a true summary of units 3 and 4, it should be set up like Row 1.)