From b92770c71959c10c35321f585ff670fd567bcb66 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Mon, 14 Feb 2022 10:39:33 +0100 Subject: [PATCH] =?utf8?q?SelfTest:=20ar=5Famount=20nicht=20bei=20Anzahlun?= =?utf8?q?gs-=20oder=20Schlu=C3=9Frechnungen=20pr=C3=BCfen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/BackgroundJob/SelfTest/Transactions.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/SL/BackgroundJob/SelfTest/Transactions.pm b/SL/BackgroundJob/SelfTest/Transactions.pm index 9eda7222c..ab145cece 100644 --- a/SL/BackgroundJob/SelfTest/Transactions.pm +++ b/SL/BackgroundJob/SelfTest/Transactions.pm @@ -472,6 +472,7 @@ sub check_ar_acc_trans_amount { from acc_trans ac left join ar on (ac.trans_id = ar.id) WHERE ac.chart_link like 'AR_amount%' AND ac.transdate >= ? AND ac.transdate <= ? + AND ar.type = 'invoice' group by invnumber,netamount having sum(ac.amount) <> ar.netamount|; my $ar_amount_not_ac_amount = selectall_hashref_query($::form, $self->dbh, $query, $self->fromdate, $self->todate); -- 2.20.1