commit 5f2afb880323a0b13f041653b253e48f0b4512b7
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Mon May 27 13:42:29 2019 +0530
committer Nabin Hait <nabinhait@gmail.com> Mon May 27 13:42:29 2019 +0530
tree 1dd21469be1e9b3244cc734d882afba0722f6a0f
parent a281ce3ddec65baa25b87e0657e8d1a183bc5e4a

fix: Do not fetch batch items and serialized items in stock reconciliation (#17725)

erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py

diff --git a/erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py b/erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py
index a00d279..1fd617c 100644
--- a/erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py
+++ b/erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py
@@ -276,7 +276,8 @@
 	items = frappe.db.sql("""
 		select i.name, i.item_name, bin.warehouse
 		from tabBin bin, tabItem i
-		where i.name=bin.item_code and i.disabled=0
+		where i.name=bin.item_code and i.disabled=0 and i.is_stock_item = 1
+		and i.has_variants = 0 and i.has_serial_no = 0 and i.has_batch_no = 0
 		and exists(select name from `tabWarehouse` where lft >= %s and rgt <= %s and name=bin.warehouse)
 	""", (lft, rgt))