Serial and Batch Bundle

NOTE: Users must create separate "Serial and Batch Bundles" for each stock transaction. They cannot use the same "Serial and Batch Bundle" across multiple stock transactions.

Allow Negative Stock has removed for Serial / Batch Items from version 15. So from version 15 users won't be able to make negative stock transactions for serial /batch items even though Allow Negative Stock has enabled in the Stock Settings.


In version 15, we have introduced the Serial and Batch Bundle. This feature will be used to link Serial / Batch Nos in the Stock transactions.

Before version 15 the Serial No field was a Small Text field. Which meant one column was holding more than one serial number. Because of this design, there were lot of a data integrity issues. So to solve this we have changed the Serial No field from Small Text to Link field in version 15. Since we can't add a child table inside a child table we have added a new doctype "Serial and Batch Bundle"

to pick/dispatch multiple Serial / Batch numbers.

Serial no Configure

How does this work?

You need a Serial and Batch bundle to be created and linked to stock transactions whenever you have to deal with Serial / Batch numbers. The user needs to create a separate "Serial and Batch Bundle" for each transaction and they can't link the same "Serial and Batch Bundle" to multiple transactions.

Auto Creation of Serial and Batch Bundle for Inward Entry

If the user wants to create an auto "Serial and Batch Bundle" for the inward entry then they have to make sure that 'Serial Number Series' has been set for the item Serial Item and the 'Automatically Create New Batch' checkbox with 'Batch Number Series' has set for the Batch Item.

For Serial No

Serial no Configure

For Batch No

Batch no Configure

After the configuration when the user creates the Purchase Receipt or Stock Entry with the Type "Material Receipt", the system will create the "Serial and Batch Bundle" for inward automatically on submission of the record.

Auto Serial Batch Bundle Inward

Auto Creation of Serial and Batch Bundle for Outward Entry

If the user wants to create an auto "Serial and Batch Bundle" for the outward entry then they have to enable the checkbox "Auto Create Serial and Batch Bundle For Outward" in the stock settings. The user can also set "Pick Serial / Batch Based On" as "FIFO / LIFO / Expiry" in the stock settings.

Auto Serial Batch Bundle Outward Configure

After the configuration when the user creates the Delivery Note or Stock Entry with the Type "Material Issue", the system will create the "Serial and Batch Bundle" for outward automatically on submission of the record.

Auto Serial Batch Bundle Outward

Manual Creation of Serial and Batch Bundle for Inward Entry

For the "Serial and Batch Bundle", both serial / batch no needs to be present first in the system. So with the manual option user has to first create the Serial / Batch Nos in the system. The user has to use the CSV import option to make Serial / Batch Nos. The blank CSV template can be downloaded using the Serial and Batch Selector.

create-using-csv

Complete GIF for manual creation of Serial and Batch Bundle for inward entry is as follow

manually-create-serial-no-inward

Manual Creation of Serial and Batch Bundle for Outward Entry

Using the Serial and Batch Selector, the user can pick the Serial / Batch Nos based on the "FIFO / LIFO / Expiry" method.

serial-batch-selector-outward

Complete GIF for manual creation of Serial and Batch Bundle for outward entry is as follow

manually-create-serial-no-outtward

History of Serial Numbers

To check the history of Serial Numbers, check the report "Serial No Ledger"

Serial No Ledger

Serial / Batch Selector

Is used to select Serial Nos / Batches manually, also this popup is used to create serial nos / batches automatically if they are not exists.

serial-batch-selector

Disable Serial / Batch Selector

If users don't want to use the Serial and Batch Selector (popup) then they can disable it through Stock Settings. To disable it, goto Stock Settings > Serial and Batch Item (TAB) > " Disable Serial No And Batch Selector " enable this checkbox and save.

disable-serial-batch-selector

Old Serial / Batch Fields

Many customers have requested to retain the old serial and batch fields to address UX issues. In response to their demand, we have retained the old serial/batch fields. These fields are solely used for entering serial numbers and batches. The system will automatically create the Serial and Batch Bundle upon the submission of the stock transaction. To enable this feature, users must navigate to Stock Settings and enable the 'Use Serial / Batch Fields' option (see below image).

use-serial-batch-fields-global

After that when user create the stock transaction like delivery note, system will show the old Serial / Batch Fields. For more details please check the below GIF

user-old-serial-batch-fieldsd

User can disable old serial / batch fields at transaction level too.

use-serial-batch-for-dn

Update Serial / Batch on Creation of Auto Bundle

If user want to update the Serial No / Batch in the Serial / Batch fields automatically on creation of the Serial and Batch Bundle, then goto Stock Settings -> disable "Do Not Update Serial / Batch on Creation of Auto Bundle".

update-Serial-Batch-on-creation-of-auto-bundle

Case:

  1. User has enabled "Use Serial / Batch Fields" in the stock settings
  2. User want to create the serial and batch bundle per single batch
  3. User has set the auto create batch in the Item master.
  4. On submission of the Purchase Receipt, system has created auto Batch, Serial and Batch Bundle and set the Batch and Serial and Batch Bundle in the respective fields on the Purchase Receipt line item..
  5. Updating the value of batch takes time and if you want to skip this step, please enable "Do Not Update Serial / Batch on Creation of Auto Bundle" in the stock settings.
  6. With this the batch column remain blank but the serial and batch bundle will have the value of the auto created bundle.

How to Use Serial and Batch Bundle

https://www.youtube.com/watch?v=-VjZvRtdjDQ&t=820s

On this page