Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
How-to guide

How to Create Stock Tracking in an ERP: Every Movement, Every Location, Counts You Can Trust

For wholesalers, retailers and manufacturers: set up stock tracking so the number on screen matches the shelf and every difference has a reason.

A godown worker scanning a carton of brass taps on a rack

Knowing how to create stock tracking in an ERP matters because staff stop trusting a stock figure the first few times it is wrong. After that, they walk to the rack before answering a customer, and the system becomes a billing tool with a stock column nobody reads.

Stock drifts for ordinary reasons. Receipts are keyed a day late, returns go back on the shelf without a record, transfers are carried in a van but not in the books, and the only count happens at year end.

This guide sets out the parts of reliable stock tracking, an illustrative rollout at a Jaipur hardware wholesaler, and how Apragya's inventory app records each movement.

How to create stock tracking, step by step

Stock tracking in an ERP means every change to stock is a document: a receipt, an issue, a transfer, a return or an adjustment. Each one names the item, the quantity and the location, so the balance at any moment is the sum of those documents.

Tracking works when four habits hold. Goods are recorded when they arrive, not when someone has time. Returns go to a separate place until checked. Transfers carry stock in transit rather than making it vanish. And a small slice of stock is counted often, so differences are found while the cause is still known.

Items that expire or carry warranties need more: a batch number and expiry date, or a serial number per unit, recorded at receipt and carried to every sale.

  1. Define every location where stock sits, including returns and damaged areas.
  2. Record opening stock per item and location after a full physical count.
  3. Post every receipt, issue and transfer as a document on the day it happens.
  4. Turn on batch or serial tracking for items that need it.
  5. Rank items by value and count the top group weekly or monthly.
  6. Post count differences with a reason code and review the reasons regularly.

What untracked stock costs

Promises that fail

Sales quotes stock that is no longer on the shelf.

Walks to the rack

Every enquiry needs someone to check by eye.

Annual count shock

A year of drift appears in one stock take, with no causes.

Goods before records

Deliveries sit in the godown before anyone keys them in.

An example: a Jaipur hardware wholesaler

Take an illustrative wholesaler of fittings, taps and hand tools with about 2,500 items across a main godown and a showroom. Its yearly stock take closed the business for two days and still left differences no one could explain.

Every change to stock passes through one record

Stock by location

On hand and reserved, per item and warehouse.

  • Receipts

    Scanned against the supplier's shipping notice.

  • Sales issues

    Posted when the invoice or delivery is made.

  • Transfers

    Godown to showroom, with stock in transit.

  • Returns

    Routed to a returns zone, not the sellable shelf.

  • Cycle counts

    A slice counted each week, differences with reasons.

  • Barcode scans

    Items identified without typing codes.

Because every movement lands on the same record, a difference can be traced to its document.

After three months of weekly counts the wholesaler stopped closing for a yearly stock take. Most differences traced back to returns put on the shelf without a record, which the returns zone fixed, and the counter staff began answering stock questions from the screen.

Two workers counting one ribboned rack while the rest of the godown keeps working
Only the rack being counted was paused; the rest of the godown kept moving goods.

How inventory tracking in ERP works in Apragya

Step 1 of 5

Expected receipts

Shipping notices list the lines, batches, expiry and cartons before goods arrive.

  1. Expected receipts: Shipping notices list the lines, batches, expiry and cartons before goods arrive.
  2. Scans at the door: Barcode and GS1 scans identify items; RFID tags can be read in bulk.
  3. Stock by location: Every receipt, issue and transfer updates the item in that warehouse.
  4. Batch and serial: Lots and individual units are followed where the item needs it.
  5. Cycle counts: Count all items, recent movers or a group, freezing only those in scope.

Getting started

  1. Load opening stock by warehouse, after a full count.
  2. Ask your main suppliers to send shipping notices.
  3. Scan items at receipt instead of typing codes.
  4. Count your highest-value items every week.
  5. Review the reason codes on differences each month.

Three months of small counts usually does more for accuracy than several years of yearly ones.

Choosing a cycle count process over a yearly stock take

A yearly stock take finds a year of errors at once and cannot say when they happened. Counting a small group each week, while the rest of the godown keeps working, catches drift while the cause is still fresh and someone remembers the day.

A yearly stock take, compared with Apragya

FeatureYearly stock takeApragya cycle counts
How oftenOnce a yearWeekly or monthly slices
Godown during countClosed for daysOnly counted items frozen
DifferencesAdjusted in one lumpPosted with reason codes
Which items firstAll alikeHigh-value items more often
Incoming goodsKeyed after arrivalChecked against a shipping notice
Tracing a gapGuessworkMovement history per item

Checked against public information on 16 September 2026.

Ways to track stock by location that hold up

One stock record

Sales, purchase and production read the same balances.

ABC for counting

A consumption ranking shows which items deserve frequent counts.

Movement history

Each balance change links back to its source document.

AI you can put to work

An agent can flag items with repeated count differences.

Audit log

Counts, adjustments and who posted them are logged.

Sync from other systems

Products and stock can be synced through a configured connection.

Tracking builds on barcodes and serial tracking. For the feature page, read stock tracking software, and to set the levels that tracking feeds, see how to create stock levels.

What it costs to start

INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus Inventory and Warehousing
2,000
AI Credits a month
Included on Starter
Free
Up to 3 users
CRM, HR and Vendor Onboarding

Creating stock tracking, answered

Does a cycle count stop the godown?
No. Only the items in the count's scope are frozen while it is open; everything else keeps moving.
How are count differences posted?
A completed count posts a stock reconciliation, which adjusts stock and records the variance.
Do we need barcodes to start?
No. Barcodes speed up receipts and counts, but stock can be tracked by item code from day one.
Which items should be counted most often?
The ones that carry most of the value, which the ABC ranking by consumption value shows.
What does it cost to start?
Inventory and Warehousing is available from the Starter plan, INR 3,999 a month for up to 10 users, which includes CRM and HR plus a choice of enterprise apps and 2,000 AI Credits a month. Pro, at INR 7,999 a month, covers 25 users and every enterprise app.

Make the stock number on screen the one people believe

Load stock by warehouse, scan at receipt and run your first weekly cycle count.