X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_accounts.inc;h=1669d20005656ccff82c445f0f24dd4881870ea7;hb=50339ff6ffe3cbb2a6237cc6a922a98481c7a41f;hp=93dc8e716062bf8975f002216dde61825568b9b0;hpb=f301d5d26c8915521462bf044f704d139c957a7c;p=fa-stable.git

diff --git a/gl/includes/db/gl_db_bank_accounts.inc b/gl/includes/db/gl_db_bank_accounts.inc
index 93dc8e71..1669d200 100644
--- a/gl/includes/db/gl_db_bank_accounts.inc
+++ b/gl/includes/db/gl_db_bank_accounts.inc
@@ -318,14 +318,7 @@ function get_default_bank_account($curr)
 
 function get_default_customer_bank_account($cust_id)
 {
-	if ($cust_id == "")
-	{
-		$sql = "SELECT debtor_no FROM ".TB_PREF."debtors_master WHERE inactive=0 ORDER BY debtor_ref LIMIT 1";
-		$result = db_query($sql, "could not retreive first customer");
-		$row = db_fetch_row($result);
-		$cust_id = $row[0];
-	}
-	$sql = "SELECT curr_code FROM ".TB_PREF."debtors_master WHERE debtor_no=$cust_id";
+	$sql = "SELECT curr_code FROM ".TB_PREF."debtors_master WHERE debtor_no=".db_escape($cust_id);
 	$result = db_query($sql, "could not retreive default customer currency code");
 	$row = db_fetch_row($result);
 	$ba = get_default_bank_account($row[0]);
@@ -334,13 +327,6 @@ function get_default_customer_bank_account($cust_id)
 
 function get_default_supplier_bank_account($supplier_id)
 {
-	if ($supplier_id == "")
-	{
-		$sql = "SELECT supplier_id FROM ".TB_PREF."suppliers WHERE inactive=0 ORDER BY supp_ref LIMIT 1";
-		$result = db_query($sql, "could not retreive first supplier");
-		$row = db_fetch_row($result);
-		$supplier_id = $row[0];
-	}
 	$sql = "SELECT curr_code FROM ".TB_PREF."suppliers WHERE supplier_id=".db_escape($supplier_id);
 	$result = db_query($sql, "could not retreive default supplier currency code");
 	$row = db_fetch_row($result);