Update delivery and billing status in SO
diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index 53ab7b5..1c2112d 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -67,3 +67,4 @@
erpnext.patches.v4_1.set_outgoing_email_footer
erpnext.patches.v4_1.fix_jv_remarks
erpnext.patches.v4_1.fix_sales_order_delivered_status
+erpnext.patches.v4_1.fix_delivery_and_billing_status_for_draft_so
\ No newline at end of file
diff --git a/erpnext/patches/v4_1/fix_delivery_and_billing_status_for_draft_so.py b/erpnext/patches/v4_1/fix_delivery_and_billing_status_for_draft_so.py
new file mode 100644
index 0000000..85e2e4c
--- /dev/null
+++ b/erpnext/patches/v4_1/fix_delivery_and_billing_status_for_draft_so.py
@@ -0,0 +1,12 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
+# License: GNU General Public License v3. See license.txt
+
+from __future__ import unicode_literals
+import frappe
+
+def execute():
+ frappe.db.sql("""update `tabSales Order` set delivery_status = 'Not Delivered'
+ where delivery_status = 'Delivered' and ifnull(per_delivered, 0) = 0""")
+
+ frappe.db.sql("""update `tabSales Order` set billing_status = 'Not Billed'
+ where billing_status = 'Billed' and ifnull(per_billed, 0) = 0""")
\ No newline at end of file
diff --git a/erpnext/selling/doctype/sales_order/sales_order.json b/erpnext/selling/doctype/sales_order/sales_order.json
index 77e7887..ebe1d84 100644
--- a/erpnext/selling/doctype/sales_order/sales_order.json
+++ b/erpnext/selling/doctype/sales_order/sales_order.json
@@ -762,7 +762,7 @@
"hidden": 1,
"label": "Delivery Status",
"no_copy": 1,
- "options": "Fully Delivered\nNot Delivered\nPartly Delivered\nClosed\nNot Applicable",
+ "options": "Not Delivered\nFully Delivered\nPartly Delivered\nClosed\nNot Applicable",
"permlevel": 0,
"print_hide": 1
},
@@ -809,7 +809,7 @@
"hidden": 1,
"label": "Billing Status",
"no_copy": 1,
- "options": "Fully Billed\nNot Billed\nPartly Billed\nClosed",
+ "options": "Not Billed\nFully Billed\nPartly Billed\nClosed",
"permlevel": 0,
"print_hide": 1
},
@@ -883,7 +883,7 @@
"idx": 1,
"is_submittable": 1,
"issingle": 0,
- "modified": "2014-07-04 17:16:36.889948",
+ "modified": "2014-07-07 17:47:40.089520",
"modified_by": "Administrator",
"module": "Selling",
"name": "Sales Order",