Everything you need to know about ERPNext inventory management for Indian businesses — multi-warehouse setup, FIFO vs moving average valuation, batch and serial tracking, FEFO, reorder alerts, stock reconciliation, perpetual inventory accounting, e-Way Bill and key reports. Written by a Frappe-certified implementation partner with 50+ ERPNext deployments in India.
Most Indian manufacturing and trading businesses manage inventory across three disconnected systems — purchase entries in Tally, stock tracking in Excel and billing in a separate POS or invoicing tool. Every transaction creates manual work: updating the Excel when goods arrive, updating it again when goods go out, reconciling the numbers at month-end when they inevitably don't match.
The Stock module is ERPNext's inventory management system. It is not a standalone inventory tool — it is fully integrated with the Purchase, Sales, Manufacturing and Accounting modules. Every inward movement (purchase receipt, stock entry, production output) and every outward movement (delivery note, sales invoice with stock update, material issue) updates the Stock Ledger in real time.
Every document that moves stock creates a Stock Ledger Entry — the single source of truth for every quantity and valuation change. The Stock Ledger is the foundation of every inventory report in ERPNext and the source of all accounting entries for inventory.
ERPNext organises warehouses in a tree structure — parent nodes as groups, leaf nodes as physical locations where stock is actually held. This structure lets a single company maintain separate visibility for multiple physical locations without losing the ability to see a consolidated view.
Each leaf warehouse can be mapped to its own accounting ledger. When perpetual inventory is enabled — the recommended setting for all businesses — every movement in or out of a warehouse automatically posts to the mapped ledger. The balance sheet always reflects the current value of each warehouse's stock without any manual journal entry.
Moving stock between warehouses — raw material from main store to production floor, finished goods from Plant A to Plant B, returns to quarantine — is done using a Material Transfer Stock Entry. The source warehouse decreases, the target warehouse increases, and if the warehouses are mapped to different cost centres, the accounting entries reflect the movement. No manual journal entry is needed.
Multi-branch distributors: ERPNext is particularly useful for distributors with branches in multiple cities. Each branch has its own warehouse, its own stock balance, its own reorder alerts. The MD sees stock across all branches from a single consolidated dashboard — without calling each branch manager.
ERPNext values inventory perpetually — every movement updates both the quantity and the monetary value of stock in real time through the Stock Ledger. The Valuation Method determines how the cost of each outgoing unit is calculated, which directly affects your Cost of Goods Sold and closing stock value.
FIFO assumes the oldest stock is consumed first. ERPNext maintains a queue of cost layers for each item-warehouse combination. Every purchase receipt adds a layer at its actual incoming cost. Every issue or sale consumes layers from the front of the queue — the oldest first — at their original purchase cost.
| Transaction | Qty | Rate (₹/kg) | Queue after | Stock Value |
|---|---|---|---|---|
| Purchase 1 — 1 Apr | 100 kg | ₹85 | [100 @ 85] | ₹8,500 |
| Purchase 2 — 15 Apr | 100 kg | ₹92 | [100 @ 85][100 @ 92] | ₹17,700 |
| Issue to production — 20 Apr | 120 kg | FIFO: 100@85 + 20@92 | [80 @ 92] | ₹7,360 |
The 120 kg issued is valued at ₹100×85 + ₹20×92 = ₹10,340. COGS = ₹10,340. Remaining 80 kg stays at ₹92/kg — the actual purchase cost of that batch.
When to use FIFO: Businesses where raw material prices fluctuate significantly between purchases — auto component manufacturers buying steel, traders buying commodity goods, pharma buying API. FIFO gives the most accurate COGS because it matches actual purchase costs to actual consumption.
Moving Average calculates a running weighted average cost across all stock currently on hand. Every new purchase recalculates the average. Every issue or sale is valued at the current average rate — not the specific cost of a particular batch.
| Transaction | Qty | Rate | Avg Rate after | Stock Value |
|---|---|---|---|---|
| Purchase 1 — 100 kg @ ₹85 | 100 kg | ₹85 | ₹85.00 | ₹8,500 |
| Purchase 2 — 100 kg @ ₹92 | 100 kg | ₹92 | ₹88.50 | ₹17,700 |
| Issue to production — 120 kg | 120 kg | ₹88.50 | ₹88.50 | ₹7,080 |
Issue valued at 120 × ₹88.50 = ₹10,620. Average rate remains ₹88.50 for remaining 80 kg. Moving Average smooths the impact of price changes across all stock.
When to use Moving Average: Businesses with stable or slowly changing purchase prices, or where management accounts use average cost for simplicity. Easier to explain to non-accountants — "everything issues at the current average cost."
| Factor | FIFO | Moving Average |
|---|---|---|
| Cost accuracy | Highest — each issue valued at actual purchase cost | Averaged — smooths price fluctuations |
| Best for | Fluctuating raw material prices (steel, commodities, API) | Stable prices, FMCG, standard costing environments |
| Batch costing | Each batch retains its purchase cost until consumed | All batches valued at the same running average |
| COGS behaviour | Rises with older cheap stock; falls when new expensive stock arrives | Smoothed — gradual change as prices move |
| Where to set in ERPNext | Item master → Valuation Method (overrides company default) | Stock Settings → Default Valuation Method |
| Can mix methods? | Yes — different items can use different methods in the same ERPNext instance | |
The most significant feature of ERPNext inventory for Indian businesses is perpetual inventory — the automatic posting of every stock movement to the general ledger. When perpetual inventory is enabled (the recommended setting), every Stock Ledger Entry creates a corresponding General Ledger Entry without any manual journal.
The result: the stock value on the balance sheet at any point in time automatically matches the sum of all Stock Ledger Entries. There is no separate month-end stock entry, no reconciliation between the stock ledger and the accounts ledger. The CA who opens ERPNext on the last day of the month sees the same stock value in the balance sheet that the stores team sees in the stock balance report.
Most Indian businesses on Tally reconcile their stock register against their Tally accounts manually at month-end — a process that takes 3–7 days and frequently produces differences. With ERPNext perpetual inventory, this reconciliation is eliminated. The accounts are always up to date because every stock movement posts to the ledger immediately.
ERPNext supports two types of item-level traceability — batch tracking (for items managed by production batch or lot) and serial number tracking (for items where each individual unit has a unique identity).
For items with batch management enabled in ERPNext, every inward transaction requires a batch number. The batch carries:
Every outward transaction — Delivery Note, POS Invoice, material issue to production — requires selection of the batch. The batch balance is tracked in real time. Full traceability from purchase to sale: you can find every delivery that used a specific batch within seconds.
FEFO is a batch selection rule that can be configured in ERPNext. When enabled for an item, the system suggests the batch with the earliest expiry date at the time of issue or delivery. This prevents newer stock from being picked before older expiring stock — critical for pharma retail, FMCG distributors and food manufacturers where expired goods create liability.
FEFO is configured per item. It is not applied globally by default — it must be enabled specifically for items where expiry sequence matters.
For high-value items where each unit needs individual tracking — machinery components, electronic equipment, tools — serial number tracking in ERPNext assigns a unique serial number to every unit. The serial number is recorded at purchase and at delivery. From any serial number, you can see:
For pharma distributors: ERPNext batch tracking with FEFO enforces compliance with Schedule H dispensing requirements for controlled drugs — batch number recorded on every invoice, expiry date visible before dispensing, oldest stock issued first automatically when configured.
ERPNext reorder alerts notify the stores or purchase team when stock falls below the configured minimum level. Reorder levels are set per item per warehouse — different minimum stock levels for different warehouses and branches.
When stock falls below the reorder point, ERPNext generates a Material Request automatically (when the reorder rule is configured to auto-create). The Material Request flows to the purchase team for supplier selection and Purchase Order creation. The reorder quantity — the amount to purchase to bring stock back to the desired level — is also configured per item per warehouse.
For manufacturers using MRP (Material Requirements Planning), ERPNext's MRP run analyses the production plan against current stock and open Purchase Orders to generate Material Requests for all shortages simultaneously — not just items that have individually hit their reorder point, but all materials needed for the planned production schedule.
No inventory system is perfectly accurate without periodic physical counting. ERPNext Stock Reconciliation is the tool for updating system stock to match a physical count.
The process:
For large warehouses with hundreds of SKUs, the Stock Reconciliation can be uploaded from a CSV template — export the current stock, update the Qty column with physical counts, upload back. The system calculates all differences in one batch.
Every movement of goods valued above ₹50,000 requires an e-Way Bill before the goods leave the dispatch location. ERPNext generates e-Way Bills from Delivery Notes and Sales Invoices through the India Compliance app.
From the submitted Delivery Note, click e-Way Bill → Generate. ERPNext presents a form for:
The India Compliance app submits this data to the e-Way Bill portal API and returns the EWB number and validity period. The EWB number is stored against the Delivery Note. No separate portal login. No re-entry of invoice data.
From ERPNext, you can also update Part B (when vehicle changes mid-journey), extend validity and cancel the e-Way Bill within 24 hours of generation if goods have not moved.
ERPNext provides a comprehensive set of real-time stock reports. The most commonly used for Indian manufacturing and trading businesses:
Beyond the core inventory module, several ERPNext features are particularly relevant for Indian businesses:
ERPNext inventory management is one of the most complete stock modules available in any ERP system at any price point — and it is included in the base licence at ₹0. The combination of multi-warehouse real-time tracking, FIFO and moving average valuation, batch and serial traceability, FEFO enforcement, automatic reorder alerts and perpetual inventory accounting addresses every inventory challenge that Indian manufacturing and trading businesses face.
The most significant benefit for Indian businesses is the elimination of the Tally-Excel-billing system disconnect. With ERPNext, the stock balance, the P&L and the balance sheet all come from the same transactions. Month-end stock reconciliation between systems is eliminated. The CA who wants to know closing stock value on the 4th of the month can read it directly from ERPNext — without waiting for the accounts team to manually update Tally.
PS Digitise implements ERPNext for manufacturing, trading and distribution businesses across India. Our implementation includes full inventory configuration — warehouse setup, item masters with HSN codes, valuation method selection, batch tracking setup, reorder rules and e-Way Bill configuration. Phase 1 live in 8 weeks.
PS Digitise is a certified Frappe Partner in India. If you are evaluating ERPNext for inventory management, we offer a free 30-minute consultation. We will assess your warehouse structure, batch tracking requirements and valuation preferences and give you a written implementation plan. Contact us here or WhatsApp +91 9677 174 743.
Certified Frappe Partner. Multi-warehouse, batch tracking, FEFO, perpetual inventory — all configured in Phase 1. Free 30-minute call. Written quote in 48 hours.
