X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/496d86f07a9421aa64bb78f369e5279f67924a3e..e7bb715fc64092d5868ab3bc246391f1fb3c81c7:/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)