X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/9bd3030a376850c427c102c6e0c54f19bd19332e..6cf3f7762efd40bee49a2b8f11bb4ab6915d9071:/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 )