Balancing-Rule: Start here

What is a Balancing-Rule

Where is a Balancing-Rule

How you define a Balancing-rule

How you use a Balancing-rule

What is a Balancing-Rule?

When AccountingIntegrator Enabler generates Output-Events, you can also configure it to check the data in those Output-Events against certain balancing criteria. The set of checks is defined as a Balancing-Rule object. You specify in balance sets on the Balance conditions tab the set of criteria to use to select data for checking.

AccountingIntegrator Enabler tests either of the following:

Currently if the balance is not achieved,

How the Balancing-Rule works

Composition of a balance set

The following table summarizes how each balance set is organized.

Balance set element Description

The Output-Events to be checked

The Output-Events:

  • are divided into groups, depending on their Criteria fields. That is, the Output-Events with identical values in their Criteria field belong to the same group.
  • have a Filter field. The value contained in this Filter field determines whether AccountingIntegrator Enabler places the Output-Event on the left or right plate in the balance set.
  • also have a Cumulative field, which provides the total weight of the plate on which you place the Output-Events.

 

Mathematical operator

Determines when the Balancing-Rule can declare the Output-Events in a given group to be in balance. The operators include: Equals, Less than, Greater than, Less than or equal to, Greater than or equal to, and Not equal to.

[FOR DETAILS: Setting the balance operator]

Examples

  • If you set the operator as Equals, the system declares the balance set as balanced when the weight of the left plate in the balance set is equal to that on the right.
  • If you set the operator as Less than or equal to, the system declares the balance set as  balanced if the weight of the left plate is less than or equal to that on the right.

 

In addition to the Criteria fields, Filter fields, filter values, Cumulative fields, and operators described in the preceding table, a balance set also comprises the Business-Document that the Balancing-Rule references.

Multiple occurrences of balance sets

For each balance set, AccountingIntegrator Enabler creates as many occurrences as the number of Output-Event groups generated when you applied the Criteria field in the balance set.  

AccountingIntegrator Enabler declares a balance only if all the occurrences of each balance set you defined in the Balancing-Rule are balanced.

Example of a two-plate balance

This example uses a Balancing-Rule which has one balance set defined.

For each Output-Event it processes in a given set, AccountingIntegrator Enabler  Rule Engine reads the values of the balancing criteria set by the associated Balancing-Rule.

  • If there is no balancing criterion, the system creates and checks a single balance set occurrence.
  • Each new combination of values produces a new balance set occurrence.
  • In the case of an existing combination of values, AccountingIntegrator Enabler  Rule Engine performs the actions described in the following table, depending on the value of the Output-Event Filter field.
If the value of the Output-Event Filter field equals the value of the... AccountingIntegrator Enabler  Rule Engine adds the ...

Left filter

  • Output-Event to the left plate
  • Value of the Cumulative field (that it reads from the Output-Event) to the total accumulated on the left plate

Right filter

  • Output-Event to the right plate
  • Value of the Cumulative field (that it reads from the Output-Event) to the total accumulated on the right plate

If the filter values read in the Output-Event do not exist in the Balancing-Rule definition, the processed Input-Event fails.

After dividing the set of Output-Events to be checked, the operation checks that the type of balance set defined is true for each of the balance set occurrences created.

If one of the balance set occurrences does not verify the balancing type:

The processed Input-Event if in the associated Transformation-Rule, you requested

fails

Rule balancing

is rejected

Input-Event balancing

Group balancing

Illustrating the example (1)

To check the accounting entries:

  • By customer: the amount debited must be equal to the amount credited and the entries balanced
  • By customer and by currency: the amount of currency debited must be equal to the amount of currency credited

The Output-Events with the following properties are to be checked:


Customer no. Currency code Credit/Debit Amount

1

EUR

D

100

1

EUR

C

100

1

SFR

D

50

1

SFR

C

50

2

EUR

D

80

2

EUR

C

100

This check requires you to create a Balancing-Rule with two balance sets, which you apply to the Output-Events to verify that they balance as illustrated in the following diagram:

When you apply the Balancing-Rule, the system creates:

  • Two balance set occurrences for the first balance set (balance by customer), because there are two separate customers.
  • Three balance set occurrences for the second balance set (balance by customer and currency), because there are three separate customer/currency pairs.

The Customer 2 - Currency: EUR balance and the Customer 2 are unbalanced.

Example of a single-plate balance

For each Output-Event it processes in a given set, AccountingIntegrator Enabler  Rule Engine reads the values of the balancing criteria defined in the associated Rule

Each new combination of criteria values produces a new balance set occurrence. In the case of an existing combination of values, AccountingIntegrator Enabler  Rule Engine:

  • reads in the Output-Event the value of the field to be aggregated
  • adds this value to the left plate

When AccountingIntegrator Enabler  Rule Engine processes all the Output-Events, it checks to make sure that all aggregated numbers that it creates are correctly balanced. (An aggregated number is the result of a balancing occurrence.)

The following describes the results if one of the aggregated numbers is different from the others (that is, it does not correctly balance).

The Input-Event processed if, in the associated Transformation-Rule, you requested:

fails

Rule balancing

is rejected

Input-Event balancing

Group balancing

Illustrating the example (2)

This example uses the same sample data shown in the table and used in the previous two-plate illustration. To check the accounting entries for all customers, the accounting debit must be equal to the credit amount in euros.

This check results in the creation of a balancing set, as illustrated below:

When AccountingIntegrator Enabler runs this check, it creates the following two occurrences of the balance set, because there are two different values for the Credit/Debit criteria field, that is, D or C:

The balancing check fails, because the amounts on the two plates are not equal.

Where is a Balancing-Rule?

Axway module

AccountingIntegrator Enabler

Workbench

Integration-Services: Finance tab

Object dependencies

When you define or import an object, it is stored in the metadata repository and is available for reuse by other objects. Typically, the objects that you define exist in a specific object hierarchy. That is, objects:

  • use objects below them in the hierarchy
  • are used by objects above them in the hierarchy

To help you manage the interlinked network of objects, the software provides the Object Dependencies Browser that displays the object dependencies for a selected object.

The following table lists the objects that use and are used by Balancing-Rules.
 

 

 

How you define a Balancing-Rule

Before you define a Balancing-Rule

Before you create a Balancing-Rule, you must create the following objects:

  • Business-Document
  • Financial-Tag (if used as criteria)

Defining a Balancing-Rule

Create the Balancing-Rule object from the Dictionary tab.

To define a new Balancing-Rule object, complete the following tabs:

In addition, the Balancing-Rule properties window contains the following tabs:

  • Signature tab
  • Description tab

After you define a Balancing-Rule

After you define a Balancing-Rule object, you can associate the Balancing-Rule with different Processing-Context-Out objects. In this case, the Output-Event structures associated with the Processing-Context-Out must be compatible with the structure of the Balancing-Rule.

How you use a Balancing-Rule

You can perform all basic operations on Balancing-Rule objects, depending on your user rights. [FOR DETAILS: Working with objects: Start here]

The Balancing-Rule object does not follow the standard object life cycle. You cannot explicitly send this object to Production.

Back to top

Related Links