I would like to be able to see at any previous date how much inventory we had at hand to be able to estimate how much longer the inventory will last and when it’s time to order more.
The issue with just looking at the inventory or the “Quantity by location report” is that it will only tell me for the current day.
The report “Inventory Quantity movement” would work very well for us if it showed all items (even items where there was no movement) as I copy this information into our excel sheet monthly to calculate how long the stock still lasts on average, when it’s time to order etc.
It would be great if Manager would tell you an estimate of how long your stock lasts using production orders and sales to calculate average usage.
Am I missing something or is my best bet to export and save this information on set dates and just hope I don’t miss a date? Perhaps I’m just stuck in my old ways and there are much better ways to get an full overview of all our raw materials and packaging to avoid disruptions?