there is a simple way for doing it, if someone can add a separate line for such charges after the items costs it would solve the problem, if it is already placed please refer me to that forum topic if not then lets discuss how it can be acheived.

Any idea what makes it negative and how can we rectify to make the unit cost turn into positive

I used view page source on items.php and the following is shown.

<tr><td class='label'>Item Code:</td><td><input  type="text" name="NewStockID" size="26" maxlength="25" value=""></td>

I used version FA 2.4.13

Secondly, the standard cost is frequently negative and the auto cost update is a headache because of lack of trail. Why the inventory valuation rate is different than standard cost? Is standard cost calculated based on average cost? If yes then when the standard cost is manually updated, should not it affect the inventory valuation?

Can someone explain in detail how the inventory costing can managed and how to stop cost update.

P.S. accounting norms does not allow cost updates. Can this be made optional in system settings ?

I am writing to inquire about the calculation of unit cost in the inventory valuation report of Front Accounting for a particular item in my inventory. The item in question is 105aps, and I have the following information:

Opening stock of 15 pieces purchased at a rate of 1,637.16
Purchase of 65 pieces at a rate of 1,708.85 in the last tax period
Purchase of 25 pieces at a rate of 2,034.51 in the last tax period
Currently, there are 9 pieces left in stock
I have noticed that the inventory valuation report in Front Accounting shows a unit cost of 1,776.15 for this item. However, I would like to understand how this unit cost is being calculated, including the purchasing prices, opening stock price, and inventory price, as well as the final unit value price.

Could you please provide me with a detailed explanation of the calculation method used to determine the unit cost in the inventory valuation report? I would greatly appreciate it if you could also provide a breakdown of the purchasing prices, opening stock price, and inventory price that contribute to the final unit value price.

Thank you for your time and assistance in this matter. I look forward to your response."

When is standard cost calculated? At purchase order? Or invoice payment... or some other transaction?

And is standard cost affected by the most recent currency rate as seen in the Exchange Rates page?

Any clarification on this is appreciated.

$page_security = "SA_ITEM";
$path_to_root = "../..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/inventory/includes/db/items_db.inc");

$mode = get_company_pref('no_item_list');
if ($mode != 0)
    $js = get_js_set_combo_item();
else
    $js = get_js_select_combo_item();

page(_($help_context = "Items"), true, false, "", $js);

if(get_post("search")) {
  $Ajax->activate("item_tbl");
}

start_form(false, false, $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING']);

start_table(TABLESTYLE_NOBORDER);

start_row();

text_cells(_("Description"), "description");
submit_cells("search", _("Search"), "", _("Search items"), "default");

end_row();

end_table();

end_form();

div_start("item_tbl");
start_table(TABLESTYLE);

$th = array("", _("No"), _("Item Code"), _("Description"), _("Category"), _("Remaining Stock"), _("Sale Price USD"), _("Promotion Price"), _("Image"));
table_header($th);

$k = 0;
$name = $_GET["client_id"];
$result = get_items_search(get_post("description"), @$_GET['type']);

while ($myrow = db_fetch_assoc($result))
{
    alt_table_row_color($k);
    $value = $myrow['item_code'];
    if ($mode != 0) {
        $text = $myrow['description'];
          ahref_cell(_("Select"), 'javascript:void(0)', '', 'setComboItem(window.opener.document, "'.$name.'",  "'.$value.'", "'.$text.'")');
    }
    else {
          ahref_cell(_("Select"), 'javascript:void(0)', '', 'selectComboItem(window.opener.document, "'.$name.'", "'.$value.'")');
    }
    label_cell($showid);
      label_cell($myrow["item_code"]);
    label_cell($myrow["description"]);
      label_cell($myrow["category"]);
    label_cell($myrow['???']);
    label_cell($myrow['???']);
    label_cell($myrow['???']);
        label_cell($myrow['???']);
    end_row();
}

end_table(1);

div_end();
end_page(true);