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!
How to create a Saved Search that will return only the PO's that belongs to the user's Department?
Hello!
I am creating a saved search to show purchase orders. The condition I am trying to set is based on the parent department of the user who is running the search.
For example, we have the following structure:
EXECUTIVE : CEO : PARENT DEPARTMENT : CHILD DEPARTMENT
If a person from the Child Department runs the search, he/she should be able to see all the POs belonging to the parent department plus it's sub departments.
I am trying to compare the parent department of the PO with the parent department of the user running the search.
The problem is that User:Department returns a string like
Tagged:
0