Grouped payment Types Report

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
[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

[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