." AND item.units=unit.abbr";
$result = db_query($sql, "The standard cost cannot be retrieved");
- return db_fetch($result);
+ $row = db_fetch($result);
+ if (is_array($row) && $row['decimals'] == -1)
+ $row['decimals'] = user_qty_dec();
+ return $row;
}
//--------------------------------------------------------------------------------------
$myrow = db_fetch_row($result);
- return $myrow[0];
+ return is_array($myrow) ? $myrow[0] : false;
+}
+
+//--------------------------------------------------------------------------------------
+
+function get_purchase_cost($stock_id)
+{
+ $sql = "SELECT purchase_cost
+ FROM ".TB_PREF."stock_master
+ WHERE stock_id=".db_escape($stock_id);
+ $result = db_query($sql, "The purchase cost cannot be retrieved");
+
+ $myrow = db_fetch_row($result);
+
+ return is_array($myrow) ? $myrow[0] : false;
}
//--------------------------------------------------------------------------------------
AND type=".ST_CUSTDELIVERY." AND trans_no=".db_escape($trans_no);
$result = db_query($sql, "Could not get stock moves");
$row = db_fetch_row($result);
- return $row[0];
+ return is_array($row) ? $row[0] : false;
}
/*
Returns start move_id in latest negative status period for $stock_id
{
/*Gets the GL Codes relevant to the item account */
$sql = "SELECT mb_flag, inventory_account, cogs_account,
- adjustment_account, sales_account, assembly_account, dimension_id, dimension2_id FROM
+ adjustment_account, sales_account, wip_account, dimension_id, dimension2_id FROM
".TB_PREF."stock_master WHERE stock_id = ".db_escape($stock_id);
$get = db_query($sql,"retreive stock gl code");
$result = db_query($sql,"retreive stock purchase price");
$row = db_fetch_row($result);
- return $row[0];
+ return is_array($row) ? $row[0] : false;
}
function update_purchase_value($stock_id, $price)