AccountingIntegrator Enabler 2.3.0 User Guide 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 List of Financial-Tags available for use as selection criteria Lower left pane Displays the specific properties of the Balance set selected from the list in the upper pane: Criteria fields Left and Right balance plates of the scale, each containing the field to be aggregated (Cumulative Field) and the access filter (Filter value field) 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: General information Cumulative and Filter fields Criteria fields Completing general information details Use the icon bar to: Add a new Balance set Duplicate a Balance set Delete a Balance set 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. To create a new Balance set, click in the upper left pane. 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. To complete the definition of the Balance set, specify the following: Criteria fieldsThe two left and right plates, each containing the Cumulative field to be aggregated and the field access FilterType of balancing to be checked by the Balance set 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. Select a Balance set and click to remove it from the list of defined Balance sets. 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: 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. [FOR DETAILS Restrictions on the type of Business-Document segment you can select] 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: Select the field you want to delete. 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 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. 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. 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: Select the field you want to delete. 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
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 List of Financial-Tags available for use as selection criteria Lower left pane Displays the specific properties of the Balance set selected from the list in the upper pane: Criteria fields Left and Right balance plates of the scale, each containing the field to be aggregated (Cumulative Field) and the access filter (Filter value field) 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: General information Cumulative and Filter fields Criteria fields Completing general information details Use the icon bar to: Add a new Balance set Duplicate a Balance set Delete a Balance set 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. To create a new Balance set, click in the upper left pane. 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. To complete the definition of the Balance set, specify the following: Criteria fieldsThe two left and right plates, each containing the Cumulative field to be aggregated and the field access FilterType of balancing to be checked by the Balance set 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. Select a Balance set and click to remove it from the list of defined Balance sets. 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: 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. [FOR DETAILS Restrictions on the type of Business-Document segment you can select] 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: Select the field you want to delete. 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 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. 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. 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: Select the field you want to delete. 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