X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=taxes%2Fitem_tax_types.php;h=549b7fc0ce97afc0e9b9baba6c7bfab26b56f215;hb=02dd4aefa3e3babb64d61140bb7f7de14e37f755;hp=f1414efcfe084145479ad4ac5c8ef2c80224bb7f;hpb=d2cc0860eccf02eaefcd90731ac3af141a841529;p=fa-stable.git

diff --git a/taxes/item_tax_types.php b/taxes/item_tax_types.php
index f1414efc..549b7fc0 100644
--- a/taxes/item_tax_types.php
+++ b/taxes/item_tax_types.php
@@ -72,10 +72,7 @@ if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
 
 function can_delete($selected_id)
 {
-	$sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE tax_type_id=".db_escape($selected_id);
-	$result = db_query($sql, "could not query stock master");
-	$myrow = db_fetch_row($result);
-	if ($myrow[0] > 0) 
+	if (key_in_foreign_table($selected_id, 'stock_master', 'tax_type_id'))
 	{
 		display_error(_("Cannot delete this item tax type because items have been created referring to it."));
 		return false;
@@ -149,7 +146,7 @@ if ($selected_id != -1)
 {
 	if ($Mode == 'Edit') {
    		$myrow = get_item_tax_type($selected_id);
-    
+   		unset($_POST); // clear exemption checkboxes
    		$_POST['name']  = $myrow["name"];
    		$_POST['exempt']  = $myrow["exempt"];