I will like to suggest that inventory items should have expiring date at the point when you buy (supplier invoice) and when you sell. (cust. Invoice). there should also be a set of reports that show me movement and valuation report as per expiring. The report such that I can filter reports in weeks month and year.