X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FRP.pm;h=88f4ebe55de72d213780ec5ae35166ced9c30ac1;hb=f9676efea9ccfa01df2a57dca9c45cc8fde0d09e;hp=81637ca5b07b29d3791aa2415d767f090f9ab637;hpb=9bd3030a376850c427c102c6e0c54f19bd19332e;p=kivitendo-erp.git diff --git a/SL/RP.pm b/SL/RP.pm index 81637ca5b..88f4ebe55 100644 --- a/SL/RP.pm +++ b/SL/RP.pm @@ -1198,7 +1198,7 @@ sub aging { AND (exchangerate.transdate = ${arap}.transdate)) AS exchangerate FROM ${arap}, ${ct} WHERE ((paid != amount) OR (datepaid > (date $todate) AND datepaid is not null)) - AND (${arap}.storno IS FALSE) + AND NOT COALESCE (${arap}.storno, 'f') AND (${arap}.${ct}_id = ${ct}.id) AND (${ct}.id = ?) AND (transdate <= (date $todate) $fromwhere )