From 7e7db9763df89c4010903f960e7ac2f6c22ff654 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Thu, 21 Dec 2017 08:13:56 +0100 Subject: [PATCH] subledger_list shows inactive records in Journal Entry. Fixed. --- includes/ui/ui_lists.inc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index eab6f4fa..35fc2b70 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -2637,12 +2637,12 @@ function subledger_list($name, $account, $selected_id=null) FROM " .TB_PREF."debtors_master d," .TB_PREF."cust_branch c - WHERE d.debtor_no=c.debtor_no AND c.receivables_account=".db_escape($account); + WHERE d.debtor_no=c.debtor_no AND NOT d.inactive AND c.receivables_account=".db_escape($account); else $sql = "SELECT supplier_id as id, supp_ref as name FROM " .TB_PREF."suppliers s - WHERE s.payable_account=".db_escape($account); + WHERE NOT s.inactive AND s.payable_account=".db_escape($account); $mode = get_company_pref('no_customer_list'); -- 2.30.2