Balance Group Support for Balance Exception Report

If you have a large number of balances that need to be validated for exceptions, group together balances that have the same exception requirements.

You can then use the balance group to define a balance exception and run the Balance Exception Report.

This enables you to define a balance exception rule that is applied to all balances within the group.

For example, to track any absence element with a value greater than $2,000, do the following:

1. Add all (primary) absence balances into a balance group.
2. Define a balance exception to support this balance group requirement, as given in this table.

   Component	Value
   Comparison Type	Current Period
   Balance Group Name	Enter a suitable name, say Salary. (Includes primary absence balances)
   Balance Group Usage Name	Enter a suitable name, say Salary Usage.
   Dimension	<Assignment > <Tax Unit> Period to Date
   Variance Type	Amount
   Variance Operator	Greater Than
   Variance Value	2000
   Severity	1

Use this balance exception to run the Balance Exception Report. With this defined balance exception rule, the report identifies any employee with a current period balance value greater than 2,000.

Suppose the payroll has three employees with the following details:

• Employee A with a Salary of 2500 and a Car Allowance of 2400.
• Employee B with a Salary of 2100 and Car Allowance of 1900.
• Employee C with a Salary of 1900 and Car Allowance of 750.

The Balance Exception Report will include the following:

• Employee A: Two exception rows. One for Salary and another for Car Allowance.
• Employee B: One exception row for Salary of 2100.
• Employee C is excluded from the report because salary and car allowance of the employee is below 2000.

When you use the Balance Exception page to create or edit an exception, the page displays balance groups that meet the following criteria:

• The balance group must have a balance group usage. The balance group usage should have a matrix type.
• Balances included in the balance group must all have the same dimension.
• The dimension of all the balances included in the balance group must match the same comparison type.

  For example, for a comparison type of Current Month, the balances in the balance group must all have dimension of Month. Similarly, for comparison type of Current Run, Current Period, Current Quarter, or Current Year, the balances in the balance group must all have dimension of Current Run, Current Period, Current Quarter, or Current Year, respectively.

When you create the balance exception you can chose either Balance Name and Dimension, or Balance Group Name, not both.

Note:

You can’t delete a balance group that is used to define a balance exception rule.

The variance types supported for the balance group is Formula and Amount. Any balance in the balance group that matches the exception condition is displayed in the Balance Exception report output.