+ return db_insert_id();
+}
+//-------------------------------------------------------------------------------------------------------------
+
+function write_grn_item($grn_batch_id, $po_detail_item, $item_code, $description, $quantity_received, $grn_item_id)
+{
+ if ($grn_item_id)
+ $sql = "UPDATE ".TB_PREF."grn_items SET qty_recd=".db_escape($quantity_received)
+ ." WHERE id=".db_escape($grn_item_id);
+ else
+ $sql = "INSERT INTO ".TB_PREF."grn_items (grn_batch_id, po_detail_item, item_code, description, qty_recd)
+ VALUES (".db_escape($grn_batch_id).", "
+ .db_escape($po_detail_item).", ".db_escape($item_code).", ".db_escape($description)
+ .", ".db_escape($quantity_received).")";
+
+ db_query($sql, "A GRN detail item could not be stored.");
+
+ $sql = "UPDATE ".TB_PREF."purch_order_details po,
+ (SELECT SUM(qty_recd) received FROM ".TB_PREF."grn_items grn WHERE po_detail_item=".db_escape($po_detail_item).") grn
+ SET po.quantity_received = grn.received
+ WHERE po_detail_item = ".db_escape($po_detail_item);
+ db_query($sql, "a purchase order details record could not be updated. This receipt of goods has not been processed ");