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

(0) Share

Report

Posted on by Rochelle Mausteller

773

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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Lisa at AonC.com 1,154 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.)

Was this reply helpful? Yes No
Rochelle Mausteller 773 on at

Like (1)

Report
Copy link

Link copied!

Thank you Lisa, this worked!

Was this reply helpful? Yes No