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

diff --git a/reporting/rep601.php b/reporting/rep601.php
index 2566216c5b981fe229ae65ffe3b6d57d6f4f113f..305ef97a4ffd39e73c32ad73f76952e4bbb0fcbe 100644 (file)
--- 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 dd7c5427fefecac9c9d2ad4c7b0c543a0fb9a1ee..2c4021f00aa3be36e6ab90e63671dba20f83d4cf 100644 (file)
--- 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");