inventory sort first in first out problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how would I create a first in - first out formula. What I want to accomplish
is everytime a user inputs waste or use, I want it to subtract from the
furthest date back forward and then by location. Or at the very least by
location. Any info would be greatly appreciated. Zenia
 
Your fifo table should look like these

Inventory_Part_FIFO_tab
part_no, Dated, Quantity, Cost

the table should have an index for part_no, and a second one combining
part_no and dated,

every time you input a transaction seek the transacted part number and start
subtracting the quantity from the oldest layer and delete the layer when it
hits zero and continue with the next layer, this will require some coding
difficult to explain in this forum's format, I suggest you read about using
recordsets in visual basic and loops (like do while),

I hope this will give some direction
 
So what I am reading is that I need to make a new table with ProductID, Date
(would this date be the receive or order date - I am assuming the receive
date) quantity and cost. What exactly do you mean by an index (is this a
query) and then would I automate this activity of subtracting?
 
Back
Top