From 8320f5fcac33bcde50d2adcd724e0d19011fb4f9 Mon Sep 17 00:00:00 2001 From: Joe Date: Tue, 4 Apr 2023 16:54:53 +0200 Subject: [PATCH] Bug 5685: Bank Statement w/Reconcile report includes gl_trans values that are "0.00". Fixed. --- reporting/rep601.php | 1 - reporting/rep602.php | 1 + 2 files changed, 1 insertion(+), 1 deletion(-) diff --git a/reporting/rep601.php b/reporting/rep601.php index 2566216c..305ef97a 100644 --- a/reporting/rep601.php +++ b/reporting/rep601.php @@ -47,7 +47,6 @@ function get_bank_transactions($from, $to, $account) WHERE bank_act = '$account' AND trans_date >= '$from' AND trans_date <= '$to' - AND amount <> 0 ORDER BY trans_date, id"; return db_query($sql,"The transactions for '$account' could not be retrieved"); diff --git a/reporting/rep602.php b/reporting/rep602.php index dd7c5427..2c4021f0 100644 --- a/reporting/rep602.php +++ b/reporting/rep602.php @@ -51,6 +51,7 @@ function get_bank_transactions($from, $to, $account) WHERE trans.bank_act = '$account' AND trans_date >= '$from' AND trans_date <= '$to' + AND trans.amount <> 0 ORDER BY trans_date,trans.id"; return db_query($sql,"The transactions for '$account' could not be retrieved"); -- 2.30.2