X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/3431644a1a66b9d3394002c1d297acc72512c3a6..fe8d6c893279abaa76ea3e20424bbf5d66de071e:/SL/DN.pm

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)