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

Anyone seeing *intermittent* "ERROR: Invalid Expression" in their Saved Search. I'm seeing it two different NS accounts.

Yes, I have! I have not found a solution for it but you're not alone with this issue. I usually end up re-writing the entire search to avoid it. The only common thread I've seen with it is searches that are looking at an enormous amount of data.

Thanks. I found my issue relates to a To_CHAR statement in which sometimes it's working with ‘DD/MM/YYYY’ and later it's working with ‘MM/DD/YYYY’. I logged it to support. 

problem was solved when we wrapped every date occurrence into TO_CHAR even though we thought they were matching date formats. It doesn't explain the intermittent nature of the error output but this is now working reliably. after two weeks, time to move on