X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FRP.pm;h=70549a2c84e829db60b2b9f9e7e3156a1896a9b5;hb=606b21908d42b97e98769da21ba4bcc72c58f92d;hp=ef93e73bbe934b49bb75a784004c5dca66ad2179;hpb=29e70d36170f13f034474b9f5a831f727980a62f;p=kivitendo-erp.git diff --git a/SL/RP.pm b/SL/RP.pm index ef93e73bb..70549a2c8 100644 --- a/SL/RP.pm +++ b/SL/RP.pm @@ -1298,7 +1298,7 @@ sub aging { phone as customerphone, fax as customerfax, ${ct}number, "invnumber", "transdate", (amount - COALESCE((SELECT sum(amount)*$ml FROM acc_trans WHERE chart_link ilike '%paid%' AND acc_trans.trans_id=${arap}.id AND acc_trans.transdate <= (date $todate)),0)) as "open", "amount", - "duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays, + "duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays, datepaid, (SELECT $buysell FROM exchangerate WHERE (${arap}.currency_id = exchangerate.currency_id)