From: Joe <joe.hunt.consulting@gmail.com>
Date: Tue, 4 Apr 2023 14:54:53 +0000 (+0200)
Subject: Bug 5685: Bank Statement w/Reconcile report includes gl_trans values that are "0... 
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=8320f5fcac33bcde50d2adcd724e0d19011fb4f9

Bug 5685: Bank Statement w/Reconcile report includes gl_trans values that are "0.00". Fixed.
---

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");