SBX - Search With Button

SBX - Forum Post Title

How to get a SOP Salesperson Report per month? Or any report for each Salesperson ID on sales per month?

Microsoft Dynamics GP Forum

Barry Coetzee asked a question on 27 Jun 2011 8:40 AM

Question Status

Suggested Answer

I need to do a sales analysis in the reports of MS Dynamics GP.

I want to receive a report on a Salesperson's Sales Per Month. Overall Turnover and Gross Profit. 

The SOP Salesperson Report does not give me a date range to insert.

I understand you can go into the sales person id and check their history, but perhaps there is a better suggestion on Salesperson Reports.

Thanks,

Reply
Rubal responded on 27 Jun 2011 9:53 AM
My Badges
Suggested Answer

Hi Barry

One option is you can add a SalesPersonID column in the Smartlist. You can use the Month's Sales Smartlist under Receivables Transaction, add SalesPersonID. You can export data in excel add subtotal by salesperson.

Rubal,

http://dynamicsgphelp.com/

Reply
Rubal responded on 27 Jun 2011 12:32 PM
My Badges
Suggested Answer

I have just detailed out the steps in blog

dynamicsgphelp.com/.../how-to-create-sop-salesperson-report-in-smartlist

Let me know if you have any questions.

Rubal,

http://dynamicsgphelp.com/

Reply
Ian Stewart responded on 28 Jun 2011 2:14 PM
My Badges

What version of GP are you using?

Have you got SSRS installed?

Reply
Rubal responded on 27 Jun 2011 9:53 AM
My Badges
Suggested Answer

Hi Barry

One option is you can add a SalesPersonID column in the Smartlist. You can use the Month's Sales Smartlist under Receivables Transaction, add SalesPersonID. You can export data in excel add subtotal by salesperson.

Rubal,

http://dynamicsgphelp.com/

Reply
Rubal responded on 27 Jun 2011 12:32 PM
My Badges
Suggested Answer

I have just detailed out the steps in blog

dynamicsgphelp.com/.../how-to-create-sop-salesperson-report-in-smartlist

Let me know if you have any questions.

Rubal,

http://dynamicsgphelp.com/

Reply

SBX - Two Col Forum

SBX - Migrated JS