Merge pull request #3298 from nabinhait/develop
party model patch fix
diff --git a/erpnext/patches/v4_2/party_model.py b/erpnext/patches/v4_2/party_model.py
index ad56109..27df2be 100644
--- a/erpnext/patches/v4_2/party_model.py
+++ b/erpnext/patches/v4_2/party_model.py
@@ -96,15 +96,16 @@
frappe.db.commit()
def delete_individual_party_account():
- frappe.db.sql("""delete from `tabAccount` acc
- where ifnull(acc.master_type, '') in ('Customer', 'Supplier')
- and ifnull(acc.master_name, '') != ''
- and not exists(select gle.name from `tabGL Entry` gle where gle.account = acc.name)""")
+ frappe.db.sql("""delete from `tabAccount`
+ where ifnull(master_type, '') in ('Customer', 'Supplier')
+ and ifnull(master_name, '') != ''
+ and not exists(select gle.name from `tabGL Entry` gle
+ where gle.account = tabAccount.name);""")
- accounts_not_deleted = frappe.db.sql_list("""select name from `tabAccount` acc
- where ifnull(acc.master_type, '') in ('Customer', 'Supplier')
- and ifnull(acc.master_name, '') != ''
- and exists(select gle.name from `tabGL Entry` gle where gle.account = acc.name)""")
+ accounts_not_deleted = frappe.db.sql_list("""select tabAccount.name from `tabAccount`
+ where ifnull(master_type, '') in ('Customer', 'Supplier')
+ and ifnull(master_name, '') != ''
+ and exists(select gle.name from `tabGL Entry` gle where gle.account = tabAccount.name)""")
if accounts_not_deleted:
print "Accounts not deleted: " + "\n".join(accounts_not_deleted)