DBD: Monthly Usage Report
The Monthly Usage Report summarizes all warehouse shipments organized by unique item code. For every item listed, it tracks the total quantity shipped alongside its corresponding financial value during the designated timeframe.
Key Features
-
Flexible Reporting Periods: Captures data either locked into a specific processing cycle or tracks activity occurring safely beyond the standard cycle window.
Direct Shipment Inclusion: While primarily designed to audit warehouse inventory items released over a period, direct drop-shipped items can optionally be accounted for.
Variable Valuation Methods: Depending on system configurations, values can be dynamically derived using:
- Value at the exact time of inventory release
- Current active selling price
- The actual billed amount for bill-as-shipped records
- A pre-set catalog (IMS) price
Navigate to: DB Distributor > Print Management > Reports > Items > Monthly Usage (FMR RC)
Available Sequences
When generating the report, the data is organized using the following sequence option:
- By Customer / Item
Understanding the Report Output
The report columns provide a clean transactional summary of stock movement totals:
| Column Header | Description |
| Item | The unique system code for the product, accompanied by its standard packaging/SKU metric (e.g., SKU: 700/CASE ). |
| Rev date | The engineering or catalog revision date assigned to the item profile. |
| Description | The alphanumeric name or label text identifying the item. |
| Quantity | The total combined number of units fulfilled and shipped during the reporting timeframe. |
| Value | The financial calculation of the shipped inventory, based on your selected valuation rules. |
💡 Tip: This report is ideal for quick reconciliation at the end of the month to cross-examine physical fulfillment counts against total billed revenue lines.