X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDN.pm;h=2cc87df2c3168946a07531be8f7b86ab8010aff8;hb=26353951881b5334436ab599ae3979f6df5d5258;hp=272bddc60933063edb47a4b167796c3afc74387a;hpb=496d86f07a9421aa64bb78f369e5279f67924a3e;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)