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.

OpsMavix 16 min read
A single connected record linking a purchase order to a stock level, a receiving note and a landed cost, set against a stack of disconnected generic ERP modules

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.

Brown cardboard boxes stored on white metal warehouse racking

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

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

  1. Every confirmed line has an expected date before it counts as inbound.
  2. Lines past their expected date are flagged and excluded from promises until reconfirmed.
  3. Date changes are recorded with who changed them and why.
  4. 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
Warehouse worker operating a pallet jack among stacked boxes and metal shelves

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

  1. Only confirmed lines with an expected date count.
  2. Overdue lines are excluded until the supplier reconfirms.
  3. Inbound supply covers commitments dated after its expected date, not before.
  4. Customer promise dates should allow for receiving and put away time.
  5. 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.

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:

  1. On order matches the open PO lines exactly.
  2. Expected date changes flow through to available to promise.
  3. Partial receipts leave the correct balance open.
  4. Cancelled balances remove phantom inbound stock.
  5. Reorder suggestions use inventory position, not shelf stock.
  6. Received cost per unit agrees with the PO and allocated charges.
  7. 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.

#Purchase Orders#Inventory Management#Procurement#Operations Systems#Stock Control#Owned Software

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.

Free · built for your business

Don't see your business in our demos?We'll build one for yours. Free.

Book a call with us and we'll build a demo for your business, for free. Not a generic tour: your products, your steps and your numbers, running on screen before you decide anything.

Free 30-min call first. If we're a fit, we build it and show it to you. No card, no pitch.

  1. 1
    Book a free call30 minutes. We learn how your business runs.
  2. 2
    We build your demoAround your products, your steps, your numbers.
  3. 3
    You see it runningYour own operation on screen. Then you decide.
WhatsApp us