Query to extract expense reports which are reassigned to different approver
Summary: We are trying to expense reports which are reassigned from one approver to another approver.
I tried to query below tables but could not frame query to obtain below columns:
Required Columns in report:
- Expense report number
- Expense date
- First Approver
- Reassigned Approver to
- Reassigned By
Do you have any query which can be used to extract above columns.
Below tables are not extracting any data in our environment:
Version (include the version you are using, if applicable):