Item Quantity On PO Is Inexplicably Inflated in Sage 100
An item in Sage 100 Item Maintenance shows a quantity of 5 on PO — yet there are no open purchase orders for that item at all. The last PO was received in May 2025. Nothing is coming. Sage 100 just thinks it is.
Item Quantity On PO is inexplicably inflated in Sage 100 v2024: Item Maintenance shows 5 on PO, a test company snapshot shows the value was already stuck at 5 in May 2026, and no open PO backs it. The number is real on screen — and wrong everywhere it matters.
Sage 100 Item Quantity On PO: A Stored Total, Not a Live Count
The On PO figure is a stored total Sage 100 maintains as purchase orders are entered, received and closed — it is not recalculated from open orders each time you look. When a receipt or an interrupted update leaves that total behind, the item keeps claiming stock is on order long after the last PO is gone, and availability reads the stale number as fact.
Why a Stale Sage 100 On PO Quantity Misleads Everyone
Buyers stop buying. Quantity available is judged after on-order stock, so an inflated On PO figure makes a short item look covered — until the shelf is actually empty and the reorder never happened.
The fix is a recalculation, not an edit. The On PO value cannot be typed over. It has to be rebuilt from the underlying transactions, in the right module order, with the company clear while it runs — skip either condition and the stale total survives the fix.
Frequently Asked Questions
Is there a utility to recalculate the Sage 100 On PO quantity? Yes. The verified route is the Rebuild Sort Files utility in Library Master, Utilities — rebuild Production Management if you use it, then Purchase Order, Sales Order, then Inventory Management, answering Yes when asked about recalculating On PO values, with no related screens open for that company code.
What about Recalculate Item History in Sage 100? Inventory Management > Utilities > Recalculate Item History is the other route teams reach for — and it likewise needs everyone logged out of Sage first.
What a Wrong On PO Quantity Costs
Every week the figure stays wrong, purchasing plans around phantom stock: expedites replace planned orders, safety stock quietly covers a gap nobody recorded, and inventory reporting carries a quantity story the warehouse cannot match.
Get Your Sage 100 Quantities Checked
Start with our free Sage 100 Health Check: we compare stored quantities like On PO against open transactions and flag the totals that no longer agree. Every Digit Masters consultant is a licensed U.S. CPA, and our Sage support plans keep quantity integrity checked at every close. If Sage 100 says stock is coming and nothing arrives, contact us before the next buy cycle trusts that number.
Related Services
This topic connects directly to our core service areas: Sage 100 Consulting, Sage 100 Support, and our Sage support plans. Related reading: our post on a Sage 100 purchase order received in full but still backordered and our post on Sage 100 reorder points updating automatically. If you're working through a similar challenge, contact us for a free consultation.