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

In a Saved Search, I can't seem to locate the Revenue Recognition Rules, Im trying to search all my journal entries that has revenue recognition rules. Any ideas.

We’re these journals created from RR or these journal will create revenue arrangements.

<@U412EABU2> Its manual created JE with Rev Rec Rules on the transaction line

I think you are better of doing saved search from revenue arrangements and looking at element source transaction type. 

Or use criteria based on type = journal and rev rec start date / end date not empty 
But normally you have a field for rev rec rules 

<@UM758FMTJ> I want it to return the rev rec rules

You have a field on JE : rev rec rules
use formula text: {generatedrevenueelement.revenuerecognitionrule}

<@U04D95EGF97> Thank you so much, it worked

Is there a list or tutorial on formula text search? I tried searching google but the result was not that good

<@U04D95EGF97> Is it possible to use formula text to return something on another transaction type? Example. I want a list of payments and their applied invoices. In this scenario, I can use join but I can only return things on the main line body of the invoices transaction. But I want to return something from the transaction line of the invoice. Lets say its call discount. So from the payment save search, can I return the invoice line transaction "discount" I tried this with join but can only return body field and not line field

Don’t think you can with this setup
You need to create a saved search based on invoice and use applying transaction to see the payment 

Don’t use main line 
And probably you need to use a formula like over partition  by {internalid}