[fix] [minor] fix in re-order query
diff --git a/stock/utils.py b/stock/utils.py
index 848783b..5376342 100644
--- a/stock/utils.py
+++ b/stock/utils.py
@@ -193,8 +193,7 @@
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
- (ifnull(end_of_life, '')='') or end_of_life > now())""",
- as_dict=True)
+ (ifnull(end_of_life, '')='' or end_of_life > now()))""", as_dict=True)
for bin in bin_list:
#check if re-order is required
item_reorder = webnotes.conn.get("Item Reorder",