Fixes Issue 30061:Customer Statement report is not considering all required
authorAtul Gaware <atul.gaware@openbravo.com>
Sun, 07 Jun 2015 21:27:32 +0530
changeset 26873 8acbd2d2afa5
parent 26872 9939e14fd9fb
child 26874 9909424c0e02
child 26875 129a8588e600
Fixes Issue 30061:Customer Statement report is not considering all required
tables

All tables are considered now except C_Period which is not needed here.
src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml	Sun Jun 07 17:19:11 2015 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml	Sun Jun 07 21:27:32 2015 +0530
@@ -138,7 +138,7 @@
         ELSE TO_DATE($P{DateFrom}) END)
     AND trunc(f.dateacct) <= (CASE WHEN ($P{DateTo} IS NULL OR $P{DateTo}='') THEN TO_DATE('09-09-9999')
         ELSE TO_DATE($P{DateTo}) END)
-    AND f.ad_table_id IN ('318','D1A97202E832470285C9B1EB026D54E2','4D8C3B3C31D1410DA046140C9F024D17','B1B7075C46934F0A9FD4C4D0F1457B42')
+    AND f.ad_table_id not IN ('145')
 ORDER BY f.dateacct, f.created]]>
 	</queryString>
 	<field name="org_address" class="java.lang.String"/>