inventory fifo db

[betna]

i want to make inventory fifo(first in first out) db
example:
February
1- beginning balance : 800 unit @ 6$ per unit
4- received 200 unit @ 7$ per unit
10- received 200 unit @ 8$ per unit
11- issued 800 unit
12- received 400 unit @ 8$ per unit
20- issued 500 unit
25- returned 100 unit to storeroom to be recorded as latest issued prices
28- received 600 unit @ 9$ per unit
the report must be like pic attached

i dont know how to make thr transaction to do this
plesae help me
my database in attachment

 

[jdraw]

see this link for some info
http://www.accessforums.net/access/fifo-inventory-25249.html

 

[HiTechCoach]

also see: Inventory Control: Quantity on Hand

 

[gemma-the-husky]

quantity is relatively easy.

once you want to manage the valuation of your inventory, it's a whole other problem. this is one of the most complex things you can do, because the difference in prices means the stock is no longer homogenous.