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.