commit 40557750d5e12161c288739d49b14fee906ac519
author Nabin Hait <nabinhait@gmail.com> Tue May 05 16:00:21 2015 +0530
committer Nabin Hait <nabinhait@gmail.com> Tue May 05 16:00:21 2015 +0530
tree 3d66ba25371e5096b5dc6819a434b7b176ff4111
parent cf22fdbc8529175d8a340a80f3d3150ad148474f

party model patch fix

erpnext/patches/v4_2/party_model.py

diff --git a/erpnext/patches/v4_2/party_model.py b/erpnext/patches/v4_2/party_model.py
index 4412ae4..e88bc9e 100644
--- a/erpnext/patches/v4_2/party_model.py
+++ b/erpnext/patches/v4_2/party_model.py
@@ -82,7 +82,7 @@
 
 	for dt in ["Journal Entry Account", "GL Entry"]:
 		records = frappe.db.sql("""select name, account from `tab%s` 
-			where account in (%s) and ifnull(party, '') = ''""" % 
+			where account in (%s) and ifnull(party, '') = '' and docstatus < 2""" % 
 			(dt, ", ".join(['%s']*len(account_map))), tuple(account_map.keys()), as_dict=1)
 		for i, d in enumerate(records):
 			account_details = account_map.get(d.account, {})