Groupings

In Simetrik, groupings are ideal for grouping transactions under a concept, before reconciling them. Their main objective is to be able to generate many-to-many or many- to-one reconciliations.

What can you use groupings for?

Usually in procurement payments, accounting and others do not represent the values at the transactional level, but a sum or grouping of these items is made to generate a value that encompasses all the detail.

This is why it is necessary, according to the criteria defined by the user, to consolidate the transactions in groups that allow comparison and later reconciliation with another source of information.

This grouping functionality also creates traceability of each of the items it contains, thus opening the group and being able to have the transactional detail and its traceability from the group to the transaction.

Additionally, it allows you to create the display of the grouped source information without creating a completely new source, thus keeping the transactionality of the source and its grouped version in parallel. This is especially valuable for sources that must be reconciled against one source in a transactional manner and against another in a grouped manner.

How to create a grouping?

Step 1. Locate the functionality To create a grouping click on the source at the bottom left under Group source:

Step 2. Create the grouping A new view will open where you must assign a name and select whether the grouping is to be applied to a reconcilable group. Similar to a pivot table, select the grouping criteria and the values you want to display.

Step 3. Save and display Select Save grouping and the source will be grouped according to the established criteria and values; these will be displayed as follows:

Note:

• You can add more than one value to the grouping.

• Within the values in the grouping you can apply the following operations:

Sum, count, minimum, maximum, average, variance, standard variance, deviation, standard deviation, median and mode.

Additional functions in a grouping

Because a cluster has a similar behavior to a source, it has some of the same functions, which are as follows:

Filters

1. Delete filters

2. Hide columns

Edit

1. Create Search V

1. Add columns: In groupings in the Add Columns button you will only have enabled the Transformation Columns.

Other

Download Here you can download your grouped source according to the filters you have applied. If you do not have any filter applied, all the transactional base that is in that grouping will be downloaded.