This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hey All, Is there any way to get Applying and Applied transactions Based on Check Number through saved search or suitescript?

You’re referring to customer payments applied to invoices?

You’ll likely be able to do it with the PreviousTransactionLineLink table.

Hi Cory, thanks for your response. It is about Bills and Bill Credits on Bill payment record. Any insight will be much appreciated..thanks

Here is a SuiteQL Query. Replace 79637 with the check number.

```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```

image.png

thank you , any thoughts on fetching Bill Credits?

Look it is a kind of limitation where we cant fetch Bill Credits based on Check Number

even in NS record Browser they haven't exposed Apply fields