Has anyone developed a way to indicate on the order if any of the order lines have been picked already?
Create a derived IDO Property (e.g. DerQtyPicked) with an implementation of:
(SELECT SUM(qty_picked) AS DerQtyPicked FROM coitem WHERE co_num = CoNum)
This was exactly what I was looking for. We added a visual indicator to the order that makes it immediately evident to our Order Entry personnel that it has been picked. Thanks for your help!
No problem. You can tweak the SQL code to determine if it was picked in full by comparing the sum of qty_picked to the sum of qty_ordered. If they match, it was picked in full, if not, there are still items to be picked.
