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

buying/utils.py

diff --git a/buying/utils.py b/buying/utils.py
index 35d89c5..ec13454 100644
--- a/buying/utils.py
+++ b/buying/utils.py
@@ -89,8 +89,10 @@
 	
 	# try fetching from price list
 	if args.buying_price_list and args.price_list_currency:
-		price_list_rate = webnotes.conn.sql("""select ref_rate from `tabItem Price` 
-			where price_list=%s and item_code=%s and buying=1""", 
+		price_list_rate = webnotes.conn.sql("""select ip.ref_rate from 
+			`tabItem Price` ip, `tabPrice List` pl 
+			where ip.price_list=pl.name and ip.price_list=%s and 
+			ip.item_code=%s and ip.buying=1 and pl.enabled=1""", 
 			(args.buying_price_list, args.item_code), as_dict=1)
 		
 		if price_list_rate: