Allocating Stock-In-Hand To Ship-out

[rahulmamtora]

Hi All,

Please refer to below snapshot. I want your help to be able to allocate available stock as shippable and alongside it running Stock leftover until it gets exhausted.

So in here I have some dummy order numbers and 3 material in stock and based on the ordered quantity I want to allocate available stock until it becomes zero.

I tried using nested-if, but since my actual data is too big and some of the cases where for some of the materials the rows are more than 30, I found it difficult to arrive at a formula that suffices my above requirement of allocating shippable and showing stock leftover, if any.

Thanks for your help in advance.

Stock.JPG