SambaPOS shows wrong person when paying a ticket if it has been moved

V5 Question
1

Hi Guys,

SambaPOS is showing the wrong person when settling(paying) a ticket after it has been moved and merged.

Scenario.

  1. Mary enters some food for table 10
  2. John enters some food for table 20
  3. Mike moves table 20 into table 10 and merges table 10 and 20
  4. Mary settles(pays) the ticket.
  5. When I run the server report, the table shows as paid by Mike.

Is there a way to fix this issue to show as paid by Mary.

Thanks in advance for your help.

[Server Sales Details:3,2,3,2,2]
Date:|{DATE}
Server:|{SETTING:CURRENTUSER}
>Time|T.No.|Payment|Total
{REPORT PAYMENT DETAILS:P.Time,T.TicketNumber,P.Type,P.Amount:(TS.Status=Paid) AND (TY=Ticket) AND (TU={SETTING:CURRENTUSER})}
>.
C.C: |||${REPORT PAYMENT TOTAL:(PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
Cash:|||${REPORT PAYMENT TOTAL:(PT=Cash) AND (TU={SETTING:CURRENTUSER})} 
G.C:|||${REPORT PAYMENT TOTAL:(PT=Gift Card) AND (TU={SETTING:CURRENTUSER})} 
Check:|||${REPORT PAYMENT TOTAL:(PT=Check) AND (TU={SETTING:CURRENTUSER})}
>TOTAL:|||${REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}
.
Busboy Tip Out 3%:|||$[={REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}*.03]
Busboy Tip Out 4%:|||$[={REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}*.04]

[Percent Off Discounts:16,12,20,20,20]
    Ticket No|Table|Discount Percent|Discount Price|Amount
    {REPORT ORDER DETAILS:T.TicketNumber,EN.Tables,OTN.Discount Custom Percent,OTP.Discount Custom Percent,ON.TotalPrice:(OT=Discount Custom Percent) AND (OU={SETTING:CURRENTUSER})}

[Dollars Off Discounts:16,12,20,20,20]
    Ticket No|Table|Discount Off|Discount Price|Amount
    {REPORT ORDER DETAILS:T.TicketNumber,EN.Tables,OTN.Discount Custom,OTP.Discount Custom,ON.TotalPrice:(OT=Discount Custom) AND (OU={SETTING:CURRENTUSER})}

{REPORT TICKET DETAILS:T.RemainingAmount.sum:(TU={SETTING:CURRENTUSER})}

[DISCOUNTS:1,1, 1, 1, 1]
>Ticket#|User|Ticket Total|Rate|Discount Amount
{REPORT CALCULATION DETAILS:T.TicketNumber,C.User,T.TotalAmount,C.Amount,C.CalculationAmount:(CT=Discount)}
2

Isn’t ticket TU ticket user?
As mike merged them it created a new ticket combining both - he created that ticket and so was the ticket user?

3

@JTRTech

Our issue is that servers(Mary and John) can not see each others tables, so Mike(Manager) needs to merge tables.

We need to track who settled the table. In this case, report should show Mary and not Mike.

Is there a way to fix this so I shows as Mary.

Thanks again.

4

Wouldn’t it be something like PU rather than TU

1 Like
5

Sorry, JTR what is PU and TU.

6

So it should be PU.username TU is going to show the ticket user which is what your report is doing.

Work Period report can give you a really good reference when building reports. Settled By portion of report shows possible usage.

[User Sales:1, 1] 
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,} 
[Settled by $1:1, 1, 1] 
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)} 
>Total Income|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}

I changed this from Issue to Question unless we are proven wrong then we can change it back but I really do not think this is a SambaPOS issue.

2 Likes
7

Kendash /JTRTech you guys are a life savers. It works like a charm. Thank you both.

1 Like