Micros 3700 - Cashier Charged Tip Totals? Problems with "Outstanding"

[Carlos547]

Hello!

I've got a client that is set up to use cashiers. Trying to create a 40-column closing tip report for the servers but am running up against the difference between a cashier's net sales and an employee's net sales. On the cashier reports I am almost always getting an "Outstanding" total and I can't figure out where it is coming from. There are no open checks at the end of the night. I've checked both on the system itself and also in the DB.

It seems to only create a difference between the net sales on the two reports when the outstanding value is a positive number. Originally I created the report using employee totals and then discovered the cashier issue. I am thinking to recreate it as a cashier report but am unable to find the cashier equivalent of "v_R_employee_sales_tips.chgd_tips_ttl"

Notice the difference in net sales on the server tip out report (v_R_employee_sales_tips.net_sls_ttl) and the net sales on the cashier report (v_R_cashier.net_sls_ttl).

Any help / suggestions would be greatly appreciated!

 

[Colin518]

Can you run another set of sales and to get a new employee net sales, new cashier sales, and new outstanding balance and post the photos here.

 

[Carlos547]

Here's another example. Despite the large outstanding on this checkout the Net sales was identical for Server and Cashier. I notice that the difference is negative.

Thanks!

 

[Colin518]

Ill preface this with im out of my league trying to help here but perhaps i can explain what i know / see here and you or someone else can make sense of it.

That said what, i do know about cashiers is this.

Net Sales are always booked to and employee and the only way net sales are booked to a cashier is if they are generated from the terminal associated with the cashier number. If a check is created by the server at a different terminal and settled at the register associated with cashier it will come through as a negative outstanding because the cashier number didn't generate the check the employee (or another cashier number)did. Vise versa if a transaction is created on the cashier terminal and then opened somewhere else and settled, it it will be a positive number outstanding, Cashier created it and never settled it.

So it seems like you have another terminal in play here that is either generating, or settling checks that are associated with this cashier.

 

[Carlos547]

Thanks Colin - This got me thinking about from another angle. I'll keep the thread posted.