Need little help in my Custom Report

V5 Question
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