"Unable to Close Cashier Office because it is Already Closed"

Receiving error “can’t close cashier office because it’s already closed”.  Usually happens because the cashier office was opened, closed and opened again instead of being opened, closed and reopened.  However this isn’t the only time this problem occurs.

 

By checking the tables and the panels we learned that VCCS will need to run the following SQL update to set the current_bus_dt to NULL on the CSH_OFF_TBL:

 

UPDATE PS_CSH_OFF_TBL

SET CURRENT_BUS_DT=NULL

WHERE BUSINESS_UNIT=NV280

     AND CASHIER_OFFICE=”XXXX”

Add Feedback