commit 13d4391e7071cbe7fa51bf74d5f415781969ee53
author Vladyslav Baidak <vbaidak@users.noreply.github.com> Tue May 29 12:52:05 2018 +0300
committer Nabin Hait <nabinhait@gmail.com> Tue May 29 15:22:05 2018 +0530
tree 880cd7c9832234c4630136be15272228bba5c8bc
parent 4d0c73a5c87fbcbcb7080a439744cea1e7da66c3

Fixed SQL syntax error in Get Loan Details (#14265)

erpnext/hr/doctype/payroll_entry/payroll_entry.py

diff --git a/erpnext/hr/doctype/payroll_entry/payroll_entry.py b/erpnext/hr/doctype/payroll_entry/payroll_entry.py
index aa27e5b..e70a5bd 100644
--- a/erpnext/hr/doctype/payroll_entry/payroll_entry.py
+++ b/erpnext/hr/doctype/payroll_entry/payroll_entry.py
@@ -184,7 +184,7 @@
 			Get loan details from submitted salary slip based on selected criteria
 		"""
 		cond = self.get_filter_condition()
-		return frappe.db.sql(""" select eld.loan_account, eld.loan
+		return frappe.db.sql(""" select eld.loan_account, eld.loan,
 				eld.interest_income_account, eld.principal_amount, eld.interest_amount, eld.total_payment
 			from
 				`tabSalary Slip` t1, `tabSalary Slip Loan` eld