Vertafore AMS360™
Streamline tax filing, reporting and reconciliation through the automated import of policy data into InsCipher.
Before Getting Started
What does this Integration do?
It utilizes Vertafore's OData connection method to automatically retrieve policy data from AMS360.
What does this Integration not do?
- At this time, it is unable to pull documents associated with policy data.
- There is no functionality yet for Tax Calculation or Payment reconciliation, though these functionalities are actively being researched for future phases.
Before continuing, please be aware that this service is not currently available to all clients. At a minimum, clients must be subscribed through Vertafore to the AMS360 OData connection method. If you are an AMS360 customer but do not currently utilize the OData connection, please contact your dedicated Vertafore sales representative or account manager to understand if this can be set up on your agency’s behalf.
Technical Installation Details
For those clients who have access to the OData connection method, the following is required:
-
Access to a Vertafore API Developer Portal account.
-
Create an OData app inside of developer portal account:
- This can be done under My Applications section. Note that initially after being created, the app will be in sandbox mode.
-
Contact Vertafore support to push sandbox OData app to Live:
- To complete this process, you will need to reach back out to Vertafore support to request that your sandbox application be pushed to Live.
-
Gather these four OAuth credentials from your Live OData app (you will need to input these in Step 1 of InsCipher-AMS360 Integration):
Credential Where to find Email My Applications -> (click on your Live OData app) -> Application Information -> Contact Email Instance / Agency ID Can be found in your AMS360 app under Agency or Company Information, or when logging into AMS360, this ID will be shown when selecting the Agency (see example screenshot below). If you cannot find this, contact your Vertafore account manager / representative. Username My Applications -> (click on your Live OData app) -> OAuth Credentials -> Show Details (under Actions) -> Client ID Password My Applications -> (click on your Live OData app) -> OAuth Credentials -> Show Details (under Actions) -> Client Secret
Additionally, a few configurations are required within your existing instance of AMS360 to ensure that InsCipher can pull information about invoice activity.
In AMS360, within the Administration tab, navigate to Agency Overview and then to Activity/Suspense Setup. Within the dialog, you will see a Checkpoints table. Enable (check ON) these three settings in the Active column and Require Activity Column (you may need to click the Edit button to make changes to the table):
- Invoice (Posting) Center Billed Only
- Invoice (Void)
- Invoice Correction (Posting)
How this works - and a few other notes
The Integration Tool will automatically extract relevant surplus lines policy data out of your local AMS database and import that data into Connect® on a daily occurrence. Typically, this occurs around 2 AM Mountain Standard Time (MST). Policies included in the daily import will be those that were marked as having the corresponding invoice:
- Exported
- Collected by the Agency
- Taxed
Steps in completing the Integration
To fully connect your agency's AMS360 instance to InsCipher to start importing policy data, you will need to complete a series of 4 steps within the InsCipher Integration Tool.
Step 1: Setup & Connection
To begin, you will first need to log into your Connect® account. Click on the Settings cog in the top right navigation bar > “Integrations” > then click on the “ADD NEW” button to start the Integration Wizard. This wizard guides you through a 4-step process of installation. Select Vertafore AMS360 from the dropdown to add the integration.
Step 1 involves the input of credentials mentioned in Technical Installation Details > Step 4, which are Email, Instance Id, Username and Password. All of these fields are required to move to Step 2.
Step 2: Initiate Mappings and install API connection
In Step 2, the InsCipher connection to your instance of AMS360 is established and fields pulled for the mapping exercise in Step 3 - Fields Mapping, are verified. Unless there are errors with the API connection and/or in retrieving mapping data, there should be no need for manual input here and you can proceed to Step 3.
Step 3: Field Mapping
Once the connection is complete and the Integration Tool is synced with InsCipher Connect®, Step 3 involves the requirement to manually map the data pulled in from your instance of AMS360 by the integration tool to standard values within InsCipher to ensure data parity. The tables required to map in the Field Mapping step are:
- Taxes and Fees
- Line of Business (LOB)
- Business Units
- Filing Types
- Insurance Companies
You will need to map all of these values in order to proceed to Step 4.
Map Taxes and Fees
The first of the required sections to map involves the Tax and Fee Mapping table (ex. shown below):
Here, the integration pulls in both AMS Code and AMS Description for each of the AMS360 fields relating to taxes or fees. To begin the mapping process, choose one of the options per AMS Code line item to map these values to in the dropdown under InsCipher Taxable Fees and State Taxes. The mapping options are:
- Do Not Import
- Broker Fee
- Carrier Fee
- Stamping Fee
- Sl Tax
- EMPA Tax
- FM Tax
- Municipal Fee
- Sl Service Charge
Map Lines of Business (LOB)
Once you’ve mapped Taxes and Fees, move down to complete Line of Business Mapping table:
Here you’ll be asked to map the derived AMS codes for individual Lines of Business (LOB) to an InsCipher Generic Line of Business code. You can do this using the State Specific to Generic LOB mapping worksheet or the more simplified Generic Lines of Business worksheet. If necessary, you can map specific LOB codes per AMS code under the InsCipher State Specific Codes column, where an option to select a state and LOB description are given.
More information on Line of Business in AMS360.
Map Business Units
Next you will need to complete the Business Unit Map section. This is where you will be able to enable or disable the import of policy data related to a specific business unit tag in AMS360.
By default, the integration is able to pull in business unit information down to the Group level in AMS360. Under the Import column, you will choose whether to enable import or leave as is - the default state is Import Disabled.
More information on Business Units in AMS360.
Map Filing Types
Filing or Transaction type naming and usage vary from AMS360 and InsCipher. In order to ensure these are mapped correctly, custom mapping is available within the Filing Types Mapping table with the option of having a transaction type vary for positive and negative amounts to match your specific workflow.
Here, the type of Policy Transaction Codes are pulled from AMS360 under the AMS Transaction Type column along with a corresponding Description, which are listed under the column labeled Comments. Within InsCipher, this will need to translate and map to platform-defined transaction types associated with negative or positive premium as defined by the platform using the InsCipher Positive Premium Filing Code and / or Negative Premium Filing Code dropdowns. Within those dropdowns, these are the InsCipher transaction types to map to:
- PN (New Policy)
- PR (Renewal Policy)
- APE (Additional Premium Endorsement)
- RPE (Return Premium Endorsement)
- AE (Audit Endorsement)
- FC (Flat Cancellation)
- ZPE (Zero Premium Endorsement)
- PC (Pro Rata Cancellation)
- XE (Extension Endorsement)
- RI (Reinstatement)
- BO (Back-out / Reversal)
- BD (Binder)
More information on Policy Transaction Codes in AMS360.
Map Insurance Companies
The final table to map on Step 3 is Insurance Company Mapping. Here, Insurance Company Code and Name are pulled from AMS360 and displayed in the first two columns. The manual mapping requirement is necessary in the third column, InsCipher Insurance Company, where for each insurance company code/name derived from the integration, the requirement is to map it with a corresponding Insurance Company on record with InsCipher.
Step 4: Summary
The final step of the integration tool is a review of the Steps completed and any issues that are still outstanding. Having the following items checked as complete indicates that there are no outstanding issues with the integration:
An integration connection made during the day may only populate with policy data the next day due to the cadence of the integration. Please reach out to InsCipher support if data in the Filings Import Log is not populated promptly within the next day.
You also have the option to pull in up to two weeks of historical data from AMS360 using the Trigger a Manual Import button.
In choosing a date, you will be limited by the Import From calendar picker component to two weeks prior to the current date. Once this request is submitted, it can take up to 30 minutes for this data to appear in the Filings Import Log.
If there are errors or other issues with the status of the integration, you will see them on this page.
Troubleshooting
At a minimum, InsCipher will notify via email and notification center if the following cases occur:
Warnings
These are generally prompts to encourage a user to take an action on something that may lead to an averse outcome if not taken in a timely manner.
Title | Description | Suggested Action |
---|---|---|
Integration Incomplete | Occurs whenever the system detects an incomplete integration before Step 3. | Complete integration steps to Step 3. |
Fields Need Mapping | If the mapping exercise for all required fields from the tables on Step 3 have been started but not completed, users will see this warning | Complete mapping exercise for all tables on Step 3. |
Errors
System based messages indicating technical problems that lead to partial or lost functionality.
Title | Description | Suggested Action |
---|---|---|
Integration Connection is Lost | Occurs whenever the integration tool cannot make connection with AMS360 | 1. Reinitiate AMS360 integration connection: On the Vertafore API Developer Portal, Navigate to: My Applications -> (click on your Live OData app) -> OAuth Credentials -> Manage OAuth Credentials -> Edit -> OAuth Credential Details dialog -> (do not make any changes, but click Save - this will re-initiate the connection). 2. Manually trigger import of data not pulled in during lost connection: On Step 4 or Summary Page of Integration Tool, click Trigger a Manual Import button. You should select the import date of the day your integration connection was lost and your agency stopped receiving data. This will pull in information that failed to import to InsCipher during the lost connection period. |
For any other errors, contact InsCipher support.
Updated 6 days ago