Reporting Intelligence - Audit every Xth report post payment

[PatC]

Hi,

Is there an out-of-the-box report, or a way to configure Intelligence to generate a report that grabs every 10th expense report submitted for payment?

Can anyone can shed some light on this?

[KevinD · Accepted solution]

@PatC I don't believe there is a report in Cognos already built for this. However, I can tell you how to achieve this. 

In your Audit Rules screen, there is an option to do a Random Audit. If you go to Audit Rules and click the Random tab, you can set your site up to select every tenth report to be set for Random Audit. This will generate an exception (yellow warning message) on that report. You can then build a Cognos report that shows all reports with this exception. 

In Cognos you would start a new report and add Employee, Report Name, Expense Type, Entry Expense Amount, and any other needed data items. Be sure to then add Exception Code from the following path: Expense>Expense Reports>Report Exceptions>Report Header Exceptions. Once you have added Exception Code, you can then create a filter on this data item to only show RANDOM. 

I think this should give you what you are looking for.