| execute:import unidecode # new requirement |
| |
| erpnext.patches.v4_0.validate_v3_patch |
| erpnext.patches.v4_0.fix_employee_user_id |
| erpnext.patches.v4_0.remove_employee_role_if_no_employee |
| erpnext.patches.v4_0.update_user_properties |
| erpnext.patches.v4_0.apply_user_permissions |
| erpnext.patches.v4_0.move_warehouse_user_to_restrictions |
| erpnext.patches.v4_0.global_defaults_to_system_settings |
| erpnext.patches.v4_0.update_incharge_name_to_sales_person_in_maintenance_schedule |
| execute:frappe.reload_doc('accounts', 'doctype', 'sales_invoice') # 2014-01-29 |
| execute:frappe.reload_doc('selling', 'doctype', 'sales_order') # 2014-01-29 |
| execute:frappe.reload_doc('selling', 'doctype', 'quotation') # 2014-01-29 |
| execute:frappe.reload_doc('stock', 'doctype', 'delivery_note') # 2014-01-29 |
| erpnext.patches.v4_0.reload_sales_print_format |
| execute:frappe.reload_doc('accounts', 'doctype', 'purchase_invoice') # 2014-01-29 |
| execute:frappe.reload_doc('buying', 'doctype', 'purchase_order') # 2014-01-29 |
| execute:frappe.reload_doc('buying', 'doctype', 'supplier_quotation') # 2014-01-29 |
| execute:frappe.reload_doc('stock', 'doctype', 'purchase_receipt') # 2014-01-29 |
| execute:frappe.reload_doc('accounts', 'doctype', 'pos_setting') # 2014-01-29 |
| execute:frappe.reload_doc('selling', 'doctype', 'customer') # 2014-01-29 |
| execute:frappe.reload_doc('buying', 'doctype', 'supplier') # 2014-01-29 |
| erpnext.patches.v4_0.map_charge_to_taxes_and_charges |
| execute:frappe.reload_doc('support', 'doctype', 'newsletter') # 2014-01-31 |
| execute:frappe.reload_doc('hr', 'doctype', 'employee') # 2014-02-03 |
| execute:frappe.db.sql("update tabPage set module='Core' where name='Setup'") |
| |
| # inserted this patch here since Item types are being changed |
| erpnext.patches.v5_2.change_item_selects_to_checks |
| erpnext.patches.v4_0.fields_to_be_renamed |
| erpnext.patches.v4_0.rename_sitemap_to_route |
| erpnext.patches.v4_0.fix_contact_address |
| erpnext.patches.v4_0.customer_discount_to_pricing_rule |
| execute:frappe.db.sql("""delete from `tabWebsite Item Group` where ifnull(item_group, '')=''""") |
| erpnext.patches.v4_0.remove_module_home_pages |
| erpnext.patches.v4_0.split_email_settings |
| erpnext.patches.v4_0.import_country_codes |
| erpnext.patches.v4_0.countrywise_coa |
| execute:frappe.delete_doc("DocType", "MIS Control") |
| execute:frappe.delete_doc("Page", "Financial Statements") |
| execute:frappe.delete_doc("DocType", "Stock Ledger") |
| execute:frappe.delete_doc("DocType", "Grade") |
| execute:frappe.db.sql("delete from `tabWebsite Item Group` where ifnull(item_group, '')=''") |
| execute:frappe.delete_doc("Print Format", "SalesInvoice") |
| execute:import frappe.defaults;frappe.defaults.clear_default("price_list_currency") |
| erpnext.patches.v4_0.update_account_root_type |
| execute:frappe.delete_doc("Report", "Purchase In Transit") |
| erpnext.patches.v4_0.new_address_template |
| execute:frappe.delete_doc("DocType", "SMS Control") |
| execute:frappe.delete_doc_if_exists("DocType", "Bulk SMS") #2015-08-18 |
| erpnext.patches.v4_0.fix_case_of_hr_module_def |
| erpnext.patches.v4_0.fix_address_template |
| |
| # WATCHOUT: This patch reload's documents |
| erpnext.patches.v4_0.reset_permissions_for_masters |
| |
| erpnext.patches.v4_0.update_tax_amount_after_discount |
| execute:frappe.permissions.reset_perms("GL Entry") #2014-06-09 |
| execute:frappe.permissions.reset_perms("Stock Ledger Entry") #2014-06-09 |
| erpnext.patches.v4_0.create_custom_fields_for_india_specific_fields |
| erpnext.patches.v4_0.save_default_letterhead |
| erpnext.patches.v4_0.update_custom_print_formats_for_renamed_fields |
| erpnext.patches.v4_0.update_other_charges_in_custom_purchase_print_formats |
| erpnext.patches.v4_0.create_price_list_if_missing |
| execute:frappe.db.sql("update `tabItem` set end_of_life=null where end_of_life='0000-00-00'") #2014-06-16 |
| erpnext.patches.v4_0.update_users_report_view_settings |
| erpnext.patches.v4_0.set_pricing_rule_for_buying_or_selling |
| erpnext.patches.v4_0.set_naming_series_property_setter |
| erpnext.patches.v4_1.set_outgoing_email_footer |
| erpnext.patches.v4_1.fix_sales_order_delivered_status |
| erpnext.patches.v4_1.fix_delivery_and_billing_status |
| execute:frappe.db.sql("update `tabAccount` set root_type='Liability' where root_type='Income' and report_type='Balance Sheet'") |
| execute:frappe.delete_doc("DocType", "Payment to Invoice Matching Tool") # 29-07-2014 |
| execute:frappe.delete_doc("DocType", "Payment to Invoice Matching Tool Detail") # 29-07-2014 |
| execute:frappe.delete_doc("Page", "trial-balance") #2014-07-22 |
| erpnext.patches.v4_2.delete_old_print_formats #2014-07-29 |
| erpnext.patches.v4_2.toggle_rounded_total #2014-07-30 |
| erpnext.patches.v4_2.fix_account_master_type |
| erpnext.patches.v4_2.update_project_milestones |
| erpnext.patches.v4_2.add_currency_turkish_lira #2014-08-08 |
| execute:frappe.delete_doc("DocType", "Landed Cost Wizard") |
| erpnext.patches.v4_2.default_website_style |
| erpnext.patches.v4_2.set_company_country |
| erpnext.patches.v4_2.update_sales_order_invoice_field_name |
| erpnext.patches.v4_2.seprate_manufacture_and_repack |
| execute:frappe.delete_doc("Report", "Warehouse-Wise Stock Balance") |
| execute:frappe.delete_doc("DocType", "Purchase Request") |
| execute:frappe.delete_doc("DocType", "Purchase Request Item") |
| erpnext.patches.v4_2.recalculate_bom_cost |
| erpnext.patches.v4_2.fix_gl_entries_for_stock_transactions |
| erpnext.patches.v4_2.update_requested_and_ordered_qty |
| execute:frappe.rename_doc("DocType", "Support Ticket", "Issue", force=True) |
| erpnext.patches.v4_4.make_email_accounts |
| execute:frappe.delete_doc("DocType", "Contact Control") |
| erpnext.patches.v4_2.discount_amount |
| erpnext.patches.v4_2.reset_bom_costs |
| erpnext.patches.v5_0.update_frozen_accounts_permission_role |
| erpnext.patches.v5_0.update_dn_against_doc_fields |
| execute:frappe.db.sql("update `tabMaterial Request` set material_request_type = 'Material Transfer' where material_request_type = 'Transfer'") |
| execute:frappe.reload_doc('stock', 'doctype', 'item') |
| execute: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)") |
| erpnext.patches.v5_0.set_default_company_in_bom |
| execute:frappe.reload_doc('crm', 'doctype', 'lead') |
| execute:frappe.reload_doc('crm', 'doctype', 'opportunity') |
| erpnext.patches.v5_0.rename_taxes_and_charges_master |
| erpnext.patches.v5_1.sales_bom_rename |
| erpnext.patches.v5_0.rename_table_fieldnames |
| execute:frappe.db.sql("update `tabJournal Entry` set voucher_type='Journal Entry' where ifnull(voucher_type, '')=''") |
| erpnext.patches.v5_0.is_group |
| erpnext.patches.v4_2.party_model |
| erpnext.patches.v5_0.party_model_patch_fix |
| erpnext.patches.v4_1.fix_jv_remarks |
| erpnext.patches.v4_2.update_landed_cost_voucher |
| erpnext.patches.v4_2.set_item_has_batch |
| erpnext.patches.v4_2.update_stock_uom_for_dn_in_sle |
| erpnext.patches.v5_0.recalculate_total_amount_in_jv |
| erpnext.patches.v5_0.update_companywise_payment_account |
| erpnext.patches.v5_0.remove_birthday_events |
| erpnext.patches.v5_0.update_item_name_in_bom |
| erpnext.patches.v5_0.rename_customer_issue |
| erpnext.patches.v5_0.rename_total_fields |
| erpnext.patches.v5_0.new_crm_module |
| erpnext.patches.v5_0.rename_customer_issue |
| erpnext.patches.v5_0.update_material_transfer_for_manufacture |
| execute:frappe.reload_doc('crm', 'doctype', 'opportunity_item') |
| erpnext.patches.v5_0.update_item_description_and_image |
| erpnext.patches.v5_0.update_material_transferred_for_manufacturing |
| erpnext.patches.v5_0.stock_entry_update_value |
| erpnext.patches.v5_0.convert_stock_reconciliation |
| erpnext.patches.v5_0.update_projects |
| erpnext.patches.v5_0.item_patches |
| erpnext.patches.v5_0.update_journal_entry_title |
| erpnext.patches.v5_0.taxes_and_totals_in_party_currency |
| erpnext.patches.v5_0.replace_renamed_fields_in_custom_scripts_and_print_formats |
| erpnext.patches.v5_0.update_from_bom |
| erpnext.patches.v5_0.update_account_types |
| erpnext.patches.v5_0.update_sms_sender |
| erpnext.patches.v5_0.set_appraisal_remarks |
| erpnext.patches.v5_0.update_time_log_title |
| erpnext.patches.v4_2.repost_sle_for_si_with_no_warehouse |
| erpnext.patches.v5_0.newsletter |
| execute:frappe.delete_doc("DocType", "Chart of Accounts") |
| execute:frappe.delete_doc("DocType", "Style Settings") |
| erpnext.patches.v5_0.update_opportunity |
| erpnext.patches.v5_0.opportunity_not_submittable |
| execute:frappe.permissions.reset_perms("Purchase Taxes and Charges Template") #2014-06-09 |
| execute:frappe.permissions.reset_perms("Expense Claim Type") #2014-06-19 |
| erpnext.patches.v5_0.execute_on_doctype_update |
| erpnext.patches.v4_2.fix_recurring_orders |
| erpnext.patches.v4_2.delete_gl_entries_for_cancelled_invoices |
| erpnext.patches.v5_0.project_costing |
| erpnext.patches.v5_0.update_temporary_account |
| erpnext.patches.v5_0.update_advance_paid |
| erpnext.patches.v5_0.link_warehouse_with_account |
| execute:frappe.delete_doc("Page", "stock-ledger") |
| execute:frappe.delete_doc("Page","stock-level") |
| erpnext.patches.v5_0.reclculate_planned_operating_cost_in_production_order |
| erpnext.patches.v5_0.repost_requested_qty |
| erpnext.patches.v5_0.fix_taxes_and_totals_in_party_currency |
| erpnext.patches.v5_0.update_tax_amount_after_discount_in_purchase_cycle |
| erpnext.patches.v5_0.rename_pos_setting |
| erpnext.patches.v5_0.update_operation_description |
| erpnext.patches.v5_0.set_footer_address |
| execute: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) |
| execute:frappe.db.sql_list("delete from `tabDocPerm` where parent='Issue' and modified_by='Administrator' and role='Guest'") |
| erpnext.patches.v5_0.update_item_and_description_again |
| erpnext.patches.v5_0.repost_gle_for_jv_with_multiple_party |
| erpnext.patches.v5_0.portal_fixes |
| erpnext.patches.v5_0.reset_values_in_tools |
| execute:frappe.delete_doc("Page", "users") |
| erpnext.patches.v5_0.update_material_transferred_for_manufacturing_again |
| erpnext.patches.v5_0.index_on_account_and_gl_entry |
| execute:frappe.db.sql("""delete from `tabProject Task`""") |
| erpnext.patches.v5_0.update_item_desc_in_invoice |
| erpnext.patches.v5_1.fix_against_account |
| erpnext.patches.v5_1.fix_credit_days_based_on |
| execute:frappe.rename_doc("DocType", "Salary Manager", "Process Payroll", force=True) |
| erpnext.patches.v5_1.rename_roles |
| erpnext.patches.v5_1.default_bom |
| execute:frappe.delete_doc("DocType", "Party Type") |
| execute:frappe.delete_doc("Module Def", "Contacts") |
| erpnext.patches.v5_4.fix_reserved_qty_and_sle_for_packed_items # 30-07-2015 |
| execute:frappe.reload_doctype("Leave Type") |
| execute:frappe.db.sql("update `tabLeave Type` set include_holiday=0") |
| erpnext.patches.v5_4.set_root_and_report_type |
| erpnext.patches.v5_4.notify_system_managers_regarding_wrong_tax_calculation |
| erpnext.patches.v5_4.fix_invoice_outstanding |
| execute:frappe.db.sql("update `tabStock Ledger Entry` set stock_queue = '[]' where voucher_type = 'Stock Reconciliation' and ifnull(qty_after_transaction, 0) = 0") |
| erpnext.patches.v5_4.fix_missing_item_images |
| erpnext.patches.v5_4.stock_entry_additional_costs |
| erpnext.patches.v5_4.cleanup_journal_entry #2015-08-14 |
| execute:frappe.db.sql("update `tabProduction Order` pro set description = (select description from tabItem where name=pro.production_item) where ifnull(description, '') = ''") |
| erpnext.patches.v5_7.item_template_attributes |
| execute:frappe.delete_doc_if_exists("DocType", "Manage Variants") |
| execute:frappe.delete_doc_if_exists("DocType", "Manage Variants Item") |
| erpnext.patches.v4_2.repost_reserved_qty #2015-08-20 |
| erpnext.patches.v5_4.update_purchase_cost_against_project |
| erpnext.patches.v5_8.update_order_reference_in_return_entries |
| erpnext.patches.v5_8.add_credit_note_print_heading |
| execute:frappe.delete_doc_if_exists("Print Format", "Credit Note - Negative Invoice") |
| |
| # V6.0 |
| erpnext.patches.v6_0.set_default_title # 2015-09-03 |
| erpnext.patches.v6_0.default_activity_rate |
| execute:frappe.db.set_value("Stock Settings", None, "automatically_set_serial_nos_based_on_fifo", 1) |
| execute:frappe.db.sql("""update `tabProject` set percent_complete=round(percent_complete, 2) where percent_complete is not null""") |
| erpnext.patches.v6_0.fix_outstanding_amount |
| erpnext.patches.v6_0.fix_planned_qty |
| erpnext.patches.v6_0.multi_currency |
| erpnext.patches.v6_2.remove_newsletter_duplicates |
| erpnext.patches.v6_2.fix_missing_default_taxes_and_lead |