A couple of years ago I found this example on the internet. I cannot remember who the author is. The example is great. However, there is one challenge to fix.
I should be able to solve it, but the past couple hours some brain cells are sleeping.
1. I add a simple fourth product, and then a purchase transaction on that 4th product.
2. The last report "Stock Value Report on Fifo basis" should list that newly added product, without doing a sale on that product as well.
3. If I add a quantity of 50 of the new product, and then capture a sale on a later date of 40, the report returns 10 which is correct.
4. If I don't capture a sale, it should return 50 as product available. It does not. That must be wrong.
5. I am sure something small will correct it.