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.