[Serial No] Major updates, code cleanup, "In Store" is now "Available". Serial No can only be created via Stock Entry / Purchase Receipt. Serial No can be auto created using Series if mentioned in Item master
diff --git a/patches/april_2012/serial_no_fixes.py b/patches/april_2012/serial_no_fixes.py
deleted file mode 100644
index 4fef016..0000000
--- a/patches/april_2012/serial_no_fixes.py
+++ /dev/null
@@ -1,10 +0,0 @@
-# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
-# License: GNU General Public License v3. See license.txt
-
-from __future__ import unicode_literals
-def execute():
- import webnotes
- from webnotes.modules import reload_doc
- reload_doc('stock', 'doctype', 'serial_no')
-
- webnotes.conn.sql("update `tabSerial No` set sle_exists = 1")
diff --git a/patches/august_2013/p05_update_serial_no_status.py b/patches/august_2013/p05_update_serial_no_status.py
new file mode 100644
index 0000000..49ab411
--- /dev/null
+++ b/patches/august_2013/p05_update_serial_no_status.py
@@ -0,0 +1,5 @@
+import webnotes
+
+def execute():
+ webnotes.conn.sql("""update `tabSerial No` set status = 'Not Available' where status='Not In Store'""")
+ webnotes.conn.sql("""update `tabSerial No` set status = 'Available' where status='In Store'""")
\ No newline at end of file
diff --git a/patches/july_2012/packing_list_cleanup_and_serial_no.py b/patches/july_2012/packing_list_cleanup_and_serial_no.py
index ad3863e..b91ef81 100644
--- a/patches/july_2012/packing_list_cleanup_and_serial_no.py
+++ b/patches/july_2012/packing_list_cleanup_and_serial_no.py
@@ -39,7 +39,7 @@
status = 'Not in Use'
if sle and flt(sle[0]['actual_qty']) > 0:
- status = 'In Store'
+ status = 'Available'
elif sle and flt(sle[0]['actual_qty']) < 0:
status = 'Delivered'
diff --git a/patches/patch_list.py b/patches/patch_list.py
index 9e6938b..99514d2 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -22,7 +22,6 @@
"patches.april_2012.update_role_in_address",
"patches.april_2012.update_permlevel_in_address",
"patches.april_2012.update_appraisal_permission",
- "patches.april_2012.serial_no_fixes",
"patches.april_2012.repost_stock_for_posting_time",
"patches.may_2012.cleanup_property_setter",
"patches.may_2012.rename_prev_doctype",
@@ -255,4 +254,5 @@
"patches.august_2013.p02_rename_price_list",
"patches.august_2013.p03_pos_setting_replace_customer_account",
"patches.august_2013.p04_employee_birthdays",
+ "patches.august_2013.p05_update_serial_no_status",
]
\ No newline at end of file