Transaction Values Allocated View
Transactions Values Allocated view allows you to see the breakdown of every value in the Transaction by the ultimate owning entities. The system can automatically apportion these breakdowns according to a selected path, or allow the user to manually specify the breakdown amounts.
Transaction Value Allocated Features
Transaction Value Allocations allow you to break down the Transaction values by the ultimate owning entities. This is available if the Transaction Code is configured to allow the Allocations to be specified.
With the allocations being part of the transaction, then they are not being dynamically determined by the system when required. Instead these values are the values that are always used for the breakdown to the ultimate owning entities. The system simply uses these allocations for reporting and system calculations. For transactions without these breakdowns it dynamically multiplies the Transaction Values by the determined Path for this Transaction to arrive at the allocations of those Values for the ultimate owning entities.
Note
Normally these breakdowns are only required to be recorded in the system for capital transactions against root entities in the entity structure for the owning entities. Other transactions against other entities in the system can just be dynamically allocated to the owning entities when required. This provides far greater performance, flexibility, and capability.
The Transaction Allocations view will show all allocations for the entire transaction (including all child transactions) by default. You can also select different rows in the Transaction Value View and this view will only show the allocation breakdown for that single transaction. You can select a different Transaction Value row, or clear the selection to see all allocation breakdowns again.
Transaction Value Allocated Properties
A Transaction Value Allocation has the following properties:
| Name | Description |
|---|---|
| [Required] [Key] Parent Transaction |
This holds the link to the parent transaction. This column is hidden by default, and auto-populated by the system |
| [Required] [Key] Entity |
The ultimate owning entity the parent transaction values are being allocated to |
| [Key] Transfer |
Transaction Allocated records are part of the set of records that the system will automatically create when processing a Transfer. If values are being moved from a Transaction Allocated record to other entities those records will be marked with the Transfer process that automatically created them. The net movement from those Transfer records will be 0, but it provides an easy way of viewing which amounts are moving due to transfers. |
| Local Values ... |
All Values for this transaction specified by the Transaction Code (and/or added manually by the user) are available for viewing (and entry, or automatically calculated, depending on the Transaction Code settings) by entity breakdown in Local currency |
| Local Net Amount | The sum of all Local allocated Values |
| Functional Values ... |
All Values for this transaction specified by the Transaction Code (and/or added manually by the user) are available for viewing (and entry, or automatically calculated, depending on the Transaction Code settings) by entity breakdown in Functional currency |
| Functional Net Amount | The sum of all Functional allocated Values |
| Reporting Values ... |
All Values for this transaction specified by the Transaction Code (and/or added manually by the user) are available for viewing (and entry, or automatically calculated, depending on the Transaction Code settings) by entity breakdown in Reporting currency |
| Reporting Net Amount | The sum of all Reporting allocated Values |
Note
The Values Allocated grid automatically displays a column for every Transaction Value in the parent Transaction, and does so for each currency; Local, Functional, and Reporting.
Commands
Note
A Transaction Allocated Value has the standard set of commands and functions when being viewed from a grid. See our standard grid functionality.
You may not be able to create/delete allocation entries if the Transaction Code has been configured to automatically allocate across the ultimate owning entities using the Allocation Path. You may be able to modify the individual amounts. If you can create/delete entries you will also be able to specifically allocate the breakdown value amounts to those entities.
The Values Allocated grid also has the following custom commands:
View Transfers
If amounts have been transferred between transaction allocations using the Transfer [see more] functionality then the "Transfer" column will be visible by default highlighting which rows are Transfers. If not it will be hidden but can be toggled using this command
Hide/Show Zero Columns
When a Transaction is new all value columns are visible, once it is saved and loaded the view will only show columns that have non-zero values by default. This greatly reduces the required screen real estate to see all values of the transaction allocations. You can always toggle the columns with 0 values to be visible again by using this command.