Stuck Items – Two-Minute Demo

A companion to the Days of Stock Report is the Current Stock Items Dashboard. This display gives you instant awareness of those items you have in inventory that haven't sold within the last X days. This dashboard has just a single selection criteria on last sales date. For example, if you wish to see all items that had not been sold after August 22, 2029, you would specify this value in the Last Sales Date field. Note how the third record in this list, the Keurig Model 450, is the one product that has sold this year, so there still may be a little life left in the sales channel for that item. However, if we change the last Sales date criteria to see only those items that had not been sold after July 30, 2029, the Keurig Item will be removed from this list. About the Selection Criteria if you wish to add more criteria such as on item class, industry, sales region or any other criteria, you could easily do so and without the assistance of a programmer or data analyst. Looking at the results of this dashboard, it's the last three columns that give you additional insight about your non selling items. First is quantity on hand. Some of the larger quantities, such as for the Dell desktop computer and hard drive, account for some $350,000 worth of inventory that's not turning into revenue. But it's not just about the quantity on hand. Although there are only six injection molding machines in stock today, their combined value is some hundred and twenty thousand dollars. So whether it's planning your inventory needs, it's in terms of projected sales or optimizing your current on hand levels so as not to find yourself in an overstock situation. Data Cells Inventory Reports have you covered.