Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

How to identify inventory items that are obsolete or unused

Option 1:

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

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

Option 2:

  1. Run an Activity Summary Spreadsheet

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

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

  3. A spreadsheet will open.

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

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

...