src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml
changeset 5069 b4990292ae3e
parent 3857 6d631363ffc7
child 5089 54767c398a62
equal deleted inserted replaced
5068:ff6ccc39f03c 5069:b4990292ae3e
   229     AND BSL.C_BANKSTATEMENT_ID = B.C_BANKSTATEMENT_ID                                           
   229     AND BSL.C_BANKSTATEMENT_ID = B.C_BANKSTATEMENT_ID                                           
   230     AND B.PROCESSED='Y'))               ),0) AS PAYMENT,             BA.C_BANKACCOUNT_ID     
   230     AND B.PROCESSED='Y'))               ),0) AS PAYMENT,             BA.C_BANKACCOUNT_ID     
   231     FROM C_BANKSTATEMENTLINE BL,     
   231     FROM C_BANKSTATEMENTLINE BL,     
   232     C_BANKSTATEMENT     BS,           C_BANK              B,           C_BANKACCOUNT       BA     
   232     C_BANKSTATEMENT     BS,           C_BANK              B,           C_BANKACCOUNT       BA     
   233     WHERE BS.C_BANKSTATEMENT_ID = BL.C_BANKSTATEMENT_ID        AND BA.C_BANKACCOUNT_ID = BS.C_BANKACCOUNT_ID        AND BA.C_BANK_ID = B.C_BANK_ID         AND BS.PROCESSED='Y'        
   233     WHERE BS.C_BANKSTATEMENT_ID = BL.C_BANKSTATEMENT_ID        AND BA.C_BANKACCOUNT_ID = BS.C_BANKACCOUNT_ID        AND BA.C_BANK_ID = B.C_BANK_ID         AND BS.PROCESSED='Y'        
   234     AND BS.STATEMENTDATE <= NOW()        AND 3=3    AND B.AD_CLIENT_ID IN (0,1000000)        AND B.AD_ORG_ID IN (1000000,0)        
   234     AND BS.STATEMENTDATE <= NOW()        AND 3=3    AND B.AD_CLIENT_ID IN ($P!{USER_CLIENT})      AND B.AD_ORG_ID IN ($P!{USER_ORG})       
   235     GROUP BY (B.CODEBANK || '/' || B.CODEBRANCH || B.DIGITCONTROL || BA.CODEACCOUNT || '.' || BA.DIGITCONTROL), BA.C_BANKACCOUNT_ID, ba.c_Currency_ID, ba.ad_client_id, ba.ad_org_id        ) AAA        
   235     GROUP BY (B.CODEBANK || '/' || B.CODEBRANCH || B.DIGITCONTROL || BA.CODEACCOUNT || '.' || BA.DIGITCONTROL), BA.C_BANKACCOUNT_ID, ba.c_Currency_ID, ba.ad_client_id, ba.ad_org_id        ) AAA        
   236     ORDER BY 1]]></queryString>
   236     ORDER BY 1]]></queryString>
   237 
   237 
   238 	<field name="BANKACCOUNT" class="java.lang.String"/>
   238 	<field name="BANKACCOUNT" class="java.lang.String"/>
   239 	<field name="INITIALBALANCE" class="java.math.BigDecimal"/>
   239 	<field name="INITIALBALANCE" class="java.math.BigDecimal"/>