details: /erp/devel/pi/rev/61f174927bf2
changeset: 11134:61f174927bf2
user: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
date: Wed Mar 09 11:14:44 2011 +0100
summary: 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.
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 007b2aaac1de -r 61f174927bf2
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,
------------------------------------------------------------------------------
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
