Custom Reports Ticket Total Amount in expression

Version 4
1

Good day,

Can’t find out how i can put Ticket.TotalAmount in expression, T.TotalAmount not working.

{REPORT TICKET DETAILS:T.TicketNumber,EN.Table,T.Date,T.Time,T.TotalAmount,CA.Discount:(CA=Discount) and (T.TotalAmount=0)}

It shows an error that ticket data doesn’t have field T.

I need to display all tickets with Zero Total Amount in my report.

2

It will show all tickets without having to do that. Do your Tickets with 0 amount also have CA=DIscount? Or do you ONLY want tickets with 0 amount to show?

Try this I have not tested it:

{REPORT TICKET DETAILS:T.TicketNumber,EN.Table,T.Date,T.Time,T.TotalAmount,CA.Discount:T.TotalAmount == 0:(CA=Discount)}
3

Yes. With discount. I trying to track 100% discounts.

I guess I just solve the problem.

Looks like this works:
{REPORT TICKET DETAILS:T.TicketNumber,EN.Table,T.Date,T.Time,T.TotalAmount,CA.Discount:(CA=Discount) and (Ticket.TotalAmount=0.00)}

1 Like
4

Seriously :slight_smile: Half a day was fighting with it. But after I posted, decided to try just to put Ticket in expression :slightly_smiling:

1 Like