| commit | 272410bb875d290f247dd7336ca5defb3f5fda11 | [log] [tgz] |
|---|---|---|
| author | Nabin Hait <nabinhait@gmail.com> | Thu Sep 05 15:43:05 2013 +0530 |
| committer | Nabin Hait <nabinhait@gmail.com> | Thu Sep 05 15:43:05 2013 +0530 |
| tree | 401be97e0b0aea852dc081863690a6ac43ef1a9b | |
| parent | 335cdeaf7d067f9f8b636f2b66bc66a333800440 [diff] |
[fix] [minor] fixes in payment reconciiation
diff --git a/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.py b/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.py index dc2bcc5..7522c23 100644 --- a/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.py +++ b/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.py
@@ -19,7 +19,7 @@ webnotes.conn.get_value("Account", self.doc.account, "debit_or_credit").lower() or "" def get_voucher_details(self): - total_amount = webnotes.conn.sql("""select %s from `tabGL Entry` + total_amount = webnotes.conn.sql("""select sum(%s) from `tabGL Entry` where voucher_type = %s and voucher_no = %s and account = %s and ifnull(is_cancelled, 'No') = 'No'""" % (self.doc.account_type, '%s', '%s', '%s'),