Skip to Content

Warehouse Inventory WMS: Multi-Warehouse, Multi-Location, Lot/Serial Numbers and FEFO

Table of contents

No titles in the blog post

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

DimensionLotSerial Number
Applicable toHomogeneous materials that can be traced in batchesProducts that are individually identifiable, high-value, or require individual traceability
Typical industriesFood, chemical, injection molding, hardwareElectronics, medical, equipment, batteries, auto parts
Traceability GranularityBatch-levelItem-level
Management CostLowerHigher, requires scanning and labeling
Typical IssuesMixed batches, expirationSerial 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."

  1. Set counting frequency by ABC classification: Class A weekly, Class B monthly, Class C quarterly.
  2. Freeze relevant locations or work orders before stocktaking to avoid movement during counting.
  3. Investigate the causes of discrepancies: wrong receipt, wrong issue, missed scan, incorrect BOM usage, unrecorded scrap.
  4. Discrepancy adjustments must be approved; warehouse staff cannot directly change figures.

Six Inventory Metrics

MetricDefinitionDescription
Inventory AccuracySKUs matching book records / SKUs countedTarget ≥98%
Inventory Turnover DaysAverage inventory / Daily average outbound costLower is better, but delivery must be ensured
Slow-moving Inventory RatioValue of inventory inactive over 90/180 days / Total inventoryDrill down by material and customer
Stockout RateStockout order lines / Total order linesRelated to safety stock and replenishment rules
Inventory AgeSegmented statistics by receipt dateFood and chemical industries focus on shelf life
Inventory discrepancy rateDiscrepancy amount / Inventory count amountAnalyze 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.

Odoo Procurement - Supports tiered pricing, procurement bidding, automatic purchasing based on inventory calculation, effectively improving supply chain and inventory performance