<?php
/**********************************************************************
Copyright (C) FrontAccounting, LLC.
- Released under the terms of the GNU Affero General Public License,
- AGPL, as published by the Free Software Foundation, either version
- 3 of the License, or (at your option) any later version.
+ Released under the terms of the GNU General Public License, GPL,
+ as published by the Free Software Foundation, either version 3
+ of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
- See the License here <http://www.gnu.org/licenses/agpl-3.0.html>.
+ See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
//------------------- update average material cost ------------------------------------------ Joe Hunt Mar-03-2008
$exclude = 0;
$qoh = get_qoh_on_date($stock_id, null, $date, $exclude);
- if ($qoh + $qty <= 0)
- $material_cost = 0;
- else
+ if ($adj_only)
{
- if ($adj_only)
- {
- if ($qoh <= 0)
- $material_cost = 0;
- else
- $material_cost = ($qoh * $material_cost + $qty * $price_in_home_currency) / $qoh;
- }
+ if ($qoh <= 0)
+ $material_cost = 0;
else
- $material_cost = ($qoh * $material_cost + $qty * $price_in_home_currency) / ($qoh + $qty);
+ $material_cost = ($qoh * $material_cost + $qty * $price_in_home_currency) / $qoh;
}
+ elseif ($qoh + $qty <= 0)
+ $material_cost = 0;
+ else
+ $material_cost = ($qoh * $material_cost + $qty * $price_in_home_currency) / ($qoh + $qty);
+
$sql = "UPDATE ".TB_PREF."stock_master SET material_cost=".db_escape($material_cost)."
WHERE stock_id='$stock_id'";
db_query($sql,"The cost details for the inventory item could not be updated");
function add_grn(&$po, $date_, $reference, $location)
{
+ global $Refs;
+
begin_transaction();
$grn = add_grn_batch($po->order_no, $po->supplier_id, $reference, $location, $date_);
} /*quantity received is != 0 */
} /*end of order_line loop */
- references::save_last($reference, 25);
+ $Refs->save(25, $grn, $reference);
+
+ add_audit_trail(25, $grn, $date_);
commit_transaction();
$sql = "UPDATE ".TB_PREF."purch_order_details
SET quantity_received = quantity_received + $entered_grn->this_quantity_inv,
+ quantity_ordered = quantity_ordered + $entered_grn->this_quantity_inv,
+ qty_invoiced = qty_invoiced + $entered_grn->this_quantity_inv,
std_cost_unit=$mcost,
act_price=$entered_grn->chg_price
WHERE po_detail_item = ".$myrow["po_detail_item"];