blob: ca6e137c57a5f2740e45b702c39a240d5895c38e [file] [log] [blame]
Anand Doshi7fbdba02014-03-25 13:50:52 +05301execute:import unidecode # new requirement
2
Nabin Hait827480f2014-05-12 17:45:37 +05303erpnext.patches.v4_0.validate_v3_patch
Anand Doshifab09042014-05-27 08:39:35 +05304erpnext.patches.v4_0.fix_employee_user_id
Anand Doshi49856912014-05-28 18:49:13 +05305erpnext.patches.v4_0.remove_employee_role_if_no_employee
Nabin Hait827480f2014-05-12 17:45:37 +05306erpnext.patches.v4_0.update_user_properties
Anand Doshi49856912014-05-28 18:49:13 +05307erpnext.patches.v4_0.apply_user_permissions
Nabin Hait827480f2014-05-12 17:45:37 +05308erpnext.patches.v4_0.move_warehouse_user_to_restrictions
Nabin Hait94195752014-05-15 17:17:58 +05309erpnext.patches.v4_0.global_defaults_to_system_settings
Nabin Hait827480f2014-05-12 17:45:37 +053010erpnext.patches.v4_0.update_incharge_name_to_sales_person_in_maintenance_schedule
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053011execute:frappe.reload_doc('accounts', 'doctype', 'sales_invoice') # 2014-01-29
12execute:frappe.reload_doc('selling', 'doctype', 'sales_order') # 2014-01-29
13execute:frappe.reload_doc('selling', 'doctype', 'quotation') # 2014-01-29
14execute:frappe.reload_doc('stock', 'doctype', 'delivery_note') # 2014-01-29
Nabin Hait827480f2014-05-12 17:45:37 +053015erpnext.patches.v4_0.reload_sales_print_format
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053016execute:frappe.reload_doc('accounts', 'doctype', 'purchase_invoice') # 2014-01-29
17execute:frappe.reload_doc('buying', 'doctype', 'purchase_order') # 2014-01-29
18execute:frappe.reload_doc('buying', 'doctype', 'supplier_quotation') # 2014-01-29
19execute:frappe.reload_doc('stock', 'doctype', 'purchase_receipt') # 2014-01-29
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053020execute:frappe.reload_doc('accounts', 'doctype', 'pos_setting') # 2014-01-29
21execute:frappe.reload_doc('selling', 'doctype', 'customer') # 2014-01-29
22execute:frappe.reload_doc('buying', 'doctype', 'supplier') # 2014-01-29
Nabin Hait827480f2014-05-12 17:45:37 +053023erpnext.patches.v4_0.map_charge_to_taxes_and_charges
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053024execute:frappe.reload_doc('support', 'doctype', 'newsletter') # 2014-01-31
25execute:frappe.reload_doc('hr', 'doctype', 'employee') # 2014-02-03
Anand Doshie9baaa62014-02-26 12:35:33 +053026execute:frappe.db.sql("update tabPage set module='Core' where name='Setup'")
Rushabh Mehta1e8025b2015-07-24 15:16:25 +053027
28# inserted this patch here since Item types are being changed
29erpnext.patches.v5_2.change_item_selects_to_checks
Nabin Hait827480f2014-05-12 17:45:37 +053030erpnext.patches.v4_0.fields_to_be_renamed
31erpnext.patches.v4_0.rename_sitemap_to_route
32erpnext.patches.v4_0.fix_contact_address
33erpnext.patches.v4_0.customer_discount_to_pricing_rule
Anand Doshif5794f12014-03-03 15:05:28 +053034execute:frappe.db.sql("""delete from `tabWebsite Item Group` where ifnull(item_group, '')=''""")
Nabin Hait827480f2014-05-12 17:45:37 +053035erpnext.patches.v4_0.remove_module_home_pages
36erpnext.patches.v4_0.split_email_settings
Nabin Hait827480f2014-05-12 17:45:37 +053037erpnext.patches.v4_0.import_country_codes
38erpnext.patches.v4_0.countrywise_coa
Nabin Hait155c96b2014-03-21 12:15:13 +053039execute:frappe.delete_doc("DocType", "MIS Control")
40execute:frappe.delete_doc("Page", "Financial Statements")
Nabin Hait2594e412014-04-28 16:23:45 +053041execute:frappe.delete_doc("DocType", "Stock Ledger")
Nabin Hait02d37bb2014-05-06 12:18:50 +053042execute:frappe.delete_doc("DocType", "Grade")
Anand Doshi0c851692014-05-08 17:40:12 +053043execute:frappe.db.sql("delete from `tabWebsite Item Group` where ifnull(item_group, '')=''")
Anand Doshi4c83e402014-05-13 17:37:56 +053044execute:frappe.delete_doc("Print Format", "SalesInvoice")
Nabin Haitea7e3d62014-05-14 18:51:45 +053045execute:import frappe.defaults;frappe.defaults.clear_default("price_list_currency")
Nabin Hait0e6554e2014-05-20 15:27:02 +053046erpnext.patches.v4_0.update_account_root_type
Nabin Hait19d1e492014-06-04 15:18:24 +053047execute:frappe.delete_doc("Report", "Purchase In Transit")
Rushabh Mehtaeaa2e552014-06-05 14:44:16 +053048erpnext.patches.v4_0.new_address_template
Rushabh Mehtaba83e9c2014-06-05 17:56:12 +053049execute:frappe.delete_doc("DocType", "SMS Control")
Anand Doshi4a069a12014-06-06 16:28:03 +053050erpnext.patches.v4_0.fix_case_of_hr_module_def
Anand Doshifc601652014-06-06 17:07:50 +053051erpnext.patches.v4_0.fix_address_template
Anand Doshi171c00c2014-06-06 15:09:26 +053052
53# WATCHOUT: This patch reload's documents
54erpnext.patches.v4_0.reset_permissions_for_masters
Anand Doshicdfa9a32014-06-09 11:26:50 +053055
Nabin Haitb63e99e2014-06-09 12:49:09 +053056erpnext.patches.v4_0.update_tax_amount_after_discount
Rushabh Mehtabd9b62f2014-11-28 11:45:02 +053057execute:frappe.permissions.reset_perms("GL Entry") #2014-06-09
58execute:frappe.permissions.reset_perms("Stock Ledger Entry") #2014-06-09
Nabin Haitd532d2f2014-06-09 15:59:04 +053059erpnext.patches.v4_0.create_custom_fields_for_india_specific_fields
Anand Doshic01db5f2014-06-09 18:01:14 +053060erpnext.patches.v4_0.save_default_letterhead
Nabin Hait91016ba2014-06-09 18:41:25 +053061erpnext.patches.v4_0.update_custom_print_formats_for_renamed_fields
Nabin Haite7f2d312014-06-12 14:58:09 +053062erpnext.patches.v4_0.update_other_charges_in_custom_purchase_print_formats
Anand Doshic1bfb632014-06-13 12:41:08 +053063erpnext.patches.v4_0.create_price_list_if_missing
Anand Doshiccf370f2014-06-16 13:50:11 +053064execute:frappe.db.sql("update `tabItem` set end_of_life=null where end_of_life='0000-00-00'") #2014-06-16
Nabin Hait91090042014-06-18 10:29:53 +053065erpnext.patches.v4_0.update_users_report_view_settings
Nabin Hait444f9562014-06-20 15:59:49 +053066erpnext.patches.v4_0.set_pricing_rule_for_buying_or_selling
Anand Doshi83da92f2014-06-23 18:04:07 +053067erpnext.patches.v4_0.set_naming_series_property_setter
Anand Doshi5ba7ab02014-06-27 21:00:05 +053068erpnext.patches.v4_1.set_outgoing_email_footer
Rushabh Mehta5f422762014-07-01 18:08:37 +053069erpnext.patches.v4_1.fix_sales_order_delivered_status
Anand Doshi8adb2112014-07-09 11:09:33 +053070erpnext.patches.v4_1.fix_delivery_and_billing_status
ankitjavalkarwork87633d62014-07-22 18:14:30 +053071execute:frappe.db.sql("update `tabAccount` set root_type='Liability' where root_type='Income' and report_type='Balance Sheet'")
nabinhait07961192014-07-29 12:12:09 +053072execute:frappe.delete_doc("DocType", "Payment to Invoice Matching Tool") # 29-07-2014
73execute:frappe.delete_doc("DocType", "Payment to Invoice Matching Tool Detail") # 29-07-2014
Anand Doshicb86d592014-07-22 19:02:11 +053074execute:frappe.delete_doc("Page", "trial-balance") #2014-07-22
Anand Doshibd748bd2014-07-29 08:51:41 +053075erpnext.patches.v4_2.delete_old_print_formats #2014-07-29
Anand Doshi35cc3202014-07-30 17:00:05 +053076erpnext.patches.v4_2.toggle_rounded_total #2014-07-30
Nabin Hait05b56d02014-08-07 15:03:25 +053077erpnext.patches.v4_2.fix_account_master_type
Rushabh Mehtac9bd3f52014-08-04 16:37:23 +053078erpnext.patches.v4_2.update_project_milestones
Anand Doshi6b8145a2014-08-08 13:24:18 +053079erpnext.patches.v4_2.add_currency_turkish_lira #2014-08-08
nabinhaitfe394422014-07-22 18:04:13 +053080execute:frappe.delete_doc("DocType", "Landed Cost Wizard")
Rushabh Mehta52f04da2014-08-25 15:17:20 +053081erpnext.patches.v4_2.default_website_style
Anand Doshi98eacdb2014-09-01 10:23:47 +053082erpnext.patches.v4_2.set_company_country
ankitjavalkarwork28a975d2014-08-26 15:04:56 +053083erpnext.patches.v4_2.update_sales_order_invoice_field_name
Nabin Hait7820b172014-10-10 18:02:23 +053084erpnext.patches.v4_2.seprate_manufacture_and_repack
85execute:frappe.delete_doc("Report", "Warehouse-Wise Stock Balance")
Nabin Hait8a28ccf2014-10-14 11:41:44 +053086execute:frappe.delete_doc("DocType", "Purchase Request")
87execute:frappe.delete_doc("DocType", "Purchase Request Item")
Nabin Hait9bbfca92014-10-15 12:24:38 +053088erpnext.patches.v4_2.recalculate_bom_cost
89erpnext.patches.v4_2.fix_gl_entries_for_stock_transactions
Nabin Hait9114c262014-11-04 15:33:41 +053090erpnext.patches.v4_2.update_requested_and_ordered_qty
Anand Doshi5745cf72015-03-31 17:31:53 +053091execute:frappe.rename_doc("DocType", "Support Ticket", "Issue", force=True)
Nabin Haita6a70a52014-11-12 17:00:42 +053092erpnext.patches.v4_4.make_email_accounts
Rushabh Mehta7d368752014-11-24 14:16:47 +053093execute:frappe.delete_doc("DocType", "Contact Control")
Nabin Hait2244ac42015-01-12 17:35:14 +053094erpnext.patches.v4_2.discount_amount
Nabin Haitcbdfb762014-12-31 13:30:36 +053095erpnext.patches.v4_2.reset_bom_costs
Nabin Haitc68646c2014-10-06 12:56:51 +053096erpnext.patches.v5_0.update_frozen_accounts_permission_role
ankitjavalkarworke69a6112014-10-08 12:46:02 +053097erpnext.patches.v5_0.update_dn_against_doc_fields
Nabin Haita6a70a52014-11-12 17:00:42 +053098execute:frappe.db.sql("update `tabMaterial Request` set material_request_type = 'Material Transfer' where material_request_type = 'Transfer'")
Nabin Hait249bbbc2014-11-26 15:35:08 +053099execute:frappe.reload_doc('stock', 'doctype', 'item')
100execute:frappe.db.sql("update `tabItem` i set apply_warehouse_wise_reorder_level=1, re_order_level=0, re_order_qty=0 where exists(select name from `tabItem Reorder` where parent=i.name)")
Neil Trini Lasrado8d344172014-12-12 11:33:50 +0530101erpnext.patches.v5_0.set_default_company_in_bom
Nabin Hait0f4350d2014-12-19 10:57:46 +0530102erpnext.patches.v5_0.capacity_planning
Nabin Haitb1205202015-02-18 11:54:08 +0530103execute:frappe.reload_doc('crm', 'doctype', 'lead')
104execute:frappe.reload_doc('crm', 'doctype', 'opportunity')
Nabin Hait8f5b8c652015-05-11 11:15:14 +0530105erpnext.patches.v5_0.rename_taxes_and_charges_master
Nabin Hait5464ca82015-07-16 12:19:57 +0530106erpnext.patches.v5_1.sales_bom_rename
Nabin Hait56ac3fb2015-01-01 13:40:18 +0530107erpnext.patches.v5_0.rename_table_fieldnames
Nabin Hait56ac3fb2015-01-01 13:40:18 +0530108execute:frappe.db.sql("update `tabJournal Entry` set voucher_type='Journal Entry' where ifnull(voucher_type, '')=''")
Rushabh Mehta38c6b522015-04-23 13:14:17 +0530109erpnext.patches.v5_0.is_group
Nabin Haitebc4ae72015-01-02 12:46:49 +0530110erpnext.patches.v4_2.party_model
Anand Doshi5445c462015-04-02 17:42:02 +0530111erpnext.patches.v5_0.party_model_patch_fix
Nabin Hait56ac3fb2015-01-01 13:40:18 +0530112erpnext.patches.v4_1.fix_jv_remarks
Nabin Hait3f671ea2015-01-21 14:07:15 +0530113erpnext.patches.v4_2.update_landed_cost_voucher
Neil Trini Lasradodc65dc32015-01-27 12:27:10 +0530114erpnext.patches.v4_2.set_item_has_batch
Nabin Haitad3fd512015-02-20 14:23:42 +0530115erpnext.patches.v4_2.update_stock_uom_for_dn_in_sle
Nabin Haitebc4ae72015-01-02 12:46:49 +0530116erpnext.patches.v5_0.recalculate_total_amount_in_jv
Neil Trini Lasradobd2ac2f2015-01-05 16:01:57 +0530117erpnext.patches.v5_0.update_companywise_payment_account
Rushabh Mehta5bceebc2015-01-23 15:22:13 +0530118erpnext.patches.v5_0.remove_birthday_events
Neil Trini Lasrado41acbff2015-01-20 17:39:46 +0530119erpnext.patches.v5_0.update_item_name_in_bom
Rushabh Mehta46e03ea2015-02-17 10:45:50 +0530120erpnext.patches.v5_0.rename_customer_issue
Nabin Haitb1205202015-02-18 11:54:08 +0530121erpnext.patches.v5_0.rename_total_fields
Anand Doshi0fe85462015-02-17 14:37:45 +0530122erpnext.patches.v5_0.new_crm_module
Rushabh Mehta6de403f2013-12-13 14:10:14 +0530123erpnext.patches.v5_0.rename_customer_issue
Rushabh Mehta06072c12015-02-17 11:50:45 +0530124erpnext.patches.v5_0.update_material_transfer_for_manufacture
Pratik Vyasd102cba2015-04-07 15:32:15 +0530125execute:frappe.reload_doc('crm', 'doctype', 'opportunity_item')
Neil Trini Lasradoe9d45bc2015-02-18 20:01:27 +0530126erpnext.patches.v5_0.update_item_description_and_image
Anand Doshi5b73da92015-03-16 17:10:28 +0530127erpnext.patches.v5_0.update_material_transferred_for_manufacturing
Rushabh Mehtac7a11cc2015-02-19 16:28:35 +0530128erpnext.patches.v5_0.stock_entry_update_value
Rushabh Mehtadc93e0a2015-02-20 15:11:56 +0530129erpnext.patches.v5_0.convert_stock_reconciliation
Rushabh Mehtad54031f2015-02-22 22:32:39 +0530130erpnext.patches.v5_0.update_projects
Rushabh Mehtad06c1182015-02-23 11:31:35 +0530131erpnext.patches.v5_0.item_patches
Rushabh Mehtaa1da88a2015-02-23 20:18:38 +0530132erpnext.patches.v5_0.update_journal_entry_title
Nabin Hait6dfbc242015-02-23 20:00:17 +0530133erpnext.patches.v5_0.taxes_and_totals_in_party_currency
134erpnext.patches.v5_0.replace_renamed_fields_in_custom_scripts_and_print_formats
Rushabh Mehta6cdfd1e2015-02-25 15:55:57 +0530135erpnext.patches.v5_0.update_from_bom
Rushabh Mehta66a92792015-02-25 17:15:45 +0530136erpnext.patches.v5_0.update_account_types
Rushabh Mehta905f8322015-03-02 13:01:39 +0530137erpnext.patches.v5_0.update_sms_sender
Neil Trini Lasradofd0920f2015-03-02 17:33:48 +0530138erpnext.patches.v5_0.set_appraisal_remarks
Rushabh Mehta2cc585f2015-02-26 15:01:23 +0530139erpnext.patches.v5_0.update_time_log_title
Nabin Hait11498ca2015-03-09 18:28:35 +0530140erpnext.patches.v4_2.repost_reserved_qty
Nabin Haitc3daa912015-04-16 13:13:18 +0530141erpnext.patches.v4_2.repost_sle_for_si_with_no_warehouse
Rushabh Mehta14ae4c32015-03-18 20:02:44 +0530142erpnext.patches.v5_0.newsletter
Nabin Haitb6061e52015-03-24 17:11:58 +0530143execute:frappe.delete_doc("DocType", "Chart of Accounts")
144execute:frappe.delete_doc("DocType", "Style Settings")
Rushabh Mehtabb2041d2015-04-02 22:11:16 +0530145erpnext.patches.v5_0.update_opportunity
Rushabh Mehtafd0f1cb2015-04-13 16:21:58 +0530146erpnext.patches.v5_0.opportunity_not_submittable
Nabin Haitfbdc0dc2015-05-08 01:24:28 +0530147execute:frappe.permissions.reset_perms("Purchase Taxes and Charges Template") #2014-06-09
Rushabh Mehta80f8b7b2015-04-19 16:18:15 +0530148execute:frappe.permissions.reset_perms("Expense Claim Type") #2014-06-19
Nabin Haitb650d692015-04-21 17:16:28 +0530149erpnext.patches.v5_0.execute_on_doctype_update
Nabin Hait2ba88c42015-04-17 12:05:00 +0530150erpnext.patches.v4_2.fix_recurring_orders
151erpnext.patches.v4_2.delete_gl_entries_for_cancelled_invoices
Neil Trini Lasradoe7ddb722015-04-15 18:21:53 +0530152erpnext.patches.v5_0.project_costing
Nabin Hait042f86e2015-04-28 13:00:23 +0530153erpnext.patches.v5_0.update_temporary_account
Nabin Haitd51b0922015-05-01 20:31:11 +0530154erpnext.patches.v5_0.update_advance_paid
Rushabh Mehtabcdea3e2015-05-06 18:45:47 +0530155erpnext.patches.v5_0.link_warehouse_with_account
Nabin Hait08c0c042015-05-07 16:59:51 +0530156execute:frappe.delete_doc("Page", "stock-ledger")
Nabin Hait15c28442015-05-08 01:28:01 +0530157execute:frappe.delete_doc("Page","stock-level")
158erpnext.patches.v5_0.reclculate_planned_operating_cost_in_production_order
Nabin Hait6752b312015-05-08 12:49:35 +0530159erpnext.patches.v5_0.repost_requested_qty
Nabin Haitb8939722015-05-15 15:15:25 +0530160erpnext.patches.v5_0.fix_taxes_and_totals_in_party_currency
Pratik Vyas1a84d8e2015-05-19 12:23:52 +0530161erpnext.patches.v5_0.update_tax_amount_after_discount_in_purchase_cycle
Rushabh Mehtaa27cca92015-05-20 15:43:17 +0530162erpnext.patches.v5_0.rename_pos_setting
Rushabh Mehtaf29a6182015-05-25 10:50:48 +0530163erpnext.patches.v5_0.update_operation_description
164erpnext.patches.v5_0.set_footer_address
Rushabh Mehta306c49f2015-05-26 15:14:58 +0530165execute:frappe.db.set_value("Backup Manager", None, "send_backups_to_dropbox", 1 if frappe.db.get_value("Backup Manager", None, "upload_backups_to_dropbox") in ("Daily", "Weekly") else 0)
Pratik Vyas37ee57c2015-05-28 12:51:37 +0530166execute:frappe.db.sql_list("delete from `tabDocPerm` where parent='Issue' and modified_by='Administrator' and role='Guest'")
Rushabh Mehtab0b446e2015-05-29 12:43:39 +0530167erpnext.patches.v5_0.update_item_and_description_again
Rushabh Mehtaa33d4682015-06-01 17:15:42 +0530168erpnext.patches.v5_0.repost_gle_for_jv_with_multiple_party
169erpnext.patches.v5_0.portal_fixes
Nabin Hait3c1017c2015-06-05 12:15:01 +0530170erpnext.patches.v5_0.reset_values_in_tools
Nabin Hait56fcf302015-06-05 18:21:25 +0530171execute:frappe.delete_doc("Page", "users")
Nabin Hait39046d62015-06-14 20:59:13 +0530172erpnext.patches.v5_0.update_material_transferred_for_manufacturing_again
Neil Trini Lasradoa25e8ea2015-06-30 17:15:13 +0530173erpnext.patches.v5_0.index_on_account_and_gl_entry
174execute:frappe.db.sql("""delete from `tabProject Task`""")
Neil Trini Lasrado3f2604e2015-06-29 15:06:46 +0530175erpnext.patches.v5_0.item_variants
Rushabh Mehta6b35ea82015-07-01 12:25:18 +0530176erpnext.patches.v5_0.update_item_desc_in_invoice
177erpnext.patches.v5_1.fix_against_account
Neil Trini Lasradocc08c682015-07-13 12:35:20 +0530178erpnext.patches.v5_1.fix_credit_days_based_on
Neil Trini Lasrado4089b3d2015-07-07 16:58:14 +0530179execute:frappe.rename_doc("DocType", "Salary Manager", "Process Payroll", force=True)
Rushabh Mehta51e70862015-07-15 16:30:22 +0530180erpnext.patches.v5_1.rename_roles
Neil Trini Lasrado20523c42015-07-15 16:39:05 +0530181erpnext.patches.v5_1.default_bom
Rushabh Mehta1e8025b2015-07-24 15:16:25 +0530182execute:frappe.delete_doc("DocType", "Party Type")
Anand Doshi2f443a52015-07-30 14:44:43 +0530183execute:frappe.delete_doc("Module Def", "Contacts")
Nabin Hait453cc372015-07-29 12:21:03 +0530184erpnext.patches.v5_4.fix_reserved_qty_and_sle_for_packed_items
Nabin Haitd1dc6222015-07-29 16:37:02 +0530185execute:frappe.reload_doctype("Leave Type")
Anand Doshi2f443a52015-07-30 14:44:43 +0530186execute:frappe.db.sql("update `tabLeave Type` set include_holiday=1")