Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

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

Posted on by 769

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?

//

  • Management Reporter - Reporting Tree to consolidate business units across multiple companies
    Thank you Lisa, this worked!
  • Verified answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,998 on at
    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.)

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,137 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans