patch for is_batch_item
diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index 2773d69..8978a3b 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -92,3 +92,4 @@
erpnext.patches.v4_2.recalculate_bom_costs
erpnext.patches.v4_2.discount_amount
erpnext.patches.v4_2.update_landed_cost_voucher
+erpnext.patches.v4_2.set_item_batch
diff --git a/erpnext/patches/v4_2/set_item_batch.py b/erpnext/patches/v4_2/set_item_batch.py
new file mode 100644
index 0000000..990be69
--- /dev/null
+++ b/erpnext/patches/v4_2/set_item_batch.py
@@ -0,0 +1,20 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
+# License: GNU General Public License v3. See license.txt
+
+from __future__ import unicode_literals
+import frappe
+
+def execute():
+ item_list = frappe.db.sql("""select name from tabItem""", as_dict=1)
+ for d in item_list:
+ count_stock_entries = frappe.db.sql("""select count(name) from `tabStock Entry Detail` where item_code= %s""",d.get("name"))[0][0]
+
+ count_batch_entries = frappe.db.sql("""select count(name) from `tabStock Entry Detail` where \
+ item_code= %s and batch_no = '' """,d.get("name"))[0][0]
+
+ if count_stock_entries > 0:
+ if count_stock_entries == count_batch_entries:
+ frappe.db.sql("""update `tabItem` set has_batch_no = 'Yes' where name = %s""",d.get("name"))
+
+ if count_batch_entries == 0:
+ frappe.db.sql("""update `tabItem` set has_batch_no = 'No' where name = %s""",d.get("name"))