Need Help to create Void Item List

V5 Question
1

Hi.
I want to create Void Item List Report Like as shown in picture

Also need for Gift Items List.

2

Report order details expression using a GStatus=Void and GStatus=Gift

1 Like
3

Can you guide me where am i wrong

[Void Items List:2, 2, 5]
>Ticket No.|Order No|Void Item Name
{REPORT ORDER DETAILS:T.TicketNumber,O.OrderNumber,GStatus=Void}
4 
[Void Items List:2, 2, 5]
>Ticket No.|Order No|Void Item Name
{REPORT ORDER DETAILS:T.TicketNumber,O.OrderNumber,O.MenuItemName:(GStatus=Void)}
5

No result found

02.JPG1167×226 23.3 KB
03.JPG691×341 17.7 KB

6

Arr, it soundly just be GStatus it will need to be something like OS.GStatus=

2 Likes
7

Hi
Can some one help to get the report of Void in detail, like food and bar separate with price, Invoice No

Presently we are getting detail Sale report of Bar and Food in Sale Report for that pls see the details below

[Brunch BAR by Amount:.6,2, 1, 1.2]

{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.Brunch=BRD)}

|Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)&&(MT.kotsale=BRD)}

[Brunch FOOD by Amount:.6,2, 1, 1.2]

{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.Brunch=BRF)}

|Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)&&(MT.kotsale=BRF)}

[Bar Sales by Amount:.6,2, 1, 1.2]

{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.kotsale=Ba)}

|Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)&&(MT.kotsale=Ba)}

[Food Sales by Amount:.6,2, 1, 1.2]

{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.kotsale=Fo)}

|Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)&&(MT.kotsale=Fo)}

[Home Consumbtion by Amount:.6,2, 1, 1.2]

{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.kotsale=Co)}

|Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)&&(MT.kotsale=Co)}

[Seesha Sales by Amount:.6,2, 1, 1.2]

{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.kotsale=Se)}

|Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)&&(MT.kotsale=Se)}

[Sales:1, 1]
{REPORT TICKET TYPES:!PreOrder && TotalAmount >= 0}

[Pre Orders:1, 1]
{REPORT TICKET TYPES:PreOrder && TotalAmount >= 0}

[Refunds:1, 1]
{REPORT TICKET TYPES:TotalAmount < 0}

[Payments:2, 1, 2]
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0}

Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}

[Refund Payments:2, 1, 2]
{REPORT REFUND PAYMENTS}

[Ticket Details:2, 1, 2]

Ticket Counts
@!{TICKET TYPE LIST}
$1|{REPORT TICKET COUNT:(TY=$1)}|{REPORT TICKET TOTAL:(TY=$1)}
Total|{REPORT TICKET COUNT}|{REPORT TICKET TOTAL}
Amount per Ticket||[=F(TN(‘{REPORT TICKET TOTAL}’)/TN(‘{REPORT TICKET COUNT}’))]
Order Counts
@!{TICKET TYPE LIST}
$1|{REPORT ORDER COUNT:(TY=$1)}|{REPORT ORDER TOTAL:(TY=$1)}
Total|{REPORT ORDER COUNT: }|{REPORT ORDER TOTAL: }
Orders per Ticket||[=F(TN(‘{REPORT ORDER COUNT: }’)/TN(‘{REPORT TICKET COUNT: }’))]
Amount per Order||[=F(TN(‘{REPORT ORDER TOTAL: }’)/TN(‘{REPORT ORDER COUNT: }’))]
Ticket Counts per State
{REPORT TICKET STATES}
Order Counts per State
{REPORT ORDER STATES}

[Ticket Tags:1, 1, 1]
{REPORT TICKET TAGS}

[Payment Details:2, 1, 2]
@{TICKET TYPE LIST}
@{TAX TYPE LIST}

$1
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(TY=$1)}
{REPORT CALCULATION DETAILS:C.Name,C.X,C.CalculationAmount.Sum:(TY=$1)}
$2||{REPORT TICKET DETAILS:TX.$2.Sum:(TY=$1)}

[User Sales:1, 1]
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,}
[Settled by $1:1, 1, 1]
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)}

Total Income|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}