commit a0630671da7a98ef93051046355ec506ef25597d
author Anand Doshi <anand@erpnext.com> Thu Apr 09 13:34:57 2015 +0530
committer Anand Doshi <anand@erpnext.com> Thu Apr 09 13:34:57 2015 +0530
tree e251f6be7013d0c6082cfabb121c33305fa118c7
parent 00a07de426fa870bb10299afddffa0787a680137

[hotfix] batch query

erpnext/controllers/queries.py

diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index ea1c4fe..e1826e7 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -264,7 +264,7 @@
 			where item = %(item_code)s
 			and name like %(txt)s
 			and docstatus < 2
-			and (ifnull(batch.expiry_date, '')='' or batch.expiry_date >= %(posting_date)s)
+			and (ifnull(expiry_date, '')='' or expiry_date >= %(posting_date)s)
 			{match_conditions}
 			order by expiry_date, name desc
 			limit %(start)s, %(page_len)s""".format(match_conditions=get_match_cond(doctype)), args)