Inventory Management for Manufacturing SMEs

Inventory management for a manufacturing SME must connect five records: the item master, bill of materials, available components, production activity and finished output. A stock system that counts raw material but cannot explain consumption, work in progress, scrap and completed goods leaves finance and operations reconciling different versions of the same production event.

Start with the inventory systems service and the item-master cleanup guide. Use the reorder automation guide only after component demand and lead-time records are reliable.

1. Classify the inventory model

List what the business purchases, consumes, transforms, produces, repairs and sells. Separate raw materials, components, packaging, consumables, work in progress, subassemblies, finished goods, by-products and scrap. Decide which items need exact quantities, values, locations, lots, serials or expiry dates. Odoo distinguishes tracked goods from untracked goods and enables valuation, adjustments, replenishment and location reporting for tracked products.

2. Stabilise units of measure

Manufacturing often purchases in one unit, stores in another and consumes in a third. A sheet may be bought, stored by square metre and issued by cut length; liquid may be purchased by drum and consumed by litre. Define a base inventory unit and controlled conversions. Test rounding, partial units and yield. Do not embed a pack quantity in a product description and expect every transaction to infer it.

3. Govern the bill of materials

A bill of materials states which components and quantities are required for a defined output. Odoo describes a BoM as the blueprint for manufactured goods and allows components, operations and version-related controls. Give each active BoM an owner, output unit, version or effective date, approved substitutes and change history. A changed component should not silently rewrite the record for already released work.

• Use one unambiguous finished-good identifier and output quantity.
• Include packaging and routinely consumed materials when they affect availability or cost.
• Record expected scrap, yield or by-products only when the business can define them.
• Control alternate components and the authority to substitute.
• Test variant-specific components rather than duplicating nearly identical products.
• Retire obsolete versions without deleting historical evidence.

4. Choose issue and output timing

Components can be issued manually, scanned at the operation or backflushed from completed output. Backflushing reduces transaction effort but assumes the BoM and actual consumption are stable. Manual issue creates evidence but can become late or incomplete. Choose by risk: high-value, variable, regulated or lot-tracked material usually needs stronger confirmation. Whatever the method, the production order should explain planned, issued, returned and scrapped quantities.

5. Control work in progress

Work in progress is not merely a finance total. Operations needs to know which order, stage and location owns the material and whether it is available for another order. Define when components leave raw stock, when output becomes finished stock, how partial completions work, and how cancelled or reworked orders return material. Avoid a generic WIP location that accumulates unexplained balances.

6. Plan components from real demand

Odoo documents a master production schedule that can plan manufacturing and purchase orders from forecasted quantities, while manufactured products require an appropriate route and BoM. The tool cannot repair weak inputs. Replenishment should consider open sales, confirmed production, available components, lead times, minimum order quantities and current WIP. Flag shortages early, but let an owner review exceptions before creating supply automatically.

7. Trace lots, serials and quality status where needed

Use lot or serial tracking only where the product, warranty, expiry, recall or customer requirement justifies it. Odoo supports lots and serials for manufactured products. Define where the identifier is captured, which component lots feed an output lot, and how quarantine or quality release affects availability. A barcode improves speed only after the identifier and process are correct.

8. Reconcile expected and actual production

Worked proof-of-fit scenario

A food producer tests one finished product with three ingredients, packaging and a batch-tracked output. The pilot receives two ingredient lots, releases a manufacturing order, issues one substitute with approval, records a partial run, scraps damaged packaging and completes the balance the next day. The team then traces the output lot back to ingredients and reconciles expected versus actual consumption. A system passes only when that normal-and-exception path is visible without a shadow spreadsheet.

Implementation sequence

Clean items and units first, then approve the representative BoMs, locations and transaction states. Pilot receiving, issue, production, scrap, return and count. Reconcile quantity and value before adding scheduling, scanning or advanced planning. This order prevents automation from multiplying an item or production model the team cannot yet explain.

Sources checked

• Odoo: Manufacturing product configuration
• Odoo: Bill of materials
• Odoo: Master production schedule

This resource provides general implementation guidance. Verify platform settings, tax, legal, payment and operational requirements against the current business context before making a live change.