FIFO Stock control

[itwilson]

I have a deliveries table and an issues table with dates, etc. What I would like to know is when I have calculated the current stock how to know which delivery they belong to. I'm going by the first in first out method. eg Say I have 200 items currently in stock and the last 2 deliveries were 100 and 250 items respectively. I would like to be able to see that the current ctock consists of the last delivery (100 items) and 100 items of the delivery before that.

Thanks

 

[The_Doc_Man]

Usually, the rule is that if you want to see it on a regular basis, you have to store it. So you might need to include a date-tag on each item to show when it came in. Otherwise, I see some complex VBA code in your future.