From c47544994b38a1540dd049075948493352ca6112 Mon Sep 17 00:00:00 2001 From: Joe Date: Sun, 25 Dec 2022 10:55:18 +0100 Subject: [PATCH] Reconcile Bank Account added filter up to reconcile data. --- gl/includes/db/gl_db_bank_accounts.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gl/includes/db/gl_db_bank_accounts.inc b/gl/includes/db/gl_db_bank_accounts.inc index ea9a83ac..08a05242 100644 --- a/gl/includes/db/gl_db_bank_accounts.inc +++ b/gl/includes/db/gl_db_bank_accounts.inc @@ -283,7 +283,7 @@ function get_sql_for_bank_account_reconcile($bank_account, $date) LEFT JOIN ".TB_PREF."comments c ON c.type = bt.type AND c.id = bt.trans_no WHERE bank_act = ".db_escape($bank_account) . " AND (reconciled IS NULL OR reconciled='". date2sql($date) ."') - AND amount != 0 + AND amount != 0 AND trans_date <= '". date2sql($date) ."' ORDER BY trans_date, bt.id"; return $sql; -- 2.30.2