Advent Axys Asset Import

Advent Axys Asset Import

If you are unfamiliar with how Asset Imports in AdvisorEngine CRM operate, see Asset Import Overview before proceeding.

Export from Advent Axys

Configure and prepare an XLS export from Advent Axys with the following Axys fields in this exact column order:

  1. Portfolio Name
  2. Portfolio Code
  3. Security
  4. Sec Type Code
  5. Security Symbol
  6. Security Type
  7. Market Value
  8. Quantity
  9. Asset Class

Contact Advent Axys support if you have any issues creating this report.

Importing Data

  1. In AE CRM, navigate to Import > Asset Import.
  2. Select Advent_Axys from the Select Interface to Run drop-down. Click Next.
    • If you do not see that option in the list, you will need to Add the Interface before you can proceed.
  3. The majority of firms will be able to leave the Configuration set to Default. Click Next.
  4. Click Choose File and browse your PC for the current XLS file. Click Next once you’ve set the file.
  5. You’ll be notified that the import has begun. Click Continue to resume working until the import is ready for review.

Reviewing Import Data

You will receive a System Alert when the imported data is ready to be previewed.

  1. Open the Alerts window and click the System Alerts tab.
  2. Click Acknowledge on the alert.
  3. Click the Alert line to open it.
  4. Click Click to Continue. The Asset Import: Preview Import Values window will open.
  5. After verifying that the data to be imported is correct, click Import to AdvisorEngine CRM. A confirmation box will appear letting you know that the import process has been launched.

Assigning the Imported Data

You will receive a System Alert when the imported data is ready to be assigned to Records and approved.

  1. Open the Alerts window and click the System Alerts tab.
  2. Click Acknowledge on the alert.
  3. Click Click to Continue. The Asset Import: Unassigned Accounts window will open. Any accounts from the import that have not previously been matched to a CRM Record will appear in the top Grid. These must be matched to Records to be imported. Any unmatched account data will be discarded from the import. To match accounts:
    1. Using the checkboxes, select all the accounts belonging to a single Record in the upper Grid.
    2. Search for and select the matching Record in the lower Grid.
    3. Click OK in the pop-up to confirm the match.
    4. Repeat the process until all accounts have been matched.
  4. Click Finish to complete the Asset Import process.