commit 2b9186da5a5107dbf2066da04bc3c1dbf1f68ee2
author Nabin Hait <nabinhait@gmail.com> Tue Aug 28 15:02:59 2018 +0530
committer Nabin Hait <nabinhait@gmail.com> Tue Aug 28 15:02:59 2018 +0530
tree ba64b6f61c1b777433174d43ce587889f4a3f364
parent b2c94c0307385c3100ed066db40047504b4b0197

[fix] naming series patch

erpnext/patches/v11_0/refactor_naming_series.py

diff --git a/erpnext/patches/v11_0/refactor_naming_series.py b/erpnext/patches/v11_0/refactor_naming_series.py
index 3a2cdbd..d5af939 100644
--- a/erpnext/patches/v11_0/refactor_naming_series.py
+++ b/erpnext/patches/v11_0/refactor_naming_series.py
@@ -110,7 +110,7 @@
 	return series_to_set
 
 def get_series_to_preserve(doctype):
-	series_to_preserve = frappe.db.sql_list("""select distinct naming_series from `tab{doctype}`""".format(doctype=doctype))
+	series_to_preserve = frappe.db.sql_list("""select distinct naming_series from `tab{doctype}` where ifnull(naming_series, '') != ''""".format(doctype=doctype))
 	series_to_preserve.sort()
 	return series_to_preserve