Hi all is there a way to auto deduct an amount off of the waiters daily tips for breakage
and for a daily report to show it
For example:
total Tips-waiters (1) $5000
Tips $750
Less Breakage $20
Total Tip Pay out $730
waiters (2) $4000
Tips $650
Less Breakage $20
Total Tip Pay out $630
Total Tip Payout $1,360
Allot more information needed.
How are you allocating tips to specific waiters/users?
Is it plain reporting on ticket user?
I am using a payment process
This is the report that i am using
[Server Sales Details: 3,2,3,2,2]
Date:|{DATE}
@{REPORT TICKET DETAILS:T.User.asc::,}
Server:|$1
TOTAL:|||R[=TN('{REPORT PAYMENT TOTAL:(TU=$1)}')-TN('{REPORT CALCULATION TOTAL:(CT=Tip) AND (TU=$1)}')]
Tip:|||R{REPORT CALCULATION TOTAL:(CT=Tip)AND (TU=$1)}
[Tickets:2,1,1,1,1,1]
Ticket|Amount|Tip|Cash/Card|
@{REPORT PAYMENT DETAILS:T.User.asc::,}
>>Waiter:|$1
{REPORT PAYMENT DETAILS:T.TicketNumber,[T.TotalAmount]-[CA.Tip],CA.Tip,P.Type:(TS.Status=Paid) AND (TU=$1)}
>Total Tip Cash:||{REPORT PAYMENT DETAILS:CA.Tip.Sum:(TS.Status=Paid) AND (TU=$1) AND (PA=Cash)}
>Total Tip Card:||{REPORT PAYMENT DETAILS:CA.Tip.Sum:(TS.Status=Paid) AND (TU=$1) AND (PA=Credit Card)}
>>Total Tips:||{REPORT PAYMENT DETAILS:CA.Tip.Sum:(TS.Status=Paid)}
I would like there to be a to be a daily deduction from the waiters tip’s of $20 for example is this possible and can i report it.
QMcKay
August 16, 2017, 12:05pm
4
You already do a calculation using an expression for your Total, so just do the same for subtracting 20 breakage:
Tip less breakage:|||R[=TN('{REPORT CALCULATION TOTAL:(CT=Tip)AND (TU=$1)}') - 20]
Thank you, you have been a great help. That works perfectly