{
$sql = "SELECT s.stock_id, c.description, s.units, s.description as name,
s.depreciation_rate, s.depreciation_method, s.inactive, rcv.tran_date as purchase_date, rcv.trans_no as purchase_no,
{
$sql = "SELECT s.stock_id, c.description, s.units, s.description as name,
s.depreciation_rate, s.depreciation_method, s.inactive, rcv.tran_date as purchase_date, rcv.trans_no as purchase_no,