web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Management Reporter - ...

Finance | Project Operations, Human Resources, ...

Answered

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

(0) Share

Report

Report

Posted on by Rochelle Mausteller

773

Hi

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 Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Lisa at AonC.com 1,028 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

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 509 Super User 2026 Season 1

#2

Giorgio Bonacorsi 375

#3

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans