ConnectWise
Here’s everything you need to know about the ConnectWise integration and how it works with the Alternative Payments platform.
ConnectWise is available for partners to use in conjunction with their Partner Dashboard to sync invoices to our platform and auto-reconcile invoice payments back to ConnectWise directly. Alternative Payments can integrate to ConnectWise On Premise or ConnectWise Cloud to make collections as seamless as possible.
Overview of synced items
The following items are synced from ConnectWise to Alternative when the integration is connected:
Invoices
Real Time
Customers
Hourly
Payments
Real Time
Deposits
❌
Archiving invoices
Real Time
Archiving customers
Real Time
Delete Payments
Real Time
PDF Invoices
Real Time
ConnectWise sync details
Invoice Status Update
Invoice statuses that are updated in ConnectWise will sync to Alternative Payments and vice versa via two-way sync
Changes to Unpaid Invoices
Changes to unpaid invoices (amount and due date) in ConnectWise will sync to Alternative Payments; changes to unpaid invoices in Alternative Payments will not sync back to ConnectWise
Partial Invoice Payments
Any partial invoice payments/credits applied in ConnectWise will reflect in the outstanding balance of the invoice in Alternative Payments
Customer Created
Customers created in Alternative do not sync to ConnectWise
Invoices Created in Alternative
Invoices created in Alternative do not sync to ConnectWise.
Deleted Invoices and Customers
Invoices and customers deleted in ConnectWise are automatically archived in the Alternative portal
How to connect ConnectWise to your Partner Dashboard
Create your security role
Login to your ConnectWise account
Navigate to System - Security roles from the side menu
Click on the + icon to add a New Role
Role ID = Alternative Agent
Click on the floppy disk icon to Save
Expand the Finance security matrix accordion to grant the following permissions
Accounting Interface: All All All All
Agreement Invoicing: None All All All
Agreements (customize): None None None All
Invoicing: None All All All
Expand the Companies security matrix accordion to grant the following permissions
Company Maintenance: None None None All
Click on the floppy disk icon to Save
Expand the System security matrix accordion to grant the following permissions
Table Setup: None None None All
(Optional) Report Writer: None None None All
Click on the floppy disk icon to Save
Expand the Procurement matrix to grant the following permission:
Products: None, None, None, All
Create an API Member for Alternative
Navigate back to System from the side menu and then Members
Select the API Members tab and click the + button
Fill out required fields (marked by *)
Save the Member by clicking the floppy disk save icon
Generate Public and Private Keys Click on the new API member just created. Select the API Keys tab next and click the + button
Enter a description (i.e. ‘Alternative Access Keys’)
Click save and copy the Public Key and Private Key.
Fill out the Alternative Payments form Navigate back to the Alternative Payments dashboard and enter in the credentials in the form:
Company ID
Public Key
Private Key
Site URL (Required for Self-Hosted ConnectWise instances)
If using Self-Hosted ConnectWise instances that are behind a firewall you will need to also whitelist our IP Addresses listed in the form
Select applicable filters (optional) Select any applicable filters to customize the data import. If no filters are selected, the system will automatically import:
Customers with an Active company status.
Invoices with a Closed status.
You're all set! Congratulations! You're all set with your ConnectWise integration. To view/edit any filters selected in the previous step, click on the three dots within the ConnectWise module and select "Manage filters."
Note: If filters have been removed, associated invoices and customers will not automatically be archived in Alternative. Please reach out to our support team or your customer success manager to archive this data.
Preferences
For partners using ConnectWise as their primary integration, the functionality to initiate manual syncs is available. Navigate to Integrations then select Preferences.
Fetch New Data:This option allows for the sync of all invoices and customers created or updated within the last hour.
Fetch Unpaid Invoices: Partners can now initiate a manual sync for all unpaid invoices. This feature is beneficial for partners who mark any invoices as paid outside of Alternative in Quickbooks Desktop (connected as secondary in Alternative payments) then sync that back to ConnectWise (connected as primary in Alternative Payments) as it addresses a caveat in ConnectWise where invoice statuses are not updated in our system when marked as paid in QBD.
Limitations:
The Fetch New can be initiated once per hour.
The Fetch Unpaid Invoices can be executed once every 12 hours.
You're all set! 🎉
Love our platform? Please rate us on Channel Program!
Last updated