I
itwilson
Guest
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
Thanks