Dead Inventory Report
A Dead Inventory or Stock Report lists all stock that has not been sold since a specified date. This tracks inventory you have on hand that has not been sold recently
If users can clearly see what isn't selling, they can make more accurate business decisions about clearance products, what not to order again or generally managing their inventory.
A Dead Inventory Report is not yet available in NetSuite and is currently logged as Enhancement # 102390: Report/Search>User would like the ability to run a search or report that would show Items that have not sold and to be able to look at the inventory and see an aging.
Workaround
As a possible alternate solution, you can create an Item Saved Search:
- Criteria tab > Standard subtab:
- Criteria tab > Summary subtab:
Note that you can add other fields in the criteria or results tab as necessary.
Here's how it should look like when you run the search:
The maximum of date field should show the latest date that the item was used in a transaction. And since we added a Summary Criteria, the search will not show any item that was used within the last rolling year.
Check out this related discussion to know more about using Summary Criteria Filters: Using the Summary subtab under Criteria tab in Saved Searches.
-----
If you find this information useful, let us know by reacting or commenting on this post!