X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FRP.pm;h=28d01af19c7572ab34c65db403679a1b79a42d35;hb=1b032ef45d886922f1fe347ec234c9b0c8c50efd;hp=80e83d56912249e66349a235015d6e5a38672a4b;hpb=33ddf79cc8c6a43ed1661a1f04002d62cdf264eb;p=kivitendo-erp.git diff --git a/SL/RP.pm b/SL/RP.pm index 80e83d569..28d01af19 100644 --- a/SL/RP.pm +++ b/SL/RP.pm @@ -1296,7 +1296,7 @@ sub aging { SELECT ${ct}.id AS ctid, ${ct}.name, street, zipcode, city, country, contact, email, phone as customerphone, fax as customerfax, ${ct}number, - "invnumber", "transdate", + "invnumber", "transdate", "type", (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, datepaid, (amount - paid) as current_open, (SELECT $buysell