web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Is there any way to ru...

Microsoft Dynamics GP (Archived)

Is there any way to run a Detail Sales History report that will sort by salesperson and allow you to choose a date range in GP 10?

(0) Share

Report

Report

Posted on by Mordy Duke

25

My company finally made the switch from GPA to Dynamics, and one of the most useful reports for us in GPA was the Detail Sales History Report which allowed you to sort by salesperson over a specified date range. It would breakdown each transaction by item and include extended price, extended cost and gross profit percentage. Dynamics does not seem to have the option to sort by salesperson and date range in the same report. Am I missing something?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,631 Moderator on at

Like (0)

Report
Copy link

Link copied!

Using the Sales Transaction SmartList, add the Salesperson ID and Originating Extended Cost fields, sort by Salesperson, Filter on the desired date range, export to Excel and add Gross Margin and GM % columns.

If you have SmartList Builder, you can add the GM and GM% columns to the SmartList and not have to edit the report in Excel.

Hope this helps,

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Anthony Beatty 2

#2

Shravan Attelli 1

#2

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans