I’m looking for ideas on data trending. We’ve been live about 30 months and the VPs are wondering how we can move beyond the ‘snapshot’ metrics we’ve been using and start saving the results of our queries for future reference.
For example inventory turns can be calculated on the spot but to go back 6 months and figure out what was in inventory at that point is a little tough. What I’d like to do is squirrel something at the end of every month so I can report against that data going forward. Is there a common practice for doing this in E10.2.300?