DBD: Inventory Status Report

The Inventory Status Report provides an inventory valuation for goods stored across distributor warehouse locations. Tied dynamically to the customer's defined accounting period, it can be filtered to show exclusively the activity that has occurred since the customer's last period close.

Key Features

Dynamic Report Titles: * Valued Inventory Status Report: When printing values is enabled, the report dynamically updates its title and outputs financial metrics (Price/Unit and Total Value ).
- Standard Inventory Status Report: When values are disabled, the financial columns are omitted and replaced automatically with procurement safeguards: Reorder Point, Average Monthly Usage, and Months-on-Hand Supply.
Fulfillment Pipeline Visibility: Includes a concise status snapshot tracking exactly what is currently on order, received, used, and physically on hand for each active warehouse.
Flexible Price Modeling: Evaluates data using either the item's core sell price or a set catalog (IMS) price.

Navigate to: DB Distributor > Print Management > Reports > Items > Inventory Status

Available Sequences

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

By Customer / Item

Understanding the Report Output

The report maps core fulfillment quantities alongside unit-level valuation markers:

Column Header	Description
Item Code	The unique catalog item identifier, accompanied by its specific manufacturing part numbers or tracking codes underneath.
Rev Date	The assigned engineering or catalog revision date version for the product.
Item Description	The alphanumeric name or classification label text identifying the item.
Loc	The specific system warehouse or storage location code holding the stock.
On Order	Quantities currently placed on open purchase orders that have not yet arrived.
Received	Total product counts officially checked into the warehouse during the cycle window.
Used	The quantity of inventory released or shipped out within the reporting period.
On Hand	The absolute physical stock currently remaining in storage.
Unit /Unit	Specifies the packaging or distribution Unit of Measure (e.g., `CASE` ).
Price /Unit	[Valued Version Only] The unit cost or sell rate applied to the line item.
Total Value	[Valued Version Only] The extended value calculation (On Hand $\times$ Price/Unit).

💡 Tip: Running this report immediately after a customer's period close helps isolate precise transactional usage numbers before new period distributions skew your baseline visibility.