Manufacturer: Bringing Production, Inventory & Accounting Together on Odoo

Business Challenge

A small-to-mid-sized manufacturer producing a range of finished goods from purchased raw materials had grown faster than its systems. Production was planned in spreadsheets, bills of materials lived in separate files maintained by different people, and stock levels were counted manually and kept in another workbook. Accounting ran in standalone software with no link to operations.

As a result, the team often discovered raw material shortages only when a job was about to start, finished-goods stock figures were rarely trusted, and product costs were estimates rather than calculated values. Sales could not confidently commit delivery dates to customers.

Pain Points

• Production planned in spreadsheets with no material visibility
• Bills of materials maintained in several inconsistent files
• Frequent raw material shortages discovered late
• Inventory figures not trusted by sales or finance
• Product costs based on estimates, not actual consumption
• Accounting disconnected from purchasing and production
• No reliable way to promise delivery dates

Requirement Analysis

I began with walk-throughs of the full flow: customer order, production planning, material purchasing, receiving, production, quality checks, finished-goods storage, dispatch and invoicing. I worked with the production manager, storekeeper, purchasing and finance to document how each step actually ran, including the workarounds.

The core requirements were a single, controlled bill of materials for each product, production orders that reserve and consume components, reorder rules for raw materials, accurate stock by location, product costing based on materials and operations, and accounting entries generated automatically from purchases, stock moves and sales. Traceability by lot was needed for selected materials.

Recommended Solution

After comparing options against these requirements, I recommended Odoo, using Manufacturing (MRP), Inventory, Purchase, Sales and Accounting in one database. Odoo's integrated design meant a sales order could drive production and purchasing requirements, production orders could consume stock and post costs, and accounting would reflect operations without double entry.

The design kept customization to a minimum, relying on standard Odoo features for routes, reordering, work centers and lot tracking, with small configuration changes for the company's document formats and approval steps. This made the system easier to maintain and upgrade.

Technology

• Odoo Manufacturing (MRP)
• Odoo Inventory with multi-location warehouses
• Odoo Purchase and Sales
• Odoo Accounting
• Lot tracking for selected materials
• Barcode scanning for stock operations

Implementation Approach

1. Mapped order-to-delivery and procure-to-pay processes, including current workarounds and pain points.
2. Cleaned and standardized product data and bills of materials into a single agreed structure.
3. Configured warehouses, locations, routes and reordering rules for raw materials and finished goods.
4. Set up work centers, production operations and product costing with the finance team.
5. Configured accounting, inventory valuation and integration with purchasing and sales.
6. Ran a stock count and migrated opening balances, then tested full cycles with real orders.
7. Trained users by role and supported the first production and month-end cycles after go-live.

Automation

• Confirmed sales orders trigger production orders for make-to-order products
• Reordering rules generate purchase requests when raw materials fall below minimum levels
• Production orders reserve components and flag shortages before work starts
• Stock moves post accounting entries automatically for inventory valuation
• Delivery validation triggers customer invoicing

Integrations

• Barcode scanners for receiving, transfers and dispatch
• Bank statement import for reconciliation
• Email for purchase orders, delivery notes and invoices
• Spreadsheet export for management reporting packs

Business Outcome

Production, inventory and accounting now run from one system. Planners see material availability before releasing jobs, so shortages are identified early enough to act. Bills of materials have one owner and one version, and product costs are calculated from actual consumption rather than estimates.

Sales can check stock and production status before committing delivery dates, and finance no longer re-enters operational data into a separate accounting package. Month-end relies on system data rather than reconciling multiple spreadsheets, and the company has a stable platform to add quality, maintenance or additional warehouses as it grows.