X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/251480b566f6ab73f5546bb3fd303ccae9701d6e..4e2b549a28f09fdc749f380a3e8c458c4ff53273:/SL/RP.pm 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 )