details: /erp/devel/pi/rev/88101b1f1a5f
changeset: 7424:88101b1f1a5f
user: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
date: Tue May 25 17:07:25 2010 +0530
summary: Fixes Issue 13162: trial balance report is wrong if exist records of
type \"opening\" similars
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 7924cbae6784 -r 88101b1f1a5f
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
Tue May 25 16:31:51 2010 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
Tue May 25 17:07:25 2010 +0530
@@ -402,7 +402,7 @@
AND F.AD_ORG_ID IN ('1')
AND F.AD_CLIENT_ID IN ('1')
AND F.ISACTIVE = 'Y')
- UNION
+ UNION ALL
(SELECT F.ACCOUNT_ID AS ACCOUNT_ID, F.AMTACCTDR AS AMTACCTDR,
F.AMTACCTCR AS AMTACCTCR,
F.DATEACCT, F.FACTACCTTYPE
FROM FACT_ACCT F
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
