DBD: Reorder Grouping Analysis Report

The Reorder Grouping Analysis provides crucial procurement data designed to facilitate combination product reordering. By grouping items that share manufacturing setups or dimensions, distributors can review items that are hovering near their reorder thresholds alongside items that have already dropped below them. This strategic bundling allows procurement teams to take advantage of volume "combo" pricing tier discounts offered by print manufacturers.

Key Features

Strategic Order Bundling: Aggregates products based on custom combination rules so you can replenish related stock items in a single, cost-effective manufacturer run.
Flexible Filtering Scope: Can be run cleanly for an individual customer account or generated across an entire group of related corporate accounts.
Automated Data Consolidation: Reorder grouping metadata is automatically collected, structured, and refreshed as a core component of the standard Print Management Cycle Update.

Navigate to: DB Distributor > Print Management > Reports > Customers > Grouping Analysis (FMR R2)

System Configuration Hint

⚙️ Setup Requirement: The unique Grouping Code used to tie items together must be configured on the individual item profile record within the Alternate U/M tab of the Item Master.

Available Sequences

When generating the analysis, the data can be organized using the following sequence options:

By Customer
By Customer Group

Understanding the Report Output

The report splits item data line entries into Usage Information on the left and Item Availability on the right, categorized under custom production group parameters:

Column / Section Header	Description
Group Header Banner	Identifies the specific shared manufacturing criteria (e.g., `Group: Continuous Group P/C: 001, L/R: 9 1/2 , T/B: 11` ).
Item Code & Description	The unique catalog item identifier code and its system description string.
Last Order	The date and volume metrics of the last official manufacturing run processed for the item.
Current Period (Usage)	Actual quantity distributed or shipped out within the active cycle window.
Year to Date (Usage)	Cumulative consumption volume tracked over the fiscal year to date.
Average Usage (Usage)	The calculated historical baseline monthly velocity run-rate for the product.
In Whse (Availability)	The absolute physical stock volume resting in your main distributor warehouse locations.
Customer Site (Availability)	Inventory quantities counted and tracked directly at designated client storage sites.
Min Sply / On Hand (Availability)	Displays the item's established safety-stock minimum threshold alongside current available stock translated into months of supply.
Qty on Order (Availability)	Quantities currently placed on open replenishment purchase orders.

💡 Tip: Review entire Group Blocks collectively. If one item in a group has triggered a hard reorder, check the On Hand supply levels of the surrounding items in that same block to catch and include them in a combo manufacturer order before they cause a separate stockout.