Fixes issue 0021757: Bank Report is not sorting data properly
authorJon Alegría <jon.alegria@openbravo.com>
Mon, 01 Oct 2012 13:17:00 +0200
changeset 9900 4304705abf8e
parent 9899 6c27023b8e86
child 9901 932a4ed2c8e6
Fixes issue 0021757: Bank Report is not sorting data properly
src/org/openbravo/erpCommon/ad_reports/ReportBank_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportBank_data.xsql	Mon Oct 01 12:45:21 2012 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportBank_data.xsql	Mon Oct 01 13:17:00 2012 +0200
@@ -42,7 +42,7 @@
       AND C_BANK.AD_ORG_ID IN ('1')
       AND 1=1
       AND C_BANKSTATEMENT.PROCESSED='Y'
-      ORDER BY NAME,STATEMENTDATE, LINE
+      ORDER BY (C_BANK.CODEBANK || '/' || C_BANK.CODEBRANCH || C_BANK.DIGITCONTROL || C_BANKACCOUNT.CODEACCOUNT || '.' || C_BANKACCOUNT.DIGITCONTROL), STATEMENTDATE, LINE
      ]]></Sql>
     <Parameter name="adUserClient" type="replace" optional="true" after="AND C_BANK.AD_CLIENT_ID IN (" text="'1'"/>
     <Parameter name="adUserOrg" type="replace" optional="true" after="AND C_BANK.AD_ORG_ID IN (" text="'1'"/>