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" |
|
LTRIM(AM->AC_NO)="1*" |
|
REPENT(AM->ENTITY)="SAP" | REPENT(AM->ENTITY)="NTRP" |
|
INANN("R", "", "AM") = 0 & INANN("T","", "AM") = 0 |
|
GL->JE_DESC="ABC COMPANY" |
|
UPPER(GL->JE_DESC)="ABC COMPANY" |
|
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.