{
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);
{
// post $qty_delayed*($avg_cost-$unit_cost)
$diff = $qty_delayed*($unit_cost-$avg_cost);
- $stock_gl_code = get_item($stock_id);
$dec = user_price_dec();
$old_cost = -round2($avg_cost, $dec);
}
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);
if (!$ref) $ref = $Refs->get_next(ST_JOURNAL, null, $date);
add_gl_trans_std_cost(ST_JOURNAL, $journal_id, $date, $cr_acc,
- 0, 0, $wo_cost_types[$cost_type], -$amount);
+ $dim1, $dim2, $wo_cost_types[$cost_type], -$amount);
$is_bank_to = is_bank_account($cr_acc);
if ($is_bank_to)
*/
function work_order_production_gl($woid, $stock_id, $quantity, $date_, $rcv_no)
{
+ global $SysPrefs, $path_to_root;
+
+ $memo = "";
+ if ($SysPrefs->loc_notification() == 1)
+ {
+ include_once($path_to_root . "/sales/includes/cart_class.inc");
+ include_once($path_to_root . "/inventory/includes/inventory_db.inc");
+ $st_ids = array();
+ $st_names = array();
+ $st_num = array();
+ $st_reorder = array();
+ }
+
$result = get_wo_requirements($woid);
// credit all the components
$total_cost = 0;
while ($bom_item = db_fetch($result))
{
-
+ if ($SysPrefs->loc_notification() == 1 && is_inventory_item($bom_item['stock_id']))
+ {
+ $line = new line_details($bom_item['stock_id'], $bom_item["units_req"] * $quantity, 0, 0, 0, 0, $bom_item['description']);
+ $loc = calculate_reorder_level($bom_item["loc_code"], $line, $st_ids, $st_names, $st_num, $st_reorder);
+ }
update_wo_requirement_issued($bom_item['id'], $bom_item["units_req"] * $quantity, $bom_item["ComponentCost"]);
// insert a -ve stock move for each item
$wo = get_work_order($woid);
add_gl_trans_std_cost(ST_MANURECEIVE, $rcv_no, $date_, $wo['wip_account'],
0, 0, $memo, -$total_cost);
+ if ($SysPrefs->loc_notification() == 1 && count($st_ids) > 0)
+ send_reorder_email($loc, $st_ids, $st_names, $st_num, $st_reorder);
}
function check_wo_costing($type, $trans_no)
while($row = db_fetch($res))
{
+ $is_bank_to = is_bank_account($row['account']);
+ if ($is_bank_to)
+ void_bank_trans($row['trans_type'], $row['trans_no']);
+
// void any related gl trans
$date = Today();
$type = $row['trans_type'];