• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Article Need to Pick On FIFO Basis

N

Naresh Yadav

Active Member
Respected All,

Presently I am trying to make an excel template that can allow me to show location and qty to pick Article & Qty based on the FIFO Basis
I mean if I get one article on dated 11 Aug 17 Qty 50 pieces and moved it in a particular location S2A05-30 Pcs and S2A05-20 pcs
Second time I get the same article or Different article Qty 39 on dated 09 sep 17 and moved in in location S2A11-39 PCS
Now when I get the order of respective articles.. It should give me the article and qty in this way
Kindly refer the attached excel file
Stock Recd and moved
Article Qty Location Moved Receive date
355244 30 S2A05 11-Aug-17
355244 20 S2A06 11-Aug-17
355244 39 S2A11 09-Sep-17
355246 20 S2A15 09-Sep-17
Order Received Qty
Article Order Qty
355244 58
355246 15
Required Result on FIFO Basis
Article Qty Location
355244 30 S2A05
355244 20 S2A06
355244 8 S2A11
355246 15 S2A15

regards
Naresh
 

Attachments

  • FIFO-.xlsx
    9.4 KB · Views: 8
Respected Sir,

thank you so much for giving your Valuable time and efforts to help me out from this puzzle.
but I don't want Zero or anything, I Just want a formula to show only those location and qty where my required qty and location gets finished
kindly find attached file..

regards
Naresh
 

Attachments

  • FIFO-(1) (1).xlsx
    10.9 KB · Views: 9
Respected Sir,

Sorry to disturb you once again but just for my knowledge, is it possible to get the same result without adding helper Column E

regards
Naresh
 

Attachments

  • FIFO-(1a) (2).xlsx
    10.5 KB · Views: 9
You must log in or register to reply here.
Back
Top