Stock Allocation basis FIFO

[abhishek4anand]

Please help to allocate stock basis request Request Delivery Date means first delivery date should be serve first (FIFO), I am stuck with same request date & quantity. Please help me out. Please refer attached work sheet Thanks

 

[vletm]

abhishek4anand
Is this Your previous same?

Stock Allocation basis required delivery date

Please help to allocate stock basis request Request Delivery Date means first delivery date should be serve first (FIFO), I am stuck with same request date & quantity. Please help me out. Please refer attached work sheet Thanks

chandoo.org

 

[abhishek4anand]

abhishek4anand
Is this Your previous same?

Stock Allocation basis required delivery date

Please help to allocate stock basis request Request Delivery Date means first delivery date should be serve first (FIFO), I am stuck with same request date & quantity. Please help me out. Please refer attached work sheet Thanks

chandoo.org

No this is first time i am using this forum...please help me out

 

[vletm]

abhishek4anand
Did Your no ... mean that You have not written that other thread?
... interesting ... because ... same username ... same registration IP ... same content IP
of course, now, Your IP is different than in #1 reply.
Any ideas?

 

[abhishek4anand]

I apologies, as have written same thing 2 times.

 

[vletm]

abhishek4anand
You should reread Forum Rules - there are useful hints to get results:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

How to get the Best Results at Chandoo.org
... You should give sample results.

You also could check this sample solution, if this could help You out ... somewhere.

 

[abhishek4anand]

Thank you so much it's look fine. but is it not possible without macro? means with excel formula..

 

[vletm]

abhishek4anand
It would be possible,
but that's my sample solution.
With Macros, You need 'only' to paste new data and press that button.

 

[bosco_yip]

Thank you so much it's look fine. but is it not possible without macro? means with excel formula

It can be done by formula solution with helper columns, please see as per following :

1] Create Helper Column 1 &2, by : Select J2:I48 >> Copy and paste to "Helper 1 & Helper 2" >> L2:M48

2] Select "Helper 1" header cell L1 >> "Editing" >> "Sort &Filter" >> Choose : "Sort A to Z", in sorting Helper 1 column by ascending order >> OK

3] In "Helper 3" N2, formula copied down :

=IF(SUM(N$1:N1)+M2>Q$2,MAX(Q$2-SUM(N$1:N1),0),M2)

4] In "Allocation" I2, formula copied down :

=IFERROR(1/(1/INDEX(N:N,AGGREGATE(15,6,ROW($L$2:$L$48)/($L$2:$L$48=G2),COUNTIF(G$2:G2,G2)))),"")

5] Hide all helper columns as per your required

6] See attached file

Regards

 

[abhishek4anand]

Thanks you Yip!.
does it not possible without sorting of Request_Delivery_Date?

Thanks..

 

[bosco_yip]

Thanks you Yip!.
does it not possible without sorting of Request_Delivery_Date?

Thanks..

Then, VBA is your choice, please check with Post #.06 answer.

 

[vletm]

abhishek4anand
Of course, You can always manually sort back Your data.

 

[abhishek4anand]

Please help me with below scenario.

If requirement not suffice from stock then look Open PO qty and allocate basis FIFO.
1 sheet for requirement
2 sheet for Stock
3 sheet for Open PO.

Thank you for support.

 

[vletm]

abhishek4anand
You seems to made some modifications eg with layout.

I tried to guess, what would You need to get this time.
There were no hint for needed result.

There are two 'modes'
... if Requirement-sheets cell J1 is bold then 'You can see - what is going on' and if non-bold then ... You can only wait.
Stock-sheet - I added 'open' values for each 'Part'.

 

[Pappu]

PLEASE HELP ME FOR BELOW POINTS
1. How to allocate a stock according to pending given seperatlly in site b & site c

please help urgentlly

 

[vletm]

Pappu
As above was Your the 1st posting,
You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

especially How to get the Best Results at Chandoo.org and You should remember

• Start a new post every time you ask a question, even if the theme is similar. The original author may continue asking questions whilst the post is in progress and of course if you are answering questions you may need to ask questions of the initial poster.