Hi everyone,
I’m looking for guidance on creating a saved search for vendor bill approvals.
We have a scenario where vendor bill approval is department-based, and each department can have multiple approvers — at least four different approvers.
To support this, I created custom approver fields on the Department record, such as:
Approver 1
Approver 2
Approver 3
Approver 4
When a department is selected on a vendor bill, these approvers are automatically populated on the transaction.
I have also created saved searches for pending vendor bills in two different approval states, because the client wants bills to route through two approval levels based on vendor category.
The requirement is that when an approver logs in and opens the saved search, they should only see vendor bills that are waiting for their approval, regardless of whether they are listed as Approver 1, Approver 2, Approver 3, or Approver 4.
For example, if the logged-in user is listed as any one of the approvers on the bill, they should be able to see that bill in the saved search. If they are not one of the approvers, the bill should not appear.
I’m finding this difficult because if I set the criteria to “Approver 1 is mine,” then the search only works when the logged-in user is specifically in the Approver 1 field. However, the same person may sometimes be Approver 2, Approver 3, or Approver 4 depending on the department, or no approver at all for certain departments so the search may return no results even though there are bills waiting for that person’s approval.
Is there a way to create a saved search that dynamically filters pending vendor bills so that the logged-in user sees bills where they are listed in any of the approver fields?
Ideally, the saved search should work like this:
Show pending vendor bills where:
- Approver 1 is the current logged-in user, OR
- Approver 2 is the current logged-in user, OR
- Approver 3 is the current logged-in user, OR
- Approver 4 is the current logged-in user - I tried this on my saved search but it didn't fetch me results the way I expected and gave me duplicate values even though main line is set to true.
Also, in this approval design, if any one of the assigned approvers approves the vendor bill, the bill should be considered approved for that approval step.
Has anyone implemented something similar using saved search criteria, formulas, workflows, or approval routing logic?
Any suggestions on the best approach would be greatly appreciated.
Thank you!