Sage 100 Inventory Replenishment: Can Reorder Points Update Automatically?
Your Sage 100 reorder points were set once — but your usage never stopped moving. For a distributor carrying thousands of SKUs, that gap between the number in the system and the demand on the shelf is where stockouts and overstock are born.
Sage 100 inventory replenishment turns on one question distributors keep asking in the Sage Community Hub: can reorder points update automatically? One widely read thread puts it plainly — usage swings sharply, the company carries several thousand SKUs, and updating points by hand is impractical. Can Sage 100 recalculate them from a rolling window, say the last three months of usage?
Stock Sage 100 Does Not Recalculate Reorder Points for You
The Hub's suggested answer is blunt: no built-in routine watches usage and rewrites your reorder points. Even Sage Inventory Advisor, remembered for replenishment guidance, recommended how much to order — it did not push new points back into your item records.
That leaves the number typed in seasons ago, for a different demand pattern, still deciding when the Inventory Reorder Report flags an item and how much it suggests. Usage moved. The trigger did not.
Reorder Points Live per Warehouse, and Available Is Not on Hand
Two details make a stale point more dangerous than it looks. First, reorder data lives at item-and-warehouse level: the Hub answer names the table, IM_ItemWarehouse, keyed by item code and warehouse code — so a point right for one warehouse can be wrong for the one that runs dry. Second, Sage 100 tests the point against quantity available, not the shelf count: on hand adjusted for sales orders, purchase orders, work orders, and backorders. A point set against yesterday's pattern misfires both ways.
Frequently Asked Questions
Can Sage 100 update reorder points automatically from usage? Not in the stock system. The Hub's suggested route builds the calculation outside Sage 100 — a report or query that turns usage into proposed points — then imports the results back.
How do teams update thousands of Sage 100 reorder points at once? Through a Visual Integrator import into IM_ItemWarehouse, carrying at least item code and warehouse code on every record — the fastest route the Hub answer describes, and the step where one wrong file does the most damage.
What Stale Reorder Points Cost
Set too low, the first warning is a stockout and a customer told to wait. Set too high, cash sits on shelves in stock nobody is moving. Across thousands of SKUs neither error announces itself — it accumulates until margin and service slip together.
Get Reorder Points That Match How You Actually Sell
Our free Sage 100 Health Check reviews your reorder methods, points, and warehouse setup against how items really move — before the next stockout or overbuy. Every Digit Masters consultant is a licensed U.S. CPA, and our support plans keep replenishment settings reviewed as usage changes. Points set once and never revisited are not protecting you. They are guessing.
Related Services
This topic connects directly to our core service areas: Sage 100 Consulting, Sage 100 Support, and our free Sage 100 Health Check. Related reading: our lot and serial tracking post and our post on when Excel stops working for inventory. If you're working through a similar challenge, contact us for a free consultation.
