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