+function get_grn_batch_from_item($item)
+{
+ $sql = "SELECT grn_batch_id FROM ".TB_PREF."grn_items WHERE id=".db_escape($item);
+ $result = db_query($sql, "Could not retreive GRN batch id");
+ $row = db_fetch_row($result);
+ return $row[0];
+}
+
+function get_grn_batch($grn)
+{
+ $sql = "SELECT * FROM ".TB_PREF."grn_batch WHERE id=".db_escape($grn);
+ $result = db_query($sql, "Could not retreive GRN batch id");
+ return db_fetch($result);
+}
+
+function set_grn_item_credited(&$entered_grn, $supplier, $transno, $date)
+{
+ $mcost = update_average_material_cost($supplier, $entered_grn->item_code,
+ $entered_grn->chg_price, $entered_grn->this_quantity_inv, $date);
+
+ $sql = "SELECT grn.*, item.*
+ FROM ".TB_PREF."grn_batch grn,"
+ .TB_PREF."grn_items item
+ WHERE item.grn_batch_id=grn.id
+ AND item.id=".db_escape($entered_grn->id)."
+ AND item.item_code=".db_escape($entered_grn->item_code);
+
+ $result = db_query($sql, "Could not retreive GRNS");
+ $myrow = db_fetch($result);
+
+ $sql = "UPDATE ".TB_PREF."purch_order_details
+ SET quantity_received = quantity_received + "
+ .db_escape($entered_grn->this_quantity_inv).",
+ quantity_ordered = quantity_ordered + "
+ .db_escape($entered_grn->this_quantity_inv).",
+ qty_invoiced = qty_invoiced + ".db_escape($entered_grn->this_quantity_inv).",
+ std_cost_unit=".db_escape($mcost).",
+ act_price=".db_escape($entered_grn->chg_price)."
+ WHERE po_detail_item = ".$myrow["po_detail_item"];
+ db_query($sql, "a purchase order details record could not be updated. This receipt of goods has not been processed ");
+
+ //$sql = "UPDATE ".TB_PREF."grn_items SET qty_recd=0, quantity_inv=0 WHERE id=$entered_grn->id";
+ $sql = "UPDATE ".TB_PREF."grn_items SET qty_recd=qty_recd+".db_escape($entered_grn->this_quantity_inv)
+ .",quantity_inv=quantity_inv+".db_escape($entered_grn->this_quantity_inv)
+ ." WHERE id=".db_escape($entered_grn->id);
+ db_query($sql);
+
+ add_stock_move(ST_SUPPCREDIT, $entered_grn->item_code, $transno, $myrow['loc_code'], $date, "",
+ $entered_grn->this_quantity_inv, $mcost, $entered_grn->chg_price);
+}