Select Financial Transactions into Set

Before any financial processes can work on financial transactions, the transactions need to be grouped together in a unit of work called the financial transaction set. The subsequent financial processes (supersede and generate financial message) work on this set. The user can define the criteria for the financial transactions to be picked up and grouped into a set by selecting values for the activity parameters. The parameters are a combination of a time span when the financial transactions were created and dynamic fields on the contract level.

This activity has two variants; the user can choose to either:

create a new Financial Transaction Set and add financial transactions to it or
add financial transactions to an existing Financial Transaction Set

Select Financial Transactions into a New Financial Transaction Set

This activity type has the following parameters:

Table 1. Select Financial Transactions into a New Financial Transaction Set
Parameter	Description
Financial Transaction Set Code	The unique code of the new financial transaction set. If no code is provided, the system generates a unique numeric code for the financial transaction set.
Description	The description of the new financial transaction set.
Transaction Creation Date From	Evaluates to true for a financial transaction if the creation date (audit column) of the financial transaction lies between (inclusive) the criteria. If the time element is not specified, it works as follows: If the time element for Transaction Creation Date From is left unspecified, it translates to 00:00. If the time element for Transaction Creation Date To is left unspecified, it translates to 23:59.
Transaction Created Time From
Transaction Creation Date To
Transaction Created Time To
Grouping	When specified, the activity includes only transactions that have a matching financial transaction set grouping specified on the financial transaction process data; when unspecified, no restriction is imposed.
Dynamic Field (1)	Field usage name of the first dynamic field that is used as a filter. Only single value, non-time valid fields on contracts are allowed. If specified - together with the value - then only contracts having a dynamic field with that value, are selected.
Value (1)	Alphanumerical value for the first dynamic field that is used as a filter.
Dynamic Field (2)	Field usage name of the second dynamic field that is used as a filter. Only single value, non-time valid fields on contracts are allowed. If specified - together with the value - then only contracts having a dynamic field with that value, are selected.
Value (2)	Alphanumerical value for the second dynamic field that is used as a filter.

Processing

Processing of this activity has an impact on the following objects in financial:

Financial Transaction Set
Financial Transactions in a Financial Transaction Set
Base Financial Objects related to the financial transactions added to the Financial Transaction Set

These objects are described in the data model section. The actions are described in more detail in the following sections.

Financial Transaction Sets

The following values are set:

The status of the Financial Transaction Set is set to Open.
If the Financial Transaction Set Code parameter has a value, it is used. If no code is provided, the code generates as a numeric code.
If the Description parameter has a value, it is used. If no description is provided, the description is set to Generated Set.

Financial Transactions in a Financial Transactions Set

Each financial transaction that meets both the activity parameter criteria and the conditions listed below, is added to the Financial Transaction Set.

The financial transaction is not already included in any Financial Transaction Set.
There are no other financial transactions in another open Financial Transaction Set, for the same Base Financial Object, that have not been handled by Generate Financial Message activity yet.

In case of (2), the financial transaction can only be added to the other open Financial Transaction Set. If this happens, message FIN-FL-SIFS-001 is created as an activity message. This does not stop the processing of other financial transactions that are selected by the activity.

Base Financial Object

As soon as a financial transaction is added to a Financial Transaction Set, the status of the related base financial object is set to 'Changed' and the General Financial Processing Complete Datetime is cleared. Also, this activity automatically adds:

all previously created financial transactions for the same Base Financial Object, that are not included in another Financial Transaction Set.
all reversal transactions for the same base object, that reverse a transaction preceding one of the included transaction.

Note that later versions of the financial transaction are not automatically included in the Financial Transaction Set.

Select Financial Transactions into an Existing Financial Transaction Set

This activity can be started within the context of an open Financial Transaction Set. This activity type has the following parameters:

Table 2. Select Financial Transactions into an Existing Financial Transaction Set
Parameter	Description
Transaction Creation Date From	Evaluates to true for a financial transaction if the creation date (audit column) of the financial transaction lies between (inclusive) the criteria. If the time element is not specified, it works as follows: If the time element for Transaction Creation Date From is left unspecified, it translates to 00:00. If the time element for Transaction Creation Date To is left unspecified, it translates to 23:59.
Transaction Created Time From
Transaction Creation Date To
Transaction Created Time To
Grouping	When specified, the activity includes only transactions that have a matching financial transaction set grouping specified on the financial transaction process data; when unspecified, no restriction is imposed.
Dynamic Field (1)	Field usage name of the first dynamic field that is used as a filter. Only single value, non-time valid fields on contracts are allowed. If specified - together with the value - then only contracts having a dynamic field with that value, are selected.
Value (1)	Alphanumerical value for the first dynamic field that is used as a filter.
Dynamic Field (2)	Field usage name of the second dynamic field that is used as a filter. Only single value, non-time valid fields on contracts are allowed. If specified - together with the value - then only contracts having a dynamic field with that value, are selected.
Value (2)	Alphanumerical value for the second dynamic field that is used as a filter.

Processing

Processing of the Select Financial Transactions into an existing Financial Transaction Set activity has an impact on the following objects in common financial:

Financial Transactions in a Financial Transaction Set
Base Financial Objects related to the financial transactions added to the Financial Transaction Set

These actions are described in more detail in the next sections.

Financial Transactions in a Financial Transactions Set

Each financial transaction that meets both the activity parameter criteria and the conditions listed below, is added to the Financial Transaction Set.

The financial transaction is not already included in any Financial Transaction Set.
There are no other financial transactions in another open Financial Transaction Set, for the same Base Financial Object, that have not been handled by Generate Financial Message activity yet.

Base Financial Object

all previously created financial transactions for the same Base Financial Object, that are not included in another Financial Transaction Set.
all reversal transactions for the same base object, that reverse a transaction preceding one of the included transaction.

Note that only earlier transactions for the same base object are automatically included; later transactions are not.

When a financial transaction is added to the set, the system iterates over each preceding transaction for the same base object, starting with the most recent. On each iterated transaction Supersede indicator is set to No. The iteration stops - before setting the indicator - as soon as a transaction has its 'message mandatory' indicator set to 'yes' or is already handled. This iteration creates a 'clean slate' for Supersede Financial Transaction activity.

Messages

The activities can generate the following messages:

Table 3. Messages
Code	Severity	Message Text
FIN-FL-SIFS-001	Informative	Cannot add financial transaction to the transaction set because another version of this transaction is included in a set {code} that is open
FIN-VL-SIFS-001	Fatal	Financial transaction set code {0} already exists
FIN-VL-SIFS-005	Fatal	Cannot add financial transactions to financial transaction set with code {0} because the set is Closed
FIN-VL-SIFS-006	Fatal	Transaction Creation Date From cannot be after Transaction Creation Date To
FIN-VL-SIFS-011	Fatal	Dynamic field usage name {field usage name} is unknown
FIN-VL-SIFS-012	Fatal	The dynamic field usage must be single value and non-time valid
FIN-VL-SIFS-013	Fatal	The dynamic field usage may not refer to a dynamic record definition or flex code set
FIN-VL-SIFS-014	Fatal	Both dynamic field and value must be specified