I was just putting together a requirements document to develop something similar. We need the daily inventory quantity / value for calculating GMROI metrics. I'm going to end up solutioning this by creating a custom "inventory history" record and a MR script to populate that on a daily basis.