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)

Suggested answer

Lisa at AonC.com 919 Super User 2025 Season 2 on at

Like (0)

Report

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

Thank you Lisa, this worked!

Was this reply helpful? Yes No