How can I add a O.ItemGroup filter to REPORT ORDER DETAILS

V5 Question
1

Its been requested that I combine item groups into single categories for servers so they can have a recommended tip based on sales that are produced out of the kitchen. When I apply an expression like O.ItemGroup!=Liquor, I don’t get any results. Here is what I’m trying to do:

[Category Sales Report:1,1,1]
>|
>Kitchen|{REPORT ORDER DETAILS:O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True) AND (O.ItemGroup!=Beer) AND (O.ItemGroup!=Liquor) AND (TS.Status=Paid) AND (TEN.Server={SETTING:CURRENTUSER})}
>
2

Is O.ItemGroup a field tag?
If so it would not want brackets and value to be quoted.
Try think this;
AND O.ItemGroup!=“Beer” AND
I’d also maybe simplify to just one for now to test :wink:

3

Try using (MG!=Beer) && (MG!=Liquor)

1 Like
4

Thanks @JTRTech. I’ve had it simple and the problem was the ItemGroup. Looks like MG is the solution.

5

Thanks @Posflow.

MG=Breakfast did work, but the != didn’t work with MG. I found a post form earlier which showed != use with MenuItem.GroupCode:

2 Likes