From f1c4ee42e28b01cf0317b61caba5c49fc65b72fc 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..ad8174be23 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.debit_type_code NOT IN (SELECT code FROM account_debit_types WHERE description = 'Void payment') $whereTType $whereBranchCode $whereRegister -- 2.30.2