Distribution in excel


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 *