Issue #24199:exclude when gltrans_deleted

diff --git a/foundation-database/public/tables/metasql/bankrec-clearedbalance.mql b/foundation-database/public/tables/metasql/bankrec-clearedbalance.mql
index d251cd2..c643759 100644 (file)
--- a/foundation-database/public/tables/metasql/bankrec-clearedbalance.mql
+++ b/foundation-database/public/tables/metasql/bankrec-clearedbalance.mql
@@ -16,6 +16,7 @@ SELECT (COALESCE(SUM(amount),0.0) + <? value("begBal") ?>) AS cleared_amount,
             AND (bankrecitem_source_id=gltrans_id)
             AND (bankrecitem_bankrec_id=<? value("bankrecid") ?>)
             AND (bankrecitem_cleared)
+            AND (NOT gltrans_deleted)
             AND (NOT gltrans_rec)
             AND (bankaccnt_id=<? value("bankaccntid") ?>) ) 
           UNION ALL

diff --git a/foundation-database/public/tables/metasql/bankrecHistory-reconciled.mql b/foundation-database/public/tables/metasql/bankrecHistory-reconciled.mql
index e6db42d..7fd754b 100644 (file)
--- a/foundation-database/public/tables/metasql/bankrecHistory-reconciled.mql
+++ b/foundation-database/public/tables/metasql/bankrecHistory-reconciled.mql
@@ -36,7 +36,8 @@ SELECT gltrans_id, gltrans_date, formatDate(gltrans_date) AS f_date,
     JOIN bankaccnt ON (bankaccnt_id=bankrec_bankaccnt_id)
  WHERE ((bankrecitem_bankrec_id=<? value("bankrec_id") ?>)
    AND (bankrecitem_source='GL')
-   AND (bankrecitem_source_id=gltrans_id) ) 
+   AND (bankrecitem_source_id=gltrans_id)
+   AND (NOT gltrans_deleted) ) 
 
 UNION