Stock is often the first place where a business notices a gap between what its records say and what is actually on the shelf. An ERP is meant to close that gap by recording every stock movement in one place and linking it to the sales orders, purchase orders and accounting entries that caused it. Understanding how that works is the best way to judge whether ERP inventory management will be trustworthy.
This article explains how stock works inside an ERP, at a general level. It covers the stock record itself, item set-up, locations, valuation, reorder rules, stock takes and the links to sales and purchasing. It does not describe any particular product, and it does not cover the physical design of a warehouse.
Read the sections as a list of questions for your own processes. The right answers depend on what you sell, how you buy and how many places you hold stock.
ERP inventory management starts with the stock record
In a spreadsheet, a stock figure is a number that someone types or pastes. In an ERP, the stock figure is the result of recorded movements: goods received, goods issued, items transferred, quantities adjusted and returns processed. The balance on screen is the sum of those movements, and each one can be traced back to the document that created it.
Every movement is a transaction
Receiving a delivery, shipping an order, moving goods between sites and correcting a count should all be transactions with a date, a user, a reference and a quantity. That history is what lets someone later explain why a balance changed. Without it, the system holds a number but not the reason for it.
Four quantities that people confuse
Most stock screens show several figures that look alike but mean different things. Four of them cause the most confusion: the quantity physically on hand, the quantity already promised to customers, the quantity on order from suppliers and the quantity available to sell. Agree these definitions before anyone builds a report on them. The terms usually work like this:
- On hand: what the system believes is physically present
- Allocated: promised to an order but not yet shipped
- On order: expected from suppliers but not yet received
- Available: usually on hand less allocated, the figure checked before a new order is accepted
Item records: the foundation everything else reads from
Every stock movement points back to an item record. If that record is untidy, the problems surface in purchasing, sales, reporting and finance all at once. Item set-up is slow, careful work, but it is usually the easiest point at which to correct things.
Stocked and non-stocked items
Not everything that is sold needs stock tracking. Services, labour, delivery charges and some bundled products behave differently from physical goods. Mark each item clearly as stocked or non-stocked. Mixing them up causes phantom shortages, or stock that is never counted because nobody realised it was there.
Bundles, kits and variants
A bundle may be sold as a single line while being made up of several stocked components. A product may also come in sizes or colours that each need their own quantity. Decide early whether the ERP should track the parent item, the components or both. A wrong choice here shows up later as stock counts that never reconcile.
Locations: where stock sits and how to model it
A location is any place where stock can be held, whether that is a warehouse, a shop, a van, a site, a supplier's premises or an area set aside for inspection. The model should follow how people really move goods, rather than how the organisation chart is drawn.
Keep the structure as simple as the work allows
Start with the places where stock is held and counted. Add sub-locations only where people need to pick, count or report at that level. Each extra level adds data to maintain and another place for a movement to go wrong.
Stock in transit and quarantine
Goods travelling between two sites are at neither end, so the record needs a way to show them. The same applies to stock held for inspection, or damaged goods waiting for a decision. Treating these as separate locations keeps the available figure honest, so they are not counted as available by mistake.
Valuation methods explained at a general level
When stock is sold, the system must decide what cost to charge against the sale and what value remains on the balance sheet. The method chosen affects reported profit and the stock figure in the accounts, so it is a finance decision as much as an operational one.
Weighted average cost
Each receipt is blended into an average cost per unit, and issues are valued at that average. The approach smooths out price changes. It can suit businesses that buy the same item at varying prices and cannot easily tell one unit from another.
First in, first out
Issues are costed against the oldest units still in stock. This can match the physical flow of goods that have a shelf life or a date code, although the system must track receipts by batch or date to apply it accurately.
Choosing a method and keeping it consistent
Whichever method is used, it should be documented, applied consistently and agreed with your accountant. Some methods are not acceptable for UK statutory accounts, and changing method part way through a year makes comparisons unreliable. Check the approach before the first live transaction is posted.
Reorder rules and deciding when to buy
Reorder rules tell the system, or the buyer, when an item has fallen low enough to act on. They are only as good as the figures behind them, particularly the lead time from each supplier and the pattern of demand.
Reorder points and safety stock
A reorder point is the level of available stock at which replenishment should be raised. It is usually based on expected use during the supplier's lead time, plus a safety margin. That margin is the safety stock. Set both per item, and review them when demand or supplier performance changes.
Lead times that reflect what really happened
The lead time quoted by a supplier and the lead time actually achieved are often different. Record the date each order was placed and the date its stock arrived, so the ERP can show what really happened. An average from recent orders is more useful for planning than the figure on the original quote.
Suggestions that a buyer still checks
Automatic suggestions save time, but a buyer should still check them against known promotions, seasonal demand and supplier minimum order quantities. Let the system propose the order, then let a person confirm it before it goes out.
Stock takes and the inventory adjustments behind them
A stock take compares what the system says with what is physically there. The gap is a variance. The process for explaining and approving that variance matters as much as the count itself.
Full counts and rolling counts
A full count often means pausing movements for a period, which some businesses cannot manage. A rolling count checks a set of items at intervals, so every item is counted regularly without closing the site. The ERP should record which method was used and when each item was last counted.
Recording and approving variances
Every adjustment should carry a reason code and the name of the person who made it. Useful reasons include damage, theft, counting error, wrong unit of measure and an unrecorded return. Large adjustments should need a second person to approve them, so the system cannot be quietly changed to match a wrong figure.
What the pattern of variances tells you
Count variances grouped by item, location and reason point to where the process breaks. Repeated errors on one product may suggest a labelling problem. Repeated losses in one location may point to a process or security issue. The pattern tends to be more useful than the total.
Where sales and purchasing meet the stock record
The stock record changes when a sales order is accepted, a purchase order is raised or goods arrive. Those events should flow into the ERP through linked steps, not through a separate list that someone keeps by hand.
Accepting an order commits stock
When an order is confirmed, the ERP should allocate stock to it, so the same units cannot be promised twice. If stock is short, the order may be backordered or shipped in part. Decide the rule for partial shipments before go-live, because it changes what customers are told.
Purchase orders create expected receipts
A purchase order should show the quantity expected and the date it is due. When goods arrive, a goods receipt records what was actually received, which may differ from the order. The gap between ordered and received quantities should be visible, not corrected silently.
Returns to suppliers and from customers
Returns need their own transactions in both directions. A customer return should restock the goods or move them to quarantine, and a supplier return should reduce stock and the amount owed. Handling returns outside the normal flow usually leads to records that do not match.
FAQ
What is ERP inventory management?
ERP inventory management is the part of an enterprise resource planning system that records every stock movement and links it to sales orders, purchase orders and accounting entries. It shows how much stock is on hand, how much is already committed and how much is free to sell. Its reliability depends on how consistently movements are recorded.
What is the difference between on hand and available stock?
On hand is the quantity the system believes is physically present. Available stock is usually on hand less the quantity already promised to customers, and it is the figure to check before accepting a new order. The exact calculation can vary between systems, so agree the definition before building reports.
Which valuation method should a small business use?
There is no single answer, and the choice has accounting consequences. Weighted average cost and first in, first out are two approaches that are often discussed, and some methods are not acceptable for UK statutory accounts. Take advice from your accountant on the method that suits your trade, and apply it consistently once chosen.
How often should a business carry out a stock take?
The right frequency depends on how valuable the stock is, how quickly it moves and how often errors appear. Some businesses use rolling counts for regular checks and a fuller count at key points such as the year end. Whatever the schedule, record each variance and its cause.
Can an ERP suggest when to reorder stock?
Many ERP systems can suggest orders based on reorder points, demand and lead times. The suggestions are only as good as the figures behind them, particularly lead times and demand history. A buyer should still review them before an order is confirmed.
Do we need an ERP for inventory if we only have one site?
Not necessarily. A single site can still benefit from linked sales, purchasing and finance records, especially when stock figures are hard to explain. The real question is whether the current process keeps the numbers reliable, and if it does, a simpler tool may be enough.
Final thought
Good ERP inventory management depends on every change to stock being recorded, defined consistently and linked to the sales and purchasing activity behind it. An ERP can provide that structure, but it does not make the rules for you. Decisions about item set-up, locations, valuation, reorder settings and count procedures belong to the business, and they should be written down.
A sensible first step is to choose one product line and trace it through the system, from receipt to sale, checking every figure against what is physically on the shelf. The gaps you find will show which rules need attention before the rest of the range moves across.
If you would like to talk through the stock rules your business needs, the ERP solutions service at Mirex Agency is the place to start. You can email hello@mirexagency.com.
