Customer Order Picking

[JavyD]

Hello everyone, just checking around to see if anyone has any ideas or have
seen a template hanging around somewhere to do the following.

Let's say I have customers orders, and inventory in a warehouse.

What I want to do, is go through each customer order, through each line or
item, see if we have enough inventory, probably a column next to the order
qty, indicating the inventory level, then, if I wish to send that order to
start being packed, check off a pack status. Now say I have this one product
I'm not going to ship, I need to check not to pack it. And say I have a new
item to add to the order, I need it to place it on the last available line on
the order.

After all of this, I need it to take all orders with a packing status, to
make a file so that I can purge into our MRP system to print all of the
orders.

Also, if there's any orders that I applied a new item to, it needs to make a
seperate file for that so that I can add those items to the orders.

Any ideas, I'll be working on this on my own, but any motivation would come
in big time handy. LOL