General Ledger GL Query Builder CQB Design Elements Filters
Understanding the GL Query Builder (continued)
Filters
Filters are used to include or exclude records from the report query. Each Filter is based on a Data Field to which a Relation is applied and criteria selected from a drop-down list or typed in by the User.
For example a report query is being designed to create a list of Customer Credit Memos posted during the month of August 2009. A filter may be created which will include only transactions with a register type of CRMEMO during the date range needed and will exclude the debit side of the transaction. Below is how this filter would be created.
ss5162
Continue on to the next page for a list of all possible filter Relation operators.