Inventory is usually the largest current asset on an Indian SME's balance sheet, and often the least understood. The accounting system shows a closing stock value, the warehouse team has its own register, sales has a different number in a spreadsheet, and the physical count at year end disagrees with all three.
ERP inventory management fixes this by making every stock movement a transaction in one system: goods received, transferred, issued, sold, returned or adjusted. Stock levels, values and ageing then come from the same source for everyone. This article explains the core inventory capabilities of an ERP, how they work day to day, and which KPIs help you judge whether inventory is under control.
Why spreadsheets and basic accounting software run out of road
Spreadsheets and accounting packages handle stock reasonably well when you have one location, a few hundred items and a small team. Problems appear as the business grows:
- Stock is updated after the fact, so "available" figures are hours or days old
- Transfers between godowns are recorded late or not at all
- Batch numbers, expiry dates and serial numbers live outside the system
- Reorder decisions depend on one experienced person's memory
- Nobody can say quickly which items have not moved in six months
An ERP does not solve these problems by itself, but it gives each of them a defined process and a place to record it. If you are weighing this move, our overview of what ERP software is is a useful starting point.
Multi-location stock visibility
Most growing businesses hold stock in more than one place: a main warehouse, a factory store, branch godowns, a consignment location or stock lying with job workers.
An ERP models each of these as a location, and larger warehouses can be broken down further into zones, racks and bins. For every item you can see:
- Quantity on hand at each location
- Quantity reserved against sales orders or work orders
- Quantity in transit between locations
- Quantity under quality inspection or on hold
- Available-to-promise quantity for sales
For example, a hypothetical electrical goods distributor with warehouses in Delhi, Jaipur and Lucknow can see that a customer's order for 200 MCBs can be fulfilled from Jaipur, even though the Delhi warehouse, which usually serves that customer, shows only 60. Businesses running several branches will find more on this in our article on how ERP helps manage multi-branch businesses.
Goods receipt notes (GRN)
The goods receipt note is the entry point for inventory. In an ERP, a GRN is created against a purchase order, which means the system already knows the expected items, quantities and rates.
A well-configured GRN process:
- Flags short or excess receipts against the PO
- Captures batch numbers, expiry dates or serial numbers at receipt
- Routes items that need inspection to a quality-hold location
- Links to the supplier invoice for three-way matching (PO, GRN, invoice)
- Updates stock and creates the accounting entry for goods received
Three-way matching alone prevents a common leak: paying suppliers for quantities that were never received, or at rates that were never agreed.
Stock transfers between locations
Transfers are where multi-location stock most often goes wrong. Material leaves one godown but is not received at the other, or is received with a different quantity, and nobody notices until the count.
An ERP handles transfers as a two-step process: a transfer out from the source location, which moves stock into an in-transit state, and a transfer in at the destination, which confirms the quantity received. Differences are recorded explicitly, not buried.
For inter-state transfers between GST registrations, the ERP also needs to generate the correct document (such as a tax invoice or delivery challan, depending on the case) and support e-way bill generation. Our article on ERP and GST compliance covers this in more detail.
Reorder levels and replenishment
Reorder planning in an ERP typically uses three parameters per item and location:
- Minimum level or safety stock: the buffer held against demand or supply variation
- Reorder level: the stock level at which a new order should be placed, usually lead-time demand plus safety stock
- Maximum level or reorder quantity: how much to order, often based on economic order quantity or supplier pack sizes
The ERP compares available stock (on hand plus on order minus reserved) against these levels and generates a reorder report or draft purchase requisitions automatically. For manufacturers, this is often replaced or supplemented by MRP, explained in our manufacturing ERP guide.
ABC analysis
Not every item deserves the same attention. ABC analysis ranks items by their annual consumption or sales value:
- A items: a small number of items that make up most of the value. Tight control, frequent counts, close supplier follow-up.
- B items: moderate value and moderate control.
- C items: many low-value items. Simple rules, larger order quantities, less frequent counts.
An ERP can calculate ABC classes automatically from transaction history and refresh them periodically. Some businesses combine ABC with XYZ analysis, which classifies items by demand variability, to set different replenishment rules for stable and erratic items.
Batch, expiry and serial tracking
Batch and expiry
Pharma, food, FMCG, chemicals and cosmetics businesses need to know which batch is where and when it expires. An ERP records the batch at receipt or production and carries it through every movement. It can then:
- Enforce FEFO (first expiry, first out) during picking
- Block expired or near-expiry batches from being sold
- Report stock by expiry bucket so near-expiry goods can be cleared early
- Trace a batch to every customer who received it, in case of a recall
Serial numbers
Electronics, machinery, appliances and automotive parts often need unit-level tracking. Serial tracking links each unit to its purchase, sale, warranty period and service history. When a customer calls with a warranty claim, the service team can confirm the sale date and invoice in seconds.
Barcode scanning
Barcodes and QR codes make inventory transactions faster and more accurate. Instead of typing item codes and batch numbers, warehouse staff scan them using handheld scanners or mobile devices.
Common uses include:
- Scanning items during GRN to match against the PO
- Scanning bin labels during put-away and picking
- Scanning during dispatch to confirm the right items and quantities
- Scanning during cycle counts
Barcoding is one of the most effective accuracy improvements a warehouse can make, and it is often a sensible early addition to an ERP rollout.
Cycle counting instead of annual stocktakes
An annual physical stocktake shuts operations down for a day or two and still produces variances that are hard to explain, because the errors happened months earlier.
Cycle counting spreads the count across the year. The ERP generates count lists daily or weekly, often weighted by ABC class, so A items are counted frequently and C items less often. Variances are investigated while the transactions are still recent, and adjustments go through an approval workflow rather than being posted directly.
Inventory valuation methods
The ERP calculates stock value continuously, based on the valuation method configured for each item or item group. The two most common in India are:
| Method | How it works | Where it suits |
|---|---|---|
| FIFO (first in, first out) | Issues are valued at the cost of the oldest stock still on hand | Perishables, items with changing purchase prices, businesses wanting stock valued close to recent cost |
| Weighted average | Each receipt updates an average cost, and issues are valued at that average | Commodity-type materials, high-volume items, businesses wanting smoother cost figures |
| Standard cost | Items carry a predetermined cost, and differences are posted as variances | Manufacturers with stable BOMs who want to track variances |
Choose the method with your chartered accountant, keep it consistent with the accounting standards applicable to you, and do not change it casually, because it affects reported profit.
One practical point: valuation is only as good as the underlying transactions. Late GRNs, missing landed costs (freight, duty, handling) or unrecorded returns distort stock values under any method.
Dead stock and slow-moving stock
Dead and slow-moving stock ties up working capital and warehouse space. An ERP identifies it through ageing reports that group stock by the number of days since the last receipt, issue or sale.
A typical approach:
- Define "slow-moving" and "non-moving" thresholds that make sense for your business, such as no movement for 90 or 180 days
- Review the list monthly with sales and purchase teams
- Decide on each item: liquidate, return to supplier, rework, transfer to a location where it sells, or write down
- Block further purchase of items flagged as non-moving until reviewed
The ERP cannot sell dead stock for you, but it stops it from hiding.
Key inventory KPIs to track
The table below lists common inventory KPIs with their definitions and formulas. Targets vary widely by industry, product mix and business model, so set your own benchmarks from your historical data rather than using generic numbers.
| KPI | What it measures | Formula |
|---|---|---|
| Inventory turnover | How many times inventory is used or sold in a period | Cost of goods sold ÷ average inventory value |
| Days inventory outstanding | Average number of days stock is held | (Average inventory value ÷ cost of goods sold) × days in period |
| Inventory accuracy | How closely system stock matches physical stock | (Number of items with no count variance ÷ number of items counted) × 100 |
| Stock-out rate | How often demand could not be met from stock | (Order lines not fulfilled due to stock-out ÷ total order lines) × 100 |
| Fill rate | Share of demand fulfilled from available stock | (Quantity shipped from stock ÷ quantity ordered) × 100 |
| Dead stock ratio | Share of inventory value with no movement beyond your threshold | (Value of non-moving stock ÷ total inventory value) × 100 |
| Carrying cost of inventory | Cost of holding stock | Storage + insurance + capital cost + obsolescence + handling, for the period |
| GRN-to-put-away time | Speed of making received goods available | Time of put-away confirmation − time of GRN |
Most ERPs can calculate these automatically, and businesses that connect their ERP to a BI tool such as Power BI can track trends by location, category and period.
Getting inventory control right in an ERP project
A few practical lessons from inventory-heavy implementations:
- Clean the item master first. Duplicate item codes, inconsistent units of measure and vague descriptions cause more problems than any missing feature. Our guide on migrating from Excel or legacy software to ERP covers data clean-up in detail.
- Count before go-live. Opening stock should come from a physical count, not the old system's closing balance.
- Decide units of measure carefully. Purchase in boxes, store in pieces and sell in dozens is fine, as long as conversions are defined correctly.
- Train the warehouse team, not just managers. The people doing GRNs and transfers determine data quality.
- Enforce the process. If goods can move without a transaction, the system will drift from reality.
Aptivix Technologies helps distributors, traders and manufacturers set up these inventory processes as part of ERP implementation and customization. If you are a distribution business, our page on ERP software for distributors explains how we typically approach multi-location stock, and you can request a consultation to discuss your specific setup.
Final thoughts
ERP inventory management is less about software features and more about discipline: every movement recorded, every location visible, every item classified and reviewed. The ERP provides the structure, the automation and the reporting. When that structure is in place, inventory stops being an annual surprise and becomes something you can plan, measure and improve month by month.
Frequently asked questions
ERP improves accuracy by making every stock movement a recorded transaction: GRNs against purchase orders, two-step transfers, work-order issues and dispatches. Barcode scanning reduces typing errors, and cycle counting finds variances while they are still recent. Accuracy ultimately depends on process discipline, so goods should never move without a corresponding transaction in the system.
FIFO and weighted average are the most common. FIFO values issues at the oldest cost on hand, while weighted average smooths price changes. Manufacturers sometimes use standard cost with variance tracking. The right choice depends on your products and applicable accounting standards, so decide with your chartered accountant and apply it consistently.
Yes. A good ERP captures batch and expiry details at receipt or production and carries them through every movement. It can enforce first-expiry-first-out picking, block expired stock from sale, report near-expiry stock and trace any batch to the customers who received it. This is essential for pharma, food, FMCG and chemical businesses.
A physical stocktake counts everything at once, usually at year end, and often requires stopping operations. Cycle counting counts a subset of items on a rolling schedule, with high-value items counted more often. Variances are found and investigated sooner, operations continue, and overall stock accuracy tends to improve steadily over the year.
Written by
Aptivix Technologies
The ERP team at Aptivix Technologies implements, customizes, integrates and builds ERP systems for growing businesses across India.
