Share
ReportDear All,
Can anyone help me generate a salesperson wise monthly items sold report please
thank you,
Shifan
*This post is locked for comments
You’re offline. This is a read only version of the page.
Dear All,
Can anyone help me generate a salesperson wise monthly items sold report please
thank you,
Shifan
*This post is locked for comments
Dear Gomez,
thanks for the reply, this helped. I only need to add the void status to it
thank you,
Shifan
The following should get you started:
select [Salesperson ID], [Item Number], [Item Description], year([Document Date]) as [Year], month([Document Date]) as [Month], SUM([QTY]) as [Quantity Sold], SUM([Extended Cost]) as [Total Cost], SUM([Extended Price]) as [Total Price] from SalesLineItems where [SOP Type] = 'Invoice' group by [Salesperson ID], [Item Number], [Item Description], year([Document Date]), month([Document Date])
You can then pivot that data in Excel or refine the query to get more information (or less) as needed.
Dear ahamed,
Thanks for the reply, more over I am looking for SQL query (view) If any anyone have please do let me know
Thank you,
Shifan
Hi Shifan,
The Smartlist Sales transaction and Sales line items report can generate your required report.
From Dynamics GP > Smart List > Sales
Choose Sales Transactions or Sales line items > Click on Columns > add > Choose the Sales Person ID and also add Invoice Date / order date
the report will have the sales person column and the dates at the end of the report which you can adjust later (from columns).
Click on search and choose invoice date in column name, in the filter choose in between and in the value enter the start and the end of the month.
you can click on favorites to save this report for future use
Best Regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (