Back Home > Advisor View > Data Dictionary > G > Report Settings: Group By Activity Type or Money Security
|
Back |
Home > Advisor View > Data Dictionary > G > Report Settings: Group By Activity Type or Money Security
|
Report Settings: Group By Activity Type or Money Security
| Applies to: | ||
|---|---|---|
| ✔ Dynamic |
✔ Client Portal |
|
This setting allows you to choose which of the securities available for that report type you see. Each report has a different list of securities to choose from, depending on which ones are applicable for the report.
You can use this setting to turn the Transactions report into a cash ledger when you set Group by to Money Security.
You might choose to use this setting if you want to create a report that's specific to certain transactions—for example, buys, sells, and income. It may be easier to interpret when transactions are partitioned to show only money securities, as opposed to a running a full chronological transactions list.
This setting allows you to use the Transactions report as a basic accounting of transactions, as a transaction report with an emphasis on transaction type, or as a ledger that tracks the impact of every transaction on an account's cash balance and to see exactly how an account arrived at its current cash balance.
To use the standard Transactions report, set Group by to <None>.
To sort all displayed transactions by type, set Group by to Activity Type.
To see a ledger of money security activity, set Group by to Money Security.
If you set Group by to Money Security, the Transactions report will be filtered to display only cash securities. Within cash securities, you can choose to include or exclude certain securities. For example, you may want to include only transactions involving cash.
For more information on the Money Security setting, see See Cash-Impacting Transactions.
| Group by set to <None> |
|---|
|
A standard transaction report is displayed based on the other report settings selected. |
| Group by set to Activity Type |
|---|
|
Transactions are grouped first by activity and then by trade date. Subtotals are provided for each activity type. |
| Group by set to Money Security |
|---|
|
Transactions are limited to only cash securities, and the Cash Impact and Cash Balance columns are added, showing the impact of each transaction as it occurs. For more information on the Money Security setting, see See Cash-Impacting Transactions. |
Functionality is the same in the PDF report templates as in dynamic reports.
Transaction Reports
|
|
For more information on the Group by setting in other reports, see Group By/Then By.
For more information on the Money Security version of the Transactions report, see See Cash-Impacting Transactions.
