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}
stephanhenning:
{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}
?
Jesse
December 30, 2020, 1:50pm
5
{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
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.
Im hoping the community can help me.
This was posted last year but did not get much attention so I’m posting again.
I would like to add a print button on and custom report entity screen.
I want my waiters to handle their own cashup at the end of the day, without them going into the admin or main menu side of Sambapos. This can be done via the entity screens easily if i can manage to get the print button to work for that specific custom report.
Previous post from forum member @adam100
1 Like