Making Products Inactive in Bulk

Your stock holding is a major investment in your business; the value of stock held should be kept as low as possible, reducing the amount of funds tied up in stock.      

From the Products / Utilities / Inactive Products

You may select either a range of products by Code, group, Sub group or Type, or the entire Product file to review.

Then set a date of last sale, to select our old product codes that have not sold since the date entered; three years is a good guide.

We also need to exclude new codes that have recently been created, but never sold.

Include Items with Stock on hand – Tick this as we wish to identify products that have been sitting for over three years.

Include Items which have never been receipted Tick this as we seek to identify obsolete codes.

Most sites will produce a rather large report.  The report will be broken down into a number of key sections.

Products with no last Sale, no last receipt, and no stock in hand – this represents codes created and never used; often a Pricebook may have been imported and the majority of the codes never used.

Products with last Sale prior to the date supplied, no last receipt, and there is stock in hand – This represents the list of stock that you currently have, but has not moved for over three years.  These items need to be reviewed, and either discounted for quick sale, or written off and removed from the general stock, so that they are not counted as part of the stocktake and never re-ordered.

Once you exit out of the report you will be prompted to mark the items as inactive.  Select No until such time as you have been through the items with stock on hand and adjusted these.  Then come back in and re run the utility, this time marking the items as inactive.