The Reorder report highlights all stock items that have fallen below their minimum stock levels and now require replenishment. It uses live stock data to show exactly which parts need reordering so you can prevent shortages before they impact service delivery.
Use this report to:
Identify stock items that need reordering in real time.
Prevent critical parts from running out.
Review supplier details, product groups, and bin locations.
Analyse 12-month usage trends to improve forecasting.
Reduce overstocking and understocking by managing reorder thresholds.
Getting There
When you need to run the Reorder report:
Open the Business Intelligence module.
Click Reports.
In the Reports window, open the Stock category.
Select Reorder Report.
Apply your filters, then click Apply to generate the report.
Available Filters and Their Impact
Branch: Filters by the branch or depot where the stock is held. Only stock linked to the selected branch or engineer locations is included.
Pro Tip: Use this to focus on a single branch or review multiple depots during replenishment planning.
Column Breakdown and Key Fields
Each row in the report represents a stock item that has fallen below its reorder point and therefore qualifies for replenishment.
Column | Description |
Part No. | Stock item number. |
Description | Stock item description. |
Bin No. | Bin locations where the item is stored. |
Supplier | Supplier account number. |
Product Group | Product group classification. |
Stock On Hand | Total available quantity across the depot and the engineers. |
Reorder Qty | Quantity required to replenish stock. |
Calculated as: (Min Stock + Min Reorder Qty + On Order For Stock) − Stock On Hand |
|
Min Stock | Minimum stock level. |
Min Reorder Qty | Minimum quantity to reorder when stock drops below the threshold. |
On Requisition | Total stock on hand across the depot and the engineers. |
On Order For Stock | Quantity currently on order but not yet received. |
12M Sales | Total sales and job usage over the last 12 months. |
12M Transactions | Number of stock transactions in the last 12 months. |
£ List K1 | List price (K1). |
% | Product group description or margin indicator. |
Cost | Cost price. |
Superseded By | Replacement part number, if applicable. |
Alternative Parts | Indicates whether a secondary supplier exists. |
Insight: These fields let you quickly assess urgency, demand, and supply chain factors when planning replenishment.