stock entry cleanup patch
diff --git a/patches/december_2012/stock_entry_cleanup.py b/patches/december_2012/stock_entry_cleanup.py
new file mode 100644
index 0000000..be93a9c
--- /dev/null
+++ b/patches/december_2012/stock_entry_cleanup.py
@@ -0,0 +1,70 @@
+import webnotes
+def execute():
+ # removed following fields
+ custom_fields()
+ deprecate_process()
+ webnotes.delete_doc("doctype", "sandbox")
+
+def custom_fields():
+ fields = [
+ {
+ "label": "Is Excisable Goods",
+ "fieldname": "is_excisable_goods",
+ "fieldtype": "Select",
+ "options": "\nYes\nNo",
+ "insert_after": "company"
+ },
+ {
+ "label": "Excisable Goods",
+ "fieldname": "excisable_goods",
+ "fieldtype": "Select",
+ "options": "\nReturnable\nNon-Returnable)",
+ "insert_after": "amended_from"
+ },
+ {
+ "label": "Under Rule",
+ "fieldname": "under_rule",
+ "fieldtype": "Select",
+ "options": "\nOrdinary\n57 AC (5) a\n57 F (2) Non-Exc.",
+ "insert_after": "remarks"
+ },
+ {
+ "label": "Transporter",
+ "fieldname": "transporter",
+ "fieldtype": "Data",
+ "options": "",
+ "insert_after": "project_name"
+ },
+ {
+ "label": "Transfer Date",
+ "fieldname": "transfer_date",
+ "fieldtype": "Date",
+ "options": "",
+ "insert_after": "select_print_heading"
+ },
+ ]
+
+ for fld in fields:
+ if webnotes.conn.sql("""select name from `tabStock Entry`
+ where ifnull(%s, '') != '' and docstatus<2""", (fld['fieldname'])):
+ create_custom_field(fld)
+
+def create_custom_field(fld):
+ fld.update({
+ "doctype": "Custom Field",
+ "dt": "Stock Entry",
+ "print_hide": 1,
+ "permlevel": 0
+ })
+
+ from webnotes.model.doclist import DocList
+ webnotes.insert(DocList([fld]))
+
+def deprecate_process():
+ webnotes.conn.sql("""update `tabStock Entry`
+ set `purpose`="Production Order - Material Transfer"
+ where process="Material Transfer" and purpose="Production Order" """)
+
+ webnotes.conn.sql("""update `tabStock Entry`
+ set `purpose`="Production Order - Update Finished Goods"
+ where process="Backflush" and purpose="Production Order" """)
\ No newline at end of file