A dBase filter can be used on some automatic documents to filter results. Only transactions, accounts or balances matching the dBase filter will display. A filter can be established on any field in the AM or GL database. Multiple conditions can be used.
Expression
DATABASE -> FIELDComparison operator VALUE
Example 1: Filtering one criteria in the AM database
AM->TYPE="B"
Only accounts in the AM database with an account type of "B" (i.e. Balance Sheet) will display.
Example 2: Using additional functions and wildcards
LTRIM(AM->AC_NO)="1*"
Only accounts in the AM database with an account number starting with 1 will display. The LTRIM function removes spaces that are added to the left of the account number when stored in the database.
Example 3: Filtering using entity abbreviations
REPENT(AM->ENTITY)="SAP" | REPENT(AM->ENTITY)="NTRP"
Only accounts in the AM database that are assigned to the abbreviated entities SAP or NTRP will display. The REPENT function is used to evaluate the entity abbreviation. The | operator (OR) is used to combine two filter commands. Accounts will display if either condition is true
Example 4: Filtering all references and tickmarks
INANN("R", "", "AM") = 0 & INANN("T","", "AM") = 0
Only accounts in the AM database that contain a reference and tickmark will display. The INANN function is used to evaluate whether a tickmark or reference is associated. The & operator (AND) is used to join both conditions.
Example 5: Filtering the GL database
GL->JE_DESC="ABC COMPANY"
Only transactions in the GL database in which the description starts with "ABC COMPANY" will display. This filter is case sensitive.
Example 6: Ignore upper and lower cases
UPPER(GL->JE_DESC)="ABC COMPANY"
Only transactions in the GL database in which the description starts with "ABC COMPANY" will display. The UPPER function is used to remove case sensitivity.
Related Articles
How do I create a L/S that only lists Material / Non-Material accounts from my trial balance?
Using the dBase filter in the properties of a Leadsheet, and other trial balance-based Automatic Documents, allows you to display specific accounts or balances. Refer to CaseWare Working Papers help for more information on dBase filters. For example, ...
How to use the Audit Program Checklist Filters?
In the Audit System Program or Checklists, sorting or searching through all your audit procedures can be tedious and time-consuming. To assist with this, the audit procedures can be filtered. Procedure: 1. Click on the Filter Procedures button, to ...
How do I use the new Flat-form Risk tables?
The new Flat-form risk tables contain risks identified in the engagement file. They can be found in several different workpapers, and the functionality of the table depends on which workpaper you are in. For those using the Public Sector template, ...
How to Print Out my RRPT - Risk Report
The RRPT Risk Report is quite a large document. Therefore the document has particular view users can select to 'neatly' print out their RRPT Risk Report. Follow the steps below to select this view: 1. Ensure the Filters and Views area is open (it ...
What is the difference between Cleared and Completed?
Issues are resolved by the assigned audit team member(s) and then cleared by the issue owner (creator). Process of an Issue: 1. Issue is raised by the audit team member (typically the manager). 2. When the issue is created the creator will then ...