X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/144e96c1d8d6c966b9f6b3665f5a828b5ad44dc5..ed9b1bfb7:/SL/BackgroundJob/SelfTest/Transactions.pm?ds=sidebyside 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|;