[Item Sales Report Restaurant1:1,5,2,1,1,2]
Item Sales Report Restaurant
G.Code|Products|Amount|Quantity|Service Charge|Total
{REPORT ORDER DETAILS:T.Product Sales Categories=FOOD:(ODI=True)}
@{REPORT ORDER DETAILS:MT.Product Sales Categories,O.Quantity.Sum,O.ExactTotal.Sum,CA.Service Charge:(ODI=True) and (TY=Ticket):{0}:,}
FOOD
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=FOOD) and (ODI=True) and (TY=Ticket)}
JUICE
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=JUICE) and (ODI=True) and (TY=Ticket)}
Cigarette
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,([O.ExactTotal]-[O.Price]).Sum,O.ExactTotal.Sum:(MT.Product Sales Categories=Cigarette) and (ODI=True) and (TY=Ticket)}
COCTAIL
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=COCTAIL) and (ODI=True) and (TY=Ticket)}
ARRACK
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=ARRACK) and (ODI=True) and (TY=Ticket)}
[Item Sales Report TakeAway :1,5,2,1,1,2]
Item Sales Report TakeAway
G.Code|Products|Amount|Quantity|Service Charge|Total
{REPORT ORDER DETAILS:T.Product Sales Categories=FOOD:(ODI=True)}
@{REPORT ORDER DETAILS:MT.Product Sales Categories,O.Quantity.Sum,O.ExactTotal.Sum,CA.Service Charge:(ODI=True) and (TY=Ticket):{0}:,}
FOOD
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=FOOD) and (ODI=True) and (TY=TakeAway)}
JUICE
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=JUICE) and (ODI=True) and (TY=TakeAway)}
Cigarette
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,([O.ExactTotal]-[O.Price]).Sum,O.ExactTotal.Sum:(MT.Product Sales Categories=Cigarette) and (ODI=True) and (TY=TakeAway)}
COCTAIL
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=COCTAIL) and (ODI=True) and (TY=TakeAway)}
ARRACK
{REPORT ORDER DETAILS:MT.Product Sales Categories,M.Name.asc,O.Price,O.Quantity.Sum,CA.Service Charge.Sum.desc,([O.TotalPrice]+([CA.Service Charge]*[O.Quantity])).Sum:(MT.Product Sales Categories=ARRACK) and (ODI=True) and (TY=TakeAway)}
[Sales:1, 1]
{REPORT TICKET TYPES:!PreOrder && TotalAmount >= 0}