For the purpose of future auditing i want to group the Tickets based on payment type
Cash
Ticket 001 amount $123
Ticket 002
Ticket 003
Ticket 004
Cheque
Ticket 005
Ticket 006
Ticket 007
Ticket 008
Credit
Ticket 009
Ticket 010
Ticket 011
Ticket 012
use tag
{REPORT PAYMENT DETAILS:}
and {REPORT PAYMENT TOTAL:}
with a filter by your payment types
ex.
[payment cash:1,1]
>T.TicketNumber|P.Amount
{REPORT PAYMENT DETAILS:T.TicketNumber,P.Amount:(PT=Cash)}
>TOTAL|{REPORT PAYMENT TOTAL:(PT=Cash)}
`[Ticket payments:1, 1,1,1, 1, 2, 1]
@{REPORT PAYMENT DETAILS:T.Id.DESC::,}
TID|Date|Time|Items|Ticket Total|Payment Type|Tendered
{REPORT PAYMENT DETAILS:T.Id.desc,T.Date,T.Time,T.ItemCount,T.TotalAmount,P.Type,P.Amount}
|||||$1 Payment Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:T.Id==$1}
||||Grand Total|{REPORT PAYMENT DETAILS:P.Amount.Sum}`
need a detailed like this,but am getting some few errors especially on the 2nd last line
on the 2nd last line, If I understand correctly, you want to get the total for each payment type?
if so, then you have a little bit wrong exceptions.
you are iterating over values by ticket id, not by payment method
try this:
[Ticket payments:1, 1,1,1, 1, 2, 1]
@{REPORT SQL DETAILS:SELECT [Name] from [PaymentTypes]:F.Name::{0},}
TID|Date|Time|Items|Ticket Total|Payment Type|Tendered
{REPORT PAYMENT DETAILS:T.Id.desc,T.Date,T.Time,T.ItemCount,T.TotalAmount,P.Type,P.Amount:(PT=$1)}
>$1 Payment Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PT=$1)}
>Grand Total|{REPORT PAYMENT DETAILS:P.Amount.Sum}
1 Like
ilyas
April 8, 2022, 2:42pm
7
bezdelmax:
[Ticket payments:1, 1,1,1, 1, 2, 1]
@{REPORT SQL DETAILS:SELECT [Name] from [PaymentTypes]:F.Name::{0},}
TID|Date|Time|Items|Ticket Total|Payment Type|Tendered
{REPORT PAYMENT DETAILS:T.Id.desc,T.Date,T.Time,T.ItemCount,T.TotalAmount,P.Type,P.Amount:(PT=$1)}
>$1 Payment Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PT=$1)}
>Grand Total|{REPORT PAYMENT DETAILS:P.Amount.Sum}
[Ticket payments:2, 1,1,1, 1, 2, 1]
@{REPORT PAYMENT DETAILS:P.Type.distinct}
TID|Date|Time|Items|Ticket Total|Payment Type|Tendered
{REPORT PAYMENT DETAILS:T.Id.desc,T.Date,T.Time,T.ItemCount;#.##,M([T.TotalAmount]),P.Type,M([P.Amount]):(PT=$1)}
>$1 Payment Total|{REPORT PAYMENT DETAILS:[P.Amount.Sum]:(PT=$1)}
>Grand Total|{REPORT PAYMENT DETAILS:[P.Amount.Sum]}
1 Like
ilyas
April 8, 2022, 2:57pm
8
[Ticket payments:1,1,1, 1, 1, 2, 1]
@{REPORT PAYMENT DETAILS:P.Type.distinct}
>TID|Date|Time|Items|Ticket Total|Payment Type|Tendered
{REPORT PAYMENT DETAILS:T.Id.desc,T.Date,T.Time,T.ItemCount;#.##,M([T.TotalAmount]),P.Type,M([P.Amount]):(PT=$1)}
>>▶|[ $1 ] Payment Total||||{REPORT PAYMENT DETAILS:[P.Amount.Sum]:(PT=$1)}
>>↪|Grand Total||||{REPORT PAYMENT DETAILS:[P.Amount.Sum]}
3 Likes
Thankyou team this is really appreciated
1 Like