We have 3 products with more quantity in Open Orders than On Hand. We already allocated quantity by customer ship-to but then realized most customers had more than one order. We need to tell customer service how much to release against each order.
I've attached a file showing the orders on the left and the initial inventory allocation on the right. I need to enter a formula in column G that will take into consideration that the inventory is being depleted with each order fulfilled. For example, the first ship-to has 2 orders; qty of 2 and qty of 12 however we have only allocated a qty of 9 to this ship-to. What formula will result in 2 on the first line and 7 on the second? Thanks!
I've attached a file showing the orders on the left and the initial inventory allocation on the right. I need to enter a formula in column G that will take into consideration that the inventory is being depleted with each order fulfilled. For example, the first ship-to has 2 orders; qty of 2 and qty of 12 however we have only allocated a qty of 9 to this ship-to. What formula will result in 2 on the first line and 7 on the second? Thanks!