X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/c09536f461b4933a1813b2af5e17eb6214f7bf38..3af1d16a776c63cdcf624bcc3eba3e8738ff0ccd:/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 )