Building a condition with the Condition Builder

The Condition Builder has three columns. You can add more than one condition on the Condition Builder. If you select Match All, all the conditions must be met. If you select Match Any, any one of the conditions must be met.

Note: Familiarity with the database structure of the business class and the values that exist is required when using literal values.

Use this procedure to build conditions.

In the left column, select the field to which you assign a condition. For example, to select employees for company 9100, select Company.

Note: The set of fields that are accessible are the fields included in the business class that you selected. If you are not sure where to find the field, specify it in the Search field, then select the occurrence that matches your condition.
In the middle column, select the condition operator, for example, is equal to.
In the right column, select Literal and specify the value. In this case, 3004.
To add another condition, click the Plus icon.
If applicable, add another condition in the second row. For example, to set only employees from the CORP process level to be eligible, select Company > ProcessLevel (left column) is equal to (center column) Literal CORP (right column).
Continue adding your conditions until you are finished. For example, to further limit the employee group to the ACCTG department, select Company > Department (left column) is equal to (center column) Literal ACCTG (right column).
```
(Company = 9100 and ProcessLevel = "CORP" and Department = "ACCTG")
```
Note: To remove a condition from the Condition Builder, click the Minus icon next to the condition.
When you are finished with your conditions, click OK. All the conditions you defined are added in the Condition box separated by and or or, that depends on whether you selected Match All or Match Any. For example:
```
(Company = 9100 and ProcessLevel = "CORP" and Department = "ACCTG")
```
To remove a condition when created, remove it from the text box.

Note: The Condition Builder does not accommodate all scenarios. For example, to pull employees from more than one department, you must edit the base condition within the text.
To add more conditions, click Builder, specify your conditions as defined above, and click OK.

When you click OK, the system asks you whether to replace the existing conditions with these conditions, or whether to append the conditions to the existing conditions. If you select Append, the conditions are added at the end of the other conditions.
To preview the group of employees or bank statement lines generated by the condition, click Preview.

Guidelines for bank line statement custom groups

The rules to group bank line statements are complex and requires careful planning.

The objective is to pull together like transactions that are assigned to the same category. For example, you can assign all credit card transactions to the same category. That means identifying all the ways in which credit card transactions are referred to on your bank statement and creating a custom group that pulls bank statement lines that include that any these descriptions. Because the strings that you are looking for are only a subset of the entire statement line, you must use a like operator and surround each string with a wildcard character (*). This is an example of a bank line statement:

(DebitCreditIndicator = DebitCreditIndicator.Credit and (Description like "*MERCHANTBNKCDDEPOSIT*" 
or Description like "*BANKCARDDEPOSIT*" or Description like "*NOVUS*" or Description like "*FNBO*" 
or Description like "*GLOBALPAY*" or Description like "*GLOBALPAYGLOBALDEP*" 
or Description like "*DISCOVERNETWORKSETTLEMENT*" or Description like "*DISCOVERBUSSVCSETTLEMENT*" 
or Description like "*AMERICANEXPRESS*" or Description like "*AMERICANEXPRESSSETTLEMENT*" 
or Description like "*DEPOSITCAPTUREBANKCARD*" or Description like "*DEPOSIT/SETTLEBANKCARD*" 
or Description like "*NPC*" or Description like "*CTSHOLDINGS*" or Description like "*BANKCARDSERVICEEDCDEP*" 
or Description like "*BANKCARDBTOTDEP*" or Description like "*NPCMERCHPYMTPROC*" or Description like "*BANKCARDMTOTDEP*" 
or Description like "*SHOWMASTERCARDMTOTDEP*" or Description like "*IATSPAYMENTS*") and DescriptionMatchesIdentifier)