patch to delete mis control and financial statements and set bank/cash account
diff --git a/erpnext/config/accounts.py b/erpnext/config/accounts.py
index 2a47c2a..6adb9ae 100644
--- a/erpnext/config/accounts.py
+++ b/erpnext/config/accounts.py
@@ -162,11 +162,6 @@
"icon": "icon-table"
},
{
- "type": "page",
- "name":"Financial Statements",
- "icon": "icon-table"
- },
- {
"type": "report",
"name": "Accounts Receivable",
"doctype": "Sales Invoice",
diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index c1f43e3..8c20452 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -30,3 +30,5 @@
erpnext.patches.4_0.fix_employee_user_id
erpnext.patches.4_0.import_country_codes
execute:patches.4_0.countrywise_coa
+execute:frappe.delete_doc("DocType", "MIS Control")
+execute:frappe.delete_doc("Page", "Financial Statements")
diff --git a/erpnext/patches/4_0/countrywise_coa.py b/erpnext/patches/4_0/countrywise_coa.py
index 6ee8987..2425856 100644
--- a/erpnext/patches/4_0/countrywise_coa.py
+++ b/erpnext/patches/4_0/countrywise_coa.py
@@ -8,8 +8,13 @@
frappe.reload_doc("setup", 'doctype', "company")
frappe.reload_doc("accounts", 'doctype', "account")
- frappe.db.sql("""update tabAccount set account_type='Fixed Asset'
- where account_type='Fixed Asset Account'""")
+ frappe.db.sql("""update tabAccount set account_type='Cash'
+ where account_type='Bank or Cash' and account_name in ('Cash', 'Cash In Hand')""")
+
+ ac_types = {"Fixed Asset Account": "Fixed Asset", "Bank or Cash": "Bank"}
+ for old, new in ac_types.items:
+ frappe.db.sql("""update tabAccount set account_type=%s
+ where account_type=%s""", (new, old))
frappe.db.sql("""update `tabAccount` set report_type =
if(is_pl_account=='Yes', 'Profit and Loss', 'Balance Sheet')""")