Feature - Sales Desk Trial Lock Logic to Prevent Locking Storm

Feature - Sales Desk Trial Lock Logic to Prevent Locking Storm

Release Date: 06/17/20
Version: 8.5 & Up

In larger Elliott installations with hundreds of salespeople and multiple warehouse locations to ship from, a special deadlock condition occurs in Sales Desk when multiple salespeople are competing for the same item (a very popular one). The deadlock can happen if the primary location does not have stock and the salespeople are competing for the secondary location's inventory. When the "deadlock storm" happens, the only solution is to kill the offending salesperson session on the PSQL monitor. In some situations, since many salespeople have  already committed to the creation of the order for the same item, killing the PSQL session for one salesperson will just result in the system substituting another salesperson.  So the admin may keep on killing the salesperson's session for many, many times until none of the salespeople are competing for the same item. 

We are making a change to Sales Desk. Before committing to creating the sales order, the system will now check to see if the all the items and inventory locations (when ordering from secondary locations) can be locked first.  If the system can't lock the item or inventory location record, then it will not commit to the order creation.  This change resolves the "deadlock storm."  We call this feature "Trial Lock." The following is an example that illustrates this new feature:

Step 1. The IMINVLOC record for Item# 0025 and Location G is locked, and the salesperson is trying to create the order containing that item: 
   
Step 2. The salesperson presses Enter on “Field Number?” in Sales Desk and tries to create the order.  The salesperson receives the message “Inventory Location 0025G Is Locked.” See sample screen below: 


Step 3. The salesperson presses “OK” on the locked message. The cursor goes back to “Field Number?” as in the first screen.  The salesperson can retry, but as long as the locking condition exists, the salesperson will continue to receive the locked message.

Step 4. Once the lock for inventory location Item# 0025 and Location G is released, the salesperson will be able to create the order from Sales Desk. See sample screen below:   



Modified Programs: CPQUOSCN, CPQUOTRY

EMK



    • Related Articles

    • Btrieve Error USE on COP Lock File

      Q - Today, for whatever reason, we experienced a large amount of locking issues in the warehouse. Several times today we ran into the problem with printing invoices where we received a message "Btrieve Error USE on COP Lock File," and it stops ...

    • CPSLSDSK Customer Order Processing Sales Desk

      Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...

    • CPPURSDQ Customer Order Processing Purge Sales Desk Quote

      Purge Sales Desk Quote Application Overview Quotes entered in Sales Desk can be purged quickly and easily. You are asked if you wish to purge and then prompted for a cut-off date. Run Instructions COP Main Menu > Util-Setup > Purge Sales Desk Quote > ...

    • User Received Lock Message on NSCTLFIL 000000100 in Sales Desk

      Release Date: 7/10/2019 Version: 7.0 & up Q - A user received this lock message when searching for a customer. We never see locks on the NSCTLFIL and I know they can cause issues for everyone if they happen. I do not know what user DUDA was doing. ...

    • Can Item Lead Time Be Added to the Sales Desk Screen?

      Recently, we have been asked if there is there way to change the data in the QTY BO field to be Lead Time and to add Lead Time data on the Sales Desk screen. For some users, QTY BO is irrelevant on this screen. The answer is yes. You can replace "BO" ...