This article will provide remediation steps to manually release cash drawers when users are unable to do so from the POS application.
If a user is unable to release their drawer due to access level restrictions, use the SkyWire admin PIN to release the drawer. If this does not work, you will need to log into the SQL database on the appropriate zone controller and try the following queries:
How to manually release a cash drawer for a single user:
**WARNING**
Only run these queries at the zone controller databases. If these are run at the enterprise level, it will cause severe damage to the data replication system.
UPDATE Shifts
SET MyDrawerOwnerTermId = NULL, MyDrawerOwnership = 0
WHERE UserId = 'enter enduser's Id here'
Or IsClockedIn = 0 and MyDrawerOwnerTermId is not NULL
How to release drawers on all terminated/deleted users:
UPDATE Shifts
SET MyDrawerOwnerTermId = NULL, MyDrawerOwnership = 0
WHERE UserId in (Select ID from Users where IsTerminated =1)
or UserId in (Select ID from Users where IsDeleted =1)
or IsClockedIn = 0 and MyDrawerOwnerTermId is not NULL