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:
ConnectWise sync details
| Item | 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
1 | 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
2 | 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
3 | 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
4 | 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
4 | Expand the Procurement matrix to grant the following permission:
- Products: None, None, None, All
6 | 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
7 | 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.
8 | 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
9 | 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.
10 | 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.
1. Fetch New Data:This option allows for the sync of all invoices and customers created or updated within the last hour.
2. 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!