Warehouse Inventory · WMS · Open Source MES
Inventory is not just "how much is in the warehouse," but "how much is available, where it is, which batch it belongs to, when it expires, and which work order will consume it." Odoo Inventory Management puts multiple warehouses and locations, batch/serial numbers, replenishment strategies, and work order material picking into a single ledger, serving as the material foundation for open source MES.
Updated: 2026-10-25 · Guangzhou Odoo Smart Odoo Implementation Team
Difference Between WMS and Inventory Ledger
One-sentence answer: An inventory ledger records "how much," while WMS manages "where, how it comes in, how it goes out, and which goes out first."
When a warehouse has only one or two materials, Excel can keep records; when there are thousands of materials, hundreds of locations, and both batches and expiration dates, without locations and strategies, it becomes "on the books but not found on site." The core of WMS is turning receiving, putaway, internal transfers, picking, verification, shipping, and cycle counting into executable tasks.
First Build the Warehouse Structure Correctly: Warehouse, Zone, Location
- Warehouse: A physical or logical warehouse, which can correspond to a factory, store, or overseas warehouse.
- Zone: Divided by purpose, such as raw material area, semi-finished goods area, finished goods area, defective area, and inspection area.
- Location: The smallest storage unit; it is recommended to code by "zone-row-column-level" for easy scanning and locating.
- Packaging: Boxes, pallets, turnover crates; can be received and issued in full boxes or broken down.
Locations are not better the finer they are: too fine increases the data entry burden for putaway and picking, while too coarse makes locating impossible. It is recommended to first classify by ABC and place high-frequency materials in locations close to the production line.
Batch or Serial Number? A Table to Decide
| Dimension | Lot | Serial Number |
|---|---|---|
| Applicable to | Homogeneous materials that can be traced in batches | Products that are individually identifiable, high-value, or require individual traceability |
| Typical industries | Food, chemical, injection molding, hardware | Electronics, medical, equipment, batteries, auto parts |
| Traceability Granularity | Batch-level | Item-level |
| Management Cost | Lower | Higher, requires scanning and labeling |
| Typical Issues | Mixed batches, expiration | Serial number mismatch, missed scans |
Many companies use "batch-level for raw materials, serial-level for finished goods"; there's no one-size-fits-all approach—choose based on customer audits and regulatory requirements.
FIFO, FEFO, and Safety Stock: Outbound Order Determines Losses
- FIFO (First In, First Out): Ship based on receipt time, suitable for most materials.
- FEFO (First Expired, First Out): Ship based on expiration date, suitable for food, pharmaceuticals, and chemicals.
- Safety Stock: Covers lead time and demand fluctuations; more is not always better.
- Replenishment Rules: Min/max stock, order-based replenishment, forecast-based replenishment; can be set per material.
- Cross-docking: Ship directly after receipt without storing, suitable for FMCG and spare parts.
Outbound strategies must be embedded in the system, not rely on veteran employees' memory; otherwise, turnover, leave, or peak seasons will cause chaos.
How to Improve Inventory Accuracy: Cycle Counting Is More Effective Than Annual Full Counts
Inventory accuracy = number of SKUs matching records / number of SKUs counted. The target is usually set above 98%, but more importantly, "errors are discovered the same day."
- Set counting frequency by ABC classification: Class A weekly, Class B monthly, Class C quarterly.
- Freeze relevant locations or work orders before stocktaking to avoid movement during counting.
- Investigate the causes of discrepancies: wrong receipt, wrong issue, missed scan, incorrect BOM usage, unrecorded scrap.
- Discrepancy adjustments must be approved; warehouse staff cannot directly change figures.
Six Inventory Metrics
| Metric | Definition | Description |
|---|---|---|
| Inventory Accuracy | SKUs matching book records / SKUs counted | Target ≥98% |
| Inventory Turnover Days | Average inventory / Daily average outbound cost | Lower is better, but delivery must be ensured |
| Slow-moving Inventory Ratio | Value of inventory inactive over 90/180 days / Total inventory | Drill down by material and customer |
| Stockout Rate | Stockout order lines / Total order lines | Related to safety stock and replenishment rules |
| Inventory Age | Segmented statistics by receipt date | Food and chemical industries focus on shelf life |
| Inventory discrepancy rate | Discrepancy amount / Inventory count amount | Analyze by storage area and team |
How does inventory integrate with open-source MES and ERP?
- Work order material picking: Pick materials based on BOM explosion, support substitute materials, backflush, and material return.
- Finished goods receipt: Automatically generate finished goods receipt and batch/serial numbers after work reporting is completed.
- Quality hold: Separate pending inspection, non-conforming, and failed locations from available inventory.
- Cost accounting: Moving average, FIFO, or standard cost, executed according to material strategy.
- Shipment traceability: Link shipping batches to customers, support recalls.
To learn about the complete chain of work orders, work reporting, quality, and OEE, please read Open-source MES system topic。
FAQ about warehouse inventory and WMS
Are WMS and ERP inventory modules the same thing?
They overlap, but with different focuses. ERP inventory manages accounting and costs, while WMS emphasizes locations, tasks, picking paths, and operational efficiency; Odoo puts both in the same inventory model, and barcode and operation strategies can be enabled as needed.
Does implementing WMS make inventory accurate?
Not necessarily. Inventory accuracy depends on whether receiving, material picking, material return, scrapping, and transfers are scanned in a timely manner, and whether inventory counts and discrepancy accountability are enforced; the system only formalizes the process.
Can batches and serial numbers be used together?
Yes. A common practice is to use batches for raw materials and serial numbers for finished goods; you can also record both supplier batch and finished product serial number for key components.
How much safety stock is appropriate?
Calculate based on demand fluctuations, lead-time fluctuations, and service targets.Don't just guess the numbers; use at least 6–12 months of historical outbound shipment and stockout records as a baseline.
How to manage multiple warehouses?
Unify material codes and batch rules, and set replenishment strategies and permissions by warehouse. Cross-warehouse transfers must account for in-transit inventory to avoid "both sides counting it as available."
How long does it take to implement inventory management?
Basic receiving, issuing, and storage for a single warehouse typically takes 2–3 weeks; with bin locations, batches, barcodes, and strategies, it usually takes 4–8 weeks. Historical data cleansing and multi-warehouse collaboration will take longer.
Continue reading
- Open Source MES: Complete Chain of Work Orders, Reporting, Quality, and Cost
- Odoo MRP Manufacturing: BOM, Scheduling, and Shop Floor Execution
- Quality Management QMS: IQC/IPQC/OQC, AQL, and 8D Closed Loop
- Equipment Maintenance TPM: Maintenance, Repair Requests, Spare Parts, and OEE
Free Trial of Warehouse Inventory Book a Warehouse Diagnostic