From d5dee66fbe81b6edb12d1c29737937acc5bf21a5 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 21 May 2013 13:10:21 +0200 Subject: [PATCH] RP aging(): Anpassung auf curr => currency_id --- SL/RP.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/RP.pm b/SL/RP.pm index 65cb30295..095f7581c 100644 --- a/SL/RP.pm +++ b/SL/RP.pm @@ -1238,7 +1238,7 @@ sub aging { "duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays, (SELECT $buysell FROM exchangerate - WHERE (${arap}.curr = exchangerate.curr) + WHERE (${arap}.currency_id = exchangerate.currency_id) AND (exchangerate.transdate = ${arap}.transdate)) AS exchangerate FROM ${arap}, ${ct} WHERE ((paid != amount) OR (datepaid > (date $todate) AND datepaid is not null)) -- 2.20.1