Pick Workbench Quantity to Pick Question

I have a situation where a pick was created, then the order was deleted, then the pick was deleted which was the incorrect sequence. On the next order for the same item, the pick quantity on the Pick Workbench form is remembering the last pick which doesn't really exist anymore.

Is there a way to completely remove the previous quantity to pick?

Thanks in advance.

Find more posts tagged with

General Discussions

Accepted answers

All comments

adata

We've encountered a similar situation a couple times. I believe in our case we had to reset the assigned_to_be_picked_qty for the itemloc and lot_loc records.

unknown

Thanks! Found the column. Does resetting the number mean updating with a new number or set to zero? Is there a form that calculates the number?

adata

In our case the item was lot tracked and the lot_loc record had a quantity on hand of 1 so the assigned_to_be_picked_qty was simply set to 0. The item_loc record was also set to 0 as the lot in question was only one in inventory. More appropriately, these should be set to the legitimately picked totals for the lot location and/or item location. We did not find a utility to re-calculate these numbers immediately and ended up manually updating the value in the database.

unknown

Your suggestion worked. Thank you so much.

FordUS_ship_req.pdf

Copyright © 2025 Infor. All rights reserved.