Inventory Management Software for Manufacturing: What It Must Do
A retail stock app counts finished goods on a shelf. A manufacturer has to track raw materials, work-in-progress, bills of materials and finished goods at once, with lot traceability underneath. This is what inventory management software for manufacturing must actually do, and why growing UK makers keep landing in the gap: outgrowing spreadsheets and disconnected tools.
Inventory management software for manufacturing has to track stock that changes form. A manufacturer buys raw materials, issues them to production orders, holds part-built work between operations, finishes products, scraps some material along the way and buys again based on what the order book will consume. A stock app that only counts sellable units on a shelf sees one part of that chain.
The practical problem is that each gap gets filled with a spreadsheet. Materials sit in one file, works orders on a whiteboard and finished goods in another file, so nobody can say with confidence whether the next job can start, what is tied up on the floor or which batch of material went into a delivered product. This guide sets out what the software must do, how to test it and which type of system fits.

A manufacturer’s stores hold materials and goods at different stages, not just finished stock. Illustrative photograph, not an OpsMavix project.
Image credit: AFINIS Group, Unsplash License. No edits.
Key Takeaways
- Manufacturing stock exists as raw materials, work in progress and finished goods, and the system must move quantities between those states.
- Bills of materials drive material issue, backflushing, costing and purchasing, so BOM accuracy comes first.
- Backflushing reduces data entry but only records standard usage; scrap and variances still need a way in.
- Lot and batch traceability should work both backwards from a customer and forwards from a supplier batch.
- Purchasing should net production demand against stock, allocations, open orders and safety stock.
- Choose between spreadsheets, packaged MRP, full ERP or a custom application by testing your own jobs, not by feature lists.
In this guide:
- 1. Understand the Four Stock States in a Factory
- 2. Build Bills of Materials You Can Trust
- 3. Record Material Issue and Backflushing
- 4. Make Work in Progress Visible
- 5. Trace Batches and Lots Both Ways
- 6. Record Scrap Yield and Variances
- 7. Buy Against Production Demand
- 8. Choose the Right Type of System
- Frequently Asked Questions
- How OpsMavix Can Help
1. Understand the Four Stock States in a Factory
Treat stock as a flow, not a count
A manufacturer converts items. Steel tube arrives in bundles, becomes a welded frame, then a coated frame, then part of a finished product. The software must record each conversion so the totals stay consistent.
| Stock state | What it is | What the software must record |
|---|---|---|
| Raw materials and bought-in parts | Items purchased to be consumed in production | Receipts, locations, units of measure, batches and allocations to orders |
| Work in progress | Material issued to a production order that is not yet finished | Which order holds it, which operation it has reached and what has been consumed |
| Finished goods | Completed products available to ship or allocate | Output quantities, batch or serial numbers and reservations against sales orders |
| Scrap and rework | Material lost, rejected or held for repair | Quantity, reason, order reference and whether it returns to stock |
Know which questions the system must answer
The test of a manufacturing inventory system is whether it answers operational questions without a stocktake:
- Can this works order start today with the materials we hold?
- What is allocated to other orders, and what is genuinely free?
- What is on the floor now, and at which stage?
- Which supplier batch went into this finished batch, and where did it ship?
- What must we order, by when, for the jobs already confirmed?
If answering means opening three spreadsheets, the software is not doing the manufacturing part of the job. The relationship between stock control and the shop floor is covered further in manufacturing and inventory management software.
2. Build Bills of Materials You Can Trust
Make the BOM the source of material logic
A bill of materials lists the components and quantities needed to make one unit, or one batch, of a parent item. It drives what is issued to an order, what backflushing deducts, what planning buys and what a product costs in materials, so a wrong BOM produces wrong stock figures automatically. Getting the structure right is covered step by step in how to set up a multi-level BOM.
Check the details that break stock figures
| BOM detail | Common error | What good looks like |
|---|---|---|
| Unit of measure | Tube bought in 6 m lengths but entered per millimetre | Stock unit, purchase unit and conversion held in the system |
| Quantity basis | Some BOMs per unit, others per batch, with no label | Base quantity stated on every BOM |
| Scrap allowance | Loss added to the finished product instead of the component | Allowance on the line where the loss happens |
| Sub-assemblies | Parts copied into several product BOMs | Shared sub-assembly referenced once |
| Version | Planning uses a superseded BOM | Approved version with an effective date |
3. Record Material Issue and Backflushing
Decide how consumption reaches the stock record
Material leaves raw stock in one of two broad ways. With manual issue, someone records the actual quantity picked or used against the works order. With backflushing, the system deducts the BOM quantity automatically when output is reported.
Microsoft’s Business Central documentation describes the backward method plainly: consumption is calculated and posted when a released production order changes to Finished. The same page lists flushing method options of Manual, Forward, Backward and pick combinations, and shows consumption posted in proportion to output: an order for 800 metres needing 8 kg of a component posts 2 kg when 200 metres are reported.
Match the method to the material
| Method | Where it fits | What to watch |
|---|---|---|
| Manual issue | Expensive, batch-tracked or variable-usage materials | Floor time to record; issues must happen before stock looks available |
| Forward flushing | Materials issued in full when an order is released | Stock leaves early; cancelled or short orders need reversals |
| Backflushing on completion | Low-value, consistent-usage items such as fasteners | Records standard usage only; overuse and scrap are hidden unless reported |
| Backflushing by operation | Long orders where stock should fall as stages complete | Operations and materials must be linked correctly in routing |
Keep issue and stock location honest
Backflushing usually deducts from a defined location. Test what happens when that location has insufficient stock: does posting stop, go negative or warn someone?
4. Make Work in Progress Visible
Track orders by stage
Work in progress is material and effort committed to an order that is not yet finished. The software should show each open works order, its current operation, what has been issued, what has been output and what is waiting for a missing component.
Live job status on the floor is the focus of manufacturing production tracking, which pairs naturally with stock control.
Work through a hypothetical WIP material value
Assume a hypothetical maker of steel workbenches has 30 frames welded but not yet coated. Each frame has consumed 10.08 m of tube at £4.00 per metre and 16 bolts at £0.25 each.
| Component per frame | Calculation | Value |
|---|---|---|
| Steel tube | 10.08 m × £4.00 | £40.32 |
| Bolts | 16 × £0.25 | £4.00 |
| Material value per frame | £40.32 + £4.00 | £44.32 |
| 30 frames in WIP | 30 × £44.32 | £1,329.60 |
All figures are hypothetical and exclude labour, overhead and VAT. How WIP is valued in the accounts, including labour and overhead, is a decision for your finance team and accountant. The software’s job is to supply consistent quantities and order references to support it.
5. Trace Batches and Lots Both Ways
Record batches at every movement
Lot or batch tracking means each receipt carries an identifier, and that identifier is recorded when material is issued to an order and when finished goods are produced and shipped. Katana’s help centre, for example, describes backward traceability from a sales order to the batch used and the ingredients in it, and forward traceability from purchased ingredients to final sales. The same article notes that batch tracking is part of its Full Traceability add-on, which shows why you should confirm exactly which edition includes the capability you need.

Each operation on the floor is a point where material, batch and scrap records can drift. Illustrative photograph, not an OpsMavix project.
Image credit: Cemrecan Yurtman, Unsplash License. No edits.
Understand when it is a legal requirement
For food and feed businesses, traceability is a legal duty. Article 18 of Regulation (EC) No 178/2002, as it applies in the UK, requires operators to identify who supplied them and the businesses to which their products have been supplied, with systems and procedures that make this information available to the competent authorities on demand. Other sectors may face traceability requirements through customer contracts, quality standards or product regulations. Check the rules that apply to your products rather than assuming a generic setting is enough.
Test traceability with a real scenario
- Pick a delivered finished batch and ask the system which supplier batches went into it.
- Pick a supplier batch and ask which finished batches and customers received it.
- Split a batch across two orders and confirm both remain traceable.
- Check how long the search takes and who can run it.
6. Record Scrap Yield and Variances
Plan for expected loss
Most processes lose some material: offcuts, trim, setup pieces or rejected parts. Planning should include an expected allowance so the buyer orders enough. Microsoft’s Dynamics 365 Supply Chain Management documentation separates constant scrap, a fixed loss per run, from variable scrap, a percentage of required material, and gives the purchased quantity as required material multiplied by one plus variable scrap, plus constant scrap. Its own example is 100 litres × 1.20 + 10 litres = 130 litres.
Capture actual loss separately
Expected scrap is a planning assumption. Actual scrap is an event that should be recorded against an order with a reason. If backflushing deducts only the standard quantity, extra loss stays in the system as stock that no longer exists.
| Hypothetical item | Calculation | Quantity |
|---|---|---|
| Benches reported complete | Output posting | 50 |
| Standard tube per bench | 9.6 m × 1.05 scrap allowance | 10.08 m |
| Tube backflushed | 50 × 10.08 m | 504 m |
| Tube actually used, from a recount | Physical check | 520 m |
| Unrecorded variance | 520 m - 504 m | 16 m |
In this hypothetical case, 16 m of tube still appears in stock after it has gone, so the next planning run treats it as available. Record extra scrap against the order and operation with a reason, and review the BOM allowance if the same variance keeps recurring.
7. Buy Against Production Demand
Net requirements, not just reorder points
Fixed reorder points work for items with steady usage. For materials driven by specific orders, purchasing should start from production demand: explode the BOMs for planned works orders, add scrap, then subtract stock that is genuinely available. Business Central’s planning documentation describes the planning system as one that balances supply and demand sets and suggests actions for the user to take, driven by forecasts and sales orders.
How exploded BOM totals turn into purchase orders is covered in the bill of materials in supply chain management, and the receiving side in purchase order inventory management.
Hypothetical material requirements worked example
A hypothetical manufacturer has confirmed orders for 150 steel workbenches over the next four weeks. Each bench uses 9.6 m of steel tube with a 5% variable scrap allowance, one laminated worktop, 16 bolts, 0.6 kg of powder coating with a constant loss of 3 kg per coating run, and four levelling feet. Assume one coating run.
Step 1: gross requirement including scrap
| Material | Calculation | Gross requirement |
|---|---|---|
| Steel tube | 150 × 9.6 m × 1.05 | 1,512 m |
| Worktops | 150 × 1 | 150 |
| Bolts | 150 × 16 | 2,400 |
| Powder coating | 150 × 0.6 kg + 3 kg | 93 kg |
| Levelling feet | 150 × 4 | 600 |
Step 2: available stock
Available = on hand - allocated to other orders + open purchase orders - safety stock.
| Material | On hand | Allocated | On order | Safety stock | Available |
|---|---|---|---|---|---|
| Steel tube | 620 m | 180 m | 400 m | 100 m | 740 m |
| Worktops | 40 | 0 | 60 | 10 | 90 |
| Bolts | 3,100 | 500 | 0 | 400 | 2,200 |
| Powder coating | 55 kg | 10 kg | 0 kg | 20 kg | 25 kg |
| Levelling feet | 1,000 | 200 | 0 | 100 | 700 |
Step 3: net requirement and order quantity
| Material | Net requirement | Purchase unit | Order quantity |
|---|---|---|---|
| Steel tube | 1,512 - 740 = 772 m | 6 m lengths | 129 lengths (774 m) |
| Worktops | 150 - 90 = 60 | Each, multiples of 20 | 60 |
| Bolts | 2,400 - 2,200 = 200 | Boxes of 500 | 1 box (500) |
| Powder coating | 93 - 25 = 68 kg | 20 kg boxes | 4 boxes (80 kg) |
| Levelling feet | 600 - 700 = none | Packs of 100 | 0 |
The steel line shows why rounding matters: 772 m ÷ 6 m is 128.67 lengths, so 129 lengths are needed. The levelling feet show why netting matters: a simple reorder rule might buy more feet when enough are already free. All quantities and pack sizes are hypothetical, and timing still needs supplier lead times offset against each order’s start date.
8. Choose the Right Type of System
Compare approaches against your gaps
| Approach | Where it can fit | What to check |
|---|---|---|
| Spreadsheets | Very few products, simple BOMs, one person maintaining them | Version control, allocations, traceability and who updates what |
| Accounting software inventory | Buying and selling finished items with basic stock | Whether BOMs, works orders, WIP and batch tracking exist in your edition |
| Packaged MRP or inventory system | Standard make-to-stock or make-to-order processes | Exact plan or add-on for batch tracking, backflushing options and integrations |
| Full ERP | Wider finance, multi-site or complex planning needs | Implementation scope, data migration, training and ongoing support |
| Focused custom application or integration | A clear gap, such as floor issue, traceability or demand-led buying | Build scope, data ownership, maintenance and links to existing tools |
Packaged systems such as Katana and Business Central provide established manufacturing functions, and many businesses should start there. A custom application or integration makes sense when your process genuinely differs or the gap is a narrow handoff between tools that already work. For metal fabricators, metal fabrication software looks at the specific records that sector needs.
Run a pilot on your own jobs
- Load the BOMs for two real products, including one with a sub-assembly.
- Receive materials with batch numbers and different units of measure.
- Release a works order, issue some materials manually and backflush others.
- Report partial output, record scrap and complete the order.
- Ship finished goods and run a backward and forward trace.
- Run a purchasing calculation and compare it with your own spreadsheet.
Ask each supplier to mark every step as demonstrated, configurable, requiring development or unsupported, and compare full running costs, not just licences.
Frequently Asked Questions
What is inventory management software for manufacturing?
It is software that tracks raw materials, work in progress and finished goods, and the movements between them. It uses bills of materials to issue or backflush components, records output and scrap, supports batch traceability and plans purchasing against production demand.
What is backflushing?
Backflushing is automatic deduction of components when output is reported, based on the BOM. Business Central, for example, posts backward-flushed consumption when a production order is set to Finished. It saves data entry but records standard usage, so actual scrap must be reported separately.
Do I need batch tracking?
If you make food or feed, traceability is a legal duty under Regulation (EC) No 178/2002 as it applies in the UK. In other sectors it may be required by customers or standards. Even where it is optional, it makes recalls and complaints far easier to investigate.
Can a manufacturing inventory system work with my accounting software?
Often, yes. Many packaged systems integrate with accounting packages, and custom systems can be built to post agreed transactions. Define which system owns stock valuation, what gets posted and how failed transfers are corrected.
Do I need a full ERP to manage manufacturing inventory?
Not necessarily. Some manufacturers need ERP-level finance and planning; others can meet their requirements with a packaged MRP system, configuration or a focused application. Test your own jobs rather than deciding by company size.
Can OpsMavix build manufacturing inventory software?
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 materials move through your business, from receipt and issue to output, scrap and dispatch, then define where BOMs, batches and purchasing logic need to connect.
That may involve configuring a packaged system, connecting stock control to the floor through an inventory automation system, building manufacturing production tracking for works orders and WIP, or developing a full custom ERP.
Contact OpsMavix with one recent works order, the BOM and stock records behind it and the point where material figures stopped matching reality. 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.