details:   /erp/devel/pi/rev/5c2f05f9b7ce
changeset: 6533:5c2f05f9b7ce
user:      Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
date:      Mon Mar 01 15:29:16 2010 +0530
summary:   periodcontrolstatus is not required to get start date of the year.

diffstat:

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

diffs (11 lines):

diff -r 39934462fbec -r 5c2f05f9b7ce 
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql      
Mon Mar 01 14:46:02 2010 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql      
Mon Mar 01 15:29:16 2010 +0530
@@ -248,7 +248,6 @@
         WHERE Y.C_YEAR_ID = P.C_YEAR_ID
           AND P.C_PERIOD_ID = PC.C_PERIOD_ID
           AND P.STARTDATE <= TO_DATE(?)
-          AND PC.PERIODSTATUS = 'O'
           AND PC.AD_CLIENT_ID IN ('1')
           AND PC.AD_ORG_ID IN ('1')
         GROUP BY Y.YEAR

------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to