projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Removed uniqueness on workorders.wo_ref key, removed obsolete additional_costs field...
[fa-stable.git]
/
manufacturing
/
includes
/
db
/
work_order_costing_db.inc
diff --git
a/manufacturing/includes/db/work_order_costing_db.inc
b/manufacturing/includes/db/work_order_costing_db.inc
index e44de122f7185eb1fd221ac6764dc15b2ead9c15..99cd1a5cfbd6304990cae54e5d617ba12a79e584 100644
(file)
--- a/
manufacturing/includes/db/work_order_costing_db.inc
+++ b/
manufacturing/includes/db/work_order_costing_db.inc
@@
-48,8
+48,8
@@
function update_material_cost($stock_id, $qty, $unit_cost, $date)
{
global $Refs;
{
global $Refs;
- $
product
= get_item($stock_id);
- $avg_cost = $
product
['material_cost'];
+ $
item
= get_item($stock_id);
+ $avg_cost = $
item
['material_cost'];
$qoh = get_qoh_on_date($stock_id, null, $date);
$qoh = get_qoh_on_date($stock_id, null, $date);
@@
-104,7
+104,7
@@
function update_material_cost($stock_id, $qty, $unit_cost, $date)
}
if ($qty > 0 && ($qoh != -$qty))
}
if ($qty > 0 && ($qoh != -$qty))
-
$avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty);
+ $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty);
$sql = "UPDATE ".TB_PREF."stock_master SET material_cost=".db_escape($avg_cost)."
WHERE stock_id=".db_escape($stock_id);
$sql = "UPDATE ".TB_PREF."stock_master SET material_cost=".db_escape($avg_cost)."
WHERE stock_id=".db_escape($stock_id);