Low Inventory Report for fast selling items, ie Alert if the inventory level fall below 7 days based on historic daily consumption
started a topic
over 6 years ago
I would like to see a Low Inventory Report for fast selling items, for example, if we sell 7pcs of Item A per day based on the previous 7 days or 14 days or 30 days, and the inventory level falls below 49pcs (weekly consumption) or 210pcs (monthly consumption), then it should appear as an entry in the Low Inventory Report. This report should auto-generate daily, and ths user can customize the base of daily consumption (7 days, 2 weeks, 3 months ...), definition of fast selling rate (ie 5 units per day, or 10 units per day...), and the required report duration (ie. inventory level below 7 day, 2 weeks, 3 months ...)
At the moment you can see the low inventory list in the dashboard, but it is not really useful. Because many of the item might be discontinued, very slow moving ... it might work when a company only sells 20 or 50 products, but when the total number of the products are more than 300 and number of inactive and slow moving items are more than 30, it is completely meaningless.
8 people like this idea
about 5 years ago
This is something that could be achieved through a Query Data report. Please contact support to discuss requirements.