How would I create a report showing sales by qty for a top sales report?

Hi steve21,

You can use the Sales by Customer Detail report to view the sales by quantity. Then, export it to Excel so you can sort for the top sales.

Here's how to get it:

1. Click Reports.
2. In the Find report by name field, enter Sales by Customer Detail.
3. Click Customize.
4. Click Rows/Columns. Then, mark the QTY box.
5. Click Run report.
6. Click the Export icon beside the Printer icon.
7. Choose Export to Excel. 

Just click the Reply button if you have other questions.

---

@ShiellaGraceA wrote:

Hi steve21,

 

You can use the Sales by Customer Detail report to view the sales by quantity. Then, export it to Excel so you can sort for the top sales.

 

Here's how to get it:

 

1. Click Reports.
2. In the Find report by name field, enter Sales by Customer Detail.
3. Click Customize.
4. Click Rows/Columns. Then, mark the QTY box.
5. Click Run report.
6. Click the Export icon beside the Printer icon.
7. Choose Export to Excel. 

Just click the Reply button if you have other questions.

---

Sales by customer didn't work, but you can go to the General Ledger account and add Qty and Products and service. Then, just export to Excel and delete everything but invoices. This will show you how much quantity in a given time.