X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/552ed9ba654d034d3846934efe97470e16b4cabc..88286589319955ce2a0479a5d053e9bda2f0c777:/SL/BackgroundJob/SelfTest/Transactions.pm diff --git a/SL/BackgroundJob/SelfTest/Transactions.pm b/SL/BackgroundJob/SelfTest/Transactions.pm index d1842c3ee..b64966a74 100644 --- a/SL/BackgroundJob/SelfTest/Transactions.pm +++ b/SL/BackgroundJob/SelfTest/Transactions.pm @@ -479,7 +479,7 @@ sub check_ap_acc_trans_amount { my $query = qq| select sum(ac.amount) as amount, ap.invnumber,ap.netamount from acc_trans ac left join ap on (ac.trans_id = ap.id) - WHERE ac.chart_link like '%AP_amount%' + WHERE ac.chart_link like '%AP_amount%' OR ac.chart_link like '%IC_cogs%' AND ac.transdate >= ? AND ac.transdate <= ? group by invnumber,trans_id,netamount having sum(ac.amount) <> ap.netamount*-1|;