| commit | c3f2fb7355ec457edca6f1972063e367d66f2c6f | [log] [tgz] |
|---|---|---|
| author | Nabin Hait <nabinhait@gmail.com> | Thu Dec 12 14:55:25 2013 +0530 |
| committer | Nabin Hait <nabinhait@gmail.com> | Thu Dec 12 15:01:12 2013 +0530 |
| tree | 4c6e1fdee3b9485309864d3a81692174f3526d9d | |
| parent | 9fd2d79fc71d352c5dd4adb87d1a538eba9e49fb [diff] |
[fix] [minor] payment to invoice patching tool
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 6a31191..dea5fb5 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
@@ -145,6 +145,8 @@ and voucher_no != gle.voucher_no) != abs(ifnull(gle.debit, 0) - ifnull(gle.credit, 0) ) + and if(gle.voucher_type='Sales Invoice', (select is_pos from `tabSales Invoice` + where name=gle.voucher_no), 0)=0 %(mcond)s ORDER BY gle.posting_date desc, gle.voucher_no desc limit %(start)s, %(page_len)s""" % {