details: https://code.openbravo.com/erp/stable/2.50/rev/4304705abf8e
changeset: 9900:4304705abf8e
user: Jon AlegrÃa <jon.alegria <at> openbravo.com>
date: Mon Oct 01 13:17:00 2012 +0200
summary: Fixes issue 0021757: Bank Report is not sorting data properly
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportBank_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 6c27023b8e86 -r 4304705abf8e
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'"/>
------------------------------------------------------------------------------
Got visibility?
Most devs has no idea what their production app looks like.
Find out how fast your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219671;13503038;y?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
