Anständig quoten.

[kivitendo-erp.git] / SL / DN.pm

diff --git a/SL/DN.pm b/SL/DN.pm
index 2566cbed7621ddfd20c1a3b62da174ce809f28e2..4bf5d56baddd1d42f46ded64d08d0676f2cde2b6 100644 (file)
--- a/SL/DN.pm
+++ b/SL/DN.pm
@@ -324,7 +324,7 @@ sub get_invoices {
   my %columns = (
     "ordnumber" => "a.ordnumber",
     "invnumber" => "a.invnumber",
-    "notes" => "a.notes",
+    "notes"     => "a.notes",
     );
   foreach my $key (keys(%columns)) {
     next unless ($form->{$key});
@@ -333,7 +333,7 @@ sub get_invoices {
   }
 
   if ($form->{dunning_level}) {
-    $where .= qq| AND a.dunning_config_id = ?|;
+    $where .= qq| AND nextcfg.id = ?|;
     push(@values, conv_i($form->{dunning_level}));
   }
 
@@ -648,7 +648,7 @@ sub print_dunning {
     qq|SELECT
          cfg.interest_rate, cfg.template AS formname,
          cfg.email_subject, cfg.email_body, cfg.email_attachment,
-         d.fee, d.dunning_date,
+         d.fee, d.transdate AS dunning_date,
          (SELECT SUM(interest)
           FROM dunning
           WHERE dunning_id = ?)