Managing Batch wise Inventory

Items with the same properties (e.g., manufacturing date, expiry date, packaging) can be grouped into Managing Batch wise Inventory. For example, pharmaceutical products are typically managed using batches so that their expiry, traceability, and stock tracking remain accurate.

1. Enable tracking in a batch of items.

To input an item in a batch, enter the “Has Batch No” checkbox under the Item Master.

 

Stock > Setup > Item > Inventory tab > Serial Nos / Batches > Has Batch No

 

When this is switched on:

 

  • Every stock transaction must be recorded in a batch number.
  • One can map a batch with manufacturing dates, expiration dates and batch attributes.

 

ERPNext Item Inventory tab showing Has Batch No enabled with Automatically Create New Batch option

 

2. Create a New Batch

You can create a new Batch manually by going to:

 

Stock > Setup > Batch No > Add Batch

 

However, in ERPNext, batches can also be created automatically if:

 

  • The item has the option of the checkbox: Automatically Create New Batch.
  • The item master sets the Batch Number Series (for example AMX-.YY.-.####).

 

This makes it so that a batch is created automatically when inward entries are performed such as Purchase Receipt or Stock Entry (Material Receipt).

3. Batch in Purchase Receipt

In making out a receipt of purchase you should either:

 

  • Tick Use Serial No / Batch Fields in the item row and choose an existing batch in the Batch No field, or
  • Allow a batch to be created automatically when there are settings to auto-create a batch when the Item Master is setup.

 

Note that every batch is individual property of one item. Only one item can be of the same batch.

 

ERPNext v16 Serial and Batch Bundle created by a Purchase Receipt with auto-created batch AMX-26-0001

In v16 the batches received are recorded in a Serial and Batch Bundle that is linked to the item row. The bundle above was created by a Purchase Receipt and shows the batch AMX-26-0001 that was created automatically.

 

4. Batch in Delivery Note

In filling in a Delivery Note you have to choose the Batch No. in the Items table.

 

In case the item is a part of Product Bundle, it is also possible to enter the batch in the Packing List field.

 

When batches are picked automatically, ERPNext selects them on the basis of FIFO, LIFO or Expiry, as set in Stock Settings > Pick Serial / Batch Based On.

 

Batch No selected in a Delivery Note item row with Use Serial No / Batch Fields ticked in ERPNext v16

 

5. Batch-wise Stock Balance Report

In order to see the stock balance per lot, visit:

 

Stock > Reports > Batch-Wise Balance History

 

This report gives Visibility on:

 

  • Item-wise and warehouse-wise batch availability
  • Opening, In and Out quantities for the chosen period (for expiry, use the Batch Item Expiry Status report)
  • Quantity available per batch

 

ERPNext v16 Batch-Wise Balance History report showing two batches of AMX-500 in Stores - DC

 

ERPNext Partner
WhatsApp Support ×

Hello 👋

How can we help you?

Chat on WhatsApp