Identifying Obsolete or Unused Inventory

How to identify inventory items that are obsolete or unused

Option 1:

1. Run the Inventory Advanced Report to show the Last Transaction Dates

   1. INV > Report Manager > Advanced Reports > Print Standard Reports > 2. Last Transaction Dates

   2. Open

      

Option 2:

1. Run an Activity Summary Spreadsheet

   1. INV > Report Manager > Inventory Status Reports > Print Standard Reports > 15. Activity Summary Spreadsheet

   2. Open

      

2. Key in the date range you are looking for on the additional options screen

   1. Open

      

3. A spreadsheet will open.

4. For sales, look at column AI on the spreadsheet for Sales Quantity and column AP for Sales Amount $

   1. Open

      

5. Sort the columns using Excel functions in the order desired, such as putting most sold quantity or dollars at the top.