Batch and lot tracking in inventory: how it works
By Graeon.ai · Updated
Batch and lot tracking means every receipt and every production run gets a batch number, and stock is held, issued and sold by that batch. With FIFO, the ERP issues the oldest batch first. Done properly, you can answer which batch went to which customer, and stores cannot issue stock that is not there.
Why batches matter
Paints, chemicals, food, plastics and many other products are made in batches. Two batches of the same item can differ in shade, strength or shelf life. If a customer complains, you need to know which batch they received, which raw material lots went into it and who else got the same batch.
Without batch tracking, stock is one number per item. That number may be right in total and still hide old material sitting at the back of the godown. Batch tracking also helps the accounts side: when stock is valued at month end, you know which material is old, which is slow-moving and which may need to be written down.
How FIFO works in practice
FIFO, first in first out, means the oldest batch is used or sold first. In an ERP, the batch is recorded on the GRN or the production entry, and when material is issued or dispatched the system suggests or picks the oldest batch available in that warehouse. Blocking negative stock matters here: if the ERP lets stores issue more than it holds, batch balances stop making sense within weeks.
Several warehouses and several units
Most manufacturers hold stock in more than one place: a raw material store, a finished goods godown, a depot in another state. Each one needs its own balance, and a transfer between them should carry the batch with it, so a movement history can show where every batch has been.
Units are the other trap. You may buy a solvent in litres, issue it in litres, pack the product in pieces and sell it in cartons. If the ERP holds only one unit per item, people convert in their heads and errors creep in. The item should know its conversions, so the same stock can be bought, stocked and billed in the unit that suits each document.
Stock audits that find the gaps
- Count by location and batch, not just by item, so you know where a difference sits
- Freeze movements for the area being counted, or count when the store is closed
- Record differences as adjustments with a reason, so they can be reviewed
- Count fast-moving and high-value items more often than the rest
- Look at the movement history of any item with repeated differences before you correct it
Common mistakes
- Allowing negative stock to keep work moving, then never correcting it
- Entering batch numbers on some documents and not others
- Keeping a different item code for each pack size instead of using units
- Bulk-loading opening stock without batches, so the first months cannot be traced
- Transferring stock between warehouses on a slip of paper, so the batch is lost on the way
- Counting once a year, when differences are too old to explain
How Graeon ERP handles it
Graeon ERP holds stock across multiple warehouses and branches, with transfers, adjustments and stock movement history. It tracks batches and lots with FIFO and blocks negative stock. One product can be bought, stocked and billed in different units, such as carton, piece and litre. Items and parties can be imported in bulk from Excel, and lists can be exported to Excel.
Rack put-away and stock audit, serial numbers from receipt to dispatch with QR labels, and colour and size variants with stock split by option are available, switched on per company.