From 08e45c8dcf24bf4017357d63b83df313529e7c32 Mon Sep 17 00:00:00 2001 From: John Doe Date: Fri, 24 Mar 2023 18:16:36 +0000 Subject: [PATCH] Bug 29664: Removing void payments from the cash register report --- reports/cash_register_stats.pl | 1 + 1 file changed, 1 insertion(+) diff --git a/reports/cash_register_stats.pl b/reports/cash_register_stats.pl index c2b22f9db2..2e30e345ff 100755 --- a/reports/cash_register_stats.pl +++ b/reports/cash_register_stats.pl @@ -114,6 +114,7 @@ if ($do_it) { $whereTType $whereBranchCode $whereRegister + AND (al.credit_type_code NOT IN ('VOID') AND al.debit_type_code NOT IN ('VOID')) ORDER BY al.date "; my $sth_stats = $dbh->prepare($query) or die "Unable to prepare query " . $dbh->errstr; -- 2.30.2