details:   /erp/devel/pi/rev/c2393661413d
changeset: 8156:c2393661413d
user:      Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
date:      Mon Aug 16 10:59:54 2010 +0530
summary:   Fixes Issue 14074: Error with Opening entry in Trial Balance report

diffstat:

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

diffs (12 lines):

diff -r 68c8c4203f91 -r c2393661413d 
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql       
Fri Aug 13 14:34:37 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql       
Mon Aug 16 10:59:54 2010 +0530
@@ -134,7 +134,7 @@
                     AND F.AD_ORG_ID IN('1')
                     AND 1=1
                     AND F.ISACTIVE = 'Y')
-              UNION
+              UNION ALL
               (SELECT F.ACCOUNT_ID AS ID, EV.VALUE AS ACCOUNT_ID, EV.NAME AS 
NAME,
                      F.AMTACCTDR, F.AMTACCTCR, F.FACTACCTTYPE, F.DATEACCT,
                      CASE ?

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to