X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDN.pm;h=2cc87df2c3168946a07531be8f7b86ab8010aff8;hb=fe8d6c893279abaa76ea3e20424bbf5d66de071e;hp=272bddc60933063edb47a4b167796c3afc74387a;hpb=3431644a1a66b9d3394002c1d297acc72512c3a6;p=kivitendo-erp.git

diff --git a/SL/DN.pm b/SL/DN.pm
index 272bddc60..2cc87df2c 100644
--- a/SL/DN.pm
+++ b/SL/DN.pm
@@ -504,7 +504,12 @@ sub get_invoices {
               ORDER BY dunning_level ASC
               LIMIT 1)
              , ?))
-       LEFT JOIN dunning d ON ((d.trans_id = a.id) AND (cfg.dunning_level = d.dunning_level))
+       LEFT JOIN dunning d ON (d.id = (
+         SELECT MAX(d2.id)
+         FROM dunning d2
+         WHERE (d2.trans_id      = a.id)
+           AND (d2.dunning_level = cfg.dunning_level)
+       ))
 
        WHERE (a.paid < a.amount)
          AND (a.duedate < current_date)