Sales Report that shows sales orders each individual rep has written for a fiscal year

We use QuickBooks Enterprise 15 - R14_19.  Thank you for the help.  It doesn't appear that it will give you a count for the total number of sales orders written per rep.  It appears you would have to manually count them after setting the filters up correctly.  It gives you the total amount sold and total qty but it doesn't appear to show the total number of sales orders written. 

Our business is strange in that we have both hard bid and retail sales and there seems to be a bit of a dispute between the retail counter sales staff and the hard bid sales staff so they were wanting to see how many tickets had been written by each rep as in the total amount of sales orders that had been typed up so that they could compare. 

The dispute arises because within the same company we have to operate on two completely different business models.  The retail side has to use high profit margin / low volume and the hard bid side has to use low profit margin / high volume.  The sales staff is having trouble grasping this concept so I am trying to explain to them how the two are differet but equal. 

The hard bid staff in theory should only be writing a small number of sales orders because they only bid projects while on the other hand the retail sales side should be writing a higher number of sales orders at lower quantities.  I just need a way to total the number of sales orders written by each rep to settle the dispute.  I can always export to excel and run a sum formula I guess unless you know of a way that QuickBooks will total the number of sales orders written.

Thanks

I think I like the K.I.S.S. method personally.  Usually time is the most valuable of all resources and seems as though expoting to excel will be faster than learning the advanaced reporting feature.  Thank you again for the help.  Much appreciated.

Thanks for picking out the time to discuss this. It is extremely helpful for me. Thanks for such a valuable help again.word counter

Amazing Tutu Thanks I check My  Sales Order Music.

---

@Anonymous wrote:

Hi DCrain, 

 

What version of QuickBooks are you running?  In my sample file on QuickBooks Desktop, I run a similar report by creating a Sales By Rep Detail report and then I change the filtering to show Non Posting transactions. 

 

Customizing the report to show non-posting transactions is important because QuickBooks will only show transactions that have affected the balance and P&L accounts by default. 

 

To create the report:

• Go to the Reports menu at the top of the screen then choose Sales and then Sales Rep By Detail
• Click Customize Report
• Choose the Filters tab
• In the Choose Filter area, choose Posting Status
• Set the Posting Status to Non-Posting

Then press OK to display the report.  

 

*If your reps are also on Estimates, they will be displayed as well. If this is the case, you may want to set the Transaction Type filter to show only sales orders. 

 

Here are some screenshots that could show you what to expect:

 

---

thisis really helpful/

yes for me too,

Yes for sure.

Nice to have this ,

Thanks for the post. That is of much help.

Thanks for the post. That was of much help.

 thank for help you your realy nice man amazeproduct

thank for help you your realy nice man amazeproduct

I have used almost 7 to 8 different accounting software for my fesco bill online but QuickBooks is one of the best software I have ever seen. Thanks to the developer and team of QuickBooks.

thanks to you brother 

Quickbooks perfectly solves the problem of creating a financial report! In my free time I love to drawing  step by step drawing tutorials!

Quickbooks perfectly solves the problem of creating a financial report! In my free time I love to draw and create step by step drawing tutorials!

Same Here. Thank you so much for such a detailed guidance. I have tried multiple accounting software but quickbooks is really the best.

Regards,

reverb

Thank you for such a detailed guidance. Reverb