I have 4 terminals but are divided into two
2 for the rooftop bar
2 for the garden bar
With each terminal named different
rooftop
cashier_rooftop
Garden
Garden_cashier
This is my report below that I use to report item sale and group sales but it keeps skipping items
Yet when you print the sambapos item sales report all items show
ROOFTOP
{REPORT ORDER DETAILS:O.MenuItemName.desc,O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) && O.MenuItemName=“$2” && ((TE=rooftop) OR (TE=cashier_rooftop)) }
@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
[$1 Sales:8, 2, 2, 4]
{REPORT ORDER DETAILS:O.MenuItemName,OS.NewBook GLA,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$2” and (MG=$1) and ((TE=rooftop) OR (TE=cashier_rooftop))}
{REPORT ORDER DETAILS:’ ‘+[O.PortionName],’',O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$2” and (MG=$1)and ((TE=rooftop) OR (TE=cashier_rooftop)) and O.PortionName!=“Normal”}
Total $1||{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) and ((TE=rooftop) OR (TE=cashier_rooftop)) and (MG=$1)}