Attached db calculates stock on fifo basis use button stock on fifo basis to view puchase, sale and stock available on fifo basis and please add to my reputation if it helps you
