Need little help in my Custom Report

V5 Question
1

I make a template but i need little changes. Template is

[TICKET DETAIL REPORT:3, 1, 1]
>Menu Item|Quantity|Price
@{REPORT TICKET DETAILS:T.TicketNumber::|}
>>{REPORT TICKET DETAILS:T.Date,T.TicketNumber:Ticket.TicketNumber=="$1":Ticket {0}-{1}}
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity,O.Price:T.TicketNumber=="$1"}
Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:T.TicketNumber=="$1"}

Capture.JPG866×416 59.4 KB

I want to show Payment type like Cash,CreditCard,Voucher or Customer

2

You will need to use {REPORT PAYMENT DETAILS} to get that information.

You can gleen some information from this Report:

[Ticket Payments:0.01,1,1,3,3,3, 1.5, 2, 2, 2, 2, 2]
@{REPORT TICKET DETAILS:T.Id.desc::,}

>|TID|NUM|Date Time|Customer|Table|Ticket Total|Cash|CC|CA|PAY TTL|+/-

|{REPORT TICKET DETAILS:T.Id,T.TicketNumber:T.Id==$1}|{REPORT TICKET DETAILS:T.Date,T.Time:T.Id==$1:{0} {1}}|{REPORT TICKET DETAILS:EN.Customers:T.Id==$1}|{REPORT TICKET DETAILS:EN.Tables:T.Id==$1}|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount:T.Id==$1}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:((PT=Cash) OR (PT=Cash USD)) AND T.Id==$1}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:((PT=Credit Card) OR (PT=Credit Card USD)) AND T.Id==$1}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:(PT=Customer Account) AND T.Id==$1}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:T.Id==$1}'),'0.00;(0.00); ')]|[=F((TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:T.Id==$1}')-TN('{REPORT TICKET DETAILS:T.TotalAmount:T.Id==$1}')),'0.00;-0.00; ')]

>> | | | | |GRAND TOTALS|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.Sum}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:((PT=Cash) OR (PT=Cash USD))}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:((PT=Credit Card) OR (PT=Credit Card USD))}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum:(PT=Customer Account)}'),'0.00;(0.00); ')]|[=F(TN('{REPORT PAYMENT DETAILS:P.Amount.Sum}'),'0.00;(0.00); ')]|[=F((TN('{REPORT PAYMENT DETAILS:P.Amount.Sum}')-TN('{REPORT TICKET DETAILS:T.TotalAmount.Sum}')),'0.00;-0.00; ')]
1 Like