From f3dded9eaaa9e0744c26b78560a875a7ed0673b8 Mon Sep 17 00:00:00 2001 From: John Doe Date: Fri, 24 Mar 2023 17:49:42 +0000 Subject: [PATCH] Bug 29664: Removing void payments from cash_register_stats --- 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..1d93f078a1 100755 --- a/reports/cash_register_stats.pl +++ b/reports/cash_register_stats.pl @@ -111,6 +111,7 @@ if ($do_it) { LEFT JOIN account_credit_types act ON (al.credit_type_code = act.code) LEFT JOIN account_debit_types adt ON (al.debit_type_code = adt.code) WHERE CAST(al.date AS DATE) BETWEEN ? AND ? + AND al.credit_type_code <> 'VOID' -- Exclude VOID payments $whereTType $whereBranchCode $whereRegister -- 2.30.2