commit 1e8025b3275c004f50ccffb0db6b21c7abfc62d1
author Rushabh Mehta <rmehta@gmail.com> Fri Jul 24 15:16:25 2015 +0530
committer Rushabh Mehta <rmehta@gmail.com> Wed Jul 29 11:38:33 2015 +0530
tree 9afa1a4cabb6be2d8aea58bd0861dd5becf3af8d
parent 18e033514e5a98368569b9eae78783f6b8e6217d

[cleanup] yes/no selects changed to checks in Item

erpnext/stock/reorder_item.py

diff --git a/erpnext/stock/reorder_item.py b/erpnext/stock/reorder_item.py
index f739f94..51dd8c1 100644
--- a/erpnext/stock/reorder_item.py
+++ b/erpnext/stock/reorder_item.py
@@ -69,7 +69,7 @@
 		from tabBin where ifnull(item_code, '') != '' and ifnull(warehouse, '') != ''
 		and exists (select name from `tabItem`
 			where `tabItem`.name = `tabBin`.item_code and
-			is_stock_item='Yes' and (is_purchase_item='Yes' or is_sub_contracted_item='Yes') and
+			is_stock_item=1 and (is_purchase_item=1 or is_sub_contracted_item=1) and
 			(ifnull(end_of_life, '0000-00-00')='0000-00-00' or end_of_life > %s))
 		and exists (select name from `tabWarehouse`
 			where `tabWarehouse`.name = `tabBin`.warehouse