By combining leading-edge technology with our advisor-focused DNA, AdvisorEngine CRM is designed to enhance the way you do business now and in the future. To prepare for your upgrade, it is important that your current Junxure data is ready for the transition. This document will guide you through the steps needed to review your unique database and ensure that data integrity is maintained during the upgrade. It includes a workable checklist followed by detailed instructions for each step. We suggest keeping a copy of your Junxure Cloud Upgrade Assessment Report (JCUA) handy as it will provide you with valuable information as you complete this checklist. Please do not hesitate to reach out to us with any questions.

We suggest keeping track of who is assigned to completing each one of these objectives and marking when it is completed.

Summary Checklist

Click any item for detailed instructions

Required

• Clean up any active/inactive users
• Ensure all users have a valid email address in their user profile
• Verify ALL contacts have a First Name and Last Name, or if the contact is an entity, an Entity Name
• Ensure all contacts have a Classification
• Make sure all associates have an Associate Type (if applicable)
• Reassign actions assigned to queues (if applicable)
• Update Tax Year date on Taxes and Suitability tab (if applicable)
• Ensure all documents are associated with a Contact Record
• Update Non-standard Insurance Types (if applicable)

Strongly Encouraged

• Review Contact-related List Data Maintenance (LDM) lists as appropriate
• Review Action-related List Data Maintenance (LDM) lists as appropriate
• Standardize Action Template and Action Sequence categories
• Copy and Save any email templates you use in Microsoft Word
• Print out a list of any Deliverables you have in the system

Suggested

• Create Data Check reports to make sure your important fields are complete
• Confirm or Print outstanding Alerts and FYIs

Required

Clean Up Any Active/Inactive Users

Ensure that your system correctly reflects your active and inactive users. Your JCUA report will identify your firm’s active and inactive users.

To make any adjustments:

1. Go to System Setup > Users.
2. Scan the list to ensure that the Active checkbox is checked only for truly active users.
3. To clear the Active check box, double-click the User Profile row to open it in edit mode and clear the Active box.

We strongly recommend that you DO NOT delete Users from the system.

Ensure all users have a valid email address in their user profile

This email address is sourced as the user’s AE CRM username. Your JCUA report will list all of the active users in your system with the email address currently listed in their User profile. Users with missing email addresses will be highlighted. Review all others for accuracy. To make any adjustments:

1. Go to System Setup > Users.
2. Double-click a user to add or update the email address.

Verify ALL contacts have a First Name and Last Name, or if the contact is an entity, an Entity name

Records in your system that do not contain a Last name or Company name will be reported on your JCUA report by their Junxure ID. To make corrections use the Search fly-out window to quickly access the Record. Type ID and then the Junxure Record ID number (no space). Example: ID111.

Ensure all contacts have a Classification

Every Contact Record in AE CRM must have at least one Classification. The JCUA report will list all records in your system that do not currently have a Classification. To easily add a Classification to each record:

1. Go to Reports > Reports List > Data Checks > People Without Classifications.
2. Choose the preview icon to bring up a grid of all Contacts without a classification.
3. Double-click a row to open the Contact and add a Classification.

Make sure all associates have an Associate Type (if applicable)

All Associates in AE CRM must have an Associate Type. Your JCUA report will identify any associates who are missing a type. To add associate types:

1. Go to Reports > Report Lists > Global Associates Report.
2. Click View Results in the upper right to see a list of all associations in your database.
3. Filter the Associate Type column for blanks.
4. Double-click a row to open the Contact and add the Associate Type for the association.

Reassign actions assigned to queues (if applicable)

The functionality enabling you to assign actions to Queues is not available in AE CRM. If you are using this feature in Junxure Desktop your JCUA will advise you of pending actions currently assigned to a Queue. Eact action will need to be reassigned to a single active User before you upgrade. Additionally, please reassign any Action Templates, Action Sequences, and Recurring Actions that are assigned to Queues. To make these adjustments:

1. Go to Reports > Actions Dashboards to view pending actions assigned to Queues.
2. Go to Reports > Reports List > Reassign Actions to reassign these actions.

We strongly recommend that you complete a backup before using this tool. Please contact the support team if you have any questions on how to use this tool.

Update Tax Year date on Taxes and Suitability tab (if applicable)

Each year, you can document tax information in the Taxes & Suitability tab and archive the previous year’s information for future reference. If the information noted in the current view of the Taxes and Suitability area does not have a year identified, it will default to the year the upgrade to AE CRM takes place. To check this detail in your Junxure database, create a report using the Contact Report Wizard.

Ensure all documents are associated with a Contact Record

Documents not specific to a contact record and found in the Company Files area will not upgrade to AE CRM. To upgrade these documents, create contact record named Migration and move these documents into that document folder to be associated with that record.

Update Non-standard Insurance Types (if applicable)

Only select insurance types are available in AE CRM. These standard insurance types are: Auto, Dental, Disability, Health, Home Owners, Life, Long Term Care, and Umbrella. The JCUA will advise you of any non-standard insurance types in your system. Please update these to a standard insurance type. If you choose not to update these, the non-standard insurance types will revert to a type of Life upon migration.

To make adjustments:

1. Create a report using the Insurance Report Wizard (Reports > Report Wizard > Insurance Report).
2. Click Check Results.
3. Double-click any row to go directly into the record and update the Insurance Type field.

Strongly Encouraged

Review Contact-related List Data Maintenance (LDM) lists as appropriate

AE CRM is more strict about discrepancies between Contact LDM lists (such as Classifications, Keywords, and Interests) and what is actually used in a Contact Record. To reconcile any discrepancies in your database, the following logic will be applied as part of your upgrade:

¹ We recommend that you use the Contact Data Maintenance tool to change any items that are not currently in your LDM lists to items that are.

Review Action-related List Data Maintenance (LDM) lists as appropriate

AE CRM is more strict about discrepancies between Action LDM lists (such as Action Type, Process, and Action Keywords) and what is actually used in an Action. To reconcile any discrepancies in your database, the following logic will be applied as part of your upgrade:

¹ We recommend that you use the Contact Data Maintenancetool to change any items that are not currently in your LDM lists to items that are.

Standardize Action Template and Action Sequence categories

In AE CRM all Workflows use the same set of categories, whether they are single-step or multi-step. Determine your standard category list and then update the Action Template Categories List AND the Action Sequence Categories List in Junxure to match. To make these updates:

1. Go to System Setup > List Data Maintenance > Action Template Categories and update the list.
2. Go to System Setup > List Data Maintenance > Action Sequence Categories and update the list to match.
3. Go to System Setup > List Data Maintenance > Action Templates and update the category for any template as necessary.
4. Go to System Setup > Action Sequence Setup and update the category for any sequence as necessary.

Copy and Save any email templates you use in Microsoft Word

While Document Templates migrate into AE CRM, Email Templates do not. You will want to open any email templates that you use and copy the content into a Microsoft Word document. This will make recreating these in AE CRM much easier.

Keep in mind that any merge fields used in the template will need to be re-added in AE CRM.

Print out a list of any Deliverables you have in the system

Deliverables migrate into AE CRM as Recurring Actions. That said, AE CRM does have deliverable-like functionality via the Service Monitor. Printing out a list of these deliverables now will allow you to recreate them the Service Monitor if desired.

You can print out a list of Deliverables within the Actions Management section under the People menu.

Suggested

Create Data Check reports to make sure your important fields are complete

We suggest cleaning up your data prior to the upgrade. Every user should determine which contact fields are important to your firm. To make sure this information is complete for all clients (or contacts), create a report using the Contact Report Wizard.

Confirm or Print outstanding Alerts and FYIs

Outstanding Alerts and FYIs do not upgrade to Junxure Cloud.

You will need to either confirm any outstanding Alerts and FYIs or print them out before your migration is complete. Don’t forget to check postponed alerts if you use this function.