[OpenbravoERP-commits] devel/pi: Fixes Issue 12334: General Ledger report shown an unco...

[hg]

details:   /erp/devel/pi/rev/39934462fbec
changeset: 6532:39934462fbec
user:      Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
date:      Mon Mar 01 14:46:02 2010 +0530
summary:   Fixes Issue 12334: General Ledger report shown an uncorrect SALDO

diffstat:

 src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql |  12 
+++++----
 1 files changed, 7 insertions(+), 5 deletions(-)

diffs (29 lines):

diff -r 3ce4a6009c15 -r 39934462fbec 
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql      
Mon Mar 01 00:56:17 2010 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql      
Mon Mar 01 14:46:02 2010 +0530
@@ -244,18 +244,20 @@
       FROM
         (
         SELECT MIN(P.STARTDATE) AS INI
-        FROM C_YEAR Y, C_PERIOD P
+        FROM C_YEAR Y, C_PERIOD P, C_PERIODCONTROL PC
         WHERE Y.C_YEAR_ID = P.C_YEAR_ID
+          AND P.C_PERIOD_ID = PC.C_PERIOD_ID
           AND P.STARTDATE <= TO_DATE(?)
-          AND P.AD_CLIENT_ID IN ('1')
-          AND P.AD_ORG_ID IN ('1')
+          AND PC.PERIODSTATUS = 'O'
+          AND PC.AD_CLIENT_ID IN ('1')
+          AND PC.AD_ORG_ID IN ('1')
         GROUP BY Y.YEAR
         ) PERIOD
       ]]></Sql>
       <Parameter name="dateTemplate"/>
       <Parameter name="date"/>
-      <Parameter name="client" type="replace" optional="true" after="AND 
P.AD_CLIENT_ID IN (" text="'1'"/>
-      <Parameter name="orgs" type="replace" optional="true" after="AND 
P.AD_ORG_ID IN (" text="'1'"/>
+      <Parameter name="client" type="replace" optional="true" after="AND 
PC.AD_CLIENT_ID IN (" text="'1'"/>
+      <Parameter name="orgs" type="replace" optional="true" after="AND 
PC.AD_ORG_ID IN (" text="'1'"/>
    </SqlMethod>
 
   <SqlMethod name="selectSubaccountDescription" type="preparedStatement" 
return="string">

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits