- /* Logic shifted to function update_average_material_cost\r
- //Chaitanya : If negative adjustment result in negative or zero inventory \r
- //then difference should be adjusted\r
- $qoh = get_qoh_on_date($stock_id);\r
- if ($qoh + $quantity <= 0 && $qoh > 0) //Positive inventory turning zero/negative\r
- {\r
- global $Refs;\r
-\r
- $id = get_next_trans_no(ST_JOURNAL);\r
- $ref = $Refs->get_next(ST_JOURNAL);\r
- $diff = get_standard_cost($stock_id) - $standard_cost;\r
- \r
- if ($diff !=0)\r
- {\r
- $stock_gl_code = get_stock_gl_code($stock_id);\r
- $memo = _("For zero inventory of ").$stock_id." INVADJ REF: ".$reference;\r
- //Reverse the inventory effect if $qoh <=0\r
- add_gl_trans_std_cost(ST_JOURNAL, $id, $date_, \r
- $stock_gl_code["inventory_account"],\r
- $stock_gl_code['dimension_id'], $stock_gl_code['dimension2_id'], $memo, \r
- -$qoh * $diff);\r
- //GL Posting to inventory adjustment account\r
- add_gl_trans_std_cost(ST_JOURNAL, $id, $date_, \r
- $stock_gl_code["adjustment_account"],\r
- $stock_gl_code['dimension_id'], $stock_gl_code['dimension2_id'], $memo,\r
- $qoh * $diff);\r
- \r
- add_audit_trail(ST_JOURNAL, $id, $date_);\r
- add_comments(ST_JOURNAL, $id, $date_, $memo);\r
- $Refs->save(ST_JOURNAL, $id, $ref); \r
- } \r
- }*/\r
-\r
- update_average_material_cost(null, $stock_id, $standard_cost, $quantity, $date_);
+ update_average_material_cost(null, $stock_id, $unit_cost, $quantity, $date_);
+
+ if (is_fixed_asset($mb_flag)) {
+ $sql = "UPDATE ".TB_PREF."stock_master SET inactive=1
+ WHERE stock_id=".db_escape($stock_id);
+ db_query($sql,"The inactive flag for the fixed asset could not be updated");
+ }