Your Stock Figures Depend on Shop Floor Events
Inventory accuracy is decided on the shop floor, not in a spreadsheet at the end of the month. Odoo can show reliable stock only when each physical movement is recorded in the same way it happened. For manufacturing managers heading into an autumn demand peak, production planning or a year-end stocktake, that link matters long before a visible variance appears.
We often find that the system is not the real starting point of the problem. Materials may be issued late, a completed product may not be registered straight away, or scrap may be placed aside without a transaction. Odoo then reports the last confirmed movement, while the factory is already working with a different reality.
A stock figure can look fine at the start of a shift and become unreliable by lunchtime. Several production orders, an urgent component substitution, a partial completion and a few unrecorded returns are enough to affect purchasing, scheduling and promised delivery dates. By the time a stock count exposes the gap, planners may already have ordered the wrong materials or committed stock that is not actually available.
Consumption Settings and Bills of Materials Must Match Reality
Manual consumption gives operators or supervisors the chance to record what was actually used. Automatic consumption, often called backflushing, can reduce clicks, but it assumes the production order follows the expected bill of materials exactly. That assumption is not always safe.
If a team regularly uses extra material, swaps an unavailable component or completes only part of an order, automatic consumption can hide the difference. The same applies when material is picked from a location other than the one planned in Odoo. The transaction may be completed, but the recorded stock movement does not describe what happened.
For effective Odoo inventory optimisation, we recommend choosing the process your team can follow consistently, rather than simply choosing the quickest-looking setting. Ask practical questions:
- Do operators use the planned quantity most of the time?
- Who records substitutions when a component is unavailable?
- How are partial production orders completed?
- Can staff consume material from more than one location?
The bill of materials sets the baseline before the order ever reaches the shop floor. An outdated quantity, a wrong unit of measure or a missing product variant means Odoo reserves the wrong stock from the start. Staff may then work around the error physically, creating a variance that looks like an operator mistake but began in master data.
Packaging, expected scrap, by-products and alternative components also need a defined place in the bill of materials. When these are handled informally, inventory differences are almost guaranteed. A bill of materials is not a one-time setup task. It is an operational record that should be reviewed whenever products, suppliers or production methods change.
Returns, Rework and Transfers Need Clear Ownership
The movements most likely to be missed are often the ones that happen under pressure. A rejected component goes back to a shelf. Unused material is returned after a job. Finished goods move to quarantine. A product needs rework rather than completion. Each event affects what is available, where it is located and whether planning can rely on it.
Putting a component back on a shelf does not make it available in Odoo. It must be transferred back to the correct location. In the same way, finished goods moved to a quality hold or rework area should not remain available as normal finished stock. Without the right transaction, planners see inventory in a place where it no longer exists.
Clear ownership prevents these gaps from becoming routine. We advise defining four points for every exception movement:
- Who records the movement
- When it must be recorded
- Which Odoo transaction or location is used
- How a supervisor checks that exceptions were handled
This becomes even more important with shift handovers, temporary staff or several warehouses. A process that depends on one experienced person remembering an unwritten rule will eventually fail. Short, clear instructions and a shared understanding of location names are usually more useful than a long procedure nobody reads.
Daily Controls Keep Small Errors From Growing
A yearly stocktake can confirm that there is a problem. It cannot explain when it began or which production flow caused it. Daily controls give you a much better chance of spotting the issue while the people involved still remember what happened.
We recommend monitoring a small set of operational signals rather than trying to review every transaction. Production orders with unconsumed components, unexpected scrap, overdue internal transfers, negative stock and repeated inventory adjustments are all worth attention. None of these automatically proves an error, but each one is a useful prompt to compare the system with the physical situation.
Targeted cycle counts are also more useful than waiting for the annual count. Focus on items that create the biggest operational risk, including expensive components, fast-moving materials and parts that can stop production when unavailable. When differences recur, look beyond the product itself. The cause may sit in one location, one work centre, one shift or one specific type of production order.
Not every issue needs custom development. Sometimes the answer is clearer ownership, a better bill of materials or a simpler consumption rule. In other cases, Odoo configuration, barcode flows, reporting, integrations or tailored development may be appropriate. We first need to understand the real process, because automating an unclear process usually makes the same problem happen faster.
Turn Variances Into a Practical Recovery Plan
When stock data cannot be trusted, start with one production flow from end to end. Follow a material from receipt through storage, consumption, production completion, returns and stock count. Compare each physical movement with the Odoo transaction that should support it. This quickly shows where the two stop matching.
Our hands-on recovery work focuses on separating process gaps from configuration gaps. We can review manufacturing workflows, correct Odoo settings where needed and help structure controls around the movements that matter most. The immediate priority should be high-risk stock, particularly constrained materials, costly components and products that regularly go through rework.
A reliable recovery plan does not begin with a full-system overhaul. Start with the places where a wrong stock figure can interrupt production or create a bad customer promise. Once physical movements and Odoo transactions match in that flow, you have a practical standard to apply across the rest of the operation.
Turn Accurate Stock Into Reliable Production
Our Odoo inventory optimisation services focus on the transactions, routes and warehouse processes that affect manufacturing commitments. BeyondERP can review where stock records diverge from physical reality and define practical corrections your team can maintain. If inaccurate availability is already affecting planning or delivery dates, contact us to discuss the workflow involved.