X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/fd6900cca59ac4a35d5fa4c20db91165f9310ea3..69822fd215cb15e1bb017f1af6f0a185f62a31e2:/SL/DN.pm

diff --git a/SL/DN.pm b/SL/DN.pm
index 2566cbed7..4bf5d56ba 100644
--- 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 = ?)