diff --git a/erpnext/patches/4_0/countrywise_coa.py b/erpnext/patches/4_0/countrywise_coa.py
index 7bf4b26..6ee8987 100644
--- a/erpnext/patches/4_0/countrywise_coa.py
+++ b/erpnext/patches/4_0/countrywise_coa.py
@@ -10,11 +10,9 @@
 	
 	frappe.db.sql("""update tabAccount set account_type='Fixed Asset' 
 		where account_type='Fixed Asset Account'""")
-		
-	for d in (('Asset', 'Debit', 'No'), ('Liability', 'Credit', 'No'), ('Expense', 'Debit', 'Yes'), 
-			('Income', 'Credit', 'Yes')):
-		frappe.db.sql("""update `tabAccount` set root_type = %s 
-			where debit_or_credit=%s and is_pl_account=%s""", d)
+
+	frappe.db.sql("""update `tabAccount` set report_type = 
+		if(is_pl_account=='Yes', 'Profit and Loss', 'Balance Sheet')""")
 			
 	frappe.db.sql("""update `tabAccount` set balance_must_be=debit_or_credit 
 		where ifnull(allow_negative_balance, 0) = 0""")
\ No newline at end of file