Oracle® Rules Palette Release 9.1.0.0.0 E15811-01

# Steps to Set-up CoA Criteria

In order to configure criteria that is used to determine the correct account for suspense or a transaction, you need to configure two rules. The two rules are as follows:

- ChartOfAccountsScreen: This rule is used to set-up the fields on the Chart of Accounts screen. It is located in the Global Explorer tab under Business Rules | Screen Rules.

- ChartOfAccountsCriteria: This rule is used to configure the logic that matches criteria and the account to use when writing records to the database. It is located in the Global Explorer tab under Business Rules | System Rules.

#### ChartOfAccountsScreen Rule

ChartofAccountsScreen business rule can be used to configure dynamic fields and validation for the criteria section in Step Four of the Chart of Accounts wizard. These fields can be configured for both suspense and transaction accounts. The criteria are client specific field information used to identify the correct account entry to which accounting should be written when there are multiple applicable accounts.

Note: This rule ONLY configures the fields. You need to configure the ChartofAccountsCriteria rule in order to configure the logic of how the information input into the fields gets values to match criteria. See the ChartOfAccountsCriteria business rule section for further information.

ChartofAccountsScreen XML Definition

<ChartOfAccountsScreen> Opening/Closing tag

<TransactionAccounting> Indicates fields for transactions

<Fields> Fields section that will be used as criteria to match a debit/credit on an account

<Field> Standard field tag

<Name> Name of field

<Display> Display of field

<DataType> Standard field datatype (this is almost always is a combo box)

<Query> Standard query tag for combo boxes and radio buttons

<SuspenseAccounting> Indicates fields for suspense

<Fields> Fields that will be used as criteria to match a debit/credit on an account

<Field> Standard field tag

<Name> Name of field

<Display> Display of field

<DataType> Standard field datatype (this is almost always a combo box)

<Query> Standard query tag for combo boxes and radio buttons

#### ChartofAccountsCriteria rule

This rule is only used in conjunction with the ChartOfAccountsScreen rule. ChartOfAccountsCriteria rule is used to configure the logic that identifies the correct account to use for accounting processing based on criteria information. The fields that capture the criteria information are configured via the ChartOfAccountsScreen rule. If a transaction or suspense account has multiple associated accounts, this rule can be configured to identify the correct one via a criteria match.

ChartofAccountsCriteria XML Definition

<ChartOfAccountsCriteria> Opening/Closing tag

<TransactionAccounting> Criteria information for transaction fields

<Criteria> Information about criteria for fields on the ChartOfAccountsScreen rule.
This tag must be configured for each transaction that could use multiple
accounts for processing.

- Attribute NAME Exact name of CoA field to match to criteria

- Attribute WILDCARD Used to specify a value that if the criteria is set will cause it to be ignored

- Attribute CATEGORY Specifies where to get a value to match criteria either POLICY or MATH.

- POLICY looks at AsPolicy and AsPolicyField

- MATH looks for a MathVariable or field in the transaction.

- Attribute CATEGORYFIELD Name of field or MathVariable to use to match the criteria value. This field or MathVariable must be the exact name found either on the Policy screen or in the transaction’s math section.

<SuspenseAccounting> List of criteria information for suspense fields

<Criteria> Information about criteria for on field on the ChartOfAccountsScreen rule

- Attribute NAME Exact name of CoA field to match criteria up to

- Attribute WILDCARD Used to specify a value that if the criteria is set will cause it to be ignored

- Attribute CATEGORY Specifies how to get a value to match criteria either SUSPENSE or SQL for either the suspense record or a SQL statement.

- Attribute CATEGORYFIELD Name of field or MathVariable to use to match the criteria value. Only valid if CriteriaCategory is not set to SQL

- Attribute - SQL SQL to get value to compare to CoA criteria. Only valid if category is set to SQL.