DBD: Client Inventory Detail Report
The Client Inventory Detail Report provides a comprehensive breakdown of active catalog items along with their physical quantities and financial valuations per location. This report is highly useful for tracking cross-reference procurement numbers and auditing precise lot compositions.
Key Features
- Cross-Reference Tracking: Automatically maps internal and external tracking numbers side-by-side, including the Customer Purchase Order number, the Distributor Purchase Order number, and the Plant Job number.
- Lot-Level Detail: Provides an option to print granular lot composition histories, detailing exactly how large warehouse quantities break down into smaller units (e.g., cases vs. boxes).
- Valuation Source Auditing: When lot details are enabled, the report offers visibility into the exact calculation origin of the listed sell price.
Navigate to: DB Distributor > Print Management > Reports > Items > Detailed Inventory Valuation
Available Sequences
When generating the report, the data is organized using the following sequence option:
- By Customer / Item
Understanding the Report Output
The report structure couples parent item tracking rows with detailed underlying transaction blocks:
| Column / Section | Description |
| Item Row Data | Displays the main product identifiers: Item Code, Description, Location Code, total Quantity On Hand, Unit of Measure (UM), and financial valuation Extension. |
| Receipt Dt | The calendar date the specific inventory batch or lot was received into the warehouse. |
| Customer PO / P/O No. | Displays the client's source Purchase Order number alongside the distributor's primary tracking number. |
| Job Number | The production plant job number tied to that specific manufacturing or distribution run. |
| Lot composed of | Breaks down packaging configurations mathematically (e.g., 10 CASEs of 3BOXs of 250 = 7,500 ). |
| Unit Value | The baseline pricing rate applied to the valuation tier (e.g., $107.14 /1000 ). |
Valuation Method Legend
When displaying price origin data, the report references a specific key indicating how the unit price was determined:
- a = Item Master
- b = Lot
- c = Item IMS
- d = Bundled
- e = Billable (Lot)
- f = Alt-1
💡 Tip: Use the valuation method letters on the report to troubleshoot why an item's sell price might vary between older and newer received lots for the same client.