commit 602e8253be23732bd7a211f537b1d4eb39e86265
author Anand Doshi <anand@erpnext.com> Mon Nov 16 19:05:46 2015 +0530
committer Anand Doshi <anand@erpnext.com> Thu Nov 19 13:23:36 2015 +0530
tree d5a8ee02c585d605acfce8029a80e38fd4fcc326
parent 06df19b56a3028e08afaeb7b5379a145d1dd245c

[enhancement] Int, Currency, Float, Percent as not null and default to 0

erpnext/controllers/queries.py

diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index 0af0b81..3c262f1 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -165,7 +165,7 @@
 			concat(substr(tabItem.description, 1, 40), "..."), description) as decription
 		from tabItem
 		where tabItem.docstatus < 2
-			and ifnull(tabItem.has_variants, 0)=0
+			and tabItem.has_variants=0
 			and tabItem.disabled=0
 			and (tabItem.end_of_life > %(today)s or ifnull(tabItem.end_of_life, '0000-00-00')='0000-00-00')
 			and (tabItem.`{key}` LIKE %(txt)s