[Web-erp-svn] SF.net SVN: web-erp:[6260] trunk/Payments.php

[<te...@us...>]

Revision: 6260
          http://sourceforge.net/p/web-erp/reponame/6260
Author:   tehonu
Date:     2013-08-20 01:48:47 +0000 (Tue, 20 Aug 2013)
Log Message:
-----------
Added ORDER BY accountname (If accountcode is not shown to user, order should be by name)

Modified Paths:
--------------
    trunk/Payments.php

Modified: trunk/Payments.php
===================================================================
--- trunk/Payments.php	2013-08-19 13:06:10 UTC (rev 6259)
+++ trunk/Payments.php	2013-08-20 01:48:47 UTC (rev 6260)
@@ -763,7 +763,8 @@
 				bankaccounts.accountcode,
 				bankaccounts.currcode
 		FROM bankaccounts INNER JOIN chartmaster
-		ON bankaccounts.accountcode=chartmaster.accountcode";
+		ON bankaccounts.accountcode=chartmaster.accountcode
+		ORDER BY bankaccountname";
 
 $ErrMsg = _('The bank accounts could not be retrieved because');
 $DbgMsg = _('The SQL used to retrieve the bank accounts was');