details: https://code.openbravo.com/erp/devel/pi/rev/c988931247b8
changeset: 15564:c988931247b8
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Wed Feb 22 12:25:32 2012 +0100
summary: Fixes issue 0019838: Payment Report does not show an empty business
partner when the option "only empty business partner" is selected.
diffstat:
modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
| 12 ++++++++-
1 files changed, 10 insertions(+), 2 deletions(-)
diffs (26 lines):
diff -r 94ab687f1f98 -r c988931247b8
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
Thu Feb 16 17:25:51 2012 +0100
+++
b/modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
Wed Feb 22 12:25:32 2012 +0100
@@ -332,12 +332,20 @@
}
// exclude empty business partner
if (strcBPartnerIdIN.isEmpty() && strcBPGroupIdIN.isEmpty()) {
- hsqlScript.append(" and (paybpc is not null or invbpc is not null)
");
+ hsqlScript.append(" and (pay.");
+ hsqlScript.append(FIN_Payment.PROPERTY_BUSINESSPARTNER);
+ hsqlScript.append(" is not null or inv.");
+ hsqlScript.append(Invoice.PROPERTY_BUSINESSPARTNER);
+ hsqlScript.append(" is not null) ");
}
// Only Empty Business Partner
} else {// if ((strcNoBusinessPartner.equals("only")))
- hsqlScript.append(" and paybpc is null and invbpc is null ");
+ hsqlScript.append(" and pay.");
+ hsqlScript.append(FIN_Payment.PROPERTY_BUSINESSPARTNER);
+ hsqlScript.append(" is null and inv.");
+ hsqlScript.append(Invoice.PROPERTY_BUSINESSPARTNER);
+ hsqlScript.append(" is null ");
}
// project
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
