Overview

A Sales Order has been locked by a user. When you try to invoice the Sales Order, you receive the following message:

The Current Sales document is already locked by user {username} at {workstation}. Do you still wish to open it for viewing?

Solution

Please follow the steps below to release the lock:

1. Open SQL Server Management Studio on the server system.
2. Right-click on your company database and select New Query.
3. Execute the following query:

   SELECT *
   FROM   semaphor 
   

4. Note the id or ids from the resulted list (from the SEMAPHORE_ID column)
5. Execute the following query:

   DELETE FROM semaphor
   WHERE  semaphore_id = {id noted earlier} 
   

   Note

   Depending on the number of ids obtained in step 3, you may need to run this query multiple times, for every lock you want to remove

Running the queries above will clear the Sales Order locks.

Testing

The Sales Orders can now be processed normally. If you're still experiencing issues, please contact support.