From 553e30a239caee854e1109d4aa96b42f78aae2d1 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..e29272a161 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 NOT IN (SELECT code FROM account_credit_types WHERE description = 'Void payment') $whereTType $whereBranchCode $whereRegister -- 2.30.2