Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Management Reporter Help - Can you "Sum" Attribute Columns

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone, 

Until now, I haven't worked any with attributes in Managment Reporter, so bear with me. 

I have a standard profit center report, it breaks apart our different products and their sales. When I drill down on a product, it shows me the account numbers associated with this product and the total amount in those accounts. From here, I can drill down once more to see sales transaction entries and their individual amounts. 

On my column definition, I've now added the following attribute columns. These are allowing me to see the document number (which is the customer id) , descriptions and invoice numbers for these transactions entries. 

Screenshot-_2800_527_2900_.png

I have two questions. 

1. Should I be able to drill down on one of these individual sales transaction entry? MR currently won't let me drill down individually, it only lets me on the screen before (which shows me all of the transactions that have hit an account). 

2. In a perfect world, I would have an interest in summing up sales by a customer - or in this case, the document number (customer id). Is there a way to sum up different attributes like so? 

Thanks in advance for the help. 

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans