Page Comparison

The Audit Query is where the query(s) are created for the audit module. A query is a set of conditions based on which you would want to audit an expense report, for example if it exceed a certain dollar amount, or missing receipts, if a specific expense type is used, audit specific employees or just do a random audit from a pool of expense reports. You can set up many query's queries to cover all scenarios for auditory purposes. There are many options to choose from to customize and specify what you want your query to search for your auditors to find. In the Audit Query you can add, edit, delete and/or assign query'squeries.

To Create an Audit Query:

Scenario: You want to create a query to display all transportation-related reports under $500. 
Here is a video demonstrating how to make a query:

...

Under the Administrators Tab:

1. Expand Audit by clicking the arrow Image Added
2. Select Audit Query 
3. Click Add 
4. Name - Enter a name for this query (For this example, "Transportation Under $500" is as the name)
5.  Your audit query is now made and ready to be edited.
6. Validation Message - The message that informs the user of their error
7. Restrict Access - Select Yes, if this is restricted to specific users. Otherwise leave this set to No
8. Click Next
9. Under Query Items, select click Add to customize the query.
   Image Removed 
10. Choose a Query Field.Field 
    (For this example, the query field is 'Expense Type')
11. Choose a Condition.
    (For this example, the condition is 'In')
12. Choose a Query Value. You can select the "...Image Added" to view the value list. Then Save.
    (For this example, all options relating to transportation would be selected. Such as airfare, mileage, car rentals, taxi, etc,.)
    Select Apply to update the query.
13. Once you have selected the expense types click OK
14. Once you have finished adding your query click Save
15. For this example, we will need to add a second query to include the Reimbursement amount. Go to Add (from #7#8)
16. Choose a Query Field- 'Reimbursable amount'
17. Choose a Condition- '<='
18. Type a Value- '500'
19. Select Apply Save to update the query.
20. Click Next
21. Under Query Assign Employee you are able to assign this query to specific employees. 
22. Click Add
23. Select the employees then click Ok
24. Click Finish

25. Select Publish. 

    Image Added
    *The query will not become active until published

    Active Query	You can see it as an auditor
    Inactive Query	Does not show on the drop-down list for the auditor

    
    

To Edit a Query:

You can edit the name, query items and assignment. 

1. Select the Query you want to edit 

   Image Removed

   Change the name

   Image Removed

   	Add and delete Query items

   Image Removed

   Assign an employee to the Query

   
   

To Delete a Query:

1. Select the Query you want to delete
2. Select 'Delete'
3. Select 'Yes' to delete

To Assign an employee to a Query:

1. Select the Query you want to assign to
2. Go to Click the Assignment tab
3. Select Add
4. Choose the Employee you want to assign the query to
5. Select 'Ok'

...