X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/64a301e55d72df9005e35647a2f166d978c1d8de..e1f93c184a9f6fe0826306383f23c454011dc9b3:/SL/DN.pm diff --git a/SL/DN.pm b/SL/DN.pm index 8191c5c19..5dd6fe918 100644 --- a/SL/DN.pm +++ b/SL/DN.pm @@ -799,7 +799,8 @@ sub print_dunning { ar.transdate, ar.duedate, ar.customer_id, ar.invnumber, ar.ordnumber, ar.cp_id, ar.amount, ar.netamount, ar.paid, - (SELECT cu.name FROM currencies cu WHERE cu.id=ar.currency_id) AS curr, + (SELECT cu.name FROM currencies cu WHERE cu.id = ar.currency_id) AS curr, + (SELECT description from department WHERE id = ar.department_id) AS department, ar.amount - ar.paid AS open_amount, ar.amount - ar.paid + da.fee + da.interest AS linetotal