This report will help you find items for which you are holding more stock than the statistics estimate you require. An overstocked item is different from dead stock. Dead stock is sitting on the shelf and hasn’t sold but an overstocked item is one which may be selling but you have too much stock of.

How to find

From the Main Menu in Retail:

  • 2 Stock Control, 3 Stock Maintenance, 1 Maintain Products in bulk
  • Press Enter to see a list of pre-created reports. If not already available and you want to save this selection for future use (to avoid configuring each time) F3 [Add] then type a recognisable name into the ‘Criteria name’ field, e.g. "SOH exceeding Cover"
  • In the field Cover greater (days) enter the number of days you classify as overstocked. I.e. if you consider, based on the current stock on hand and previous usage, that any item with 6 months (or more) worth of stock is too much to carry then enter 180.
  • Press F12 [Accept Details] to compile the report

The following 3 steps are optional

  • To remove items recently purchased (and therefore may not have had a chance to sell) Press F2 [Edit List then] R- Remove Items in Bulk
  • In the field Received within (days) enter the number of days you classify as being new stock. I.e. if you consider any item bought within the last 3 months as new then enter 90.
  • Press F12 [Accept Details]
  • To print out the list press F10 [Other] then ‘P’ for Print Product List

How to Resolve

  • Do a stock take if necessary  
  • Consider options for moving excess stock if SOH is accurate (ie specialling). You may also choose to set the Don’t Order flag within the F4 [Stock] section of the product stockcard. This will then prompt if someone tries to place an order for more of this item.  Also check the Reorder point and Reorder quantities on the product stockcard.