dBase filter

You can use a dBase filter to only display specific transactions, accounts or balances in an automatic document.

Syntax: DATABASE->FIELDNAME<ComparisonOperator>VALUE

Filter Description

AM->TYPE="B"

  • Filters one criteria in the AM database.
  • Only displays accounts in the AM database with an account type of "B" (i.e. Balance Sheet).

LTRIM(AM->AC_NO)="1*"

  • Uses additional functions and wildcards.
  • Only displays accounts in the AM database with an account number starting with 1.
  • The LTRIM function removes spaces that are added to the left of the account number when stored in the database.

REPENT(AM->ENTITY)="SAP" | REPENT(AM->ENTITY)="NTRP"

  • Filters using entity abbreviations .
  • Only displays accounts in the AM database that are assigned to the abbreviated entities SAP or NTRP.
  • The REPENT function is used to evaluate the entity abbreviation.
  • The | operator is used to combine two filter commands. Accounts will display if either condition is true

INANN("R", "", "AM") = 0 & INANN("T","", "AM") = 0

  • Filters all references and tickmarks.
  • Only displays accounts in the AM database that contain a reference and tickmark.
  • The INANN function is used to evaluate whether a tickmark or reference is associated.
  • The & operator is used to join both conditions.

GL->JE_DESC="ABC COMPANY"

  • Filters the GL database.
  • Only displays transactions in the GL database in which the description starts with "ABC COMPANY".
  • This filter is case sensitive.

UPPER(GL->JE_DESC)="ABC COMPANY"

  • Ignores upper and lower case.
  • Only displays transactions in the GL database in which the description starts with "ABC COMPANY".
  • The UPPER function is used to remove case sensitivity.

Notes:

  • Filters can be enhanced by using Text functions to define the filter. For more information, see Text functions.
  • Filters may contain multiple conditions. Use & or | to join the conditions.
  • The maximum length for a database filter is 200 characters.
  • Filters may break or not function correctly if you modify the format of the filtered automatic document.