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

Notifications

Announcements

No record found.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans