The ERP Says 1,000 Pieces. The Warehouse Says 700.
It is 10:00 in the morning.
Production needs a component for an urgent production order. The production manager checks the ERP before calling the warehouse.
The system shows:
Available stock: 1,000 pieces.
“Perfect,” he thinks. “We need only 200.”
He asks the warehouse team to issue the material.
The warehouse team checks the rack.
They find only:
700 pieces.
Now the questions start.
“Where did the other 300 pieces go?”
The warehouse team says the stock may have already been consumed.
Production says they have not received it.
Purchase says there is no current shortage.
Finance says the inventory balance was correct in the last report.
And the ERP still says:
1,000 pieces.
This situation may sound simple, but imagine it happening with 500 items.
Or 5,000 items.
Suddenly, this is no longer just a warehouse problem.
It becomes a manufacturing problem.
Because when inventory information cannot be trusted:
- Purchasing does not know what it really needs to buy.
- Production does not know what it can actually manufacture.
- Planners cannot fully trust MRP.
- Sales cannot confidently promise delivery dates.
- Finance starts questioning inventory valuation.
- Management loses confidence in ERP reports.
This is why inventory accuracy is not merely a warehouse KPI.
It is one of the foundations of manufacturing ERP success.
Does Your Factory Have Any of These Problems?
Before discussing inventory accuracy technically, think about what happens in your factory every day.
Do any of these situations sound familiar?
- Production is waiting for a material even though ERP shows sufficient stock.
- Purchasing discovers shortages only after production has started.
- Buyers regularly place emergency purchase orders.
- Inventory keeps increasing, but critical materials are still unavailable.
- The same material gets purchased again even though another purchase order is already open.
- Production schedules change because one small component is missing.
- Planners maintain Excel sheets because they do not completely trust ERP data.
- Management asks, “What will become a shortage next week?”, but nobody can answer quickly.
- Physical counting repeatedly finds differences.
- Material is available somewhere in the factory, but nobody knows exactly where.
- Production consumes more material than the BOM indicates.
- Stock adjustments are made repeatedly without understanding why the differences occurred.
If two or three of these situations sound familiar, your problem may not simply be insufficient inventory.
The bigger problem may be:
You do not have a reliable picture of your inventory at the moment you need to make a decision.
And that is where inventory accuracy becomes critical.
What Does Inventory Accuracy Actually Mean?
Inventory accuracy sounds simple:
The quantity recorded in the ERP should match the quantity physically available.
But manufacturing inventory is more complicated than a single number.
Suppose your ERP says:
500 pieces
What does that actually mean?
You still need to know:
- Where are those 500 pieces?
- Are all 500 physically available?
- Are some reserved for another production order?
- Are some under quality inspection?
- Are some damaged?
- Are some blocked?
- Are some allocated to another customer?
- Are some in another warehouse?
- Are some in transit?
- Are they the correct lot or batch?
- Has some of the quantity already been consumed but not posted?
So inventory accuracy is not only about quantity.
It is about having the correct information about:
Item + Quantity + Location + Status + Lot/Serial + Availability
at the time when someone needs to make a business decision.
That is a much more useful definition of inventory accuracy for a manufacturing organization.
Why Inventory Accuracy Matters More in Manufacturing
In a trading business, an inventory difference might result in a shipment problem.
In manufacturing, the consequences can travel through the entire operation.
Imagine the ERP says:
100 motors available
A production order requires:
80 motors
The planner sees enough stock and releases the production order.
But the warehouse discovers that only:
60 motors are actually usable.
Now there is a shortage of:
20 motors.
What happens next?
Production may stop.
The production schedule changes.
The purchase team starts calling suppliers.
An emergency purchase order may be raised.
The company may pay for expedited delivery.
The customer delivery date may move.
Management starts asking why the production plan failed.
And eventually someone discovers that the original problem was simply:
The inventory record was wrong.
That is why inventory accuracy affects much more than the warehouse.
It affects:
- Production planning
- MRP
- Procurement
- Customer delivery
- Inventory investment
- Production cost
- Financial reporting
- Management decisions
A small inventory discrepancy can therefore create a much larger business problem.
The Most Dangerous Problem: System Stock vs. Usable Stock
One of the most common mistakes in manufacturing is assuming:
System stock = usable stock
They are not always the same.
Consider this example.
The ERP shows:
1,000 pieces
But the actual situation is:
| Stock Situation | Quantity |
| Physically available | 500 |
| Reserved for another order | 200 |
| Under quality inspection | 150 |
| Damaged | 50 |
| Allocated elsewhere | 100 |
| Total | 1,000 |
The production manager says:
“We need 100 pieces.”
The warehouse says:
“We have 1,000.”
But the planner needs to ask:
“How many of those 1,000 can actually be used for this production order?”
That is the more important question.
A good manufacturing ERP should help distinguish between physical stock, available stock, reserved stock, quality-held stock and committed stock.
Because a piece that exists physically but cannot be used for the current requirement is not the same as freely available inventory.
A Real Manufacturing Situation: The Material Was There, But Nobody Could Find It
Here is another situation that can easily happen in a growing manufacturing company.
The production supervisor tells purchasing:
“We don’t have the material. Please arrange it urgently.”
The purchasing manager starts checking suppliers.
An emergency purchase is almost raised.
Then someone from the warehouse asks:
“Have you checked all warehouse locations?”
After searching, the material is found.
It was physically available.
But it was stored in:
Warehouse B → Rack 07 → Bin 14
while the ERP showed the quantity under:
Warehouse A → General Location
The company technically had the material.
But operationally, the material was unavailable.
This is an important lesson.
Inventory accuracy is not only about getting the quantity right.
It is also about getting the location right.
If employees cannot find the material when they need it, the organization effectively behaves as though the material does not exist.
How Does Inventory Become Inaccurate?
Inventory discrepancies usually do not appear by themselves.
They are created by everyday business transactions.
Common causes include:
- Purchase receipt not posted immediately
- Material issued to production without an ERP transaction
- Production consumption posted late
- Finished goods completed physically but not recorded
- Warehouse transfers not recorded
- Material stored in the wrong location
- Scrap not recorded
- Rejected material not moved to the correct status
- Material returned from production without proper posting
- Incorrect UOM conversion
- Duplicate item codes
- Incorrect BOM quantities
- Manual stock adjustments
- Material substitutions not recorded
- Physical counting errors
The important point is:
Inventory accuracy is usually a process problem before it becomes a counting problem.
If the same transaction errors happen every day, a large annual physical inventory may correct the balance temporarily.
But it does not necessarily correct the process that created the discrepancy.
Receiving: Where Inventory Accuracy Begins
Inventory accuracy starts before material reaches the storage rack.
It starts at receiving.
Suppose the purchase order says:
500 bearings
The supplier delivers:
470 bearings
If the warehouse team accidentally receives 500 into the ERP, the system now believes that 500 pieces have arrived.
Production planning may later use that number.
The company thinks it has 500.
It actually has 470.
A small receiving mistake has now become a planning problem.
The receiving process should therefore verify:
- Correct item
- Correct quantity
- Correct UOM
- Purchase order
- Batch or lot where applicable
- Serial number where applicable
- Quality status
- Storage location
For materials requiring inspection, there should also be a clear distinction between:
Received
and:
Released for use
A material can physically be inside the factory without being available for production.
Quality Inspection Can Change What “Available” Means
Consider an electrical component received from a supplier.
The warehouse receives:
1,000 pieces
But quality inspection identifies:
- 900 accepted
- 70 rejected
- 30 pending investigation
The physical quantity is still 1,000.
But the production-usable quantity is:
900
If the ERP treats all 1,000 pieces as unrestricted stock, MRP may assume production has enough material.
That can create an unexpected shortage.
This is why inventory and quality processes should not operate as completely separate processes.
Physical possession does not always mean operational availability.
Production Consumption: Where Many Differences Begin
Manufacturing introduces another important source of inventory errors.
Materials leave the warehouse and go into production.
Suppose a production order requires:
100 kg of raw material
The ERP records:
100 kg issued
But production actually consumes:
108 kg
because of process loss.
If the additional 8 kg is never recorded, the ERP continues to believe that the 8 kg exists somewhere.
The next production order may try to use it.
The warehouse then discovers that the material is missing.
Someone may blame the warehouse.
But the real issue happened during:
Production consumption reporting.
This is why manufacturing inventory accuracy depends heavily on the shop floor.
Scrap Is Also an Inventory Transaction
Manufacturing operations naturally create some level of:
- Scrap
- Rejection
- Trimming loss
- Process loss
- Damaged material
- Wastage
Suppose ERP shows:
1,000 kg
Production consumes:
300 kg
and generates:
20 kg scrap
If the scrap is not recorded, ERP may continue to show an inflated quantity.
Now imagine that the same thing happens every day.
The difference becomes significant.
That is why scrap should not be treated as an informal shop-floor activity.
If material leaves usable inventory, the ERP needs to know about it.
The Hidden Problem: Material Substitution
Consider a common shop-floor situation.
The BOM requires:
Component A
But Component A is unavailable.
Production finds:
Component B
which can be used instead.
The supervisor approves the substitution and production continues.
From the production team’s perspective, the problem is solved.
But if the substitution is not recorded in ERP, the system may continue to believe:
- Component A was consumed.
- Component B is still available.
After several production orders, the ERP inventory can become significantly different from reality.
This is why manufacturing ERP should provide controlled processes for:
- Material substitution
- Alternate materials
- Excess consumption
- Short consumption
- Scrap
- Returns
The objective is not to stop production from solving practical problems.
The objective is to make sure the ERP records what actually happened.
UOM Errors Can Create Surprisingly Large Differences
Another common source of inventory discrepancies is the Unit of Measure.
Suppose purchasing buys:
1,000 meters of cable
but the warehouse stores and issues it as:
Rolls
One roll contains:
100 meters
If the ERP is not configured correctly, differences can appear between:
- Purchase quantity
- Stock quantity
- Production consumption
- Sales quantity
The same issue can happen with:
- Kilograms vs. grams
- Boxes vs. pieces
- Sheets vs. kilograms
- Liters vs. drums
- Rolls vs. meters
UOM conversion may look like a small master-data configuration.
In reality, it can have a direct impact on inventory accuracy.
Inventory Accuracy and MRP Are Directly Connected
This is one of the most important connections to understand.
A simplified MRP calculation is:
Gross Requirement − Available Supply = Net Requirement
Now imagine:
ERP says:
Available stock = 1,000
Physical usable stock is:
700
MRP believes the company has 1,000.
It may therefore recommend purchasing less material than the company actually needs.
Production starts.
The shortage becomes visible.
The purchasing team has to place an emergency order.
This is why even an excellent MRP engine cannot compensate for unreliable inventory data.
The system can only plan based on the information available to it.
Wrong inventory data produces wrong planning decisions.
This is why inventory accuracy is not just an inventory issue.
It is a prerequisite for reliable MRP.
Real-Life Experience: When the ERP Wasn’t the Real Problem
One lesson I have repeatedly seen during ERP discussions and manufacturing process reviews is that companies often begin with:
“Our ERP stock is wrong.”
My first response is usually not:
“Let’s adjust the stock.”
I want to understand what happened before the number became wrong.
I ask:
When was the material received?
When was it physically moved?
When was the receipt posted?
When was it issued to production?
Who recorded the consumption?
Was any material rejected?
Was anything returned?
Was any material substituted?
Was scrap recorded?
Was the warehouse transfer posted?
These questions often reveal that the ERP is not necessarily the original problem.
The real issue may be that the physical process and ERP transaction are happening at different times—or that a transaction is being skipped completely.
That is one of the most important lessons I have learned from ERP work:
When inventory is wrong, don’t immediately adjust the quantity. First understand why it became wrong.
Otherwise, the same problem will happen again.
Why “Just Adjust the Stock” Is Not a Solution
Suppose the ERP shows:
1,000
Physical counting finds:
850
The easy answer is:
Inventory adjustment = −150
Now ERP shows:
850
It looks solved.
But the more important question is:
Why were 150 pieces missing?
Maybe:
- 100 were consumed but never issued.
- 20 were scrapped.
- 15 were transferred to another warehouse.
- 10 were damaged.
- 5 were counted incorrectly.
The adjustment corrected the number.
But it did not correct the process.
The same discrepancy can happen again next week.
That is why mature inventory management focuses on root-cause analysis, not only variance correction.
Cycle Counting: A Practical Way to Maintain Accuracy
Many companies think inventory counting means:
“Count everything once a year.”
A full physical inventory can certainly be useful.
But manufacturing companies can also use cycle counting.
Instead of waiting for one large annual count, selected items can be counted regularly throughout the year.
For example:
A Items
High-value or critical materials
Count frequently
B Items
Medium-value materials
Count periodically
C Items
Lower-value or less critical materials
Count less frequently
The exact frequency should depend on the company’s inventory-control policy, item value, movement and criticality.
The important principle is:
Do not wait until the end of the year to discover that your inventory has been wrong for eleven months.
Regular counting helps the organization identify discrepancies earlier.
But Cycle Counting Alone Is Not Enough
A company can perform cycle counts every week and still have poor inventory accuracy.
Why?
Because if the root cause of the discrepancy is not fixed, the problem keeps returning.
For example:
Monday
ERP = 1,000
Physical = 950
Adjustment = −50
Next Monday:
ERP = 1,000
Physical = 960
Adjustment = −40
The counting process is working.
But the business process is not.
The real question is:
Why does the inventory keep becoming inaccurate?
Maybe production consumption is not posted.
Maybe warehouse transfers are not recorded.
Maybe receiving is delayed.
Maybe employees are maintaining parallel spreadsheets.
Maybe the UOM configuration is incorrect.
Maybe material is being physically moved without an ERP transaction.
Cycle counting should therefore be used not just to correct inventory, but to identify recurring causes of inventory errors.
Inventory Accuracy Is a Company-Wide Responsibility
Another common mistake is saying:
“Inventory accuracy is the warehouse department’s responsibility.”
It isn’t.
The warehouse is an important participant, but inventory accuracy depends on the entire operational chain.
Purchase
Must order and receive the correct material and quantity.
Warehouse
Must store, transfer and issue material correctly.
Quality
Must correctly identify accepted, rejected and blocked material.
Production
Must report consumption, returns, scrap and substitutions.
Sales
Must maintain accurate demand and allocations.
Planning
Must work with reliable inventory information.
Finance
Needs reliable inventory valuation and adjustments.
Management
Needs reliable information for decision-making.
Inventory accuracy therefore belongs to the entire organization.
What Happens When Inventory Accuracy Is Poor?
The consequences are usually much larger than the original inventory difference.
1. Production Delays
The ERP says material is available.
Production discovers that it is not.
The production order stops.
2. Emergency Purchasing
The buyer has to find material urgently.
The company may pay:
- Higher prices
- Expedited freight
- Emergency supplier charges
3. Excess Inventory
The opposite can also happen.
If ERP says material is lower than reality, purchasing may order more.
The warehouse then receives material that was not actually required.
4. Unreliable MRP
MRP plans against incorrect inventory.
Purchase and production recommendations become less reliable.
5. Poor Customer Commitments
Sales may believe products or components are available.
Physical stock says otherwise.
Customer promises become difficult to maintain.
6. Financial Differences
Inventory is an important financial asset.
If quantities are wrong, inventory valuation and financial reporting can also be affected.
The important point is that:
The cost of poor inventory accuracy is usually much larger than the value of the original inventory discrepancy.
Inventory Accuracy Is Also About Traceability
Quantity is not the only thing manufacturers need to know.
Depending on the industry, the company may need to know:
- Which lot was received?
- Which supplier supplied it?
- When was it received?
- Which warehouse contains it?
- Which production order consumed it?
- Which finished product used it?
- Which customer received that product?
For lot-controlled or serial-controlled materials, this becomes even more important.
Imagine that a component is later found to have a quality problem.
The company should ideally be able to determine:
Which stock is affected?
Where is it?
Which production orders used it?
Which finished products contain it?
Which customers received those products?
Inventory accuracy therefore supports not only planning, but also traceability and quality control.
What a Good Inventory Process Looks Like
A strong manufacturing inventory process should create a connected chain:
Purchase Order
↓
Material Receipt
↓
Quality Inspection
↓
Warehouse / Location
↓
Material Reservation
↓
Issue to Production
↓
Actual Consumption
↓
Scrap / Return / Substitution
↓
Production Completion
↓
Finished Goods
↓
Shipment
The objective is that every important physical movement has a corresponding business transaction in ERP.
The closer the system transaction is to the physical transaction, the more reliable the inventory information becomes.
This is why transaction discipline matters so much.
What Should a Manufacturing ERP Control?
A good manufacturing ERP should help control inventory at the transaction level.
Receiving
Record what actually arrived.
Putaway
Record where the material was stored.
Transfers
Record movement between warehouses and locations.
Reservations
Identify material already committed to specific requirements.
Production Issues
Record what was actually issued.
Production Consumption
Record what was actually consumed.
Scrap
Record material lost or rejected.
Returns
Record unused material coming back from production.
Quality Status
Distinguish usable inventory from inspection or blocked inventory.
Cycle Counting
Regularly compare system quantity with physical quantity.
Adjustments
Control inventory corrections with proper authorization and reasons.
The objective is simple:
Make the ERP reflect what is actually happening in the factory.
A Simple Inventory Accuracy Example
Consider a company manufacturing electrical panels.
ERP shows:
1,000 contactors
Production requires:
600 contactors
The planner thinks:
“We have enough.”
But investigation reveals:
- 100 are reserved for another production order.
- 150 are under quality inspection.
- 50 are physically missing.
- 100 are in another warehouse.
- 600 are available for the current requirement.
The company has 1,000 units recorded in the system.
But the planning decision is very different when inventory status and commitments are considered.
This is why modern ERP inventory management should answer more than:
“How much stock do we have?”
It should answer:
“How much stock is available, where is it, what condition is it in, and what is it already committed to?”
Inventory Accuracy Becomes More Important as the Business Grows
A small company may survive with:
- One warehouse
- Few products
- Limited suppliers
- Manual records
- One production line
As the business grows, the situation changes.
It may have:
- Multiple warehouses
- Multiple production locations
- Hundreds of products
- Thousands of components
- Multiple UOMs
- Lot-controlled materials
- Serial-controlled equipment
- Subcontracting
- Rework
- Multiple production lines
The number of inventory transactions increases dramatically.
At that point, relying on memory, paper notes and disconnected Excel sheets becomes increasingly risky.
The company does not simply need:
More inventory.
It needs:
Better process control.
That is where ERP becomes increasingly important.
The ERP Implementation Lesson: Don’t Start With Stock Adjustment
When a company tells me:
“Our inventory is inaccurate.”
I would not start by asking:
“How do we adjust the stock?”
I would start by asking:
Where does inventory enter the organization?
Where does it move?
Where is it consumed?
Where is it rejected?
Where is it returned?
Where is it scrapped?
Where is it transferred?
Where is it shipped?
Once these questions are answered, we can identify where the physical process and ERP process are becoming disconnected.
This approach is much more valuable than simply correcting the final balance.
Because the objective is not to have accurate inventory today.
The objective is to keep it accurate:
Tomorrow.
Next month.
Next year.
How to Know Whether Your Inventory Is Really Accurate
Companies often ask:
“What percentage of our inventory is accurate?”
That is a useful question, but it should not be the only measurement.
Consider tracking:
- Inventory record accuracy
- Cycle count variance
- Inventory adjustment value
- Stockouts caused by inventory discrepancies
- Number of emergency purchases
- Warehouse location discrepancies
- Unposted production transactions
- Unrecorded scrap
- Receiving delays
- Inventory ageing
- Negative inventory occurrences
More importantly, look for patterns.
If one warehouse consistently has more discrepancies, investigate it.
If one product family repeatedly shows shortages, investigate it.
If one production line repeatedly consumes more material than the BOM says, investigate it.
The objective of measurement should not simply be:
“How many differences did we find?”
It should be:
“Why are these differences happening?”
What Inventory Accuracy Should Mean for Management
For management, inventory accuracy should ultimately answer five questions.
1. What do we have?
The correct quantity.
2. Where is it?
The correct warehouse and location.
3. Can we use it?
The correct availability and quality status.
4. What is it committed to?
The correct reservations and allocations.
5. What is it worth?
The correct financial value.
When these five pieces of information can be trusted, inventory becomes a management asset rather than a source of confusion.
How Cyprus ERP and Onfinity ERP Can Help
The purpose of an ERP system should not simply be to show an inventory number on a screen.
The real objective should be to create a connected process in which the inventory number has a clear operational meaning.
This is where Cyprus ERP and Onfinity ERP can support a broader manufacturing ERP approach.
The inventory process can be connected across:
Procurement → Inward → Quality → Warehouse → Inventory → Production → Consumption → Scrap/Return → Finished Goods → Sales → Finance
This connection matters because inventory accuracy cannot be maintained by the warehouse module alone.
Consider the problems discussed throughout this article.
Stock exists, but production cannot use it.
The ERP needs to distinguish availability, reservations, allocations and quality status.
The wrong material quantity is planned.
The ERP needs accurate BOMs, item masters and UOMs.
Material arrives too late.
Planning needs realistic supplier lead times and requirement dates.
Purchasing works from separate Excel sheets.
Procurement and material planning need to work from connected information.
Production discovers shortages after starting the job.
The business needs earlier visibility into material availability and expected shortages.
Inventory keeps increasing while shortages continue.
Management needs visibility into demand, supply, commitments and actual availability.
This is why the real value of ERP is not simply having an “MRP” button or an “Inventory” screen.
The value comes from connecting the information required to make good manufacturing decisions.
The Real Value of Onfinity ERP Is Not Just Knowing the Stock
The more important question is:
Can the business trust the stock information enough to make decisions?
If the answer is yes, several other processes become stronger.
Accurate Inventory
↓
More Reliable MRP
↓
Better Purchasing Decisions
↓
More Stable Production Planning
↓
Fewer Emergency Purchases
↓
Better Customer Commitments
↓
Better Working Capital Control
This is why inventory accuracy should not be treated as a small warehouse function.
It is part of the foundation on which the broader ERP process operates.
Final Thoughts: Inventory Accuracy Is About Trust
At the beginning of this article, we looked at a simple situation.
The ERP said:
1,000 pieces.
The warehouse found:
700 pieces.
It is tempting to call that an inventory problem.
But the real issue is deeper.
Maybe the missing 300 pieces were consumed but never posted.
Maybe they were moved to another location.
Maybe they were rejected.
Maybe they were scrapped.
Maybe they were reserved.
Maybe they were never physically received.
The important question is not only:
“Why is the number wrong?”
It is:
“Where did the process stop matching reality?”
That is the real purpose of inventory accuracy.
An ERP system should not simply tell a company what inventory it thinks it has.
It should provide a reliable picture of what the business actually has, where it is, what condition it is in, what it is committed to, and what can be used.
Once that information can be trusted, everything else becomes easier.
MRP becomes more reliable.
Purchasing becomes more intelligent.
Production planning becomes more realistic.
Warehouse operations become more controlled.
Financial reporting becomes more dependable.
And management can make decisions based on facts rather than assumptions.
That is why inventory accuracy is not merely a warehouse KPI.
It is a foundation of manufacturing ERP success.
Because before an ERP can help you decide:
“What should we purchase?”
it first needs to answer:
“What do we actually have?”
And that answer needs to be right.
About the Author
Surya Sagar is an ERP professional with practical experience in understanding and designing business processes across manufacturing, supply chain, inventory, procurement, production and financial operations.
His approach to ERP is centered on a simple principle:
“ERP should follow the way the business actually works—not force the business to work around the software.”
Through his work with ERP implementations and manufacturing organizations, Surya focuses on translating complex business requirements into practical ERP processes that users can understand and management can control.
His experience includes working closely with organizations to understand how purchasing, inventory management, production planning, material consumption, quality processes and financial transactions connect with each other.
For Surya, inventory accuracy is not simply about making the physical stock match the ERP balance.
It is about making sure that the ERP reflects the reality of the business closely enough for people to trust it when making important decisions.
Is Your Inventory Data Ready for MRP?
If your organization regularly faces:
- “Stock is showing in ERP, but we can’t find it.”
- “Production needs material that the system says is available.”
- “We keep making stock adjustments.”
- “MRP recommendations are not reliable.”
- “Purchasing keeps placing emergency orders.”
- “Nobody is sure which warehouse actually has the material.”
- “Physical counts keep finding the same discrepancies.”
then another stock adjustment may not be the real solution.
It may be time to review the entire inventory process—from purchasing and receiving to quality, warehouse movement, production consumption and finished-goods shipment.
Cyprus ERP and Onfinity ERP bring these manufacturing processes together so that inventory information can become part of a connected operational picture.
Because successful ERP is not about having more data.
It is about having data that the business can trust.
And when your people trust the inventory data, they can make better decisions before a small inventory discrepancy becomes a production problem.
