Changes to the inventory need to cater for the ability to report as at on he Inventory. Currently price changes to inventory records are not tracked -e.g
01/07/08 Receive in 100 at 100.00
15/08/08 Purchase Invoice at 125.00
19/09/08 Update Cost Price Change to 115.00
The IN_SOH record only shows the latest cost of 115.00. As At reporting on 1 July reports cost of 115.00 not 100.00
This is further compounded when part of the stock is sold or transferred before/after each of these changes