Run an audit query
IRIS Financials has an function that allows for any extra data or changes to existing data to be tracked and reported upon.
You must select the applicable fields on the Audit Definition before it can report on any data. You are unable to report on any actions that have occurred before the applicable audit has been switched on.
Running a system audit involves these tasks:
Switch on the audit using the Audit Definition
Run and use the Reporting Suite audit report
Manually creating an audit using the Audit Query
Switch on the audit using the Audit Definition
- Log in to IRIS Financials as an administrator, (that is, using the CUSTADMIN login).
- Select Admin Modules, then select Audit Definition from the menu.
- The PS Financials Audit Definition - Standard Auditing window opens.

- Select the audit options required for each data table within the database. Select Expand (+) next to the table name to display the details for each table.
You can select these tables with the Standard Auditing functionality. If you would like to Audit more extensively, contact the Support Team.
The 3 levels of audit options are:
Insert - adding a record to the database.
Update - making amendments to the database. For example, changing bank details.
Delete - removing data from the database.
As a minimum, select audit options for the details in these tables:
D_NAMEBANKINFO - contains all of the bank account information on the system.
D_NAMETERMS - contains all of the payment terms information.
M_ACCOUNT - contains all of the header information for the accounts, for example, title, account code, and so on.
M_NAMEACCOUNT - contains all of the contact information held against the account, for example, address.
M_TAXACCOUNT - contains all of the details on the VAT accounts and periods, including the date and user details for closing and opening the VAT period, which you can audit.
- When you have made your selections, select Apply to save your changes, then select Close. You can then load the Audit Query to report these amendments.

Manually creating an audit using the Audit Query
You can use the Audit Query if you are on an older version of the software and do not have access to the Account Audit Report from the Reporting Suite.
- Log in to IRIS Financials as an administrator, (that is, using the CUSTADMIN login).
- Select AdminModules, then select Audit Query from the menu.
- The PS Financials Audit Query window opens.

- Complete the criteria as follows:
Database - Select the database you want to report on.
Action - Select the actions you want to report on, for example, insert, update, delete, and so on. For more information about actions, refer to Switch on the audit using the Audit Definition.
User Group - Select the user group you want to report on.
User - Select an individual or all users to report on.
Table - Select the applicable table you want to report on. For more information about tables, refer to Switch on the audit using the Audit Definition.
Column - Select the options from the table that you want to report on. For example, the account name or who has accessed the account.
Comparison - If you know the specific change you can select the option. We recommend leaving this as Any Change.
Old Value - If you have selected a Comparison, select the original value of a record. We recommend leaving this as Any Change.
New Value - If you have selected a Comparison, select the new value of a record. We recommend leaving this as Any Change.
Modified - Select an option to report on a specific timeframe. If you select an option, select a from and to date from the extra Modified fields. - When you have selected your criteria, select Search.
- The report appears, similar to this graphic, with the details for the selected criteria.
- Select Expand (+) next to the database column for any item to display the details of the action.

The database tables detailed in this guide are the only ones able to be audited as part of the standard functionality, to audit other database tables (although they appear in the list lists) you need to purchase an extra licence.