https://netsuiteprofessionals.com logo
s

S. T.

04/21/2022, 1:22 AM
We're looking to create a saved search for pending PO's where the next approver has a termination date. This would be helpful in preventing pending PO's from sitting too long in limbo due to someone leaving the company before approving it. Is this even possible with a saved search since I would need data from both the PO and employee record?
b

battk

04/21/2022, 2:26 AM
use the next approver join
should be towards the bottom of the filters list
s

S. T.

04/22/2022, 2:47 AM
I see next approver field but that's it towards the bottom
b

battk

04/22/2022, 2:53 AM
do you know what a join look like?
s

S. T.

04/22/2022, 2:58 AM
Not quite. I'm new to saved searches
its a feature of advanced saved searches
s

S. T.

04/24/2022, 1:21 AM
Gotcha. This is what I thought you were referring to but I couldn't find one related to the next approver's termination date. But I'll take a closer look Monday. Thanks!