[Web-erp-svn] SF.net SVN: web-erp:[6261] trunk/CustomerReceipt.php

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

Revision: 6261
          http://sourceforge.net/p/web-erp/reponame/6261
Author:   tehonu
Date:     2013-08-20 01:54:00 +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/CustomerReceipt.php

Modified: trunk/CustomerReceipt.php
===================================================================
--- trunk/CustomerReceipt.php	2013-08-20 01:48:47 UTC (rev 6260)
+++ trunk/CustomerReceipt.php	2013-08-20 01:54:00 UTC (rev 6261)
@@ -750,9 +750,9 @@
 				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');
 $AccountsResults = DB_query($SQL,$db,$ErrMsg,$DbgMsg);