cancel
Showing results for 
Search instead for 
Did you mean: 
gerdgoebel
Level 4

I need a top selling items report

I am using QB Prem 2020 with latest updates.

I use assembly items which are grouped.

I am looking for a top selling items report that just lists the item with description and the total sales, either by quantity or amount. I don't need the groups for this report.

I tried to customize some sales by item reports but all of them show me the sales by group.

Anybody knows how to do this?

1 Comment 1
JenoP
Moderator

I need a top selling items report

We're unable to run a sales report per items that were used in an assembly, gerdgoebel.

 

This is because they were sold as groups and not individually. You'll want to get a list of all the items that comprise the group. Then, compare it with the quantity in the Sales by Item Detail report. This way, you would still know how much of the items were sold. 

 

Here's how:

 

  1. Go to the List menu and select Item list.
  2. Look for the assembly item.
  3. Right-click on it and select Print Assembly Item.

 

Check out these articles as well about running reports for additional reference:

 

Don't hesitate to reply below or visit us again if you need anything else. 

 

assembly.PNG

Need to get in touch?

Contact us