commit 718d835f45f7e080acfec0d5ac105eab248d24ef
author Saurabh <saurabh6790@gmail.com> Mon Jul 18 15:20:47 2016 +0530
committer Saurabh <saurabh6790@gmail.com> Tue Jul 19 11:38:16 2016 +0530
tree e88420a4b80e5fecb3919c46e31d21c58ec16750
parent f589c82d680a39260f60a364992031eeb7b1fe82

[enhance] Add Accounts table in  to mention expense account based on company  #5777

erpnext/demo/user/hr.py

diff --git a/erpnext/demo/user/hr.py b/erpnext/demo/user/hr.py
index 50bb173..c5cbe6b 100644
--- a/erpnext/demo/user/hr.py
+++ b/erpnext/demo/user/hr.py
@@ -63,7 +63,9 @@
 
 def get_expenses():
 	expenses = []
-	expese_types = frappe.db.sql("select name, default_account from `tabExpense Claim Type`",as_dict=1)
+	expese_types = frappe.db.sql("""select ect.name, eca.default_account from `tabExpense Claim Type` ect,
+		`tabExpense Claim Account` eca where eca.parent=ect.name
+		and eca.company=%s """, frappe.flags.company,as_dict=1)
 
 	for expense_type in expese_types[:random.randint(1,4)]:
 		claim_amount = random.randint(1,20)*10