blob: c5d8e0f9f6b7d291b4abcbdcc75815df806d494e [file] [log] [blame]
Anand Doshi7fbdba02014-03-25 13:50:52 +05301execute:import unidecode # new requirement
Rohit Waghchaurea5f40942017-06-16 15:21:36 +05302erpnext.patches.v8_0.move_perpetual_inventory_setting
Zarrar17fd6612017-12-08 14:57:38 +05303erpnext.patches.v10_0.rename_schools_to_education
Zarrar13ddc7e2018-03-20 12:38:43 +05304erpnext.patches.v11_0.rename_production_order_to_work_order
Nabin Hait827480f2014-05-12 17:45:37 +05305erpnext.patches.v4_0.validate_v3_patch
Anand Doshifab09042014-05-27 08:39:35 +05306erpnext.patches.v4_0.fix_employee_user_id
Anand Doshi49856912014-05-28 18:49:13 +05307erpnext.patches.v4_0.remove_employee_role_if_no_employee
Nabin Hait827480f2014-05-12 17:45:37 +05308erpnext.patches.v4_0.update_user_properties
Anand Doshi49856912014-05-28 18:49:13 +05309erpnext.patches.v4_0.apply_user_permissions
Nabin Hait827480f2014-05-12 17:45:37 +053010erpnext.patches.v4_0.move_warehouse_user_to_restrictions
Nabin Hait94195752014-05-15 17:17:58 +053011erpnext.patches.v4_0.global_defaults_to_system_settings
Nabin Hait827480f2014-05-12 17:45:37 +053012erpnext.patches.v4_0.update_incharge_name_to_sales_person_in_maintenance_schedule
Nabin Hait6d7b0ce2017-06-15 11:09:27 +053013execute:frappe.reload_doc('stock', 'doctype', 'warehouse') # 2017-04-24
Rohit Waghchaure774ce632016-08-31 15:45:05 +053014execute:frappe.reload_doc('accounts', 'doctype', 'sales_invoice') # 2016-08-31
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053015execute:frappe.reload_doc('selling', 'doctype', 'sales_order') # 2014-01-29
16execute:frappe.reload_doc('selling', 'doctype', 'quotation') # 2014-01-29
17execute:frappe.reload_doc('stock', 'doctype', 'delivery_note') # 2014-01-29
Nabin Hait827480f2014-05-12 17:45:37 +053018erpnext.patches.v4_0.reload_sales_print_format
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053019execute:frappe.reload_doc('accounts', 'doctype', 'purchase_invoice') # 2014-01-29
20execute:frappe.reload_doc('buying', 'doctype', 'purchase_order') # 2014-01-29
21execute:frappe.reload_doc('buying', 'doctype', 'supplier_quotation') # 2014-01-29
22execute:frappe.reload_doc('stock', 'doctype', 'purchase_receipt') # 2014-01-29
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053023execute:frappe.reload_doc('accounts', 'doctype', 'pos_setting') # 2014-01-29
24execute:frappe.reload_doc('selling', 'doctype', 'customer') # 2014-01-29
25execute:frappe.reload_doc('buying', 'doctype', 'supplier') # 2014-01-29
Nabin Haitbbc394f2016-07-11 12:40:18 +053026execute:frappe.reload_doc('accounts', 'doctype', 'asset_category')
Rushabh Mehtade086392016-08-16 10:01:38 +053027execute:frappe.reload_doc('accounts', 'doctype', 'pricing_rule')
Nabin Hait827480f2014-05-12 17:45:37 +053028erpnext.patches.v4_0.map_charge_to_taxes_and_charges
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053029execute:frappe.reload_doc('support', 'doctype', 'newsletter') # 2014-01-31
30execute:frappe.reload_doc('hr', 'doctype', 'employee') # 2014-02-03
Anand Doshie9baaa62014-02-26 12:35:33 +053031execute:frappe.db.sql("update tabPage set module='Core' where name='Setup'")
Rushabh Mehta1e8025b2015-07-24 15:16:25 +053032erpnext.patches.v5_2.change_item_selects_to_checks
Nabin Hait37200452016-09-23 16:31:43 +053033execute:frappe.reload_doctype('Item')
Nabin Hait827480f2014-05-12 17:45:37 +053034erpnext.patches.v4_0.fields_to_be_renamed
35erpnext.patches.v4_0.rename_sitemap_to_route
Rushabh Mehtaead3ccf2016-07-24 22:28:34 +053036erpnext.patches.v7_0.re_route #2016-06-27
Nabin Hait827480f2014-05-12 17:45:37 +053037erpnext.patches.v4_0.fix_contact_address
38erpnext.patches.v4_0.customer_discount_to_pricing_rule
Anand Doshif5794f12014-03-03 15:05:28 +053039execute:frappe.db.sql("""delete from `tabWebsite Item Group` where ifnull(item_group, '')=''""")
Nabin Hait827480f2014-05-12 17:45:37 +053040erpnext.patches.v4_0.remove_module_home_pages
41erpnext.patches.v4_0.split_email_settings
Nabin Hait827480f2014-05-12 17:45:37 +053042erpnext.patches.v4_0.import_country_codes
43erpnext.patches.v4_0.countrywise_coa
Nabin Hait155c96b2014-03-21 12:15:13 +053044execute:frappe.delete_doc("DocType", "MIS Control")
45execute:frappe.delete_doc("Page", "Financial Statements")
Nabin Hait2594e412014-04-28 16:23:45 +053046execute:frappe.delete_doc("DocType", "Stock Ledger")
Nabin Hait02d37bb2014-05-06 12:18:50 +053047execute:frappe.delete_doc("DocType", "Grade")
Anand Doshi0c851692014-05-08 17:40:12 +053048execute:frappe.db.sql("delete from `tabWebsite Item Group` where ifnull(item_group, '')=''")
Anand Doshi4c83e402014-05-13 17:37:56 +053049execute:frappe.delete_doc("Print Format", "SalesInvoice")
Nabin Haitea7e3d62014-05-14 18:51:45 +053050execute:import frappe.defaults;frappe.defaults.clear_default("price_list_currency")
Nabin Hait0e6554e2014-05-20 15:27:02 +053051erpnext.patches.v4_0.update_account_root_type
Nabin Hait19d1e492014-06-04 15:18:24 +053052execute:frappe.delete_doc("Report", "Purchase In Transit")
Rushabh Mehtaeaa2e552014-06-05 14:44:16 +053053erpnext.patches.v4_0.new_address_template
Rushabh Mehtaba83e9c2014-06-05 17:56:12 +053054execute:frappe.delete_doc("DocType", "SMS Control")
Anand Doshib6c5b212015-08-18 16:27:20 +053055execute:frappe.delete_doc_if_exists("DocType", "Bulk SMS") #2015-08-18
Anand Doshi4a069a12014-06-06 16:28:03 +053056erpnext.patches.v4_0.fix_case_of_hr_module_def
Anand Doshifc601652014-06-06 17:07:50 +053057erpnext.patches.v4_0.fix_address_template
Anand Doshi171c00c2014-06-06 15:09:26 +053058
59# WATCHOUT: This patch reload's documents
60erpnext.patches.v4_0.reset_permissions_for_masters
Neil Trini Lasrado6e343e22016-03-09 17:02:59 +053061erpnext.patches.v6_20x.rename_project_name_to_project #2016-03-14
Anand Doshicdfa9a32014-06-09 11:26:50 +053062
Nabin Haitb63e99e2014-06-09 12:49:09 +053063erpnext.patches.v4_0.update_tax_amount_after_discount
Rushabh Mehtabd9b62f2014-11-28 11:45:02 +053064execute:frappe.permissions.reset_perms("GL Entry") #2014-06-09
65execute:frappe.permissions.reset_perms("Stock Ledger Entry") #2014-06-09
Nabin Haitd532d2f2014-06-09 15:59:04 +053066erpnext.patches.v4_0.create_custom_fields_for_india_specific_fields
Anand Doshic01db5f2014-06-09 18:01:14 +053067erpnext.patches.v4_0.save_default_letterhead
Nabin Hait91016ba2014-06-09 18:41:25 +053068erpnext.patches.v4_0.update_custom_print_formats_for_renamed_fields
Nabin Haite7f2d312014-06-12 14:58:09 +053069erpnext.patches.v4_0.update_other_charges_in_custom_purchase_print_formats
Anand Doshic1bfb632014-06-13 12:41:08 +053070erpnext.patches.v4_0.create_price_list_if_missing
Anand Doshiccf370f2014-06-16 13:50:11 +053071execute: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 +053072erpnext.patches.v4_0.update_users_report_view_settings
Nabin Hait444f9562014-06-20 15:59:49 +053073erpnext.patches.v4_0.set_pricing_rule_for_buying_or_selling
Anand Doshi83da92f2014-06-23 18:04:07 +053074erpnext.patches.v4_0.set_naming_series_property_setter
Anand Doshi5ba7ab02014-06-27 21:00:05 +053075erpnext.patches.v4_1.set_outgoing_email_footer
Rushabh Mehta5f422762014-07-01 18:08:37 +053076erpnext.patches.v4_1.fix_sales_order_delivered_status
Anand Doshi8adb2112014-07-09 11:09:33 +053077erpnext.patches.v4_1.fix_delivery_and_billing_status
ankitjavalkarwork87633d62014-07-22 18:14:30 +053078execute:frappe.db.sql("update `tabAccount` set root_type='Liability' where root_type='Income' and report_type='Balance Sheet'")
nabinhait07961192014-07-29 12:12:09 +053079execute:frappe.delete_doc("DocType", "Payment to Invoice Matching Tool") # 29-07-2014
80execute:frappe.delete_doc("DocType", "Payment to Invoice Matching Tool Detail") # 29-07-2014
Anand Doshicb86d592014-07-22 19:02:11 +053081execute:frappe.delete_doc("Page", "trial-balance") #2014-07-22
Anand Doshibd748bd2014-07-29 08:51:41 +053082erpnext.patches.v4_2.delete_old_print_formats #2014-07-29
Anand Doshi35cc3202014-07-30 17:00:05 +053083erpnext.patches.v4_2.toggle_rounded_total #2014-07-30
Nabin Hait05b56d02014-08-07 15:03:25 +053084erpnext.patches.v4_2.fix_account_master_type
Rushabh Mehtac9bd3f52014-08-04 16:37:23 +053085erpnext.patches.v4_2.update_project_milestones
Anand Doshi6b8145a2014-08-08 13:24:18 +053086erpnext.patches.v4_2.add_currency_turkish_lira #2014-08-08
nabinhaitfe394422014-07-22 18:04:13 +053087execute:frappe.delete_doc("DocType", "Landed Cost Wizard")
Rushabh Mehta52f04da2014-08-25 15:17:20 +053088erpnext.patches.v4_2.default_website_style
Anand Doshi98eacdb2014-09-01 10:23:47 +053089erpnext.patches.v4_2.set_company_country
ankitjavalkarwork28a975d2014-08-26 15:04:56 +053090erpnext.patches.v4_2.update_sales_order_invoice_field_name
Nabin Hait7820b172014-10-10 18:02:23 +053091erpnext.patches.v4_2.seprate_manufacture_and_repack
92execute:frappe.delete_doc("Report", "Warehouse-Wise Stock Balance")
Nabin Hait8a28ccf2014-10-14 11:41:44 +053093execute:frappe.delete_doc("DocType", "Purchase Request")
94execute:frappe.delete_doc("DocType", "Purchase Request Item")
Nabin Hait9bbfca92014-10-15 12:24:38 +053095erpnext.patches.v4_2.recalculate_bom_cost
96erpnext.patches.v4_2.fix_gl_entries_for_stock_transactions
Nabin Hait9114c262014-11-04 15:33:41 +053097erpnext.patches.v4_2.update_requested_and_ordered_qty
Anand Doshi5745cf72015-03-31 17:31:53 +053098execute:frappe.rename_doc("DocType", "Support Ticket", "Issue", force=True)
Nabin Haita6a70a52014-11-12 17:00:42 +053099erpnext.patches.v4_4.make_email_accounts
Rushabh Mehta7d368752014-11-24 14:16:47 +0530100execute:frappe.delete_doc("DocType", "Contact Control")
Nabin Hait2244ac42015-01-12 17:35:14 +0530101erpnext.patches.v4_2.discount_amount
Nabin Haitcbdfb762014-12-31 13:30:36 +0530102erpnext.patches.v4_2.reset_bom_costs
Nabin Haitc68646c2014-10-06 12:56:51 +0530103erpnext.patches.v5_0.update_frozen_accounts_permission_role
ankitjavalkarworke69a6112014-10-08 12:46:02 +0530104erpnext.patches.v5_0.update_dn_against_doc_fields
Nabin Haita6a70a52014-11-12 17:00:42 +0530105execute:frappe.db.sql("update `tabMaterial Request` set material_request_type = 'Material Transfer' where material_request_type = 'Transfer'")
Nabin Hait249bbbc2014-11-26 15:35:08 +0530106execute:frappe.reload_doc('stock', 'doctype', 'item')
Neil Trini Lasrado8d344172014-12-12 11:33:50 +0530107erpnext.patches.v5_0.set_default_company_in_bom
Nabin Haitb1205202015-02-18 11:54:08 +0530108execute:frappe.reload_doc('crm', 'doctype', 'lead')
109execute:frappe.reload_doc('crm', 'doctype', 'opportunity')
Nabin Hait8f5b8c652015-05-11 11:15:14 +0530110erpnext.patches.v5_0.rename_taxes_and_charges_master
Nabin Hait5464ca82015-07-16 12:19:57 +0530111erpnext.patches.v5_1.sales_bom_rename
Nabin Hait56ac3fb2015-01-01 13:40:18 +0530112erpnext.patches.v5_0.rename_table_fieldnames
Nabin Hait56ac3fb2015-01-01 13:40:18 +0530113execute:frappe.db.sql("update `tabJournal Entry` set voucher_type='Journal Entry' where ifnull(voucher_type, '')=''")
Rushabh Mehta38c6b522015-04-23 13:14:17 +0530114erpnext.patches.v5_0.is_group
Nabin Haitebc4ae72015-01-02 12:46:49 +0530115erpnext.patches.v4_2.party_model
Anand Doshi5445c462015-04-02 17:42:02 +0530116erpnext.patches.v5_0.party_model_patch_fix
Nabin Hait56ac3fb2015-01-01 13:40:18 +0530117erpnext.patches.v4_1.fix_jv_remarks
Nabin Hait3f671ea2015-01-21 14:07:15 +0530118erpnext.patches.v4_2.update_landed_cost_voucher
Neil Trini Lasradodc65dc32015-01-27 12:27:10 +0530119erpnext.patches.v4_2.set_item_has_batch
Nabin Haitad3fd512015-02-20 14:23:42 +0530120erpnext.patches.v4_2.update_stock_uom_for_dn_in_sle
Nabin Haitebc4ae72015-01-02 12:46:49 +0530121erpnext.patches.v5_0.recalculate_total_amount_in_jv
Neil Trini Lasradobd2ac2f2015-01-05 16:01:57 +0530122erpnext.patches.v5_0.update_companywise_payment_account
Rushabh Mehta5bceebc2015-01-23 15:22:13 +0530123erpnext.patches.v5_0.remove_birthday_events
Neil Trini Lasrado41acbff2015-01-20 17:39:46 +0530124erpnext.patches.v5_0.update_item_name_in_bom
Rushabh Mehta46e03ea2015-02-17 10:45:50 +0530125erpnext.patches.v5_0.rename_customer_issue
Nabin Haitb1205202015-02-18 11:54:08 +0530126erpnext.patches.v5_0.rename_total_fields
Anand Doshi0fe85462015-02-17 14:37:45 +0530127erpnext.patches.v5_0.new_crm_module
Rushabh Mehta6de403f2013-12-13 14:10:14 +0530128erpnext.patches.v5_0.rename_customer_issue
Rushabh Mehta06072c12015-02-17 11:50:45 +0530129erpnext.patches.v5_0.update_material_transfer_for_manufacture
Pratik Vyasd102cba2015-04-07 15:32:15 +0530130execute:frappe.reload_doc('crm', 'doctype', 'opportunity_item')
Neil Trini Lasradoe9d45bc2015-02-18 20:01:27 +0530131erpnext.patches.v5_0.update_item_description_and_image
Anand Doshi5b73da92015-03-16 17:10:28 +0530132erpnext.patches.v5_0.update_material_transferred_for_manufacturing
Rushabh Mehtac7a11cc2015-02-19 16:28:35 +0530133erpnext.patches.v5_0.stock_entry_update_value
Rushabh Mehtadc93e0a2015-02-20 15:11:56 +0530134erpnext.patches.v5_0.convert_stock_reconciliation
Rushabh Mehtad54031f2015-02-22 22:32:39 +0530135erpnext.patches.v5_0.update_projects
Rushabh Mehtad06c1182015-02-23 11:31:35 +0530136erpnext.patches.v5_0.item_patches
Rushabh Mehtaa1da88a2015-02-23 20:18:38 +0530137erpnext.patches.v5_0.update_journal_entry_title
Nabin Hait6dfbc242015-02-23 20:00:17 +0530138erpnext.patches.v5_0.taxes_and_totals_in_party_currency
139erpnext.patches.v5_0.replace_renamed_fields_in_custom_scripts_and_print_formats
Rushabh Mehta6cdfd1e2015-02-25 15:55:57 +0530140erpnext.patches.v5_0.update_from_bom
Rushabh Mehta66a92792015-02-25 17:15:45 +0530141erpnext.patches.v5_0.update_account_types
Rushabh Mehta905f8322015-03-02 13:01:39 +0530142erpnext.patches.v5_0.update_sms_sender
Neil Trini Lasradofd0920f2015-03-02 17:33:48 +0530143erpnext.patches.v5_0.set_appraisal_remarks
Rushabh Mehta2cc585f2015-02-26 15:01:23 +0530144erpnext.patches.v5_0.update_time_log_title
Nabin Haitbbc394f2016-07-11 12:40:18 +0530145erpnext.patches.v7_0.create_warehouse_nestedset
146erpnext.patches.v7_0.merge_account_type_stock_and_warehouse_to_stock
147erpnext.patches.v7_0.set_is_group_for_warehouse
Nabin Hait621dcc32017-03-28 13:45:56 +0530148erpnext.patches.v7_2.stock_uom_in_selling
Nabin Haitc3daa912015-04-16 13:13:18 +0530149erpnext.patches.v4_2.repost_sle_for_si_with_no_warehouse
Rushabh Mehta14ae4c32015-03-18 20:02:44 +0530150erpnext.patches.v5_0.newsletter
Nabin Haitb6061e52015-03-24 17:11:58 +0530151execute:frappe.delete_doc("DocType", "Chart of Accounts")
152execute:frappe.delete_doc("DocType", "Style Settings")
Rushabh Mehtabb2041d2015-04-02 22:11:16 +0530153erpnext.patches.v5_0.update_opportunity
Rushabh Mehtafd0f1cb2015-04-13 16:21:58 +0530154erpnext.patches.v5_0.opportunity_not_submittable
Nabin Haitfbdc0dc2015-05-08 01:24:28 +0530155execute:frappe.permissions.reset_perms("Purchase Taxes and Charges Template") #2014-06-09
Rushabh Mehta80f8b7b2015-04-19 16:18:15 +0530156execute:frappe.permissions.reset_perms("Expense Claim Type") #2014-06-19
Nabin Haitb650d692015-04-21 17:16:28 +0530157erpnext.patches.v5_0.execute_on_doctype_update
Nabin Hait2ba88c42015-04-17 12:05:00 +0530158erpnext.patches.v4_2.fix_recurring_orders
159erpnext.patches.v4_2.delete_gl_entries_for_cancelled_invoices
Neil Trini Lasradoe7ddb722015-04-15 18:21:53 +0530160erpnext.patches.v5_0.project_costing
Nabin Hait042f86e2015-04-28 13:00:23 +0530161erpnext.patches.v5_0.update_temporary_account
Nabin Haitd51b0922015-05-01 20:31:11 +0530162erpnext.patches.v5_0.update_advance_paid
Rushabh Mehtabcdea3e2015-05-06 18:45:47 +0530163erpnext.patches.v5_0.link_warehouse_with_account
Nabin Hait08c0c042015-05-07 16:59:51 +0530164execute:frappe.delete_doc("Page", "stock-ledger")
Nabin Hait15c28442015-05-08 01:28:01 +0530165execute:frappe.delete_doc("Page","stock-level")
166erpnext.patches.v5_0.reclculate_planned_operating_cost_in_production_order
Nabin Hait6752b312015-05-08 12:49:35 +0530167erpnext.patches.v5_0.repost_requested_qty
Nabin Haitb8939722015-05-15 15:15:25 +0530168erpnext.patches.v5_0.fix_taxes_and_totals_in_party_currency
Pratik Vyas1a84d8e2015-05-19 12:23:52 +0530169erpnext.patches.v5_0.update_tax_amount_after_discount_in_purchase_cycle
Rushabh Mehtaa27cca92015-05-20 15:43:17 +0530170erpnext.patches.v5_0.rename_pos_setting
Rushabh Mehtaf29a6182015-05-25 10:50:48 +0530171erpnext.patches.v5_0.update_operation_description
172erpnext.patches.v5_0.set_footer_address
Rushabh Mehta306c49f2015-05-26 15:14:58 +0530173execute: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 +0530174execute:frappe.db.sql_list("delete from `tabDocPerm` where parent='Issue' and modified_by='Administrator' and role='Guest'")
Rushabh Mehtab0b446e2015-05-29 12:43:39 +0530175erpnext.patches.v5_0.update_item_and_description_again
Rushabh Mehta5a700822016-03-03 16:47:36 +0530176erpnext.patches.v6_0.multi_currency
Nabin Hait71089912016-09-21 16:34:33 +0530177erpnext.patches.v7_0.create_budget_record
Rushabh Mehtaa33d4682015-06-01 17:15:42 +0530178erpnext.patches.v5_0.repost_gle_for_jv_with_multiple_party
179erpnext.patches.v5_0.portal_fixes
Valmik Jangla651dc5b2016-05-02 12:00:06 +0530180erpnext.patches.v5_0.reset_values_in_tools # 02-05-2016
Nabin Hait56fcf302015-06-05 18:21:25 +0530181execute:frappe.delete_doc("Page", "users")
Nabin Hait39046d62015-06-14 20:59:13 +0530182erpnext.patches.v5_0.update_material_transferred_for_manufacturing_again
Neil Trini Lasradoa25e8ea2015-06-30 17:15:13 +0530183erpnext.patches.v5_0.index_on_account_and_gl_entry
184execute:frappe.db.sql("""delete from `tabProject Task`""")
Rushabh Mehta6b35ea82015-07-01 12:25:18 +0530185erpnext.patches.v5_0.update_item_desc_in_invoice
186erpnext.patches.v5_1.fix_against_account
Neil Trini Lasrado4089b3d2015-07-07 16:58:14 +0530187execute:frappe.rename_doc("DocType", "Salary Manager", "Process Payroll", force=True)
Rushabh Mehta51e70862015-07-15 16:30:22 +0530188erpnext.patches.v5_1.rename_roles
Neil Trini Lasrado20523c42015-07-15 16:39:05 +0530189erpnext.patches.v5_1.default_bom
Rushabh Mehta1e8025b2015-07-24 15:16:25 +0530190execute:frappe.delete_doc("DocType", "Party Type")
Anand Doshi2f443a52015-07-30 14:44:43 +0530191execute:frappe.delete_doc("Module Def", "Contacts")
Nabin Hait17405d42015-07-30 13:47:02 +0530192erpnext.patches.v5_4.fix_reserved_qty_and_sle_for_packed_items # 30-07-2015
Nabin Haitd1dc6222015-07-29 16:37:02 +0530193execute:frappe.reload_doctype("Leave Type")
Nabin Hait94f15fc2015-08-03 11:16:55 +0530194execute:frappe.db.sql("update `tabLeave Type` set include_holiday=0")
Nabin Hait1db0b6d2015-08-03 15:37:41 +0530195erpnext.patches.v5_4.set_root_and_report_type
196erpnext.patches.v5_4.notify_system_managers_regarding_wrong_tax_calculation
Nabin Haitad44b002015-08-03 17:43:58 +0530197erpnext.patches.v5_4.fix_invoice_outstanding
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530198execute:frappe.db.sql("update `tabStock Ledger Entry` set stock_queue = '[]' where voucher_type = 'Stock Reconciliation' and ifnull(qty_after_transaction, 0) = 0")
Anand Doshiaa5182b2015-08-04 23:06:01 +0530199erpnext.patches.v5_4.fix_missing_item_images
Nabin Hait3c3a3ec2015-08-07 17:17:03 +0530200erpnext.patches.v5_4.stock_entry_additional_costs
Anand Doshibfbf7682015-08-14 12:05:50 +0530201erpnext.patches.v5_4.cleanup_journal_entry #2015-08-14
Zarrar13ddc7e2018-03-20 12:38:43 +0530202erpnext.patches.v5_7.update_item_description_based_on_item_master
Anand Doshib6c5b212015-08-18 16:27:20 +0530203erpnext.patches.v5_7.item_template_attributes
Anand Doshife13bfe2015-08-25 12:49:40 +0530204execute:frappe.delete_doc_if_exists("DocType", "Manage Variants")
205execute:frappe.delete_doc_if_exists("DocType", "Manage Variants Item")
Nabin Hait14aa9c52016-04-18 15:54:01 +0530206erpnext.patches.v4_2.repost_reserved_qty #2016-04-15
Nabin Haitfa5fcf52015-08-18 12:39:50 +0530207erpnext.patches.v5_4.update_purchase_cost_against_project
Anand Doshife13bfe2015-08-25 12:49:40 +0530208erpnext.patches.v5_8.update_order_reference_in_return_entries
209erpnext.patches.v5_8.add_credit_note_print_heading
210execute:frappe.delete_doc_if_exists("Print Format", "Credit Note - Negative Invoice")
Rushabh Mehta17679c62015-08-26 22:19:41 +0530211
212# V6.0
Nabin Hait59c4ae52015-09-03 10:46:48 +0530213erpnext.patches.v6_0.set_default_title # 2015-09-03
Rushabh Mehta91b0e232015-08-31 15:04:48 +0530214erpnext.patches.v6_0.default_activity_rate
Rushabh Mehta85abdc42015-09-03 10:29:38 +0530215execute:frappe.db.set_value("Stock Settings", None, "automatically_set_serial_nos_based_on_fifo", 1)
Nabin Haitd387dd32015-09-08 16:14:36 +0530216execute:frappe.db.sql("""update `tabProject` set percent_complete=round(percent_complete, 2) where percent_complete is not null""")
Nabin Hait83a358a2015-09-07 15:22:24 +0530217erpnext.patches.v6_0.fix_outstanding_amount
Nabin Hait2377cdf2015-09-09 18:45:41 +0530218erpnext.patches.v6_0.fix_planned_qty
Anand Doshie9b14e42015-09-17 17:46:37 +0530219erpnext.patches.v6_2.remove_newsletter_duplicates
Anand Doshi0332f832015-09-17 19:01:27 +0530220erpnext.patches.v6_2.fix_missing_default_taxes_and_lead
Rushabh Mehta72fbf902015-09-17 18:29:44 +0530221erpnext.patches.v6_3.convert_applicable_territory
Anand Doshid970b002015-09-25 17:57:20 +0530222erpnext.patches.v6_4.round_status_updater_percentages
Nabin Hait7a287a92015-10-02 15:32:00 +0530223erpnext.patches.v6_4.repost_gle_for_journal_entries_where_reference_name_missing
Rushabh Mehtad10ba852015-10-02 12:42:48 +0530224erpnext.patches.v6_4.fix_journal_entries_due_to_reconciliation
225erpnext.patches.v6_4.fix_status_in_sales_and_purchase_order
Nabin Haitb7e46c42015-10-12 16:46:29 +0530226erpnext.patches.v6_4.fix_modified_in_sales_order_and_purchase_order
Rushabh Mehta86125b22015-10-13 11:48:08 +0530227erpnext.patches.v6_4.fix_duplicate_bins
228erpnext.patches.v6_4.fix_sales_order_maintenance_status
Rushabh Mehta17429912015-09-29 16:36:57 +0530229erpnext.patches.v6_4.email_digest_update
Anand Doshi71ebad52015-10-02 17:14:40 +0530230
231# delete shopping cart doctypes
232execute:frappe.delete_doc_if_exists("DocType", "Applicable Territory")
233execute:frappe.delete_doc_if_exists("DocType", "Shopping Cart Price List")
234execute:frappe.delete_doc_if_exists("DocType", "Shopping Cart Taxes and Charges Master")
Anand Doshieca2e422016-01-27 12:36:21 +0530235
Rushabh Mehta73e73792015-10-07 11:07:43 +0530236erpnext.patches.v6_4.set_user_in_contact
Anand Doshi95dfc272015-10-20 19:03:30 +0530237erpnext.patches.v6_4.make_image_thumbnail #2015-10-20
Anand Doshi7c0eadb2015-10-20 17:30:02 +0530238erpnext.patches.v6_5.show_in_website_for_template_item
Nabin Haitbe464692015-10-21 12:06:51 +0530239erpnext.patches.v6_4.fix_expense_included_in_valuation
Nabin Haita90a0522015-10-28 15:50:26 +0530240execute:frappe.delete_doc_if_exists("Report", "Item-wise Last Purchase Rate")
Anand Doshic794ca52015-10-27 16:56:22 +0530241erpnext.patches.v6_6.fix_website_image
Nabin Hait7c654cd2015-11-06 10:37:26 +0530242erpnext.patches.v6_6.remove_fiscal_year_from_leave_allocation
Rushabh Mehta511421b2015-11-13 11:04:50 +0530243execute:frappe.delete_doc_if_exists("DocType", "Stock UOM Replace Utility")
Anand Doshi72218052015-11-23 19:00:11 +0530244erpnext.patches.v6_8.make_webform_standard #2015-11-23
Saurabh20628f52015-11-18 12:18:59 +0530245erpnext.patches.v6_8.move_drop_ship_to_po_items
Anand Doshiebae7262015-11-25 15:51:01 +0530246erpnext.patches.v6_10.fix_ordered_received_billed
Nabin Hait6c173e92015-11-30 16:07:43 +0530247erpnext.patches.v6_10.fix_jv_total_amount #2015-11-30
Rushabh Mehta9785cd32015-11-27 12:23:31 +0530248erpnext.patches.v6_10.email_digest_default_quote
Saurabh70ed6ed2015-12-08 14:02:53 +0530249erpnext.patches.v6_10.fix_billed_amount_in_drop_ship_po
Nabin Hait4ad09632015-12-08 16:50:20 +0530250erpnext.patches.v6_10.fix_delivery_status_of_drop_ship_item #2015-12-08
Nabin Haita974ab32015-12-08 12:56:14 +0530251erpnext.patches.v5_8.tax_rule #2015-12-08
Rushabh Mehta13ec41a2015-12-10 12:31:36 +0530252erpnext.patches.v6_12.set_overdue_tasks
Nabin Haita613ea82016-01-20 18:31:20 +0530253erpnext.patches.v6_16.update_billing_status_in_dn_and_pr
Anand Doshieca2e422016-01-27 12:36:21 +0530254erpnext.patches.v6_16.create_manufacturer_records
255execute:frappe.db.sql("update `tabPricing Rule` set title=name where title='' or title is null") #2016-01-27
Anand Doshi17d4fc42016-01-19 18:38:08 +0530256erpnext.patches.v6_20.set_party_account_currency_in_orders
Anand Doshi7b52dc92016-02-26 20:49:33 +0530257erpnext.patches.v6_19.comment_feed_communication
Rushabh Mehta3cdf3542016-02-08 11:52:22 +0530258erpnext.patches.v6_21.fix_reorder_level
Neil Trini Lasradoabd92482016-02-03 18:33:43 +0530259erpnext.patches.v6_21.rename_material_request_fields
Nabin Hait5a4c7d32016-02-29 12:01:44 +0530260erpnext.patches.v6_23.update_stopped_status_to_closed
Rushabh Mehta5839a8d2016-03-02 17:51:24 +0530261erpnext.patches.v6_24.repost_valuation_rate_for_serialized_items
262erpnext.patches.v6_24.set_recurring_id
shreyas6f8dfa42016-03-07 18:22:40 +0530263erpnext.patches.v6_20x.set_compact_print
Anand Doshi6d59a412016-03-10 14:20:49 +0530264execute:frappe.delete_doc_if_exists("Web Form", "contact") #2016-03-10
Anand Doshi4284fcf2016-03-11 17:16:30 +0530265erpnext.patches.v6_20x.remove_fiscal_year_from_holiday_list
Nabin Hait2646f842016-03-21 15:19:51 +0530266erpnext.patches.v6_24.map_customer_address_to_shipping_address_on_po
Rushabh Mehtac20c5362016-03-25 17:19:28 +0530267erpnext.patches.v6_27.fix_recurring_order_status
Rushabh Mehtad42167e2016-05-11 16:47:14 +0530268erpnext.patches.v6_20x.update_product_bundle_description
Rohit Waghchaureb2382c02016-09-22 18:45:06 +0530269erpnext.patches.v7_0.update_party_status #2016-09-22
Rushabh Mehtad42167e2016-05-11 16:47:14 +0530270erpnext.patches.v7_0.remove_features_setup
Nabin Haitca909632016-05-18 12:22:42 +0530271erpnext.patches.v7_0.update_home_page
Nabin Hait591a5ab2016-05-26 17:41:39 +0530272execute:frappe.delete_doc_if_exists("Page", "financial-analytics")
273erpnext.patches.v7_0.update_project_in_gl_entry
Rushabh Mehtad56306a2016-06-09 15:56:48 +0530274execute:frappe.db.sql('update tabQuotation set status="Cancelled" where docstatus=2')
Rushabh Mehtaa55fb642016-06-14 15:54:17 +0530275execute:frappe.rename_doc("DocType", "Payments", "Sales Invoice Payment", force=True)
276erpnext.patches.v7_0.update_mins_to_first_response
Nabin Hait2effad32016-06-24 12:48:24 +0530277erpnext.patches.v6_20x.repost_valuation_rate_for_negative_inventory
Rohit Waghchaure774ce632016-08-31 15:45:05 +0530278erpnext.patches.v7_0.migrate_mode_of_payments_v6_to_v7
Anand Doshif576f3b2016-06-25 19:51:48 +0530279erpnext.patches.v7_0.system_settings_setup_complete
Rohit Waghchaurec4afd632016-07-26 20:47:42 +0530280erpnext.patches.v7_0.set_naming_series_for_timesheet #2016-07-27
Revant Nandgaonkar88e16a72016-07-16 11:00:37 +0530281execute:frappe.reload_doc('projects', 'doctype', 'project')
282execute:frappe.reload_doc('projects', 'doctype', 'project_user')
Rohit Waghchaured6c986d2016-06-03 14:44:35 +0530283erpnext.patches.v7_0.convert_timelogbatch_to_timesheet
284erpnext.patches.v7_0.convert_timelog_to_timesheet
285erpnext.patches.v7_0.move_timelogbatch_from_salesinvoiceitem_to_salesinvoicetimesheet
Rohit Waghchaure0a6529a2016-09-28 12:55:02 +0530286erpnext.patches.v7_0.remove_doctypes_and_reports #2016-10-29
Kanchan Chauhanfb3eb132016-06-29 15:04:08 +0530287erpnext.patches.v7_0.update_maintenance_module_in_doctype
Rohit Waghchaure4d8f4d72016-06-30 18:07:39 +0530288erpnext.patches.v7_0.update_prevdoc_values_for_supplier_quotation_item
Kanchan Chauhand963b762016-07-02 12:23:59 +0530289erpnext.patches.v7_0.rename_advance_table_fields
Rohit Waghchaurea71d9d32016-07-05 00:34:00 +0530290erpnext.patches.v7_0.rename_salary_components
291erpnext.patches.v7_0.rename_prevdoc_fields
Rohit Waghchauree94d18b2016-07-06 20:12:58 +0530292erpnext.patches.v7_0.rename_time_sheet_doctype
Kanchan Chauhan7ff0c4e2016-07-14 12:12:26 +0530293execute:frappe.delete_doc_if_exists("Report", "Customers Not Buying Since Long Time")
294erpnext.patches.v7_0.make_is_group_fieldtype_as_check
Rohit Waghchaure7b6fdb72016-09-12 19:06:41 +0530295execute:frappe.reload_doc('projects', 'doctype', 'timesheet') #2016-09-12
296erpnext.patches.v7_1.rename_field_timesheet
Kanchan Chauhan9846b942016-07-15 14:06:20 +0530297execute:frappe.delete_doc_if_exists("Report", "Employee Holiday Attendance")
Nabin Hait6831b942016-07-14 14:39:16 +0530298execute:frappe.delete_doc_if_exists("DocType", "Payment Tool")
299execute:frappe.delete_doc_if_exists("DocType", "Payment Tool Detail")
Saurabh718d8352016-07-18 15:20:47 +0530300erpnext.patches.v7_0.setup_account_table_for_expense_claim_type_if_exists
Rushabh Mehta20038ad2016-07-21 16:01:59 +0530301erpnext.patches.v7_0.migrate_schools_to_erpnext
Nabin Haite593f172016-11-04 11:43:58 +0530302erpnext.patches.v7_1.update_lead_source
Nabin Haitbc691dc2016-08-01 12:36:28 +0530303erpnext.patches.v6_20x.remove_customer_supplier_roles
Neil Trini Lasradod69d9612016-07-25 11:39:23 +0530304erpnext.patches.v7_0.remove_administrator_role_in_doctypes
Neil Trini Lasradoce1c63f2016-07-25 18:24:37 +0530305erpnext.patches.v7_0.rename_fee_amount_to_fee_component
Rohit Waghchaure26cf01a2016-07-22 13:24:33 +0530306erpnext.patches.v7_0.calculate_total_costing_amount
Nabin Haitfeed3132016-07-30 15:58:06 +0530307erpnext.patches.v7_0.fix_nonwarehouse_ledger_gl_entries_for_transactions
Neil Trini Lasrado74dbd162016-07-22 01:17:39 +0530308erpnext.patches.v7_0.remove_old_earning_deduction_doctypes
309erpnext.patches.v7_0.make_guardian
Rohit Waghchaure08aadb82016-07-29 13:23:30 +0530310erpnext.patches.v7_0.update_refdoc_in_landed_cost_voucher
Neil Trini Lasrado50b22782016-08-01 23:45:33 +0530311erpnext.patches.v7_0.set_material_request_type_in_item
Nabin Hait99d4ff42016-08-08 14:12:16 +0530312erpnext.patches.v7_0.rename_examination_to_assessment
Nabin Haitf44b5152016-08-09 17:07:59 +0530313erpnext.patches.v7_0.set_portal_settings
Rohit Waghchaure4b246832016-09-29 12:54:24 +0530314erpnext.patches.v7_0.update_change_amount_account
Nabin Hait99d4ff42016-08-08 14:12:16 +0530315erpnext.patches.v7_0.repost_future_gle_for_purchase_invoice
Kanchan Chauhanbccf0fa2016-07-29 12:56:30 +0530316erpnext.patches.v7_0.fix_duplicate_icons
Nabin Hait0da75ae2016-08-26 12:40:02 +0530317erpnext.patches.v7_0.move_employee_parent_to_child_in_salary_structure
318erpnext.patches.v7_0.repost_gle_for_pos_sales_return
Rohit Waghchaure69aebf42016-08-23 10:41:15 +0530319erpnext.patches.v7_1.update_total_billing_hours
Kanchan Chauhan145f87c2016-08-29 15:26:57 +0530320erpnext.patches.v7_1.update_component_type
Nabin Hait2490ea02016-09-01 12:29:31 +0530321erpnext.patches.v7_0.repost_gle_for_pos_sales_return
322erpnext.patches.v7_0.update_missing_employee_in_timesheet
Nabin Hait5a4ca642016-09-02 12:15:41 +0530323erpnext.patches.v7_0.update_status_for_timesheet
324erpnext.patches.v7_0.set_party_name_in_payment_entry
Neil Trini Lasrado49da25d2016-09-06 15:28:13 +0530325erpnext.patches.v7_1.set_student_guardian
Rohit Waghchaurec9404402016-09-09 13:08:23 +0530326erpnext.patches.v7_0.update_conversion_factor_in_supplier_quotation_item
Nabin Haitd5ebd792016-09-14 15:50:22 +0530327erpnext.patches.v7_1.move_sales_invoice_from_parent_to_child_timesheet
Rohit Waghchaure03e5e682016-09-12 16:14:06 +0530328execute:frappe.db.sql("update `tabTimesheet` ts, `tabEmployee` emp set ts.employee_name = emp.employee_name where emp.name = ts.employee and ts.employee_name is null and ts.employee is not null")
Nabin Haitb015f1b2016-09-20 16:53:02 +0530329erpnext.patches.v7_1.fix_link_for_customer_from_lead
Rohit Waghchaure17adb972016-09-29 01:07:28 +0530330execute:frappe.db.sql("delete from `tabTimesheet Detail` where NOT EXISTS (select name from `tabTimesheet` where name = `tabTimesheet Detail`.parent)")
Rohit Waghchaure414199a2016-09-19 13:59:18 +0530331erpnext.patches.v7_0.update_mode_of_payment_type
robert schoutend7721a62016-09-21 11:16:53 +0800332
Kanchan Chauhandc869642016-10-18 11:29:41 +0530333execute:frappe.reload_doctype('Employee') #2016-10-18
robert schoutend7721a62016-09-21 11:16:53 +0800334execute:frappe.db.sql("update `tabEmployee` set prefered_contact_email = IFNULL(prefered_contact_email,'') ")
Nabin Hait9f4ca1f2016-09-20 16:59:15 +0530335execute:frappe.reload_doctype("Salary Slip")
336execute:frappe.db.sql("update `tabSalary Slip` set posting_date=creation")
Saurabh00e82cd2017-11-17 19:06:08 +0530337execute:frappe.reload_doc("stock", "doctype", "stock_settings")
Nabin Hait738d8c22017-08-08 11:15:13 +0530338erpnext.patches.v8_0.create_domain_docs #16-05-2017
Rushabh Mehtafc800b32016-09-23 21:51:51 +0530339erpnext.patches.v7_1.update_portal_roles
Saurabhf24d5232016-10-03 17:14:31 +0530340erpnext.patches.v7_1.set_total_amount_currency_in_je
Nabin Hait16f3f372016-10-07 12:54:27 +0530341finally:erpnext.patches.v7_0.update_timesheet_communications
Rohit Waghchaure770d04e2016-10-05 23:02:15 +0530342erpnext.patches.v7_0.update_status_of_zero_amount_sales_order
Faris Ansaria0608d42016-10-10 14:32:35 +0530343erpnext.patches.v7_1.add_field_for_task_dependent
Rohit Waghchaureac9172f2016-10-18 17:22:56 +0530344erpnext.patches.v7_0.repost_bin_qty_and_item_projected_qty
Rohit Waghchaure18fa0d82016-10-20 16:16:28 +0530345erpnext.patches.v7_1.set_prefered_contact_email
Rohit Waghchaure0ecad332016-11-04 12:26:55 +0530346execute:frappe.reload_doc('accounts', 'doctype', 'accounts_settings')
347execute:frappe.db.set_value("Accounts Settings", "Accounts Settings", "unlink_payment_on_cancellation_of_invoice", 0)
Nabin Hait0f75a022018-01-30 15:32:17 +0530348execute:frappe.db.sql("update `tabStock Entry` set total_amount = 0 where purpose in('Repack', 'Manufacture')")
Nabin Hait551360a2016-10-31 16:38:09 +0530349erpnext.patches.v7_1.save_stock_settings
Rohit Waghchaure0ecad332016-11-04 12:26:55 +0530350erpnext.patches.v7_0.repost_gle_for_pi_with_update_stock #2016-11-01
Nabin Haita469e652016-11-08 15:26:27 +0530351erpnext.patches.v7_1.add_account_user_role_for_timesheet
Nabin Hait31f64362016-11-08 17:25:14 +0530352erpnext.patches.v7_0.set_base_amount_in_invoice_payment_table
Nabin Haitceca1b92016-11-09 14:58:36 +0530353erpnext.patches.v7_1.update_invoice_status
Rushabh Mehta8dfbe7c2016-11-16 11:18:20 +0530354erpnext.patches.v7_0.po_status_issue_for_pr_return
Nabin Hait8af429d2016-11-16 17:21:59 +0530355erpnext.patches.v7_1.update_missing_salary_component_type
Nabin Haitd8551672016-11-21 19:13:22 +0530356erpnext.patches.v7_1.rename_quality_inspection_field
357erpnext.patches.v7_0.update_autoname_field
Nabin Hait672ffc02016-11-25 11:15:20 +0530358erpnext.patches.v7_1.update_bom_base_currency
Nabin Hait5c18bd92016-12-06 16:16:58 +0530359erpnext.patches.v7_0.update_status_of_po_so
Nabin Hait288a18e2016-12-08 15:36:23 +0530360erpnext.patches.v7_1.set_budget_against_as_cost_center
Kanchan Chauhanf0b0db42016-12-12 11:12:07 +0530361erpnext.patches.v7_1.set_currency_exchange_date
Nabin Hait201af802016-12-13 14:30:32 +0530362erpnext.patches.v7_1.set_sales_person_status
363erpnext.patches.v7_1.repost_stock_for_deleted_bins_for_merging_items
Rushabh Mehta2a86c322016-12-20 12:20:39 +0530364execute:frappe.delete_doc('Desktop Icon', {'module_name': 'Profit and Loss Statment'})
Rushabh Mehta174c3472016-12-27 12:29:11 +0530365erpnext.patches.v7_2.update_website_for_variant
Neil Trini Lasrado5c874552016-12-29 17:05:29 +0530366erpnext.patches.v7_2.update_assessment_modules
Nabin Haite43a94d2017-01-13 13:14:32 +0530367erpnext.patches.v7_2.update_doctype_status
368erpnext.patches.v7_2.update_salary_slips
Rushabh Mehta818af752017-01-19 13:08:46 +0530369erpnext.patches.v7_2.delete_fleet_management_module_def
Neil Trini Lasrado16d40cf2017-01-20 19:16:39 +0530370erpnext.patches.v7_2.contact_address_links
Nabin Hait1f9d1bb2017-01-20 20:09:44 +0530371erpnext.patches.v7_2.mark_students_active
Nabin Hait349d5202017-01-20 15:44:35 +0530372erpnext.patches.v7_2.set_null_value_to_fields
Neil Trini Lasradof36ff482017-01-27 13:37:12 +0530373erpnext.patches.v7_2.update_guardian_name_in_student_master
Rushabh Mehta710dc532017-01-27 15:48:31 +0530374erpnext.patches.v7_2.update_abbr_in_salary_slips
Neil Trini Lasrado4aabe612017-02-01 19:32:28 +0530375erpnext.patches.v7_2.rename_evaluation_criteria
mbauskare1e25a02017-02-16 19:36:59 +0530376erpnext.patches.v7_2.update_party_type
Nabin Hait0d665792017-02-20 19:22:03 +0530377erpnext.patches.v7_2.setup_auto_close_settings
Nabin Hait9f4cb0c2017-02-20 15:00:04 +0530378erpnext.patches.v7_2.empty_supplied_items_for_non_subcontracted
Nabin Hait8bb69ff2017-02-20 19:01:04 +0530379erpnext.patches.v7_2.arrear_leave_encashment_as_salary_component
Kanchan Chauhan42f55cf2017-02-21 13:44:01 +0530380erpnext.patches.v7_2.rename_att_date_attendance
Nabin Hait5079c9e2017-02-22 15:31:31 +0530381erpnext.patches.v7_2.update_attendance_docstatus
382erpnext.patches.v7_2.move_dates_from_salary_structure_to_employee
Manas Solankid77fac12017-02-24 14:44:59 +0530383erpnext.patches.v7_2.make_all_assessment_group
Revant Nandgaonkard07c0412017-03-30 21:41:07 +0530384erpnext.patches.v8_0.repost_reserved_qty_for_multiple_sales_uom
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +0530385erpnext.patches.v8_0.addresses_linked_to_lead
Javier Wong9b11d9b2017-04-14 18:24:04 +0800386execute:frappe.delete_doc('DocType', 'Purchase Common')
mbauskar3ddfce42017-04-13 16:16:15 +0530387erpnext.patches.v8_0.update_stock_qty_value_in_purchase_invoice
Javier Wong54d9c9e2017-04-14 18:33:44 +0800388erpnext.patches.v8_0.update_supplier_address_in_stock_entry
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530389erpnext.patches.v8_0.rename_is_sample_item_to_allow_zero_valuation_rate
Nabin Hait117be7d2017-04-18 14:02:07 +0530390erpnext.patches.v8_0.set_null_to_serial_nos_for_disabled_sales_invoices
Nabin Haitf3823732017-04-19 21:01:19 +0530391erpnext.patches.v8_0.enable_booking_asset_depreciation_automatically
392erpnext.patches.v8_0.set_project_copied_from
mbauskar9cf6d632017-04-25 12:55:21 +0530393erpnext.patches.v8_0.update_status_as_paid_for_completed_expense_claim
Nabin Haitb6a89202017-04-25 17:27:53 +0530394erpnext.patches.v7_2.stock_uom_in_selling
mbauskare94c6e72017-04-29 15:41:34 +0530395erpnext.patches.v8_0.revert_manufacturers_table_from_item
Manas Solanki426b8a12017-05-09 15:32:52 +0530396erpnext.patches.v8_0.disable_instructor_role
397erpnext.patches.v8_0.merge_student_batch_and_student_group
rohitwaghchaure73456ac2017-05-16 11:29:57 +0530398erpnext.patches.v8_0.rename_total_margin_to_rate_with_margin # 11-05-2017
Nabin Hait8a27cf32017-05-16 12:43:00 +0530399erpnext.patches.v8_0.fix_status_for_invoices_with_negative_outstanding
400erpnext.patches.v8_0.make_payments_table_blank_for_non_pos_invoice
Nabin Haitc7953862017-05-24 18:39:16 +0530401erpnext.patches.v8_0.set_sales_invoice_serial_number_from_delivery_note
mbauskarff70f382017-05-24 16:55:24 +0530402erpnext.patches.v8_0.delete_schools_depricated_doctypes
rohitwaghchaured2be55b2017-06-07 12:04:01 +0530403erpnext.patches.v8_0.update_customer_pos_id
tundebabzy99b734b2017-06-07 07:32:07 +0100404erpnext.patches.v8_0.rename_items_in_status_field_of_material_request
mbauskarf819c932017-06-08 23:39:58 +0530405erpnext.patches.v8_0.delete_bin_indexes
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530406erpnext.patches.v8_0.move_account_head_from_account_to_warehouse_for_inventory
Makarand Bauskardd986f62017-06-16 13:02:45 +0530407erpnext.patches.v8_0.change_in_words_varchar_length
bcornwellmottd53dd7f2017-06-13 08:40:24 -0700408erpnext.patches.v8_0.update_stock_qty_value_in_bom_item
mbauskar4b299ba2017-06-22 11:36:57 +0530409erpnext.patches.v8_0.update_sales_cost_in_project
mbauskar66e2a512017-06-22 16:18:12 +0530410erpnext.patches.v8_0.save_system_settings
Rushabh Mehta919a74a2017-06-22 16:37:04 +0530411erpnext.patches.v8_1.delete_deprecated_reports
rohitwaghchaureda8de2f2017-09-27 17:11:40 +0530412erpnext.patches.v9_0.remove_subscription_module
413erpnext.patches.v8_7.make_subscription_from_recurring_data
Rushabh Mehta00ae4242017-06-27 17:31:41 +0530414erpnext.patches.v8_1.setup_gst_india #2017-06-27
Sagar Vora067991e2017-06-30 16:42:26 +0530415execute:frappe.reload_doc('regional', 'doctype', 'gst_hsn_code')
Nabin Hait852cb642017-07-05 12:58:19 +0530416erpnext.patches.v8_1.removed_roles_from_gst_report_non_indian_account
Nabin Haitf3f0dfe2017-07-06 14:49:34 +0530417erpnext.patches.v8_1.gst_fixes #2017-07-06
Nabin Hait949a9202017-07-05 13:55:41 +0530418erpnext.patches.v8_0.update_production_orders
Nabin Hait8b486b02017-07-07 13:14:25 +0530419erpnext.patches.v8_1.remove_sales_invoice_from_returned_serial_no
Nabin Hait73121862017-07-12 16:01:24 +0530420erpnext.patches.v8_1.allow_invoice_copy_to_edit_after_submit
Saurabhe74e4b12017-07-13 14:17:07 +0530421erpnext.patches.v8_1.add_hsn_sac_codes
rohitwaghchaureea4497c2017-07-17 14:55:42 +0530422erpnext.patches.v8_1.update_gst_state #17-07-2017
423erpnext.patches.v8_1.removed_report_support_hours
Rohit Waghchaure8333b572017-07-17 15:56:36 +0530424erpnext.patches.v8_1.add_indexes_in_transaction_doctypes
Makarand Bauskar6e30f042017-07-18 12:30:57 +0530425erpnext.patches.v8_3.set_restrict_to_domain_for_module_def
Makarand Bauskarc446bf62017-07-18 10:54:13 +0530426erpnext.patches.v8_1.update_expense_claim_status
Nabin Hait64c32dc2017-08-16 15:04:18 +0530427erpnext.patches.v8_3.update_company_total_sales #2017-08-16
bcornwellmott96381da2017-07-24 10:12:30 -0700428erpnext.patches.v8_4.make_scorecard_records
Makarand Bauskar98b52a72017-07-31 15:09:52 +0530429erpnext.patches.v8_1.set_delivery_date_in_so_item #2017-07-28
Makarand Bauskar9306aff2017-07-21 15:19:47 +0530430erpnext.patches.v8_5.fix_tax_breakup_for_non_invoice_docs
bcornwellmott96381da2017-07-24 10:12:30 -0700431erpnext.patches.v8_5.remove_quotations_route_in_sidebar
KanchanChauhan7800bd82017-07-26 17:55:25 +0530432erpnext.patches.v8_5.update_existing_data_in_project_type
mbauskar8b6f7912017-07-31 12:30:53 +0530433erpnext.patches.v8_5.set_default_mode_of_payment
Rohit Waghchaure33977822017-07-28 17:45:12 +0530434erpnext.patches.v8_5.update_customer_group_in_POS_profile
Rohit Waghchaure250e9642017-08-02 18:23:39 +0530435erpnext.patches.v8_6.update_timesheet_company_from_PO
Rushabh Mehta16962942017-08-04 10:50:56 +0530436erpnext.patches.v8_6.set_write_permission_for_quotation_for_sales_manager
Nabin Hait879e1622017-08-21 08:28:55 +0530437erpnext.patches.v8_5.remove_project_type_property_setter
rohitwaghchaure16645802017-09-28 11:05:03 +0530438erpnext.patches.v8_7.add_more_gst_fields #21-09-2017
mbauskaraaec42e2017-08-28 11:57:56 +0530439erpnext.patches.v8_7.fix_purchase_receipt_status
Faris Ansari491108a2017-08-30 12:37:05 +0530440erpnext.patches.v8_6.rename_bom_update_tool
Rohit Waghchaure4e006b02017-09-11 11:49:25 +0530441erpnext.patches.v8_7.set_offline_in_pos_settings #11-09-17
Prateeksha Singh228c3412017-12-15 18:32:27 +0530442erpnext.patches.v8_9.add_setup_progress_actions #08-09-2017 #26-09-2017 #22-11-2017 #15-12-2017
Prateeksha Singh95d8fd32017-09-04 11:14:04 +0530443erpnext.patches.v8_9.rename_company_sales_target_field
Faris Ansarie4434d32017-09-05 17:18:04 +0530444erpnext.patches.v8_8.set_bom_rate_as_per_uom
tundebabzyab5b0302017-09-21 10:20:39 +0100445erpnext.patches.v8_8.add_new_fields_in_accounts_settings
Nabin Hait45dce892017-09-14 15:17:38 +0530446erpnext.patches.v8_9.set_print_zero_amount_taxes
Nabin Haitbc9006f2017-09-18 13:16:04 +0530447erpnext.patches.v8_9.set_default_customer_group
Saurabh2222f102017-09-18 15:05:18 +0530448erpnext.patches.v8_9.remove_employee_from_salary_structure_parent
449erpnext.patches.v8_9.delete_gst_doctypes_for_outside_india_accounts
Nabin Haitc9f9e522017-09-28 12:31:33 +0530450erpnext.patches.v8_9.set_default_fields_in_variant_settings
451erpnext.patches.v8_9.update_billing_gstin_for_indian_account
Vishal3a75a5e2017-09-18 16:04:52 +0530452erpnext.patches.v8_9.set_member_party_type
453erpnext.patches.v9_0.add_user_to_child_table_in_pos_profile
Nabin Hait5a834202017-10-05 19:51:10 +0530454erpnext.patches.v9_0.set_schedule_date_for_material_request_and_purchase_order
Manas Solankif91ad752017-10-09 12:41:24 +0530455erpnext.patches.v9_0.student_admission_childtable_migrate
Nabin Hait1c123752017-10-25 12:10:44 +0530456erpnext.patches.v9_0.fix_subscription_next_date #2017-10-23
rohitwaghchauree181dd42017-10-09 12:43:36 +0530457erpnext.patches.v9_0.add_healthcare_domain
Saurabha7d5f942017-10-18 16:02:08 +0530458erpnext.patches.v9_0.set_variant_item_description
tundebabzycba7a112017-10-25 07:27:10 +0100459erpnext.patches.v9_0.set_uoms_in_variant_field
Manas Solanki464289b2017-10-25 12:13:42 +0530460erpnext.patches.v9_0.copy_old_fees_field_data
Manas Solanki36e2fb82017-11-06 17:44:59 +0530461execute:frappe.delete_doc_if_exists("DocType", "Program Fee")
Manas Solanki40ef7e72017-11-02 16:04:16 +0530462erpnext.patches.v9_0.set_pos_profile_name
Manas Solankiaeb00262017-11-10 10:58:43 +0530463erpnext.patches.v9_0.remove_non_existing_warehouse_from_stock_settings
464execute:frappe.delete_doc_if_exists("DocType", "Program Fee")
tunde1c2edae2017-08-31 22:52:06 +0100465erpnext.patches.v8_10.change_default_customer_credit_days
rohitwaghchaure43edd5d2017-11-14 17:59:20 +0530466erpnext.patches.v9_0.update_employee_loan_details
467erpnext.patches.v9_2.delete_healthcare_domain_default_items
Rushabh Mehtaa5ebebd2017-11-16 17:03:52 +0530468erpnext.patches.v9_1.create_issue_opportunity_type
Saurabh3499ba02017-11-17 12:29:26 +0530469erpnext.patches.v9_2.rename_translated_domains_in_en
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530470erpnext.patches.v9_0.set_shipping_type_for_existing_shipping_rules
Manas Solanki966f1412017-11-23 15:22:10 +0530471erpnext.patches.v9_0.update_multi_uom_fields_in_material_request
Shreya Shahe3d6d212017-11-27 12:02:13 +0530472erpnext.patches.v9_2.repost_reserved_qty_for_production
Jamsheerb4884752017-11-28 10:47:06 +0530473erpnext.patches.v9_2.remove_company_from_patient
Zarrar95ee7652017-11-29 18:44:02 +0530474erpnext.patches.v9_2.set_item_name_in_production_order
475erpnext.patches.v10_0.update_lft_rgt_for_employee
Vishal Dhayagude8677cd12017-11-30 13:52:30 +0530476erpnext.patches.v9_2.rename_net_weight_in_item_master
Shreyaf8e7bc72017-12-01 10:42:12 +0530477erpnext.patches.v9_2.delete_process_payroll
Ameya Shenoy5c623682017-12-06 18:36:27 +0530478erpnext.patches.v10_0.add_agriculture_domain
479erpnext.patches.v10_0.add_non_profit_domain
rohitwaghchaurec9ed0942017-12-28 18:42:22 +0530480erpnext.patches.v10_0.setup_vat_for_uae_and_saudi_arabia #2017-12-28
rohitwaghchaure24e52652017-12-14 13:06:21 +0530481erpnext.patches.v10_0.set_primary_contact_for_customer
482erpnext.patches.v10_0.copy_projects_renamed_fields
Nabin Hait4c816a12017-12-16 11:17:36 +0530483erpnext.patches.v10_0.enabled_regional_print_format_based_on_country
484erpnext.patches.v10_0.update_asset_calculate_depreciation
Manas Solanki5807cd82017-12-22 10:50:10 +0530485erpnext.patches.v10_0.add_guardian_role_for_parent_portal
Nabin Hait07e53762018-01-05 18:19:59 +0530486erpnext.patches.v10_0.set_numeric_ranges_in_template_if_blank
Saurabh35d8ce42018-01-12 16:58:32 +0530487erpnext.patches.v10_0.update_reserved_qty_for_purchase_order
Charles-Henri Decultot90657fb2018-01-23 11:10:14 +0100488erpnext.patches.v10_0.fichier_des_ecritures_comptables_for_france
Manas Solankibba5fd72018-01-12 16:21:09 +0530489erpnext.patches.v10_0.update_assessment_plan
490erpnext.patches.v10_0.update_assessment_result
Vishal Dhayagudec463c062018-01-26 11:27:22 +0530491erpnext.patches.v10_0.added_extra_gst_custom_field
Saurabh03f6b3e2018-01-29 16:25:33 +0530492erpnext.patches.v10_0.set_default_payment_terms_based_on_company
Nabin Hait2ef1f842018-02-03 09:14:53 +0530493erpnext.patches.v10_0.update_sales_order_link_to_purchase_order
Nabin Haite6d65bc2018-02-14 17:44:06 +0530494erpnext.patches.v10_0.added_extra_gst_custom_field_in_gstr2 #2018-02-13
Giovannida409992017-12-11 10:01:45 +0100495erpnext.patches.v10_0.item_barcode_childtable_migrate
Shreya Shahf718b0c2018-02-20 11:26:46 +0530496erpnext.patches.v10_0.rename_price_to_rate_in_pricing_rule
497erpnext.patches.v10_0.set_currency_in_pricing_rule
Vishal Dhayagudebd59a532018-02-15 14:22:11 +0530498erpnext.patches.v10_0.set_b2c_limit
499erpnext.patches.v10_0.update_translatable_fields
rohitwaghchauree2558302018-02-20 12:20:00 +0530500erpnext.patches.v10_0.rename_offer_letter_to_job_offer
501execute:frappe.delete_doc('DocType', 'Production Planning Tool', ignore_missing=True)
Suraj Shettyd3069fe2018-02-21 15:15:43 +0530502erpnext.patches.v10_0.migrate_daily_work_summary_settings_to_daily_work_summary_group
tundebabzycad22db2018-02-22 06:38:36 +0100503erpnext.patches.v10_0.add_default_cash_flow_mappers
rohitwaghchaure4e8fdf72018-02-22 11:03:48 +0530504erpnext.patches.v11_0.make_quality_inspection_template
Jamsheer665b4872018-03-08 13:08:35 +0530505erpnext.patches.v10_0.remove_and_copy_fields_in_physician
Manas Solanki5fd7b3b2018-03-05 11:28:29 +0530506erpnext.patches.v10_0.update_status_for_multiple_source_in_po
Nabin Haitf68dc692018-03-01 10:54:24 +0530507erpnext.patches.v10_0.set_auto_created_serial_no_in_stock_entry
Zarrar91fc1a82018-02-22 10:57:49 +0530508erpnext.patches.v10_0.update_territory_and_customer_group
Achilles Rasquinha78064b72018-03-05 17:53:23 +0530509erpnext.patches.v10_0.update_warehouse_address_details
Nabin Hait2c7a6e62018-03-12 14:12:12 +0530510erpnext.patches.v10_0.update_reserved_qty_for_purchase_order
Achilles Rasquinhad8f7de92018-03-15 12:48:32 +0530511erpnext.patches.v10_0.update_hub_connector_domain
Manas Solankic7114452018-03-21 10:12:27 +0530512erpnext.patches.v10_0.set_student_party_type
Nabin Hait061d9122018-03-23 16:20:27 +0530513erpnext.patches.v10_0.update_project_in_sle
Nabin Haitb9c82b92018-03-27 14:25:27 +0530514erpnext.patches.v10_0.fix_reserved_qty_for_sub_contract
Nabin Hait03b59742018-07-13 17:45:15 +0530515erpnext.patches.v11_0.merge_land_unit_with_location
Prateeksha Singh420c7902018-04-05 14:44:16 +0530516erpnext.patches.v11_0.add_index_on_nestedset_doctypes
517erpnext.patches.v11_0.remove_modules_setup_page
Shreya Shah4dc453d2018-04-24 12:19:36 +0530518erpnext.patches.v11_0.rename_employee_loan_to_loan
Shreya Shaha2056a32018-06-13 17:11:17 +0530519erpnext.patches.v11_0.move_leave_approvers_from_employee #13-06-2018
Shreya Shah828f5ab2018-04-23 13:21:35 +0530520erpnext.patches.v11_0.update_department_lft_rgt
Shreya Shah44e719d2018-04-20 10:28:52 +0530521erpnext.patches.v11_0.add_default_email_template_for_leave
Zarrar65994212018-06-08 16:57:06 +0530522erpnext.patches.v11_0.set_default_email_template_in_hr #08-06-2018
Zarrardfe897b2018-07-01 16:45:53 +0530523erpnext.patches.v11_0.uom_conversion_data #30-06-2018
Saurabh63590492018-04-25 11:32:54 +0530524erpnext.patches.v10_0.taxes_issue_with_pos
rohitwaghchauree8358f32018-05-16 11:02:26 +0530525erpnext.patches.v11_0.update_account_type_in_party_type
tundebabzy0125f7b2018-03-12 13:50:50 +0100526erpnext.patches.v10_1.transfer_subscription_to_auto_repeat
Suraj Shetty00cced12018-05-03 19:06:32 +0530527erpnext.patches.v11_0.update_brand_in_item_price
528erpnext.patches.v11_0.create_default_success_action
Jamsheer0cde6ae2018-05-16 10:54:00 +0530529erpnext.patches.v11_0.add_healthcare_service_unit_tree_root
Saurabhed393d12018-05-03 18:52:25 +0530530erpnext.patches.v10_0.set_qty_in_transactions_based_on_serial_no_input
531erpnext.patches.v10_0.show_leaves_of_all_department_members_in_calendar
Shreya Shahb15ef842018-04-14 12:33:01 +0530532erpnext.patches.v11_0.rename_field_max_days_allowed
Nabin Hait55184482018-04-14 17:04:56 +0530533erpnext.patches.v11_0.create_salary_structure_assignments
Nabin Hait8076d6d2018-04-15 15:03:54 +0530534erpnext.patches.v11_0.rename_health_insurance
rohitwaghchaureefff6e52018-04-18 10:52:07 +0530535erpnext.patches.v11_0.rebuild_tree_for_company
Zlash65540d7aa2018-04-20 09:39:29 +0530536erpnext.patches.v11_0.rename_supplier_type_to_supplier_group
Zlash65d25a2642018-05-13 14:34:20 +0530537erpnext.patches.v11_0.create_department_records_for_each_company
Rohit Waghchaured644e6d2018-05-12 15:27:18 +0530538erpnext.patches.v11_0.make_location_from_warehouse
rohitwaghchaure7c6bef42018-05-14 20:39:01 +0530539erpnext.patches.v11_0.make_asset_finance_book_against_old_entries
Shreyaacc4cec2018-05-15 17:50:52 +0530540erpnext.patches.v11_0.check_buying_selling_in_currency_exchange
Shreya Shah93d60862018-07-03 10:07:32 +0530541erpnext.patches.v11_0.move_item_defaults_to_child_table_for_multicompany #02-07-2018
Zarrar17089ee2018-06-14 11:54:18 +0530542erpnext.patches.v11_0.refactor_erpnext_shopify
rohitwaghchaure05152da2018-05-30 15:28:09 +0530543erpnext.patches.v11_0.rename_overproduction_percent_field
rohitwaghchaure2da6b3d2018-06-05 13:06:52 +0530544erpnext.patches.v11_0.update_backflush_subcontract_rm_based_on_bom
Shreya Shahae95a8a2018-05-28 18:24:28 +0530545erpnext.patches.v10_0.update_status_in_purchase_receipt
Shreya Shah4fa600a2018-06-05 11:27:53 +0530546erpnext.patches.v11_0.inter_state_field_for_gst
rohitwaghchaure2da6b3d2018-06-05 13:06:52 +0530547erpnext.patches.v11_0.rename_members_with_naming_series #04-06-2018
Shreya Shah157815f2018-06-11 17:32:17 +0530548erpnext.patches.v11_0.set_update_field_and_value_in_workflow_state
549erpnext.patches.v11_0.update_total_qty_field
deepak-mntb95f60c2018-06-12 16:04:49 +0530550erpnext.patches.v11_0.update_sales_partner_type
rohitwaghchauree647c1f2018-06-15 13:06:28 +0530551erpnext.patches.v11_0.rename_asset_adjustment_doctype
Shreya Shah77de8dc2018-06-19 10:43:08 +0530552execute:frappe.db.sql("update `tabDesktop Icon` set type = 'module' where module_name = 'Restaurant'")
Nabin Hait6e86fb22018-06-29 14:36:28 +0530553erpnext.patches.v11_0.set_salary_component_properties
Rushabh Mehtadf23c7d2018-07-05 15:19:28 +0530554erpnext.patches.v11_0.set_user_permissions_for_department
Alchezdf1eae82018-07-13 12:50:04 +0530555erpnext.patches.v11_0.hr_ux_cleanups
Suraj Shetty6dfc1652018-07-16 18:10:16 +0530556erpnext.patches.v11_0.skip_user_permission_check_for_department
Suraj Shettya6f98432018-07-16 18:39:01 +0530557erpnext.patches.v11_0.set_department_for_doctypes
Jamsheerf9269112018-07-16 18:08:53 +0530558erpnext.patches.v11_0.update_allow_transfer_for_manufacture
559erpnext.patches.v11_0.rename_healthcare_doctype_and_fields
Shreya Shah3c9839f2018-07-17 18:01:44 +0530560erpnext.patches.v11_0.add_item_group_defaults
Saurabhd7897f12018-07-18 17:08:16 +0530561erpnext.patches.v10_0.update_address_template_for_india
Faris Ansari9d1b7d42018-07-26 18:54:58 +0530562execute:frappe.delete_doc("Page", "hub")