Article: KB-11749
How to:
resolve when a sku is locked in the Put system with "SKU LOCD" message.
Skill required to complete this article: Software ~ Order Fulfillment Put-To-Light and level is No Skill Level Association.

1. Access the database by typing dbaccess $DB_SQL -.

2. Navigate to the carton ex:   select * from carton where ship_label_id ="060199800040797278";

3. Use the ton number to find the orderl entries.

> select q_ordered,q_picked,in_use,status from orderl where ton ="101369950";

 

 

  q_ordered    q_picked      in_use      status

 

          1           1           0          17

          1           0      236403           0

          1           1           0          17

          1           1           0          17

          1           1           0          17

          1           1           0          17

          1           1           0          17

          1           1           0          17

 

8 row(s) retrieved.

4. The pick is locked by a GUI user id 236403. Use the sku_code to find if any how many picks are locked with this Gui id. 

 

>select unique in_use,count(*) from orderl where sku_code ="661395702060199800040797278" group by in_use;

 

 

     in_use       (count(*))

 

          0                7

     236403                1

 

2 row(s) retrieved.

 

5. Update the in_use field to 0.

> update orderl set in_use =0 where in_use ="236403" and ton ="101369950";

 

1 row(s) updated.

 

> select q_ordered,q_picked,in_use,status from orderl where ton ="101369950";

 

 

  q_ordered    q_picked      in_use      status

 

          1           1           0          17

          1           0           0           0

          1           1           0          17

          1           1           0          17

          1           1           0          17

          1           1           0          17

          1           1           0          17

          1           1           0          17

 

8 row(s) retrieved.

 

6. Have the site try to fill it. 

 Related Articles
No Related Articles Available.
 Help us improve this article...
What did you think of this article?
poor   excellent
Your Email:
Tell us why you rated the content this way. (optional)
RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
   
Toolbar's wrapper 
 
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
 
 
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.
   
 

 Comments...
No user comments available for this article.
Published on 6/24/2023.
Last Modified on 6/22/2023.
Last Modified by Christopher Ferguson.
Article has been viewed 243 times.
Rated out 0 of 10 based on 0 votes.
Print Article Print Article
Print Article Email Article