Balancing-Rule: Balance Conditions tab

About the Balance Conditions tab

Using the right pane

Using the left pane

Completing general information details

Setting Criteria, Cumulative, and Filter fields

Setting the balance operator

Setting the Output-Event type Financial-Tag

Restrictions on the use of Business-Document segments

About the Balance Conditions tab

Use the Balance Conditions tab to define and test the balancing criteria against the Output-Event data. You can set a maximum of 50 Balance sets. Each Balance set comprises a number of properties based on the segments from the Business-Document selected on the General tab.

The Balance conditions tab comprises three panes, as illustrated schematically below.

Upper left pane

General information on the list of Balance sets

Right pane

Business-Document sub-tab

  • Tree structure of Business-Document you selected in the General tab Structure field

Financial-Tag sub-tab

Lower left pane

Displays the specific properties of the Balance set selected from the list in the upper pane:

Using the right pane

The right pane displays the Business-Document selected in the Business-Document field on the General tab, and the list of Output-Event type Financial-Tags you defined.

When you click the Business-Document, this pane displays a tree of its segments.

You can drag-and-drop a field from the Business-Document to the appropriate zone in the left pane:

Zone in left pane Number of fields you can define

Criteria field

As many as required

Cumulative field

Only one

Filter field

Similarly, you can drag-and-drop a Financial-Tag into the Financial-Tag zone in the left pane. When you use a Financial-Tag the system only applies the Balancing-Rule to the Output-Events which have a Financial-Tag included in the set of selected Financial-Tags. For example, suppose you have four Output-Events:

  • One debit with a Local Financial-Tag
  • One debit with an IAS Financial-Tag
  • One credit with a Local Financial-Tag
  • One credit with an IAS Financial-Tag

You can choose to apply the Balancing-Rule on the Local Output-events only, the IAS Output-Events only, or both.

Using the left pane

The left pane contains three sections for defining the Balance set:

Completing general information details

Use the icon bar to:

Adding a Balance set

If the Compensation option is selected on the Compensation tab and you want to create a new Balance set, the system displays a message that warns you that only one Balance set can be taken into account for a given compensation Output-Event.

  1. To create a new Balance set, click in the upper left pane.
  2. Set the following general information attributes of the Balance set.
Field Contents

Number

Indicates the order in which the system executes the Balancing-Rules. The system assigns this number automatically when you create the balance set.

Label

Double click in the Label field to enter a free-text description for this Balance set.

To modify the Label, double click it, or press F2.

  1. To complete the definition of the Balance set, specify the following:

Duplicating a Balance set

Select an existing Balance set and click to create a copy. The system creates another Balance set beneath the one you selected and assigns a default Number. You must then modify the definition fields as required.

Deleting a Balance set

If the Compensation option is selected on the Compensation tab and you want to delete a Balance set, the system displays a message that warns you that you will loose the mappings and asking him if you want to continue anyway. If you choose to continue, all the mappings are lost and the compensation option is deselected.

  1. Select a Balance set and click to remove it from the list of defined Balance sets.
  2. Click Yes on the confirmation message.

Setting Criteria Fields

The Criteria fields serve to group together the Output-Event objects to weigh in the balance set. You can only place those Output-Events whose Criteria fields are identical in the same group.

Adding balance criteria

To set balance criteria:

  1. Drag-and-drop segments that you want to set as criteria from the Business-Document tree in the right pane and place them in the Criteria field zone in the left pane.
  2. [FOR DETAILS Restrictions on the type of Business-Document segment you can select]
  3. Define the Filter field and filter values to specify which plate (left or right) the system places the Output-Events to add the contents of their Cumulative fields.

Deleting balance criteria

Select a balance criterion and drag-and-drop it into the Business-Document tree in the right pane.

Or alternatively:

  1. Select the field you want to delete.
  2. Right-click and select Delete from the contextual menu.

Setting Cumulative fields

The Cumulative field corresponds to the field to be aggregated (that is, the weight of the object to be weighed), selected from the numeric segments in the Business-Document. This field is mandatory in the plate definition and must be an Integer.

Adding a Cumulative field

From the right pane, drag-and-drop a Business-Document segment field into the Cumulative field.

[FOR DETAILS Restrictions on the type of Business-Document segment you can select]

Deleting a Cumulative field

Select a Cumulative field and drag-and-drop it into the Business-Document tree in the right pane.

Setting Filter fields

The Filter field serves to filter the Output-Events before the system counts them on the plates of the balance set. Typically, you have one filter for the left plate and one for the right.

Adding a filter

  1. From the right pane, drag-and-drop a Business-Document segment field into the Filter field. [FOR DETAILS Restrictions on the type of Business-Document segment you can select]
    This activates the Filter Value box. Type in the Filter Value you require.
  2. Click to add a filter value. AccountingIntegrator Enabler generates a blank cell in the Filter Value box. Enter the required value for the identifier you selected in the Criteria field.
  3. When AccountingIntegrator Enabler runs the Balancing-Rule, it performs an OR logical operation on all the values to determine if the Output-Event, via the contents of its Filter field, satisfies the filter condition.

Example

This example uses the following filter:

  • Left filter field: DIRECTION
  • Right filter field: DIRECTION
  • Left filter values: D, 1, -
  • Right filter values: C,2,+

This filter means that AccountingIntegrator Enabler places and counts Output-Events which contain a value of:

  • D,1 or - in their DIRECTION filter field on the left plate
  • C,2 or + in their DIRECTION filter field on the right plate

Deleting a filter

Select a filter value in the Filter Value box and click to delete it.

Caution: There is no warning or confirmation message.

Setting the balance operator

In the Operator field, select an operator from the drop-down list to specify the type of test the Balancing-Rule applies to the criteria set in the Criteria field.

Operator label

Equals

Less than

Greater than

Less than or equal to

Greater than or equal to

Not equal to

Setting the Output-Event type Financial-Tag

From the right pane, drag-and-drop a Financial-Tag into the Financial-Tag field.

Or alternatively:

  1. Select the field you want to delete.
  2. Right-click and select Delete from the contextual menu.

Use this option to specify which Financial-Tags must have Output-Events included in the Balancing-Rule.

Restrictions on the use of Business-Document segments

This table summarizes the Business-Document segments you cannot use in defining the Balance set.

Balance definition field Business-Document segment not available

Criteria

  • Segments that are already defined as Criteria, Cumulative or Filter fields in this Balance set
  • Segments that are hierarchically inferior or superior to segments already defined as fields

Cumulative

  • Segments that are already defined as Criteria, Cumulative or Filter fields in this Balance set
  • Segments that are hierarchically inferior or superior to segments already defined as fields
  • Segments whose Data Type is set to Alphanumeric or Date

Filter

  • Segments that are already defined as Criteria, Cumulative or Filter fields in this Balance set
  • Segments that are hierarchically inferior or superior to segments already defined as fields

Back to top

Related Links