Back |
Home > Advisor View > Accounts, Groups & Households > Custom Fields for Accounts, Reporting Groups, Households, and Securities
|
Custom Fields for Accounts, Reporting Groups, Households, and Securities
Have you wanted to track specific information in Advisor View, but couldn't find an existing field for that information? You can create custom fields to make this possible. Custom fields are available for:
Accounts and reporting groups
To keep track of new account status, you can create a New Account custom field that is set to Yes for all new accounts by default. When the account is fully set up, it is changed to No. Combined with a saved search, this allows you to effectively track new account status.
Households
Cherry Street Financial has its own in-house financial planning offering. This service gives clients a percentage that indicates the likelihood of meeting their financial goals based on their current financial choices.
Cherry Street adds a custom field called Odds of Success (%) and they use a bulk upload to populate all the Households with this metric. They then create a client dashboard tile that displays this percentage on the client portal, allowing each client to see their Household's financial planning status.
Securities
Let's say you want to use a custom bond rating classification system and then generate reports or view audit history information on your screen when a rating is either upgraded or downgraded. You can add custom fields to any security and then run PDF reports using custom security information.
Custom fields can contain any data that you want and can be number fields, percentage fields, data fields, check boxes, drop-down lists, or text fields—it's completely up to you.
Once you set up your custom fields, you can see them on:
Reports. Add custom fields as available columns on most of your dynamic, PDF, and bulk reports.
Custom Sections and Headers & Footers. Add custom fields to your custom sections and headers and footers.
The Accounts, Households, and Securities Pages. Add custom fields as columns to views on the Accounts, Households, and Securities pages.
Saved Searches. Create complex saved searches using custom data fields.
Household custom fields are not available for saved searches.
To set up custom fields, you'll first create the global custom field and designate what entity it applies to (accounts, accounts and groups, Households, or securities). Then you'll update the field either one at a time on the appropriate page or in bulk using bulk uploads.
To create a custom field:
On the Setup menu, click Custom Fields.
On the Custom Fields page, click Create.
Complete the following settings:
Keep Household custom field names clear and precise if your clients are likely to see it on their dashboard tiles.
When finished, click Create.
To delete a custom field:
On the Setup menu, click Custom Fields.
On the Custom Fields page, click Delete for the field you want to delete.
You can't delete a custom field when it's being used somewhere in Advisor View. If you want to delete a field, you first have to find everywhere it is used, stop using it in each location, and then delete it. To make it easier to find where fields are used, you can use the In Use report, which provides a list of where each custom field is used.
To run the In Use report:
On the Setup menu, click Custom Fields.
Click the In Use hyperlink in the row of the field you want to delete.
A CSV file will automatically be generated and downloaded that tells the report name, report type, and owner name associated with each use of that particular field.
To make changes to a custom field:
On the Setup menu, click Custom Fields.
Click Edit next to the custom field you want to edit.
When you've finished making changes, click Save.
You cannot reorganize the order custom fields appear in on the Custom Fields panel.
Accounts, groups, Households, and securities display custom fields alphabetically on their Custom Fields panels. If you create a custom field section, the sections appear in alphabetical order after all the individual custom fields. Within a section, all settings appear in alphabetical order.
Once you've created a global custom field, follow these steps to assign it to an account, group, Household, or security:
Open the grid page you want to view.
Accounts
Households
Securities
Click the entity where you want to assign the custom field.
In the Custom Fields tab, enter the values for the custom fields. If the custom field you want does not appear, visit Create Global Custom Fields for Accounts, Reporting Groups, Households, or Securities.
You can see tracked changes for custom fields by clicking the Show History link for that field. This link will be available for custom fields that maintain history, and it allows you to see when the custom field was modified, and who modified it.
For more information on maintaining history, see Maintain History.
When finished making the changes, click Save.
After you've built your custom fields and assigned the appropriate values to your accounts and groups, follow these steps to add the custom fields to saved searches:
On the Reports menu, click Saved Searches.
In the list of saved searches, choose the saved search where you want to use a custom field.
Click Add Filter. The custom fields will appear in the list of search filters. In the example below, City/Office is a custom field.
Household custom fields are not available for saved searches.
When you've finished customizing your saved search, click Save.