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, can 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

Note

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