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

  1. Log in to IRIS Financials as an administrator, (that is, using the CUSTADMIN login).
  2. Select Admin Modules, then select Audit Definition from the menu.
  3. The PS Financials Audit Definition - Standard Auditing window opens.
    PS Financials Audit Definition - Standard Auditing window listing audit tables from D_ACCOUNTUSERFIELDS to D_KEYLISTKEY. Each has Insert, Update and Delete check boxes that are all clear.
  4. 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.
    PS Financials Audit Definition - Standard Auditing window with the D_NAMEBANKINFO table highlighted and its columns listed, from LEDGER to USERREF, each with Insert, Update and Delete check boxes.
    D_NAMETERMS - contains all of the payment terms information.
    PS Financials Audit Definition - Standard Auditing window with the D_NAMETERMS table highlighted and its columns listed, from LEDGER to DISCOUNT_NOMINAL, each with Insert, Update and Delete check boxes.
    M_ACCOUNT - contains all of the header information for the accounts, for example, title, account code, and so on.
    PS Financials Audit Definition - Standard Auditing window with the M_ACCOUNT table highlighted. The description reads Ledger Account record. Its columns include LEDGER, ACCOUNT, TITLE and DETAILSTATUS.
    M_NAMEACCOUNT - contains all of the contact information held against the account, for example, address.
    PS Financials Audit Definition - Standard Auditing window with the M_NAMEACCOUNT table highlighted. Its columns include LEDGER, ACCOUNT, ADDRESSNAME, ADDRESS1 to ADDRESS3 and EMAIL_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.
    PS Financials Audit Definition - Standard Auditing window with the M_TAXACCOUNT table highlighted. Its columns are LEDGER, ACCOUNT, STARTDATE, ENDDATE, TAXSTATUS and AUTOMATIC.
  5. 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.
    PS Financials Audit Definition - Standard Auditing window listing tables from D_ACCOUNTUSERFIELDS to D_DOCUMENTSECURITY with Insert, Update and Delete check boxes. Apply and Close are highlighted.

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.

  1. Log in to IRIS Financials as an administrator, (that is, using the CUSTADMIN login).
  2. Select AdminModules, then select Audit Query from the menu.
  3. The PS Financials Audit Query window opens.
    PS Financials Audit Query window with General, Data, User and Date criteria sections and a Search option.
  4. 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.
  5. When you have selected your criteria, select Search.
  6. The report appears, similar to this graphic, with the details for the selected criteria.
  7. Select Expand (+) next to the database column for any item to display the details of the action.
    PS Financials Audit Query results with a Logon row expanded and the detail rows highlighted. The columns are Database, Action Time, Action, Table, Column, Row ID and Old Value.

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.