Amendment Required in rep601.php for voided transactions. Fixed.
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Wed, 1 Jan 2020 15:51:21 +0000 (16:51 +0100)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Wed, 1 Jan 2020 15:51:21 +0000 (16:51 +0100)
reporting/rep601.php

index 079e3c1ff818fc6ce11d7f8c39105707809bdf2d..e5411bd5c8d425c533c4c9c10bf852af4aa67aeb 100644 (file)
@@ -47,6 +47,7 @@ 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");