Cognos available reports to check automatic or manual validation by T&E Accountant

[Ilonaglowacka]

Hello,

I would like to check if there is some general report  in Cognos with detailed information as per expense lines, where we could also find information if the expense was validated automatically  or went thought manual audit  and validated by T&E Accountant. Also is there possibility to check in concur queries (create querie) if the expense was processed automatically/manually

[KevinD]

@Ilonaglowacka within Cognos there is a Workflow Audit Trail folder that has a Step data item and Employee Assigned to Step data item. This will show if an employee was assigned to the step or if the system was assigned. 

[Ilonaglowacka]

Dear Kevin ,

Thank you for your reply however the above-mentioned solution will be in the Cognos reporting? I'm looking for a report to be generated for some period of time, with details as per expense line with this additional information about manual/automatic posting) . Also, as far as I remember there was a specific column in Some Cognos report  called "Appraiser" where  I think there was this information - concur system or name of accountant filled in. Please correct me if I'm wrong.  I was also wondering if this information could be found in this part "create/manage queries" by choosing correct data object , not only checking audit for every  single report.

Thank you in advance  for your reply

[KevinD]

@Ilonaglowacka Yes, my first reply was referring to using Cognos reporting.

I've not heard of any column named Appraiser. The create and manage queries is from the Processor screen and it meant for querying a list of expense reports to then process. This type of query will not contain the audit trail of the workflow. You would need to open each report separately and view the audit trail.