Skip to content
Tutorials Center
My learning

Topics

Lesson 12 of 36 ยท ERP Modules

Inventory and Warehouse Management

Learn how the ERP inventory and warehouse module tracks stock: item master, movements, valuation (FIFO, average), reorder points, safety stock, ABC analysis and cycle counting, with examples.

Inventory is money sitting on shelves. Too little and customers wait; too much and cash, space and shelf life are wasted. The inventory and warehouse module records what stock exists, where it is, what it is worth and every movement in and out. Almost every other module touches it: sales reserves and ships, purchasing receives, production consumes and produces.

This lesson covers the data model, movements, valuation methods, replenishment logic and counting. Examples are Python stand-ins.

Item master and locations

Each stock-keeping unit (SKU) has an item master record: code, description, unit of measure, dimensions and weight, tracking type (none, batch/lot, serial number), valuation method, supplier, reorder parameters and more. Stock is held at locations: plant, warehouse, zone, aisle, rack, bin. Large warehouses add a warehouse management system (WMS) layer for directed put-away and picking.

Stock movements

Stock changes only through documented movements (also "transactions"):

Movement Effect
Goods receipt (from purchase or production) Increases stock
Goods issue (to sales or production) Decreases stock
Transfer between locations Moves stock, total unchanged
Adjustment (count difference, damage) Increases or decreases with a reason
Return Reverses a receipt or issue

Stock on hand at any time equals the sum of all movements, so the movement history is the audit trail.

Python Stock as the sum of movements

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Stock statuses

On-hand stock is not all available. Systems distinguish unrestricted (free), reserved (promised to orders), quality inspection (not yet usable) and blocked (damaged or recalled). Available to promise (ATP) = on hand minus reserved, plus expected receipts, minus expected demand.

Valuation

Stock is an asset, so it must be valued. Common methods:

  • FIFO (first in, first out): oldest cost is used first.
  • Weighted average: cost recalculated at each receipt.
  • Standard cost: a fixed planned cost, with variances posted separately.
Python FIFO versus average cost

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Different methods give different cost of goods sold and different profit, which is why the method is a documented accounting policy.

Replenishment: reorder point and safety stock

The reorder point (ROP) is the stock level that triggers a new order: expected demand during the lead time plus safety stock.

Python Reorder point and order quantity

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

ABC analysis

A small share of items usually makes most of the value. ABC analysis ranks items by annual usage value: A (top ~70-80% of value, tight control), B (next ~15-20%), C (the long tail, simple control). It guides how often to count and how closely to plan each class.

Python ABC classification

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Counting and accuracy

Counting compares system stock with physical stock. A yearly wall-to-wall count stops operations; cycle counting counts a few items every day, focused on A items. Differences are investigated, then posted as adjustments with a reason code. Inventory record accuracy below about 95% breaks MRP (plan to produce) and promises to customers.

Batches, serials and expiry

Food, chemicals and medicines need batch tracking with expiry dates and FEFO picking (first expired, first out). Electronics and machines use serial numbers for warranty and traceability. When a defect appears, forward and backward traceability shows which customers received a batch and which supplier lot it came from.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Stock on hand equals

    Movements are the audit trail; their sum is the current stock.
  2. 2. Reorder point is

    When stock falls to this level, a replenishment order should be placed.
  3. 3. With rising purchase prices, FIFO compared with weighted average usually gives

    FIFO issues the older, cheaper layers first, so COGS is lower when prices rise.
  4. 4. Why do cycle counts focus more on A items?

    A items represent most value, so accuracy there matters most.

Summary

  • Inventory is tracked by item, location and movements; stock is the sum of movements.
  • Valuation (FIFO, average, standard) affects reported cost and profit.
  • Reorder points, safety stock and EOQ drive replenishment; ABC analysis directs effort.
  • Counting, batch and serial tracking keep data accurate and traceable.

Next: Manufacturing and MRP in Practice