Transactions Set View

The Transactions Set View is designed to allow you to work with all Transactions within a set. A set of Transactions involve all header Transactions that are child Transactions of a root Transaction or a custom parent entity. Transaction Sets allow groups of related transactions to all be viewable and modifiable at the same time. See here for more information on Transaction Structures.

Transaction Set Features

Transaction Sets allow the user to modify all related transactions that were created by a user, created through custom processes in the Transaction Code, or have the same entity item parent (For instance Blend Transactions use the Transaction Set view as they are the parent item for the set of transactions they automatically create). The user can then interact with all these Transactions and modify them individually.

Transaction Set Properties

Transaction Sets are a list of Transactions with the following properties:

Name	Description
[Key] [Read-Only] Reference	The unique reference for the Transaction. This is automatically generated by the system and is auto-incremented each time even across Canvases.
[Required] Status	The Status of the Transaction, cam be: In Progress Committed Finalized Cancelled Sometimes this is locked, and can only be changed via the Save command which will allow you to select a new status. You can not change a Transaction to cancelled, you have to use the Cancel command on a finalized Transaction.
[Required] Transaction Code	The Transaction Code for this Transaction which defines the Requirements, Values, Rules and Processing of this Transaction
[Required] Transaction Date	The transaction date for the Transaction. This date is used for all sub-transactions too.
[Required] Financial Date	The Financial Date for this Transaction. This is calculated from the Transaction Date and the latest Period Closing on the Entity for this Transaction. If the Transaction Date is less than the Latest Period Closing for the Entity, then the Financial Date will be the next day after the latest Period Closing for that Entity. Otherwise it will match the Transaction Date if it is in an open period.
Settlement Date	An optional date that is only required if the Transaction Code configuration requires it.
Description	A short user friendly description for this transaction
Cancelled	Holds the Transaction record this Transaction cancelled during a Cancel or Cancel/Correct operation
Corrected By	Holds the transaction record this Transaction was Corrected By during a Cancel/Correct operation
[Required] Entity	The legal Entity this Transaction is against.
Instrument	Optional - The Financial Instrument, if any, this Transaction is operating against. Unless specifying Allocations of the Transaction Values individually, then the Path is required if this isn't provided.
Path	Optional - The Path to use when allocating the Values from this Transaction to their ultimate owners. Unless specifying Allocations of the Transaction Values individually, then the Instrument is required if this isn't provided.
Local Net Amount	The total of all values in this transaction stored in the local currency
Func Net Amount	The total of all values in this transaction stored in the functional currency, which is the currency of the legal Entity of this transaction
Reporting Net Amount	The total of all values in this transaction stored in the reporting currency, which is the currency of the Entity Set this Entity belongs to. In other words the common currency for consolidating reporting across all entities in the entity structure
Currency	This is the local currency the values for this Transaction will be entered in. This is calculated from the currency of the Instrument against this transaction, or if there is none it is the currency of the Entity.
Ledger	The Ledger this transaction entry if to be reported against. This ledger, unless overridden, will be the ledger used for the GL Posting entries too
Allocation Type	The Allocation Amount to use when allocating the values in this Transaction to their ultimate owners through the Allocation Path. Possible values are: Default This indicates to use the AmountA amount through the Path for allocation AmountB This indicates to use the AmountB amount through the Path for allocation
Rounding	This indicates the type of rounding to apply when automatically creating allocated transaction entries for the value amounts. This can be: Currency Round allocated amounts to the nearest number of decimal places held for this currency Cents Round allocated amounts to the nearest .01 TenCents Round allocated amounts to the nearest .1 Singles Round allocated amounts to the nearest single unit Tens Round allocated amounts to the nearest 10 Hundreds Round allocated amounts to the nearest 100
Units	The number of Units for this Transaction. Only available depending on the Transaction Code configuration.
Price	The Price for a Unit in this Transaction. Only available depending on the Transaction Code configuration.
FX Rate	Holds the FX Rate automatically pulled from the exchange rates table from the Local Currency to the Functional Currency of this transaction.
Reporting FX Rate	Holds the FX Rate automatically pulled from the exchange rates table from the Local Currency to the Reporting Currency of this transaction.

The Transaction Set view has the same columns for editing Transactions as the Transaction View itself, although some of those columns may be hidden by default.

Commands

A Transaction Set has the standard set of commands and functions when being viewed from a grid. See our standard grid functionality.