Item Sale Report

V5 Question
1 
[Group Food:2.3, 0.7, 1.3]
@{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.sum:(MT.Group=Food):{0}:,}
>>$1
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.sum,O.ExactTotal.sum:(MG=$1)}
>Total $1:|{REPORT ORDER DETAILS:O.Quantity.sum,O.ExactTotal.Sum:(MG=$1)}
>Total Group Food: |{REPORT ORDER DETAILS:O.Quantity.sum,O.ExactTotal.sum:(MT.Group=Food)}

this report display all item Sales included Void and Free.

I want report all Item sales not include void item and Gift Item. How to do it.

2

Change it to this:

[Group Food:2.3, 0.7, 1.3]
@{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.sum:(MT.Group=Food):{0}:,}
>>$1
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.sum,O.ExactTotal.sum:(MG=$1) AND (OS.GStatus= )}
>Total $1:|{REPORT ORDER DETAILS:O.Quantity.sum,O.ExactTotal.Sum:(MG=$1) AND (OS.GStatus= )}
>Total Group Food: |{REPORT ORDER DETAILS:O.Quantity.sum,O.ExactTotal.sum:(MT.Group=Food) AND (OS.GStatus= )}
1 Like
3

Yes It’s work again. :grinning:

4

Used this in one of my reports and is working as expected. Thanks @Jesse

1 Like