From 5f8a4fc5783f6533add3015efc446574d9d8e96d Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Thu, 29 Sep 2016 12:56:17 +0200 Subject: [PATCH] =?utf8?q?Abteilung=20an=20Druckvorlage=20in=20Mahnungen?= =?utf8?q?=20=C3=BCbergeben?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DN.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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 -- 2.20.1