how to get check number in the transaction saved search?

AI generated answer (using internal Slack threads):

To get the check number in a transaction saved search, you can use the

{otherrefnum}

field. This field typically holds the check number for payment records. If you are looking to get applying and applied transactions based on the check number through a saved search or SuiteScript, you can use a SuiteQL query. Here is an example:

sql
select 
  t.trandisplayname applying_transaction,
  appliedto.trandisplayname applied_to_transaction,
  billLink.foreignamount applied_amount
from transaction t 
join transactionLine line
on line.transaction = t.id
join PreviousTransactionLineLink billLink
on billLink.nextdoc = t.id
AND billLink.nextline = line.id
left outer join transaction appliedto
	on appliedto.id = billLink.previousdoc
where t.type = 'VendPymt' 
AND t.number = '79637' -- Replace 79637 with CHECK number

Please replace '79637' with your check number. However, please note that there is a limitation where you can't fetch Bill Credits based on the Check Number. Even in NetSuite's record browser, they haven't exposed Apply fields. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******