commit 346a6a5d841c9372156f815985b1d45913f81001
author Nabin Hait <nabinhait@gmail.com> Tue Dec 13 11:27:46 2016 +0530
committer GitHub <noreply@github.com> Tue Dec 13 11:27:46 2016 +0530
tree d8e67eab635883a443972f55484bb57dcfb01888
parent f0b0db444db6bf38c03d3504e85448b9d68415fa

Update set_sales_person_status.py

erpnext/patches/v7_1/set_sales_person_status.py

diff --git a/erpnext/patches/v7_1/set_sales_person_status.py b/erpnext/patches/v7_1/set_sales_person_status.py
index 4eb4b25..929beac 100644
--- a/erpnext/patches/v7_1/set_sales_person_status.py
+++ b/erpnext/patches/v7_1/set_sales_person_status.py
@@ -4,4 +4,5 @@
 def execute():
 	frappe.reload_doc('setup','doctype','sales_person')
 	frappe.db.sql("""update `tabSales Person` set enabled=1 
-		where employee IN (select employee from tabEmployee where status != "Left")""")
\ No newline at end of file
+		where (employee is null or employee = '' 
+			or employee IN (select employee from tabEmployee where status != "Left"))""")