Let me try to explain as succinctly as possible here. We are a manufacturing company, but we do not use the manufacturing module. We make various products in 40 lb bags. I recently enabled lot number tracking and it's causing some headaches.
We have 410 lb of product A in inventory, lot number 1. We get an order in for 520 lb and create the sales order, overriding the shortage but allocating 400 lb of lot number 1.
Production looks at the spreadsheet we pull out of the sales module to see open orders, sees that we need more product to fill the order. They will produce product A lot number 2, and they will use that extra 10 lb of lot number 1 as part of the production.
I go to inventory transaction entry, enter how much of product A lot number 2 was produced, and start to enter the raw materials used. It tells me product A has -90 available, however, on the lot number entry screen, it does show 10 lb of lot number 1 as still available, but it won't allow me to enter it.
_______________________________
Currently this means I am having to go to the open order(s) for product A and reduce the amounts below the amount on hand, then post the production, then go back and restore the order to the correct amount, with both lot numbers allocated appropriately.
What is the proper way to do this that doesn't tie the inventory in knots? Should we be doing something else instead of overriding the shortage? Any help would be appreciated. Our office manager is a very, VERY nice lady but she is ready to murder me.