Cumulative groupings
This functionality is a complementto improve the adaptability of thegroupings to the different usecases you may have in yourreconciliation process.
Last updated
This functionality is a complementto improve the adaptability of thegroupings to the different usecases you may have in yourreconciliation process.
Last updated
Types of groupings:
ACCUMULATIVE: Is where all records are dynamically grouped together as files are uploaded to the source and can be reconciled again, regardless of whether any previous versions are reconciled.
NON-CUMULATIVE: Where records from the original source will only be part of a single grouping that becomes immutable once reconciled.
The behavior of cumulative groupings is to continue accumulating items in a grouping even though it is already reconciled, while in the case of non-cumulative groupings the behavior is the opposite, an item can only belong to one line of the grouping.
When creating a grouping you must consider the following improvements that were added in the creation process
The reconcilable group will be chosen by default (all source).
The name of the grouping will be generated by default: Grouping dd/mm/yyyy
The cumulative grouping toggle will be disabled, therefore all groupings will be born as non-cumulative)
Step 1. When creating a grouping you will be able to select the behavior you want your grouping to have through the toggle located at the top right.
Behavior in Editing
When a grouping of any type is used in a reconciliation and once the reconciliation becomes "finished", the possibility of making changes to the structure of this grouping will be blocked. Therefore, when editing a reconciliation you must take into account the following restrictions:
Modify the grouping criteria (neither delete nor add new ones).
Delete value fields or modify the arithmetic operation applied on them. Only new value columns can be added.
Modify the Reconcilable Group
Modify the accumulable toggle.
It shall be allowed:
Modify the name of the grouping
Add transformation column and new value columns
Hide columns
Important notice
Once a grouping has been used in a reconciliation, it can no longer be activated or deactivated in the "Cumulative" option.
A grouping of any type can only be used in a single reconciliation. Once the grouping is set to " finished " status, the possibility to make changes to the structure of the grouping will be blocked.
You will not be able to generate a reconciliation between two cumulative groupings, as they are of type "N:N", i.e. many to many.
Note: An N:N reconciliation is a reconciliation under which its configuration will allow you to reconcile many items of counterparty A against many items of a counterparty B. This type of configuration is very useful when you need to compare a record against a product catalog where you may have the same record associated to one or more products. So you will have N records as many products as you have associated.
When one of the sources to be reconciled is a cumulative grouping, deleting a file from any of the reconciled sources will not delete the records from the reconciliation.
