Steuern nach Steuerschlüssel und Steuersatz ordnen

Steuern wurden bisher immer nur nach Steuerschlüssel geordnet. Jetzt
wird eine neue Untersortierung verwendet (Steuersatz).

diff --git a/SL/AM.pm b/SL/AM.pm
index 0c3c835..c85c479 100644 (file)
--- a/SL/AM.pm
+++ b/SL/AM.pm
@@ -1717,7 +1717,7 @@ sub taxes {
                    (SELECT accno FROM chart WHERE id = chart_id) AS taxnumber,
                    (SELECT description FROM chart WHERE id = chart_id) AS account_description
                  FROM tax t
-                 ORDER BY taxkey|;
+                 ORDER BY taxkey, rate|;
 
   my $sth = $dbh->prepare($query);
   $sth->execute || $form->dberror($query);

diff --git a/SL/Form.pm b/SL/Form.pm
index 810891e..7b5d257 100644 (file)
--- a/SL/Form.pm
+++ b/SL/Form.pm
@@ -2106,7 +2106,7 @@ sub _get_taxcharts {
 
   my $where = @where ? ' WHERE ' . join(' AND ', map { "($_)" } @where) : '';
 
-  my $query = qq|SELECT * FROM tax $where ORDER BY taxkey|;
+  my $query = qq|SELECT * FROM tax $where ORDER BY taxkey, rate|;
 
   $self->{$key} = selectall_hashref_query($self, $dbh, $query);