X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FRP.pm;h=28d01af19c7572ab34c65db403679a1b79a42d35;hb=1b032ef45d886922f1fe347ec234c9b0c8c50efd;hp=70549a2c84e829db60b2b9f9e7e3156a1896a9b5;hpb=606b21908d42b97e98769da21ba4bcc72c58f92d;p=kivitendo-erp.git

diff --git a/SL/RP.pm b/SL/RP.pm
index 70549a2c8..28d01af19 100644
--- a/SL/RP.pm
+++ b/SL/RP.pm
@@ -1296,9 +1296,9 @@ 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,
+      "duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays, datepaid, (amount - paid) as current_open,
       (SELECT $buysell
        FROM exchangerate
        WHERE (${arap}.currency_id = exchangerate.currency_id)