- if ($myrow['type'] == ST_SUPPRECEIVE)
- {
- // Has the supplier invoice increased the receival price?
- $sql = "SELECT DISTINCT act_price FROM ".TB_PREF."purch_order_details pod INNER JOIN ".TB_PREF."grn_batch grn ON pod.order_no =
- grn.purch_order_no WHERE grn.id = ".$myrow['trans_no']." AND pod.item_code = '$stock_id'";
- $result = db_query($sql, "Could not retrieve act_price from purch_order_details");
- $row = db_fetch_row($result);
- if ($row[0] > 0 AND $row[0] <> $myrow['price'])
- $price = $row[0];
- }