Purchase Order Inventory Management System: Right-Sized, Not Bloated
A purchase order inventory management system connects what you order to what you hold — so a reorder point raises the PO, receiving books it against the order, and the cost lands where it belongs. This guide shows why most growing businesses get sold a bloated generic platform when they need one right-sized owned system, and how to tell the two apart before you sign.
A purchase order inventory management system links each purchase order line to the stock record of the item being bought. It shows how many units are on order, when each open line is expected, what has actually been received against it and how much of that inbound supply can be promised to customers before it arrives.
The practical problem is usually not raising the order. It is that the order and the stock figure live apart. Buyers reorder lines that are already inbound, sales promise stock that has not been confirmed, and the warehouse books a short delivery as if it were complete. This guide focuses on that purchase order to stock link: the quantities, dates and receipts that make an inventory figure trustworthy.

Stock on the shelf is only part of the picture once purchase orders are open. Illustrative photograph, not an OpsMavix project.
Image credit: CHUTTERSNAP, Unsplash License. No edits.
Key Takeaways
- On hand, on order, allocated and available are different quantities and should be stored separately.
- Every open purchase order line needs an expected date, or inbound stock cannot be promised safely.
- Goods should be received against the specific PO line so short and over deliveries stay visible.
- Available to promise can include inbound supply, but only time-phased against confirmed dates.
- Reorder decisions should use stock on hand plus open orders minus commitments, not the shelf count alone.
- Choose configuration, integration, packaged software or a focused build according to the gaps you can demonstrate.
In this guide:
- 1. Understand How Purchase Orders Change Stock
- 2. Separate On Hand On Order and Available
- 3. Keep Expected Dates on Every Open PO Line
- 4. Receive Against the PO Line Not the Product
- 5. Calculate Available to Promise With Inbound Stock
- 6. Link Reorder Decisions to Open Purchase Orders
- 7. Carry Cost From the PO Into Stock Value
- 8. Compare System Approaches and Pilot One Supplier
- Frequently Asked Questions
- How OpsMavix Can Help
1. Understand How Purchase Orders Change Stock
A purchase order is future supply
A purchase order records what you have agreed to buy from a supplier: the items, quantities, prices and terms. Shopify’s own purchase orders help page, for example, describes a purchase order as listing “the products, quantities, costs, payment terms, and supplier details for an order”, and explains that once it is marked as ordered, an inventory transfer can be used to track shipments, receive inventory and add cost adjustments.
From an inventory point of view, that agreement is future supply. It does not change what is physically on the shelf, but it should change three decisions: whether to buy more, what you can promise customers and what you expect to hold next week.
This post stays on that inventory link. For raising and approving orders, see purchase order software and purchase order management software. For chasing late suppliers, see the purchase order tracking system guide. For spend control in a smaller company, see purchase order system for small business.
The events that should move a stock figure
| PO event | Stock effect | Common mistake |
|---|---|---|
| PO drafted | None | Counting drafts as inbound supply |
| PO confirmed by supplier | On order increases | Not recording the confirmation at all |
| Expected date changed | Timing of inbound supply moves | Leaving the original date in place |
| Partial receipt | On hand increases, on order decreases by the received amount | Closing the whole line |
| Over delivery accepted | On hand increases by the accepted quantity | Silently accepting units nobody ordered |
| Line cancelled | On order decreases | Leaving phantom inbound stock on the record |
| Return to supplier | On hand decreases | Adjusting stock without referencing the receipt |
The key point is that each event changes a different quantity. A system that only stores “stock” as one number cannot represent this table.
2. Separate On Hand On Order and Available
Define each quantity once
Most stock arguments come from people using the same word for different numbers. Agree the definitions below and keep each one as a separate field or calculation.
| Quantity | Plain meaning | Where it comes from |
|---|---|---|
| On hand | Units physically held and booked in | Receipts minus dispatches and adjustments |
| Allocated | On hand units reserved for confirmed customer orders | Sales orders and picking |
| Free stock | On hand not yet allocated | On hand minus allocated |
| On order | Confirmed PO quantity not yet received | Open PO lines minus receipts and cancellations |
| Available to promise | Supply you can still commit to new demand by a date | Free stock plus dated inbound supply minus later commitments |
On order should be calculated from open PO lines, not typed in. If it is a manual field, it will drift the first time a delivery is part received or a line is cancelled.
Keep quarantined stock out of available
Stock that has arrived but is awaiting inspection, damaged or held for return is physically present but not sellable. Treat it as its own status. Otherwise free stock looks healthier than the shelf really is.
Check the definitions with each team
Ask a buyer, a salesperson and a warehouse lead to read the same SKU screen and say what they can do with each number. If their answers differ, the definitions are not yet agreed, whatever the software says.
3. Keep Expected Dates on Every Open PO Line
Dates belong to lines, not just orders
One purchase order may contain lines that arrive weeks apart. A single header date hides that. Store an expected date per line, and per delivery if a supplier splits shipments.
The expected date should come from the supplier’s confirmation, not from the buyer’s hope. When the supplier changes it, update the line and keep the previous date in the history so you can see how often that supplier moves.
Distinguish three dates
| Date | Meaning | Used for |
|---|---|---|
| Requested date | When you asked the supplier to deliver | Measuring the supplier against your request |
| Confirmed expected date | When the supplier says it will arrive | Available to promise and planning |
| Received date | When the goods were booked in | Measuring actual supplier lead time |
Only the confirmed expected date should feed available to promise. A requested date the supplier never accepted is not supply you can sell.
Practical date checklist
- Every confirmed line has an expected date before it counts as inbound.
- Lines past their expected date are flagged and excluded from promises until reconfirmed.
- Date changes are recorded with who changed them and why.
- Received dates are captured at booking in, not when the invoice arrives.
4. Receive Against the PO Line Not the Product
Why the reference matters
If goods are booked in only against the product code, stock goes up but the purchase order does not know. On order stays inflated, the buyer sees supply that has already landed and reorder logic double counts it.
Receiving against the specific PO line updates both sides in one action: on hand rises and the line’s outstanding quantity falls. The goods receiving process and the goods received note guides cover the warehouse steps in detail.
Handle short and over deliveries explicitly
HYPOTHETICAL example. A PO line is for 200 units. The supplier delivers 170.
- On hand rises by 170.
- On order for that line falls from 200 to 200 - 170 = 30.
- The line stays open with 30 outstanding, unless the buyer cancels the balance.
If the 30 are never coming, cancel the balance so on order drops to zero. Leaving it open creates phantom inbound stock that available to promise and reorder logic will both trust. If customer orders were waiting on those units, the shortfall is also a backorder decision.
Over deliveries need a rule too: accept and amend the line, accept into a holding status, or reject. Whatever the rule, the accepted quantity should be visible against the PO so the invoice check later has a true record. The two-way vs three-way matching guide explains why that receipt record matters for payment.
Receiving checklist
| Check | Why it matters for stock |
|---|---|
| Scan or select the PO line, not just the SKU | Keeps on order accurate |
| Count before signing | Short deliveries are caught while the driver is present |
| Record damaged units separately | Prevents unsellable stock showing as free |
| Decide whether the balance stays open | Removes phantom inbound supply |
| Record the received date | Feeds lead time measurement |

Booking goods in against the right purchase order line keeps on hand and on order in step. Illustrative photograph, not an OpsMavix project.
Image credit: Tiger Lily, Pexels License. No edits.
5. Calculate Available to Promise With Inbound Stock
Time-phase the inbound supply
Available to promise (ATP) answers a simple question: if a customer asks for a quantity by a date, can we commit to it without breaking an earlier promise? The available to promise guide covers the general formula. Here the focus is on how open POs feed it.
Inbound supply can be included, but only from its confirmed expected date onwards and only for commitments that fall after that date.
HYPOTHETICAL worked example
One SKU has the following position (all figures hypothetical):
- On hand: 120 units.
- Allocated to customer orders due this week: 80 units.
- PO line A: 200 units, confirmed for day 10.
- Existing customer order due day 12: 60 units.
| Point in time | Calculation | Available to promise |
|---|---|---|
| Today to day 9 | 120 - 80 | 40 |
| Day 10 onwards, if PO line A arrives in full | 40 + 200 - 60 | 180 |
A new customer asks for 150 units. The honest answer is: 40 can ship now, and 150 can be promised from day 10 or later, provided PO line A arrives in full.
Now suppose PO line A arrives short, with 170 units:
| Point in time | Calculation | Available to promise |
|---|---|---|
| Day 10 onwards, short receipt | 40 + 170 - 60 | 150 |
If the 150 unit order was already promised against day 10, it is still covered, but with nothing left over. Any further promise depends on the 30 outstanding units or another PO. Without the receipt linked to the line, nobody would see that margin disappear.
Rules for promising inbound stock
- Only confirmed lines with an expected date count.
- Overdue lines are excluded until the supplier reconfirms.
- Inbound supply covers commitments dated after its expected date, not before.
- Customer promise dates should allow for receiving and put away time.
- Selling inbound stock to consumers in advance raises its own questions; the pre-order stock management guide covers caps and dispatch dates.
If your channels all draw from one stock pool, these rules also help with preventing overselling, because each channel sees the same available figure.
6. Link Reorder Decisions to Open Purchase Orders
Use inventory position, not shelf stock
A reorder point compares a stock figure with a trigger level. The question is which stock figure. Using only on hand ignores supply already ordered. Using on hand plus on order without subtracting commitments ignores demand already promised.
A common working definition is:
Inventory position = on hand + on order - allocated or backordered demand
The reorder point calculation guide covers how to set the trigger itself.
HYPOTHETICAL worked example
A different SKU (all figures hypothetical):
- On hand: 120 units.
- On order across open PO lines: 350 units.
- Allocated and backordered customer demand: 140 units.
- Average usage: 20 units per day; lead time: 14 days; safety stock: 60 units.
| Measure | Calculation | Result |
|---|---|---|
| Reorder point | (20 x 14) + 60 | 340 |
| Inventory position | 120 + 350 - 140 | 330 |
| Shelf only view | 120 - 140 | -20 |
| Ignoring commitments | 120 + 350 | 470 |
With the correct position of 330, the line is just below its reorder point of 340, so a new order is due. The shelf only view (-20) would trigger a panic order and rush freight even though 350 units are inbound. Ignoring commitments (470) would suggest nothing is needed at all.
If the business runs a min/max approach with a maximum of 700, the suggested order is 700 - 330 = 370 units.
Link the suggestion to the PO
When the buyer accepts a suggestion, the new PO line should reference the SKU and the trigger that created it. That makes it possible to review later whether the reorder settings are working. For lumpy or seasonal demand, a time-phased order point uses the same dated inbound supply described in section 5.
7. Carry Cost From the PO Into Stock Value
Value stock at receipt
The PO holds the agreed unit price. The receipt confirms how many units actually arrived. Together they give the value added to stock. Additional costs such as freight can then be allocated to the received units under whatever costing method your accountant has agreed.
HYPOTHETICAL worked example
Using the short delivery from section 4 (figures hypothetical, VAT excluded):
| Item | Calculation | Amount |
|---|---|---|
| Original PO line value | 200 x £4.20 | £840.00 |
| Value of units received | 170 x £4.20 | £714.00 |
| Inbound freight allocated | Given | £68.00 |
| Total cost of received units | £714.00 + £68.00 | £782.00 |
| Cost per received unit | £782.00 / 170 | £4.60 |
Two things are visible here. First, stock should be valued on the 170 received, not the 200 ordered. Second, freight adds £68.00 / 170 = £0.40 per unit, so a margin calculated on the £4.20 PO price would be overstated. For imported goods, duty and other charges also need consideration; see the landed cost calculation guide.
Keep the accounting decisions with finance
Whether freight is capitalised into stock, how costs are averaged and when the invoice price replaces the PO price are accounting policy decisions. A purchase order inventory management system should apply the agreed rules consistently and show which receipt and PO line each cost came from.
8. Compare System Approaches and Pilot One Supplier
Match the approach to the gap
| Approach | Where it can fit | What to check |
|---|---|---|
| Configure current tools | Your inventory or ecommerce platform already supports POs and receiving | Whether on order, expected dates and partial receipts appear on the stock screen your team uses |
| Connect existing systems | Purchasing and stock live in separate tools that each work | Which system owns the PO line, how receipts sync and how failures are shown |
| Packaged inventory software | Your process is close to the standard PO, receive and reorder flow | Line level dates, ATP with inbound supply, cost allocation and reporting |
| Focused custom application | A specific gap, such as ATP across inbound POs, is valuable and well defined | Data access, support, maintenance and integration with accounts |
| Full ERP, packaged or custom | Purchasing, stock, production and finance all need deeper coordination | Scope, migration, implementation effort and ongoing ownership |
Packaged software often handles the standard flow well, and established products can be configured for many businesses. A custom build tends to make sense when the gap is specific and costly, or when several systems must share one PO to stock record that no single product provides. In every case, compare licences or hosting, implementation, data migration, training and ongoing change costs.
Pilot with one supplier
Pick one supplier with a mix of full, short and late deliveries. Run their open POs through the proposed setup for a few weeks and check:
- On order matches the open PO lines exactly.
- Expected date changes flow through to available to promise.
- Partial receipts leave the correct balance open.
- Cancelled balances remove phantom inbound stock.
- Reorder suggestions use inventory position, not shelf stock.
- Received cost per unit agrees with the PO and allocated charges.
- Users can trace any available figure back to the PO lines behind it.
Where stock is held at more than one site, include a second location in the pilot; the multi-location inventory management guide explains why inbound supply needs a destination location. The purchase order cycle guide shows where these steps sit in the wider procure to pay process.
Frequently Asked Questions
What is a purchase order inventory management system?
It is a system, or a set of connected systems, that links purchase order lines to stock records. It shows what is on order, when it is expected, what has been received against each line and how inbound supply affects what can be promised and reordered.
Does on order stock count as available?
Not automatically. On order stock can be included in available to promise from its confirmed expected date, for commitments falling after that date. Unconfirmed or overdue lines should be excluded until the supplier reconfirms.
What happens to a purchase order when a delivery is short?
The received quantity is booked against the line, on hand rises by that amount and the remaining balance stays on order. If the balance will not arrive, cancel it so the system stops treating it as inbound supply.
Why should reorder points use on order quantities?
Because a reorder point based only on shelf stock ignores units already inbound, which leads to duplicate orders. Using inventory position (on hand plus on order minus committed demand) avoids buying the same supply twice.
What is the difference between lead time and an expected date?
Lead time is a typical duration from ordering to receiving, used for planning. An expected date is the specific confirmed arrival date for one PO line, used for promising and tracking that order.
Should stock be valued at the PO price or the invoice price?
That depends on your accounting policy. Many businesses value receipts at the PO price and adjust when the invoice is matched. Agree the rule with your accountant and make sure the system applies it consistently.
Do I need a full ERP to link purchase orders to stock?
Not necessarily. Many inventory and ecommerce platforms handle POs, receipts and on order quantities. A full ERP or a focused build is worth considering when those tools cannot show the dated inbound supply, partial receipts or costs your decisions depend on.
Can OpsMavix build a purchase order inventory management system?
Yes. OpsMavix can build focused applications or a full custom ERP, and can configure or integrate suitable existing tools where those approaches fit the requirements.
How OpsMavix Can Help
OpsMavix can map how purchase orders, receipts and customer orders currently affect your stock figures, then define the smallest system change that makes on order, expected dates and available to promise trustworthy.
That may involve configuring existing tools, connecting purchasing and stock systems, an inventory automation system, a wholesale order management system for promising inbound stock to trade customers, ecommerce inventory automation for channel availability or invoice approval workflows that check receipts before payment.
Contact OpsMavix with one recent short or late delivery, the records behind it and the handoff that creates the most rework. We can use that evidence to define requirements and a practical pilot.
Getting value from OpsMavix? Add us as a preferred source on Google — you'll see more of our operations content in your AI Overviews, AI Mode and Search.