From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Thu, 21 Dec 2017 07:13:56 +0000 (+0100)
Subject: subledger_list shows inactive records in Journal Entry. Fixed.
X-Git-Tag: v2.4.4~34
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=7e7db9763df89c4010903f960e7ac2f6c22ff654

subledger_list shows inactive records in Journal Entry. Fixed.
---

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');