patch to update cancelled BOMs
diff --git a/patches/november_2012/cancelled_bom_patch.py b/patches/november_2012/cancelled_bom_patch.py
new file mode 100644
index 0000000..3420a08
--- /dev/null
+++ b/patches/november_2012/cancelled_bom_patch.py
@@ -0,0 +1,14 @@
+import webnotes
+
+def execute():
+ cancelled_boms = webnotes.conn.sql("""select name from `tabBOM`
+ where docstatus = 2""")
+
+ for bom in cancelled_boms:
+ webnotes.conn.sql("""update `tabBOM` set is_default=0, is_active='No'
+ where name=%s""", (bom[0],))
+
+ webnotes.conn.sql("""update `tabItem` set default_bom=null
+ where default_bom=%s""", (bom[0],))
+
+
\ No newline at end of file
diff --git a/patches/patch_list.py b/patches/patch_list.py
index f54de50..d2e2a47 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -683,4 +683,8 @@
'patch_module': 'patches.november_2012',
'patch_file': 'support_ticket_response_to_communication',
},
+ {
+ 'patch_module': 'patches.november_2012',
+ 'patch_file': 'cancelled_bom_patch',
+ },
]
\ No newline at end of file