| commit | bdb83b1b5a25fc6a6aa451239deda2eda01f080d | [log] [tgz] |
|---|---|---|
| author | Nabin Hait <nabinhait@gmail.com> | Thu Dec 12 01:33:42 2013 -0800 |
| committer | Nabin Hait <nabinhait@gmail.com> | Thu Dec 12 01:33:42 2013 -0800 |
| tree | 5da457c0e8451c9583498682849b929d733bb32a | |
| parent | a6db546457b35310bb251938f96b1df4ea9f293a [diff] | |
| parent | c3f2fb7355ec457edca6f1972063e367d66f2c6f [diff] |
Merge pull request #1177 from nabinhait/hotfix1 [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""" % {