Report ticket types Help!

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

I have two ticket types which have negative amounts Refunds and Payouts
I want to have a separate report for each ticket type

I have tried {REPORT TICKET TYPES:TotalAmount < 0 && (TY=Refund)} & {REPORT TICKET TYPES:TotalAmount < 0 && (TY=Payout)}but its not working.

I also have ‘Quotes’ and ‘Layaways’ which I definitely need separated

[Layaways:1, 1]
{REPORT TICKET TYPES:PreOrder && TotalAmount >= 0  && (TY=Layaway)}
2

You can try that.

[Refund Tickets:1, 1]
{REPORT TICKET DETAILS:T.TicketNumber,T.TotalAmount:(TY=Refund)}
[Layaways:1, 1]
{REPORT TICKET DETAILS:T.TicketNumber,T.TotalAmount:(TY=Layaway)}
3

OK I got this working another way

[Layaway:1, 1] Layaway|{REPORT TICKET DETAILS:=[T.TotalAmount]-[T.Tax]:(TY=Layaway)} Tax Total|{REPORT TICKET DETAILS:T.Tax:(TY=Layaway)} GRAND TOTAL|{REPORT TICKET DETAILS:T.TotalAmount:(TY=Layaway)

I thought there would have been an easier way to filter the`REPORT TICKET TYPES because it adds the taxes by default but this works too.

Just curious if there is a field for taxable amount?

4

This is the correct way to do it. However you’ll need to add .sum (like T.Tax.sum) after field names on Total rows.

5

Looks like we both posted those at the same time.

I have been reading the Custom Report Tags in detail Tutorial and I’m slowly starting to get my head around it.

Ok perfect that was my next question. I did not see anything about the .sum but im sure I probably missed it. Thanks