Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Unrestricted Saved Search not returning results for non-admin users on formula columns.
Hi all,
I have this saved search that returns results looking like this. These results are also the same if I change to a non-admin role.
However, my users that don't have an admin role appear to be getting blank results on all the formula results. At least, I believe this is the main factor. I have given the search to 2 other admins who are able to load results and 3 non-admins who cannot load results.
The formulas look like this.
I have also tried an alternate way of writing the formula but to no avail.
CASE
WHEN {type} = 'Invoice'
AND TO_CHAR({trandate}, 'MM') = '01'
0