Sales Invoice Report Grouped by Item


I am facing a small problem. Through report builder, I am trying to build a simple report to give total number of items sold grouped by Item name. I wanna make it simple and without query as I will be changing parameters every day.

What I do from inside Sales Invoice Report Buikder is the following:

  • “Add Filter” by date, then
  • “Add Group”: “Item Name (Sales Invoice Item)”
    then Sum but I cannot find sum by “Quantity”!! just “total quantity” which does not help at all.

I repeated the steps as followed by you and could found “Quantity (Sales Order Item)” as an option.


Is this what you were looking for? Hope this helps.

Thanks a lot Michelle. I do not know why this option is not appearing on my side.
Please check below pic.