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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter 2012 Reporting Tree: Departments--Not Companies

(0) ShareShare
ReportReport
Posted on by

Hello:

In Management Reporter 2012 CU13, I have a reporting tree pulling in all departments--one row for each department.

Also in each row, for the "Company" column, I have @ANY specified.

But, when I run the report, it is only pulling in data for the company that I'm logged in to--not for all companies.  I thought that pulling in data for any and all companies was, well, the function of @ANY.  I guess not.

Okay, then.  We have eighteen companies to report on.  And, we already have a separate departmental tree that has a branch for each company.

We simply want, instead, a consolidated tree for all departments across all companies.  If that cannot be done with @ANY, then how is it done?

It sounds like I'm going to have to have eighteen rows for each department.  That's ridiculous and is going to take forever to do.

I'm shocked that a simple consolidated departmental tree cannot be accomplished with @ANY.

Thanks, in advance, for any help!

Below is an excerpt from my current tree.

ANY.PNG

John

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Disregard.  I accomplished this by exporting to Excel, sorting by department and company, creating eighteen rows per department, pasting back into the tree, and promoting accordingly.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans