Fixed Assets inquiry has not connected with right GRN

null@example.com (kvvaradha) — Sat, 07 May 2022 14:49:27 +0000

From fixed assets inquiry page, we have a purchased column with link, thats giving wrong trans_no.

get_fixed_asset_purchase function get invoice now, how do we link the invoice trans no in place of GRN trans no.

function purchase_link($row)
{

      if ($row['purchase_date'] === NULL)
        return "";

      return get_supplier_trans_view_str(ST_SUPPRECEIVE, $row["purchase_no"], sql2date($row["purchase_date"]));
}

Here the $row['purchase_no'] has not exist.

function purchase_link($row)
{

      if ($row['purchase_date'] === NULL)
        return "";
      //my suggestion would be something like this to get GRN now.
       $sql ="SELECT trans_no FROM ".TB_PREF."stock_moves WHERE 1=1 AND type =".ST_SUPPRECEIVE." AND stock_id =".db_escape($row['stock_id'])." AND qty > '0' ";
      $res = db_query($sql, "Can't get grn no");
       $row2=db_fetch($res);

     return get_supplier_trans_view_str(ST_SUPPRECEIVE, $rows["trans_no"], sql2date($row["purchase_date"]));
}

@Joe, check it. otherwise we need to connect the invoice, instead of the GRN in purchase link.

and also i see, we can try the depreciation start with the date given from fixed assets input date. i dont know the reason why we are using every month start date.

FrontAccounting forum — Fixed Assets inquiry has not connected with right GRN

Fixed Assets inquiry has not connected with right GRN