I would like to get a report showing consumption data for materials held in our stores. I will want to run this for a range of material numbers (Maybe around 4-5000 different stock items). Purpose of running this is to a) Identify stock items which haven't been used for a certain length of time (e.g. 1 year) and also to look at the frequency of use of certain materials so that most frequently used items can be stored more conveniently.
Example layout would include Material number, short text, days since last move, last move date, number in stock as of date report is run, value (Either total or per item) then for a specified date range, looking at either the number of units used per month or the number of stock movements per month or both (e.g. were 10 units taken once or 1 unit taken 10 times)
Happy to export into Excel or if it requires multiple reports and vlookups then can do that of course.
Is/are there standard transaction reports which would provide me with this data? if so, please could you let me know as i cant find how to get all of this info - particularly the monthly breakdown of consumption.