cancel
Showing results for 
Search instead for 
Did you mean: 
ankit1301
Occasional Member - Level 2

Report to show current approver

Hi,


Requirement -

Need to track expense reports pending for approval - A report that would show the current manager the report is pending with.  

 

Progress so far -

I was able to create a custom report with Column "Employee assigned to step" but it shows the current approver and the future approvers as well - Have multiple level approval flow.

 

Issue -

I am not able to filter the output whch would show the current approver only with whom the report is currently pending.      

2 Solutions
Solution
JessicaL
Frequent Member - Level 1

Yes, my solution will work. If you have the Processor Role, and you are in the Process Reports screen (from Expense Tab):

1.png

 

Then, you click the button "Create/Manage Queries" and set up your new Querie as below:

2.png

Then, run that query, the Approval Status column says where the report is stuck. For instance, it could say things like "Submitted & Pending Approval - Lynch, Jessica" or "Approved & in Accounting Review". That way, you know to reach out to Jessica and ask her to please log into Concur to approve the pending reports. 

 

But, I saw other suggestions as well that could work. I just find this is the easiest for me, as I try to keep the reports moving along so we send emails to our approvers that haven't approved reports in a while - yes, there is a Concur email notification for that 🙂 - but, we still find an email from our team usually moves the report along quicker, as some people simply delete those Concur emails.

 

In any case, I hope your issue is resolved and you find a way that works for you. If you need help with this way, though, please let me know. 

 

Best,

 

 

Jessica
Travel and Expense System Administrator

View solution in original post

Solution
ankit1301
Occasional Member - Level 2

Hi All - Raised this with Concur Support and they guided me to the Workflow aging report. This reprort does show the current approver the report is pending with along with other workflow related details.  

 

Capture.PNG

View solution in original post

11 REPLIES 11
JessicaL
Frequent Member - Level 1

Hello there,

Do you have the Expense Processor Role? If so, you could run the query "Waiting for Approval". On the bottom of the page, there is an option to "Send to Excel".

Best,

Jessica
Travel and Expense System Administrator
ankit1301
Occasional Member - Level 2

Hi @JessicaL  - Thanks for taking out time to respond to my query. Actually I am after a report from Admin perspective who can track where the expense report is currently stuck for approval.  Do you still think the query "Waiting for Approval" would work?


Thanks,

Ankit 

Solution
JessicaL
Frequent Member - Level 1

Yes, my solution will work. If you have the Processor Role, and you are in the Process Reports screen (from Expense Tab):

1.png

 

Then, you click the button "Create/Manage Queries" and set up your new Querie as below:

2.png

Then, run that query, the Approval Status column says where the report is stuck. For instance, it could say things like "Submitted & Pending Approval - Lynch, Jessica" or "Approved & in Accounting Review". That way, you know to reach out to Jessica and ask her to please log into Concur to approve the pending reports. 

 

But, I saw other suggestions as well that could work. I just find this is the easiest for me, as I try to keep the reports moving along so we send emails to our approvers that haven't approved reports in a while - yes, there is a Concur email notification for that 🙂 - but, we still find an email from our team usually moves the report along quicker, as some people simply delete those Concur emails.

 

In any case, I hope your issue is resolved and you find a way that works for you. If you need help with this way, though, please let me know. 

 

Best,

 

 

Jessica
Travel and Expense System Administrator
ankit1301
Occasional Member - Level 2

Thanks @JessicaL  - This worked for me. I could see single line item per report and can see the approve name next to "Submitted and Pending Approval"

KevinD
Community Manager
Community Manager

@ankit1301 I think @JessicaL's suggestion would be a faster option and much easier. However, if you don't have the Processor role, then that wouldn't really be an option.

 

So, let's suppose you don't have the processor role...can you provide a screenshot of all the data items you have on your report you are building? You'll definitely need a filter, but with multiple levels of approval, it could be a tricky to know exactly what to filter on.  


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
ankit1301
Occasional Member - Level 2

Hi @KevinD,

 

Thanks for getting back on this. Attaching the screenshot of the current extract - I really can't figure out which field to filter on 🙂Report.PNG

tstagliano
Routine Member - Level 2

@ankit1301   you will want to include the field current workflow active = 1 field and create a filter on that so it will only show that current, active step of the workflow and the approver assigned to that step

Thomas Stagliano, M.I.T.
ankit1301
Occasional Member - Level 2

Hi @tstagliano,


Even I thought so and added that column to my report already but if you look at my screenshot, all the steps have the Current workflow = 1. Can you please check in youe system if youy have similar scenario. Report.PNG  

tstagliano
Routine Member - Level 2

@ankit1301   Typically when we do any workflow reporting to show the most recent approver, we filter on the belwo items that work for use

 

- Filter on the Approver Roles within our org ("Role Legacy Key in (Auth_Approver, CO_Approver and Manager)"

- Employee Assigned to Step is not any of the System or Admin accounts

- Step Action Date/Time IS  NOT NULL

- Current Workflow Flag (Current=1) = 1

 

 

Thomas Stagliano, M.I.T.
ankit1301
Occasional Member - Level 2

Thanks @tstagliano  - But in our case all the lines are showing Current Workflow Flag (Current=1) = 1. I have created a case for Concur to investigate. 

 

 

Solution
ankit1301
Occasional Member - Level 2

Hi All - Raised this with Concur Support and they guided me to the Workflow aging report. This reprort does show the current approver the report is pending with along with other workflow related details.  

 

Capture.PNG