X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fincludes%2Fdb%2Fitems_trans_db.inc;h=0bcdb82b80e6e12f7fb26108745cd2fa8e5f9c5a;hb=3ff9ed87cb909f19c8fe3e7dfda5df79d0c01a6c;hp=ce1153eddd6de37714cc1e2de3043149c5ddf6c8;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/inventory/includes/db/items_trans_db.inc b/inventory/includes/db/items_trans_db.inc index ce1153ed..0bcdb82b 100644 --- a/inventory/includes/db/items_trans_db.inc +++ b/inventory/includes/db/items_trans_db.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ //------------------------------------------------------------------------------------------------------------- function stock_cost_update($stock_id, $material_cost, $labour_cost, $overhead_cost, @@ -25,31 +34,32 @@ function stock_cost_update($stock_id, $material_cost, $labour_cost, $overhead_co $qoh = get_qoh_on_date($_POST['stock_id']); + $date_ = Today(); if ($qoh > 0) { - $update_no = get_next_trans_no(systypes::cost_update()); - $date_ = Today(); + $update_no = get_next_trans_no(ST_COSTUPDATE); if (!is_date_in_fiscalyear($date_)) $date_ = end_fiscalyear(); $stock_gl_code = get_stock_gl_code($stock_id); - + $new_cost = $material_cost + $labour_cost + $overhead_cost; - + $value_of_change = $qoh * ($new_cost - $last_cost); - + $memo_ = "Cost was " . $last_cost . " changed to " . $new_cost . " x quantity on hand of $qoh"; - add_gl_trans_std_cost(systypes::cost_update(), $update_no, $date_, $stock_gl_code["adjustment_account"], + add_gl_trans_std_cost(ST_COSTUPDATE, $update_no, $date_, $stock_gl_code["adjustment_account"], $stock_gl_code["dimension_id"], $stock_gl_code["dimension2_id"], $memo_, (-$value_of_change)); - add_gl_trans_std_cost(systypes::cost_update(), $update_no, $date_, $stock_gl_code["inventory_account"], 0, 0, $memo_, - $value_of_change); - } + add_gl_trans_std_cost(ST_COSTUPDATE, $update_no, $date_, $stock_gl_code["inventory_account"], 0, 0, $memo_, + $value_of_change); + } + add_audit_trail(ST_COSTUPDATE, $update_no, $date_); commit_transaction(); - - return $update_no; + + return $update_no; } //-------------------------------------------------------------------------------------------------------------