DBD: Monthly Activity by Warehouse Report
The Monthly Activity by Warehouse Report delivers a complete auditing history of all stock movements recorded during the active Print Management billing cycle. By tracking individual transaction events item-by-item, this report allows distributors and customers to monitor financial changes to physical inventory assets held in fulfillment facilities.
Key Features
- Granular Transaction Logging: Details every transaction by type (such as inventory releases, warehouse receipts, and physical count adjustments).
- Location Mapping: Captures both the sourcing fulfillment warehouse and the destination customer delivery location involved in every transactional event.
- Consolidated Recap Ledger: Automatically generates an activity summary at the close of the report to display combined dollar balances for all system inputs and outputs.
Navigate to: DB Distributor > Print Management > Reports > Items > Monthly Activity by Warehouse
Available Sequences
When generating this log, the data is organized using the following sequence option:
- By Customer / Item / Warehouse
Understanding the Report Output
The layout features detailed transactional line entries grouped by specific item profiles:
| Column Header | Description |
| Item | The unique system item code identifier. |
| Rev Date | The active catalog revision level assigned to the item profile. |
| Description | The alphanumeric master catalog label or name identifying the item. |
| Whse | The designated source or storage fulfillment warehouse code handling the transaction. |
| Date | The calendar date the system transaction was officially processed. |
| Ref No. | The internal tracking code, order reference number, or document ID. |
| Activity | The precise functional designation of the movement (e.g., Release , Reorder Receipt ). |
| Loc. | The specific customer delivery site or destination location code profile. |
| Quantity | The physical count of units adjusted, received (positive), or shipped (negative). |
| Value | The financial value calculation assigned to the volume change event. |
Summary Totals Block
The bottom of each customer ledger aggregates total unit actions into three primary operational blocks:
- Releases: The total dollar value of goods distributed or shipped to locations.
- Receipts: The total dollar value of incoming stock replenished or checked into storage.
- Total Activity: The net calculation of all transactional impacts combined.
💡 Tip: This report is a crucial verification checklist during standard end-of-cycle processing because it clearly outlines the exact transaction paths responsible for discrepancies in final period counts.