web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter Consolidation of Departments for multiple entities

(0) ShareShare
ReportReport
Posted on by 145

Here is my scenario, I have multiple companies and each company has a listing of departments (which are predominantly the same) and I want to be able to provide a departmental manager a report of all of their departments by entity.

I created a tree in management reporter that looks like this to start

Company               Unit Name          Unit Description         Dimensions

@Any                     Consolidated      Summary of all Units

@Any              Corporate           Corporate Dept.         Department 100:150   

LSLP         Corporate_LSLP  Corporate_LSLP          Department 100:150  

CGLP        Corporate_CGLP Corporate_CGLP         Department 100:150  

This continues for the same department for all entities, and then I would select the next department and do the same thing, and each of the entities is a reporting unit under the summary Department heading.  However when I run the report there is no data showing.  I selected @Any as the company on the report definition as well.  If I remove my tree and select a specific company the report works so I know it isn't anything from the row or column definition.

 

Please Help what am I missing here?

Thank you

Lonnie 

*This post is locked for comments

I have the same question (0)
  • MattPaulen Profile Picture
    6,912 on at
    RE: Management Reporter Consolidation of Departments for multiple entities

    My first thought would be to make sure that the Department segment is in fact called Department in each of the companies.

    When you choose @Any in the report definition, it will run for the company that you are currently logged in to in MR (shown at the bottom of MR).  What company are you logged in to?  If you take out the tree and use LSLP, does it populate with data?  What about CGLP?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans