Customise enquiry displays
Some Of the nominals and ledgers used in this topic may be different to those in your chart of accounts.
An enquiry is used to view documents that have been added to IRIS Financials to record your establishment/organisation's transactions. In any enquiry window, you can customise the display. For example, adjust the column widths or add and remove columns to show only the information you need. You can also use enquiries to export data in a report form. For more information, refer to Exporting Data to Excel.
Enquiries have a range of functions that you can use with various documents. For more information, refer to Detail enquiry functions and Document enquiry functions.
These examples use the Document Enquiry window, but the functionality is the same in all enquiry windows.
Add or remove columns
- On the enquiry window, right-click anywhere on the document column header bar (or where available, the detail line column header bar).
- Select or deselect the required column headings from the pop-up menu, then select anywhere on the enquiry window to close the pop-up menu.
The column types available for selection depend on whether the headings are at document or detail line level. Selected fields have a Tick icon next to the Title if they are currently displayed. If the column heading is not visible in the enquiry window, use the horizontal scroll bar to move across the window.
Adjust column widths
If a column does not show its full details, or you want to reduce the width of a column to display more columns in the window, you can adjust the individual column widths.
- On the enquiry window, point to the column title in the header bar, then when the adjustment pointer appears, double-click to increase or decrease the width. Alternatively, select and drag the column to the right or left to resize it to the required width.
Move columns
If you want to move the order of the columns, you can drag the required column to a different position.
- On the enquiry window, select and hold the column title in the header bar of the column you want to move, then drag it to the required position on the header bar.
Sort columns
To sort the data, for the required column, select the heading until the results appear in the required ascending or descending order.
You can sort only one column at a time.
Group results
To group the data by a specific column type, select the required heading and drag it onto Drag a column here to group by that column.
To expand grouped column data and display individual transactions, select + for the required row.
Filter results
Results can either be filtered by specific values or on more than one type of criteria.
Sort on specific values
- For the required column heading, select the list arrow.
- Select all the required values.
- To close the filter, select the column heading.
Sort on more than one criteria value
- For the required column heading, select the list arrow.
-
Select the advanced filter icon.
- Enter the required criteria.
- To display the results, select OK.
Save customised displays
If you have customised the display of the enquiry window and you want to save the settings so that they appear by default when you run the particular enquiry, you can save the selected columns as default. When you run the enquiry type again, your default columns then appear with the results.
- On the enquiry window, when you have selected the columns you want to be your default, select SETTINGS, then select SAVE AS DEFAULT COLUMNS.
- The Save As Default Columns message appears, select OK to return to the enquiry window.