details: https://code.openbravo.com/erp/devel/pi/rev/dde84b1e4ad5
changeset: 18511:dde84b1e4ad5
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Fri Nov 09 12:34:14 2012 +0100
summary: Fixed issue 22243 Show Opening, closing and regularization entries
in JER
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql |
21 ++-------
1 files changed, 6 insertions(+), 15 deletions(-)
diffs (45 lines):
diff -r c609be6c16ed -r dde84b1e4ad5
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
---
a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
Fri Nov 09 07:39:22 2012 +0000
+++
b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
Fri Nov 09 12:34:14 2012 +0100
@@ -47,11 +47,8 @@
GROUP BY f.C_ACCTSCHEMA_ID, SC.NAME, F.AD_TABLE_ID, F.DATEACCT,
F.ACCTDESCRIPTION, F.DESCRIPTION, F.ACCTVALUE, F.DOCBASETYPE, F.RECORD_ID,
F.FACT_ACCT_GROUP_ID, F.ACCOUNT_ID,F.FACTACCTTYPE,
(CASE F.AMTACCTDR WHEN 0 THEN (CASE SIGN(F.AMTACCTCR) WHEN -1 THEN 1
ELSE 2 END) ELSE (CASE SIGN(F.AMTACCTDR) WHEN -1 THEN 3 ELSE 4 END) END),
F.AD_CLIENT_ID
- HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA,
- AD_REF_LIST_V AR
- WHERE AR.VALUE=AA.DOCBASETYPE
- AND AR.AD_REFERENCE_ID = '183'
- AND AD_LANGUAGE=?
+ HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA
+ LEFT JOIN (select * from AD_REF_LIST_V WHERE AD_REFERENCE_ID = '183'
AND AD_LANGUAGE=?) AR ON AR.VALUE=AA.DOCBASETYPE
ORDER BY SCHEMA_NAME, DATEACCT, FACTACCTTYPE2, IDENTIFIER, ORD, SEQNO
]]></Sql>
<Field name="rownum" value="count"/>
@@ -173,11 +170,8 @@
GROUP BY f.C_ACCTSCHEMA_ID, SC.NAME, F.AD_TABLE_ID, F.DATEACCT,
F.ACCTDESCRIPTION, F.DESCRIPTION, F.ACCTVALUE, F.DOCBASETYPE, F.RECORD_ID,
F.FACT_ACCT_GROUP_ID, F.ACCOUNT_ID,F.FACTACCTTYPE,
(CASE F.AMTACCTDR WHEN 0 THEN (CASE SIGN(F.AMTACCTCR) WHEN -1 THEN 1
ELSE 2 END) ELSE (CASE SIGN(F.AMTACCTDR) WHEN -1 THEN 3 ELSE 4 END) END),
F.AD_CLIENT_ID
- HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA,
- AD_REF_LIST_V AR
- WHERE AR.VALUE=AA.DOCBASETYPE
- AND AR.AD_REFERENCE_ID = '183'
- AND AD_LANGUAGE=?
+ HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA
+ LEFT JOIN (select * from AD_REF_LIST_V WHERE AD_REFERENCE_ID = '183'
AND AD_LANGUAGE=?) AR ON AR.VALUE=AA.DOCBASETYPE
ORDER BY SCHEMA_NAME, DATEACCT, FACTACCTTYPE2, IDENTIFIER, ORD, SEQNO
]]></Sql>
<Field name="rownum" value="count"/>
@@ -238,11 +232,8 @@
GROUP BY f.C_ACCTSCHEMA_ID, SC.NAME, F.AD_TABLE_ID, F.DATEACCT,
F.ACCTDESCRIPTION, F.DESCRIPTION , F.ACCTVALUE, F.DOCBASETYPE, F.RECORD_ID,
F.FACT_ACCT_GROUP_ID, F.ACCOUNT_ID,F.FACTACCTTYPE,
(CASE F.AMTACCTDR WHEN 0 THEN (CASE SIGN(F.AMTACCTCR) WHEN -1 THEN 1
ELSE 2 END) ELSE (CASE SIGN(F.AMTACCTDR) WHEN -1 THEN 3 ELSE 4 END) END),
F.AD_CLIENT_ID
- HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA,
- AD_REF_LIST_V AR
- WHERE AR.VALUE=AA.DOCBASETYPE
- AND AR.AD_REFERENCE_ID = '183'
- AND AD_LANGUAGE=?
+ HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA
+ LEFT JOIN (select * from AD_REF_LIST_V WHERE AD_REFERENCE_ID = '183'
AND AD_LANGUAGE=?) AR ON AR.VALUE=AA.DOCBASETYPE
ORDER BY SCHEMA_NAME, DATEACCT, FACTACCTTYPE2, IDENTIFIER, ORD, SEQNO
]]></Sql>
<Field name="rownum" value="count"/>
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
