details: /erp/stable/2.50/rev/2938f20924f4
changeset: 9230:2938f20924f4
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Tue Feb 22 18:26:51 2011 +0100
summary: Fixes issue 0015954: The RptC_Remittance.jrxml ignores if the BP has
an account inactive
It has been added a new condition in the SQL sentence to filter only by active
bank accounts
diffstat:
src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r ac312f1987de -r 2938f20924f4
src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml
--- a/src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml Tue Feb 22
18:13:08 2011 +0100
+++ b/src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml Tue Feb 22
18:26:51 2011 +0100
@@ -219,6 +219,7 @@
WHERE RL.C_REMITTANCE_ID = $P{C_REMITTANCE_ID}
AND RL.C_DEBT_PAYMENT_ID = D.C_DEBT_PAYMENT_ID
AND D.C_BPARTNER_ID = B.C_BPARTNER_ID
+ AND BPB.ISACTIVE = 'Y'
ORDER BY DATEPLANNED, RL.LINE]]></queryString>
<field name="DATEPLANNED" class="java.sql.Timestamp"/>
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
