[Sales:1,2,1,1] >Item Group|Item|[N]Quantity|[C]Total {REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.Quantity,O.TotalPrice:(DE=HYDROS)} Currently the report is doing Coke 1 Coke 1 Fanta 6 Coke 2 Sprite 7 Coke 5 Coke 3 Sprite 5 Fanta 6 I want the items on the report to be Coke 12 S…

Try this one [Department Sales Details: 3,3,2,2,2] >Manager:|{SETTING:CURRENTUSER} Date:|{DATE}|{TIME} @{REPORT PAYMENT DETAILS:T.Department.asc::,} Department:|| $1 Discount:|||${REPORT TICKET DETAILS:CA.Discount.sum:(TS.Status=Paid) AND (DE=$1)} Round:|||${REPORT TICKET DETAILS:CA.Rou…

Add .sum to O.Quantity. O.Quantity.sum

Here’s a report I used at one point for an install with multiple departments. I did not write this. I found it on the forum years back when I knew even less about reports. [Item Sales by Department:5, 2, 2,1] @{TICKET TYPE LIST} @{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=Tru…

I added “.Sum.desc” to it. I now have O.Quantity.Sum.desc Full code [Restaurant Sales:1,2,1,1] >Item Group|Item|[N]Quantity|[C]Total {REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.Quantity.Sum.desc,O.TotalPrice:(DE=Restaurant)} >Sub Total||{REPORT ORDER DETAILS:O.ExactTotal.Sum.desc.sum:(ODI=T…

Thank you for this. I tried to figure where to add the DE tag, but It didnt work for me. [Department report] The First is till not summing this well. The second is perfect, but how can I add department tag or where should I put it.