DBD: Item Usage Report

The Item Usage Report packs an extensive amount of analytical data into a single view. Because it consolidates broad inventory status with multi-year consumption metrics, it is specially formatted for electronic or preprinted forms. It serves as a vital tool for comprehensive audit health and is generally run at the end of cycle processing.

Key Features

Combined Report Logic: Merges data models similar to both the Items Status Report and the Usage History Summary Report.
Rolling Averages: Automatically calculates rolling average monthly usage over the last 4, 6, and 12 months.
Proactive Inventory Controls: Displays minimum required stocking levels, current quantity on hand, and trailing order history side-by-side to optimize procurement.

Navigate to: DB Distributor > Print Management > Reports > Customers > Print Management Usage

Available Sequences

When generating the report, you can organize the data using the following sequence options:

By Customer / Item
By Salesperson / By Customer / Item

Understanding the Report Output

The report headers are deeply detailed, separating current period tracking from core catalog specifications and rolling consumption forecasting:

Section / Column Group	Description
Header Block	Tracks administrative information including Client Name/Code, Date Prepared, and the precise Reporting Window (Beginning/Ending dates).
Item Specifications	Lists core warehouse descriptors: Item Number, Name, Size, Unit (UOM), Number of Plys, and Qty Per Unit.
Inventory Status	Outlines current availability using WHSE INV (Warehouse Inventory), IN HOUSE INV, and TOTAL QTY ON HAND.
Reorder & Backorder	Displays current procurement statuses via REORDER QTY and QTY ON ORDER.
Usage Grid (By Month/Year)	Breaks down actual item distribution horizontally across a calendar view (`JAN` through `DEC` ) over multiple historical years.
Rolling Averages	Displays calculated usage velocities under LAST 4 MO, LAST 6 MO, and LAST 12 MO.
Months On Hand	Forecasts time to depletion based on the item's rolling average monthly usage metrics.
Minimum Level	The designated safety-stock baseline configuration for the item.
Previous Order	A quick history snapshot revealing the last transaction's QTY, calculated MOS (Months), and DATE.

💡 Tip: Look for an asterisk (* ) in the inventory status areas on the report layout. This visually flags active item records that require close attention during your end-of-cycle processing due to critical stock changes or backorder states.