$sql .= "AND ".TB_PREF."grn_batch.supplier_id ='" . $fromsupp . "' ";
$sql .= "ORDER BY ".TB_PREF."grn_batch.supplier_id,
".TB_PREF."grn_batch.id";
$sql .= "AND ".TB_PREF."grn_batch.supplier_id ='" . $fromsupp . "' ";
$sql .= "ORDER BY ".TB_PREF."grn_batch.supplier_id,
".TB_PREF."grn_batch.id";