Query - Create Report to Identify Timed Out IExpense and Direct Payments
Greetings,
I need help with writing a query to list records that have timed out in Iexpense and Direct Payments. Currently when iExpenses or direct payments sit with an approver for more than 10 days some escalate but some never escalate and just time out. These timed out iExpeneses and direct payments don't make it to the accounting department for approval and the payments don't get paid until an employee alerts us of the error which could be months later and even in the next fiscal year.
It would be helpful to have a report that could identify items that sit for 10 days or more without action, so that we can fix. Thank you.