Manufacturing Systems: Connecting Production, Quality and Inventory
In many factories, production, quality and the warehouse each keep their own records. Connecting them is what makes stock accurate, batches traceable and product costs believable.

In many factories, three different records describe the same day. Production has its shift reports, quality has its inspection sheets and the warehouse has the stock system. Each is reasonably accurate on its own. Put them side by side and they disagree: the stock system shows finished goods that quality has not released, raw material that production says it used is still listed in the store, and nobody can say exactly which batch of resin went into last Tuesday’s order.
Why the three islands drift apart
Production, quality and inventory are often systemised at different times, by different people, for different reasons. The warehouse gets a stock module because finance needs inventory values. Quality keeps paper or spreadsheet records because it needs flexibility. Production reports on paper at the end of each shift because the shop floor has no terminals.
Each island works for its own team. The trouble is at the boundaries, where one department’s event should change another department’s records. When those updates depend on someone retyping a paper report the next morning, they arrive late, arrive wrong or do not arrive at all.
Take a plastic packaging manufacturer in Sahab producing bottles and caps for food and cosmetics customers. Its ERP (enterprise resource planning) system holds stock and sales orders, quality results sit in spreadsheets, and production is recorded on shift sheets entered by a clerk a day later. Stock counts regularly show differences in raw materials, finished goods are sometimes shipped before inspection is complete, and when a customer reports a defect, tracing the affected batches takes days.
The events that must connect the three
Connected manufacturing systems are mostly about a small number of events, each of which must update several records at once. The table below shows the main ones.
| Event on the floor | Production record | Quality record | Inventory record |
|---|---|---|---|
| Raw material received | Not affected | Incoming inspection required | Stock added in quarantine until approved |
| Material issued to a work order | Material consumed against the order | Batch of material linked to the order | Stock reduced from the store |
| Production reported | Quantity made, time and scrap recorded | In-process checks linked to the batch | Finished goods added on hold |
| Quality release or rejection | Rework order created if needed | Result recorded against the batch | Stock moved to available, or to rejected |
| Shipment to customer | Not affected | Certificate of analysis attached where required | Stock reduced, batch linked to customer order |
When each of these events is recorded once, at the time it happens, all three departments see the same picture. When any of them is recorded separately in each island, they drift apart again.
Treat quality status as part of inventory
The most important design decision is to make quality status part of every stock record. Every batch of raw material and finished goods should carry a status such as quarantine, available, on hold or rejected, and the system should only allow available stock to be issued to production or shipped to customers.
This sounds simple, and in most modern ERP systems it is supported directly through stock statuses or separate quality locations. But it changes behaviour on the floor. A warehouse team can no longer ship goods because they are physically on the shelf; they ship them because quality has released them. In the Sahab example, this one change would stop shipments going out ahead of inspection.
Getting data off the shop floor reliably
Connected systems depend on timely data from the floor, and that is often the weakest link. Shift sheets entered the next day are slow and error-prone. Better options exist without a large investment:
- Simple terminals or tablets at each line, where operators record quantities, scrap and downtime against the work order at the end of each run or each hour.
- Barcode or QR code labels on material batches and finished pallets, scanned when material is issued and when finished goods are moved. This removes most typing errors and makes traceability automatic.
- Automatic deduction for low-value materials (often called backflushing), where the system deducts standard quantities when production is reported, while high-value or batch-controlled materials are issued by scan.
- Quality checks recorded at the point of inspection, on a tablet or terminal linked to the batch, rather than on paper sheets typed in later.
Machine data collection, reading counts and states directly from equipment, can come later for companies that need it. Many mid-sized factories gain most of the benefit from reliable manual capture at the right moment.
Traceability and true product costs follow
Once the events in the table are captured properly, two valuable results follow without much extra work.
The first is traceability. When a customer reports a problem with a delivery, you can trace from their order to the finished batch, to the work order, to the raw material batches used and their supplier, in minutes rather than days. You can also trace forward: if a supplier warns that a raw material lot is faulty, you can find every finished batch and every customer affected. For food, cosmetics and pharmaceutical supply chains, customers increasingly expect this capability.
The second is believable product costing. Actual material consumption, scrap and production time recorded against each work order give finance a far better view of what each product really costs to make, compared with standard costs that have not been updated for years.
A sensible order of implementation
- Clean the foundations: item codes, bills of materials (the materials and quantities in each product) and routings (the sequence of production steps) that reflect how products are really made.
- Introduce stock statuses for quarantine, hold and release, and enforce them in issuing and shipping.
- Move production reporting onto the floor, against work orders, at the time of production.
- Add batch labelling and scanning for materials and finished goods.
- Connect quality results to batches in the same system or through an integration.
- Use the data: traceability reports, scrap analysis, actual versus standard cost and stock accuracy measures.
A factory that tells one story
Connecting production, quality and inventory depends less on advanced software than on recording a small number of events once, at the right moment, in a way that updates every department’s view together.
Our Enterprise Systems service helps manufacturers design and implement these connections, from bills of materials and data migration to shop floor capture and quality integration. Scrap reports, stock reconciliations and quality alerts that are still compiled by hand are a natural next step for our Intelligent Automation work.



