I checked all the news group before this posting and could not find my question. I am looking for a detailed item sales report with all items showing only once in a report. Currently when I run my detail item sale report same item shows up again and again.
I am looking for a detailed item report where one item shows only once in a report with quantity added togather. Current Example: Detailed item sales report
item Look Discription Price QTY Total
111 Marlboro Red 2.00 3 6.00
119 Doral FF KNK 1.50 2 3.00
145 Milk 3.00 1 3.00
111 Marlboro Red 1.00 3 3.00
145 Milk 3.00 3 9.00
119 Doral FF KNK 1.50 4 6.00
Instead of same item showing again and again on same report for particullar report, I want it to show up only once and rolled up the quantity in one line.
item Look Discription Price QTY Total
111 Marlboro Red 3.00 3 9.00
119 Doral FF KNK 1.50 6 9.00
145 Milk 3.00 4 12.00
Thank you advance