From 618b134c01c14489dba1ca0e186a8fb8c6adc83c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 22 Feb 2022 11:20:41 +0100 Subject: [PATCH] =?utf8?q?Mahungen:=20W=C3=A4hrung=20auch=20f=C3=BCr=20Dru?= =?utf8?q?ckvorlagen=20bereitstellen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Ansonsten erhält die kivitendo GmbH durch den subtilen marei default_account.tex zuviele ungeklärte Zahlungseingänge --- SL/DN.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/SL/DN.pm b/SL/DN.pm index d9d02a626..28eb6afc0 100644 --- a/SL/DN.pm +++ b/SL/DN.pm @@ -967,7 +967,7 @@ sub print_dunning { c.country, c.department_1, c.department_2, c.email, c.customernumber, c.greeting, c.contact, c.phone, c.fax, c.homepage, c.email, c.taxincluded, c.business_id, c.taxnumber, c.iban, - c.ustid, + c.ustid, c.currency_id, curr.name as currency, ar.id AS invoice_id, co.* FROM dunning d @@ -975,6 +975,7 @@ sub print_dunning { LEFT JOIN customer c ON (ar.customer_id = c.id) LEFT JOIN contacts co ON (ar.cp_id = co.cp_id) LEFT JOIN employee e ON (ar.salesman_id = e.id) + LEFT JOIN currencies curr ON (c.currency_id = curr.id) WHERE (d.dunning_id = ?) LIMIT 1|; my $ref = selectfirst_hashref_query($form, $dbh, $query, $dunning_id); -- 2.20.1