MPH WMSReorder suggestions
Get a ranked list of items to reorder based on sales velocity, current stock and supplier lead times
Purchasing → Replenishment works out what needs restocking and pre-fills a purchase order for you.
How the suggestion is calculated
For each tracked, non-bundle item:
- Daily velocity - outbound movements over the lookback window, divided by the number of days.
- Days of stock - how long current stock lasts at that velocity, taking incoming purchase orders and open demand into account.
- Reorder point - the item's manual reorder point, or
velocity × (lead time + safety stock days)when it is set to Auto. - An item is suggested when projected stock falls below the reorder point.
The maths starts from on hand, not available. Available already has reserved stock subtracted, and open demand is subtracted again further down - starting from available would count the same reservations twice and inflate every suggestion.
Change the warehouse and the lookback window (30, 60 or 90 days) from the filter bar, and use Needs ordering only to hide everything that is comfortable.
Reading a row
| Column | Meaning |
|---|---|
| On hand | Physical stock in the warehouse |
| Ordered | Quantity on open purchase orders. The popover lists them |
| Committed | Quantity owed to open sales orders. The popover lists them |
| Days of stock | Coverage at the current velocity |
| Order qty | The suggestion, editable inline |
Each item also has a popover explaining the numbers behind it - available, reserved, velocity, lead time and reorder point - so you can sanity-check a suggestion without leaving the page.
Creating a PO from suggestions
Suggestions are grouped by supplier, because a purchase order goes to one supplier.
- Select rows, or tick a supplier group to take all of them.
- Adjust Order qty inline where you want to deviate.
- Choose either:
- Create PO - starts a new draft purchase order with those lines, or
- Add to existing PO - appends them to one of that supplier's open orders, which avoids sending a supplier two orders in one morning.
Explain with AI
The sparkle button next to an item asks the configured AI assistant to explain why the suggestion looks the way it does - velocity, lead time, projected coverage and risk. Useful as a reality check before committing money, or when handing the queue to someone who does not know the formula.
Requires the assistant to be configured under Settings → AI assistant.