details: /erp/stable/2.50/rev/d276a24c4ada
changeset: 9270:d276a24c4ada
user: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
date: Wed Mar 09 10:41:27 2011 +0100
summary: Fixes issue 0015850: the XLS generated in report trial balance is
not correct
Added an union all in the sql that shows the results in XLS.
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 96d35f520e14 -r d276a24c4ada
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
Wed Mar 09 10:37:37 2011 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
Wed Mar 09 10:41:27 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,
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
