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!
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!