DBD: Obsolete / Inactive Item Analysis

The Obsolete / Inactive Item Analysis report evaluates inventory items that have shown low or no activity over a designated number of days. It provides critical insight for adjusting stock levels, managing seasonal patterns, and identifying products that may be ready for archival.

Key Features

Dual Activity Tracking: Features distinct settings to check either for active warehouse physical movement or for plant order activity.
Seasonal Evaluation: Supports an optional breakout of up to two years of historical monthly usage data to distinguish between permanent inactivity and expected seasonal lulls.
Automated Customer Outreach: Includes an option to populate and update the Inactive Item Notice Print File, which works with a preprinted form to automatically alert customers when their forms go completely inactive.

Navigate to: DB Distributor > Print Management > Cycle Processing > Reorder/Low Stock Functions > Inactive Item > Analysis (FMO N1)

Available Sequences

When generating the analysis, the data is organized using the following sequence option:

By Customer / Item

Understanding the Report Output

The report combines core catalog indicators with multi-year transactional timelines:

Column / Section	Description
Selection Parameters	Displays filter logic applied at execution time (e.g., `Inactive since` or `Last produced prior to` thresholds).
Item Code & Description	Lists the unique product ID, catalog engineering revision dates, and clear description lines.
Last Produced / Last Released	Shows critical dates of the item's last manufacturing run versus its last operational warehouse deployment.
Committed	Displays any current physical quantities allocated or held for pending orders.
On Hand	The absolute physical inventory remaining in storage, scaled to its defined selling package/unit parameters (e.g., `48 CTN/700` ).
Usage by Month Grid	Provides a horizontal month-by-month (`JAN` through `DEC` ) view across a rolling two-year historical window to isolate consumption pacing.

💡 Tip: Tracking the variance between Last Produced and Last Released fields can show you if a client is burning through old stock or completely sitting on stagnant capital.