commit e82eee512b077570aacddfbdf4bbb6d6bf21be14
author Akhilesh Darjee <akhileshdarjee@gmail.com> Mon Jan 20 16:09:45 2014 +0530
committer Akhilesh Darjee <akhileshdarjee@gmail.com> Mon Jan 20 16:09:45 2014 +0530
tree 3b9477d9b46f776caf2714f6ea0ab475f13a4a18
parent 8a4111fe0eca17c786c4eb6ea5ad6cd03ea2fa6c
parent dbb495548352d46b30bf84fb4b29ef4a247cb21c

Enabled feature in Price List

selling/utils/product.py

diff --git a/selling/utils/product.py b/selling/utils/product.py
index 32ff85a..22bb880 100644
--- a/selling/utils/product.py
+++ b/selling/utils/product.py
@@ -27,8 +27,9 @@
 	else:
 		in_stock = -1
 		
-	price = price_list and webnotes.conn.sql("""select ref_rate, currency from
-		`tabItem Price` where item_code=%s and price_list=%s""", 
+	price = price_list and webnotes.conn.sql("""select ip.ref_rate, ip.currency from
+		`tabItem Price` ip, `tabPrice List` pl where ip.price_list=pl.name and 
+		ip.item_code=%s and ip.price_list=%s and pl.enabled=1""", 
 		(item_code, price_list), as_dict=1) or []
 	
 	price = price and price[0] or None