Mark Has Batch No and Has Serial No items once the items have already been created

ERPNext
1

Is there any way to mark Has Batch No and Has Serial No items once the items have already been created and there are transactions with them?
I would appreciate the help

2

first make sure the stock balance is 0, then use system console, to activate the has_batch like this

frappe.db.set_value("Item", "your_item_code", "has_batch", 1)

1 Like
3

Yesterday I was discussing this issue with a client, as many products are now being moved to have batches so as per erpnext, creating new item is not the right solution.

Passing sql entry is fine but I have asked my team to look into a proper solution as I tested Microsoft dynamics and it officially allows items to be changed from non-batch to batch and vis-verse only when the inventory of that item is zero in all warehouses.

We will follow the same approach.

1 Like
4

the option to convert normal item into serialized or batched item is not available in ERP at the moment.

work around is to create a new item, repack existing item into new item and disable the existing one.

5

This does not work for many region due to compliance, we have worked it out maybe will look into pushing it upstream as creating new item will lose the item history, as said in my previous post the product expiry calculation logic is being changed so we need to have the ability to change the item logic on erp too.

1 Like