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

Does anyone know how to get to the equivalent of the `applyingtransactions` record in SuiteQL? I’m trying to query vendor bills which were `paid only with vendor credits.`

<@U0176EEDYR2> Have you dived into this?  I think I’m looking at one of your older scripts right now.

<@U2ASTKU79> Could use your help on this one buddy.

<@U856E2SEA> You’re the SuiteQL guru, for me anyhow.

oh boy. it's been a while since I've done anything like this

```// this filter is functionally equivalent to Bills being paid only via Bill Credits
['min(formulatext: ns_concat({applyingtransaction.type}))', search.Operator.DOESNOTCONTAIN, 'Payment']```
Does this look familiar?

I think Zack might have done something with the NextTransactionLink or NextTransactionLineLink table but I need to play around with it a bit

Sean sent me something about `NextTransactionLineLink`, is that the table I’m looking for?

```select * from previoustransactionlink where previousdoc in ('887617');```
this gave me something useful

I didn't really test this very thoroughly so your mileage may vary

to filter bills such that you _only_ get those that were paid with vendor credits, you would obviously get the complete set of bills and remove those without payments and those with non-credit applications

<@UCV5NMJ14> Yeah, I think the PreviousTransactionLineLink and NextTransactionLineLink tables are what you're looking for. This might help a bit: <https://timdietrich.me/blog/netsuite-suiteql-related-transactions/>