X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FCA.pm;h=983f9bd0460f8ac619d5958d2af7b0139262f2cb;hb=eb07117b26f569d689835471cab6665e510e123e;hp=cee831609c0663e1fd451c6c9d7f3cc018acd267;hpb=25bc0205cd9e428a3c37cae0872360485ebc2bcb;p=kivitendo-erp.git

diff --git a/SL/CA.pm b/SL/CA.pm
index cee831609..983f9bd04 100644
--- a/SL/CA.pm
+++ b/SL/CA.pm
@@ -366,8 +366,8 @@ sub all_transactions {
   }
 
   my $sort = grep({ $form->{sort} eq $_ } qw(transdate reference description)) ? $form->{sort} : 'transdate';
-
-  $query .= qq|ORDER BY $sort|;
+  my $sort2 = ($sort eq 'reference')?'transdate':'reference';
+  $query .= qq|ORDER BY $sort , $sort2 |;
   my $sth = prepare_execute_query($form, $dbh, $query, @values);
 
   #get detail information for each transaction