src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml
changeset 5069 b4990292ae3e
parent 3857 6d631363ffc7
child 5089 54767c398a62
--- a/src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml	Wed Sep 23 11:03:25 2009 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml	Wed Sep 23 11:19:02 2009 +0530
@@ -231,7 +231,7 @@
     FROM C_BANKSTATEMENTLINE BL,     
     C_BANKSTATEMENT     BS,           C_BANK              B,           C_BANKACCOUNT       BA     
     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'        
-    AND BS.STATEMENTDATE <= NOW()        AND 3=3    AND B.AD_CLIENT_ID IN (0,1000000)        AND B.AD_ORG_ID IN (1000000,0)        
+    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})       
     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        
     ORDER BY 1]]></queryString>