Hi
I have an outstanding order report listing all outstanding order lines. I want to be able to allocate available stock to order lines, allocating to the oldest order frist.
My proposal is to have one sheet listing outstanding order lines (Sheet 1). The a second sheet to hold a stock list with available quantity (Sheet 2). I need a formula to allocate available stock until the stock is depleted. If no stock the result would be 0.
Sheet 1 (oustandind order lines)
A1 = Stock ID
B1 = Qty on order
C1 = Original order date
D1 = (Proposed Allocated Qty formula)
Sheet 2 (Stock List)
A1 = Stock ID
B1 = Qty Available
I hope this is clear?
I have an outstanding order report listing all outstanding order lines. I want to be able to allocate available stock to order lines, allocating to the oldest order frist.
My proposal is to have one sheet listing outstanding order lines (Sheet 1). The a second sheet to hold a stock list with available quantity (Sheet 2). I need a formula to allocate available stock until the stock is depleted. If no stock the result would be 0.
Sheet 1 (oustandind order lines)
A1 = Stock ID
B1 = Qty on order
C1 = Original order date
D1 = (Proposed Allocated Qty formula)
Sheet 2 (Stock List)
A1 = Stock ID
B1 = Qty Available
I hope this is clear?