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

image.png

Hi all,

We have a record that generates journals, and there are millions of journals now.
Sometimes I need to create a saved search to get the records without journals. So I want to open the dropdown menu or modal, and select NONE, but it takes minutes, and sometimes after the request finishes, the menu doesn't show up, and I have to press the button again.
I also tried to use a text formula, but it doesn't work, it returns 0 results, while I know there are some records without journals.
Any ideas to solve this?

Try to use the criteria "Type", and then "None of: Journals."

The record happens to have a field called type, but I don't think it is what you are thinking of.

You are thinking of the Type field that you can find on the transactions search. And even that wouldn't be relevant here.

try formula numeric.  maybe it returns id, data type mismatch.