Historical Stock Qty

Hi Chris,

RMS definitely stores the required information but it can be a bit difficult to get at. The item movement report has the data you need but probably not in the format you hoped for. If you export the report to excel and put a little work into some formulas you could potentially get your information without too much effort, the 66,000 row limitation might cause a problem depending on how much data you?re working with.

We are in the middle of building an advanced purchasing tool that shows things like number of out of stocks during a given period of time and length of out of stocks - we use this same information to calculate these figures.

I hope that helps!

Rick Feul> Is there a way (or indeed does RMS hold) of getting historical stock level