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

266 thoughts on “Distribution in excel

  1. пита рецепт без дрожжей

    I’m amazed, I have to admit. Seldom do I come across a blog that’s equally educative and entertaining, and let me tell you, you’ve hit the nail on the head. The problem is something that too few people are speaking intelligently about. I am very happy I came across this during my hunt for something concerning this.| а

Comments are closed.