Rhoogerh
Occasional Member - Level 3

How to capture in which approvers queue a report is sitting

I have a report that shows all reports that have a status of "Submitted and Pending Approval", and shows the number of days between their first submission and the current date.  The intent is for the user to monitor those that are too long awaiting approvals.  The problem is that I can capture the Default Approver, but that is not always where the holdup lies . . . sometimes it is with an upline approver (e.g. the report exceeded the initial approver's authority level).  I am unable to determine what field - if one exists - that would capture the approver whose queue the report is in (and, ideally, how long it had been in that queue).  Any suggestions?

0 REPLIES 0