From 24bcc8808379757aef39136d5bc20fbd557c53ae Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Mon, 14 Jan 2019 09:21:19 +0100 Subject: [PATCH] =?utf8?q?SelfTests:=20check=5Fap=5Fpaid=20ber=C3=BCcksich?= =?utf8?q?tigt=20Auswahl=20von=20fromdate=20und=20todate?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/BackgroundJob/SelfTest/Transactions.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/BackgroundJob/SelfTest/Transactions.pm b/SL/BackgroundJob/SelfTest/Transactions.pm index d953966c6..fea648642 100644 --- a/SL/BackgroundJob/SelfTest/Transactions.pm +++ b/SL/BackgroundJob/SelfTest/Transactions.pm @@ -480,7 +480,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%' OR ac.chart_link like '%IC_cogs%' + 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|; -- 2.20.1