Fixes issue 0016173: the XLS generated in report trial balance is not correct
authorEgoitz Castillo <egoitz.castillo@openbravo.com>
Wed, 09 Mar 2011 11:14:44 +0100
changeset 11134 61f174927bf2
parent 11133 007b2aaac1de
child 11135 50c83574cdc9
Fixes issue 0016173: the XLS generated in report trial balance is not correct
Added an union all in the sql that shows the results in XLS.
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql	Wed Mar 09 11:07:36 2011 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql	Wed Mar 09 11:14:44 2011 +0100
@@ -295,7 +295,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,
                       c_bpartner.c_bpartner_id as bpid, m_product.m_product_id as pdid, c_project.c_project_id as pjid,