I am trying to run some processor queries to show all the reports that have been approved by "date approved." I can only find submit date but many times users will submit a report and the report is approved days later. Therefor submit date is not helpful. Is this available?
In addition we are trying to call reports in the expense API and would like to pull all reports approved for the day but we cannot find that field to utilize. This seems like a very basic item that should be on all reports. Any help would be greatly appreciated.
@Dmontone the best option from the Processor screen is to run a query for Processor Start Date Equals Today's Date. There is not an option to see Approved Date from the Processor screen.
Also, if you are on a Professional configuration of SAP Concur, you can get the Approved Date from Cognos reporting.
P.S. I provided a screenshot for the processor start date query.
@harmbasra If by Approved date you mean "Approved by the Processor" that would be the Sent for Payment Date in Cognos. There is the Approver Statistics report in the Standard Reports>Expense Processing folder. This could work for you. It allows you to choose the date range.
You could even build your own Cognos report. I don't know if you have experience building reports in Cognos, but I'm going to just pretend that you do. 🙂 All you need is to add the following data items:
Sent for Payment Date
That is a very basic report that would show the date the processor approved the report.
Let me know if this help. If you do not have experience building reports in Cognos, let me know. I can point you to some resources that might help.