Sorting sattlement report by Waiter not Ticket number

I have a great report for seeing all tickets settled by which waiter, but the list become very long and it is dufficult to track waiters as report is in ticket number order, I would like it to be in waiter order. How will I do it please?

Ticket settlement

[PAYMENTS BY WAITER:2,2,2,2,2]

Waiter|Table|Amount|Payment|Ticket
{REPORT PAYMENT DETAILS:P.User,EN.Tables,T.TotalAmount,P.Type,T.TicketNumber}

Sort based on the P.User field by appending .asc (ascending) or .desc (decending) after the field.

{REPORT PAYMENT DETAILS:P.User.asc,EN.Tables,T.TotalAmount,P.Type,T.TicketNumber}

Thank you very much Joseph! I’ve been looking for this for years. I have more questions but will create new ticket for each so future learning is easier.

Actually, if I only wanted to show current user where do I add the {SETTING:CURRENTUSER} ?

{REPORT PAYMENT DETAILS:P.User,EN.Tables,T.TotalAmount,P.Type,T.TicketNumber:(PU={SETTING:CURRENTUSER})}

I would remove P.User since your only filtering to that user and it’s understood.

1 Like

Thank you, all works well… for other users here is my custom report

[PAYMENTS BY WAITER:3,5,5,3]

{SETTING:CURRENTUSER}
Table|Amount|Payment|Ticket
{REPORT PAYMENT DETAILS:T.TicketNumber,EN.Tables,T.TotalAmount,P.Type:(PU={SETTING:CURRENTUSER})}
CASH:|||R{REPORT PAYMENT TOTAL:(PT=Cash) AND (PU={SETTING:CURRENTUSER})}
CARD:|||R{REPORT PAYMENT TOTAL:(PT=Credit Card) AND (PU={SETTING:CURRENTUSER})}
Zapper:|||R{REPORT PAYMENT TOTAL:(PT=Zapper) AND (PU={SETTING:CURRENTUSER})}
Voucher:|||R{REPORT PAYMENT TOTAL:(PT=Voucher) AND (PU={SETTING:CURRENTUSER})}
Account:|||R{REPORT PAYMENT TOTAL:(PT=Customer Account) AND (PU={SETTING:CURRENTUSER})}

TOTAL:|||R{REPORT PAYMENT TOTAL:(PU={SETTING:CURRENTUSER})}

Please just rename the PT=Zapper to your payment types and remove what you don’t need

waiter window

For exta help link this report to an entity screen as a current user waiter report so waiters can cash themselves out without any management help, save a lot of time.

1 Like