Skip to main content
Use Operations > Inventory > Dead Stock to find dormant stock that may need a clearance, a return to the vendor, or a write-down review. A product is listed when it has stock on hand but nothing has been drawn from its cost layers, by a shipment or a stock reduction, within the number of days you choose. The report is read-only.

Before You Start

  • Permission: you need View Reports to open the screen and run the report.
  • Location filter: the Location list appears only when your company has more than one location, and it needs View Settings to load. Without that permission the report still runs for all locations.
  • What counts as movement: stock leaving a FIFO cost layer, for example when an order ships or an adjustment reduces stock. Receiving more of a product does not count as movement.
Other ways in: search for Dead Stock in the command palette. The other Operations > Inventory screens (Overview, Transactions, Receive, Adjustments, Supply & Demand, Valuation, Aging and ABC Analysis) are one step away from the same group.

Run the Report

  1. Open Operations > Inventory > Dead Stock. The report runs with a 90 day window as soon as the page opens.
  2. Enter a number of days in No movement in last (days), from 1 to 730. A blank field uses 90.
  3. If you have more than one location, choose one in Location, or leave All locations.
  4. Select Run Report, or press Enter in the days field. The button reads Running while the report loads.
The report also runs again on its own once you finish typing the days (when you pause or leave the field) and when you pick a location. The days and the location stay in the page address, so going Back from another screen, refreshing, or sharing the link brings back the same report, and opening the report fresh starts at 90 days for all locations.

Read the Results

Summary cards:
  • Total dead stock value: the value of every listed product, with the note No movement in (days)+ days.
  • Dead stock units: the units in open cost layers across the listed rows, and the number of distinct products (SKUs).
  • Lookback window: the number of days the report used.
Table columns: The footer reads Total (n SKUs) with the units and value. The Lookback window card adds “Adjust above + re-run to change threshold”. Each row is one product at one location. With All locations, a product dormant at two warehouses shows a row for each, named in Warehouse, while the SKU count on the Dead stock units card and in the footer counts the product once. Choose a location in Location to see one warehouse.

Messages You May See

Common Scenarios

  • Quarterly clearance list: run with 90 days and review the products with the highest value first.
  • Long-dormant review: run with 365 days to find stock that has not moved in a year.
  • Never sold: look for Never in Last movement. These products were received but nothing has left their layers.
  • Before buying more: check that a product you plan to reorder is not already dormant at another location.

What This Report Does Not Change

Running the report is read-only. It posts nothing to the ledger, moves no stock, and sends no notifications. To clear or write down stock you find here, use an inventory adjustment or a vendor return.

Inventory Aging

Operations > Inventory > Aging: how long current stock has been on hand.

ABC Analysis

Operations > Inventory > ABC Analysis: classify products by consumption value.

Inventory Valuation

Operations > Inventory > Valuation: the value of all stock you hold.

Inventory Adjustments

Operations > Inventory > Adjustments: write down or remove stock you decide to clear.

Vendor Returns

Operations > Returns > Vendor Returns: send unsold stock back to the vendor.