Fixes issue 0017767: General ledge report is not showing correctly the
authorJon Alegría <jon.alegria@openbravo.com>
Fri, 22 Jul 2011 10:20:52 +0200
changeset 13250 f0e06340b593
parent 13249 34f013b87007
child 13251 9122806c6732
Fixes issue 0017767: General ledge report is not showing correctly the
information
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql	Fri Jul 22 09:55:07 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql	Fri Jul 22 10:20:52 2011 +0200
@@ -167,7 +167,7 @@
         WHERE 6=6
         GROUP BY VALUE, NAME, ID, FACTACCTTYPE, DATEACCT, FACT_ACCT_GROUP_ID, description, bpname, bpid, pdname, pdid, pjname, pjid, ISDEBIT
         HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0
-        ORDER BY VALUE, NAME, ID, FACTACCTTYPE, DATEACCT, FACT_ACCT_GROUP_ID, description,  bpname, bpid, pdname, pdid, pjname, pjid, ISDEBIT
+        ORDER BY VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, description,  bpname, bpid, pdname, pdid, pjname, pjid, ISDEBIT
       ]]></Sql>
     <Field name="rownum" value="count"/>
     <Parameter name="adLanguage"/>