SF.net SVN: ledger-smb:[5141] tags/1.3.22/LedgerSMB/PE.pm

[..hidden..]

Revision: 5141
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5141&view=rev
Author:   ehuelsmann
Date:     2012-10-05 21:18:48 +0000 (Fri, 05 Oct 2012)
Log Message:
-----------
Close bug 3559621: query error when generating sales orders from time cards.

Modified Paths:
--------------
    tags/1.3.22/LedgerSMB/PE.pm

Modified: tags/1.3.22/LedgerSMB/PE.pm
===================================================================
--- tags/1.3.22/LedgerSMB/PE.pm	2012-10-04 10:11:02 UTC (rev 5140)
+++ tags/1.3.22/LedgerSMB/PE.pm	2012-10-05 21:18:48 UTC (rev 5141)
@@ -1844,7 +1844,7 @@
                 LEFT JOIN company c ON eca.entity_id = c.entity_id
 		    WHERE pr.parts_id IS NULL
 		          AND j.allocated != j.qty $where
-		 ORDER BY pr.projectnumber, c.name, j.checkedin::date|;
+		 ORDER BY pr.projectnumber, c.legal_name, j.checkedin::date|;
     if ( $form->{summary} ) {
         $query =~ s/j\.description/p\.description/;
         $query =~ s/c\.name,/c\.name, j\.parts_id, /;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.