Between operator—Used when a range of source accounts are specified in the Criteria Value field. Separate the accounts that specify the range by a comma.
Like operator—Used when the source accounts in the Criteria Value field contain wildcard characters. Use question marks (?) as placeholders and asterisks (*) to signify indeterminate numbers of characters.
In operator—Used to include one source account or a list of non-sequential source accounts.
By default, a logic account is created for each center in the trial balance. For example, if the Criteria Value field is 12300, the result would be a logic account created for each source center that is associated with account 12300.
You can create a logic account that summarizes multiple source centers by, in the Criteria Value field, placing a semicolon after the account name and entering the number that identifies the number of characters that you want to group by.
For example, if the value in the Criteria Value field is 12300;4, the result would be a summarized account that includes all source centers that have the same first four characters in the source center name. The source center assigned to account 12300 is the four characters that start at position 1. In addition, if the value in the Criteria Value field is 12300;3;4, the result would be a summarized account that includes all source centers that have the same three characters in the source center, starting at position 4. The source center assigned to account 12300 is the three characters that start at position 4.
You can create a logic account that summarizes all source centers by, in the Criteria Value field, placing a semicolon after the account name and entering a text value. This hard-coded text value becomes the center for the summarized logic account. For example, if the value in the Criteria Value field is 12300;Dept100, the result would be a summarized account that includes all source centers. The source center assigned to account 12300 is Dept100.