From 88286589319955ce2a0479a5d053e9bda2f0c777 Mon Sep 17 00:00:00 2001 From: Daniel Krieger Date: Mon, 4 Jun 2018 10:51:12 +0200 Subject: [PATCH] SelfTests: False Positive bei Buchungen auf ic_cogs als Sammelkonto vermeiden --- 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 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|; -- 2.20.1