details: https://code.openbravo.com/erp/devel/pi/rev/724c769c39e9
changeset: 14779:724c769c39e9
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Wed Nov 30 19:53:38 2011 +0100
summary: Fixes bug 19218: When filtering in payment report (no credit
payments) invoices awaiting payment are not displayed
diffstat:
modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
| 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (14 lines):
diff -r e91e9c0e5672 -r 724c769c39e9
modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
a/modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
Wed Nov 30 19:17:04 2011 +0100
+++
b/modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
Wed Nov 30 19:53:38 2011 +0100
@@ -156,8 +156,8 @@
// Exclude payments that use credit payment
if (!strInclPaymentUsingCredit.equalsIgnoreCase("Y")) {
- hsqlScript.append(" and not (pay.amount = 0 ");
- hsqlScript.append(" and pay.usedCredit > pay.generatedCredit) ");
+ hsqlScript.append(" and (not (pay.amount = 0 ");
+ hsqlScript.append(" and pay.usedCredit > pay.generatedCredit) or pay
is null)");
}
// due date from - due date to
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
