Distribution in excel

Hi 

I want to allocate Stock available (Column K) qty as per Sales order – Line item combination (basis first come first serve basis).

 

Sales order qty – 5169

Available stock qty – 3500

* Allocation should happen basis first Sales order and first line item combination.

 

Please guide solution to it…

By: Ayush

Leave a Reply

Your email address will not be published. Required fields are marked *