ID964 - Connectwise Manage Agreement Sync - Overview

This integration syncs agreement invoices from Connectwise Manage to eAutomate as contracts. 

Jump to Overview | Samples | Variables | Set UpAlert Functionality | Best Practices & Tips |  Related Alerts 

Click to Subscribe  

Click here for our ID964 videos!



Connectwise (CW) Manage and the RMM tools do an excellent job of tracking products included on agreements, so we recommend that the CW Agreement be the master for contract billing. This sync process will take the agreement invoices from CW and create matching contracts in eAutomate. The base amount and additions from the Connectwise agreement will push to eAutomate and update the line items on the contract when the agreement is billed in Connectwise. This sync does not push any information from eAutomate to Connectwise.


**It's important to note that Connectwise Manage is not an accounting software and therefore things do not have to balance in the same way that they do in eAutomate. For example, the Connectwise invoice can have an item with a quantity and extended price and show a billed amount of zero. EAutomate will not allow this, the software automatically calculates the billed amount as the quantity times the extended price. 


This process will create the contract if it does not exist in eAutomate, and create the items on the contract if they also do not exist. You can choose to create the contracts and items yourself in eAutomate and link them to the agreements and products in Connectwise, but we recommend allowing the sync to create these for you. This way requires the least manual intervention by your team and therefore saves you the most time.


We are using "templates" in eAutomate to create both the contracts and the items. A contract template is simply a non-billing contract, with the customer as your dealership, that the sync will copy, update the customer, and add the line items to match the Connectwise agreement invoice. Similarly, item templates are simply items that the sync copies when creating new items in eAutomate to be added to the contract. We create these templates for you as part of the testing process for the sync.


The trigger for the sync is the creation of the agreement invoice in Connectwise. Once a new agreement invoice is created, the sync will check:

1. Is the customer linked in Connectwise? (This is done through mapping the ConnectWise company to a custom property on the eAutomate customer record. Invoices where the customer or bill to customer is not found will error and not import)

2. Is the agreement in Connectwise linked to a contract in eAutomate? (This is done by a custom field in CW. If the contract was created by the sync, the field will be automatically updated by the sync. If you want to sync to existing EA contracts, you'll need to manually fill in these custom fields with the EA contract number, though we don't recommend using this option). If the agreement is linked to a contract in eAutomate, that contract will be updated by the sync.

3. If the contract does not exist, the sync will create the contract by copying the appropriate contract template, then add the line items from the agreement invoice to the contract as serviceable items. Items that don't already exist in eAutomate will also be created based on the item templates.

Once the contract is updated by the sync, you will need to cycle the contract through the billing queue in eAutomate.



  • Must be on Connectwise 2015.3 or later, REST API was introduced in 2015.3. On-Premise or Hosted will both work.
  • Must be on eAutomate 8.7 or later, Serviceable items added then. Will work with either ECI Hosted or On-Premise.
  • Not required, but we do suggest you enable the "HelpDesk Button" in eAutomate.
  • .NET Framework on the server must be version 4.6.1 or higher.
  • Must be subscribed to ID747 
  • Serviceable items must be enabled in eAutomate (see here for where to turn that on)


Run Schedule: Every 15 minutes

Type of Output: Data Push

*  *  *




The blue shaded areas on the contract are information pulled from ConnectWise:

  1. Customer - The customer from the ConnectWise agreement.
  2. Start date - The start date will match the agreement billing start date UNLESS the agreement started mid-month. Those contracts will import showing a start date of the first of the month. This is due to how the proration calculations work in eAutomate. The line item amount coming in from ConnectWise has already been prorated, if the line item is added in eAutomate with a partial month, eAutomate will prorate the amount again. 
  3. Expiration date - End date of agreement in ConnectWise.
  4. Billing cycle - Will match from ConnectWise as long as billing cycles are set to match exactly between CW and EA. Details on that here.


The green shaded areas on the contract are pulled from the template used to create the contract:

  • Contract type
  • Contract bill code
  • Base distribution code

The yellow shaded areas are automatically generated by eAutomate:

  • Contract number - The new contract created by the sync will use the next auto-generated number. If you have set something in variable 9 on the alert, those characters will be added at the beginning of the contract number.

On the Equipment/Items tab of the contract:


Each product listed on the additions tab of the agreement will be listed as a serviceable item on the contract in eAutomate.

The blue shaded areas on the contract are information pulled from ConnectWise:

  1. Item number - pulled from ConnectWise, item is created by sync if doesn't already exist.
  2. Description - description from ConnectWise, if there are multiple line items on the ConnectWise agreement of the same item number, all will be rolled up together and description will contain information from all items. (eAutomate doesn't allow the same item to be listed on the contract more than once.)
  3. Quantity - matches the quantity of the production in ConnectWise **If there are multiple products listed of the same product ID those will be rolled into one item on the contract, see more details on this here.**
  4. Unit base rate - Price from ConnectWise
  5. Base rate - Ext Price from ConnectWise


The green shaded areas on the contract are pulled from the templates

  • Base distribution code - code from the item record, which would match the code on the item template for that product type.

On the Billing/Contact Tab:


The blue shaded areas on the contract are information pulled from ConnectWise:

  1. Bill to - matches bill to customer in ConnectWise
  2. Name - contact name on the ConnectWise agreement
  3. Blanket PO - ConnectWise invoice number


The green shaded areas on the contract are pulled from the template used to create the contract:

  • Billing group - if set on the template
  • Report group

The yellow shaded areas are automatically pulled from the customer record in eAutomate:

  • Branch
  • Tax code
  • Taxable
  • Terms 

The messages tab:


The blue shaded areas on the contract are information pulled from ConnectWise:


The sync adds a billing queue message noting when the next bill date of the agreement in ConnectWise is, this pulls from the next bill date in ConnectWise. If no date is shown in ConnectWise in this field, the message will indicate that ConnectWise didn't provide a date. This message will need to be acknowledged before billing the contract.


*  *  *




Variable W: Serviceable Item - Enter the item number to be added to the contract that will be used on all service calls generated by ID965 integration. This item will be added to all contracts created by the sync. **Required, the default value is CW-Service.

Variable Z: Mark Invoices Paid - Option to mark invoices as paid in ConnectWise when the invoice is paid in eAutomate. The default option is No, switch to Yes if you want the sync to update the invoices in ConnectWise and mark as paid.


Variable 4: Default Contract Template - the name of the default contract template in eAutomate. This template would be used if there is no matching contract template for the agreement type from Connectwise. The default is **CWAgreement.  **Required, we will create this template for you during the preflight process.

Variable 3: Contract # Field - the name of the custom field in Connectwise used to store the eAutomate contract number. See this link for how to set up the custom field in Connectwise. The default value is ZCJ_ContractNumber. **Required.

Variable 5: Default Item Template - the name of the default item template in eAutomate. This template would be used if there is no matching item template for the product type in Connectwise. The default is **CWJuiceDefault. **Required, we will create this template for you during the preflight process.

Variable 6: Item # Field - the name of the custom field in Connectwise to store the eAutomate item number. See this link for how to set up the custom field in Connectwise. The default value is ZCJ_ItemNumber, when the sync creates an item it will add the item number to this field. **Required. 


Variable 11: Default Term Code - Termination code to use when a contract detail line item is terminated on the eAutomate contract. Needs to be the code, not the description. **Required**

Variable 1: Agreement Status - If you would only like to sync agreements with a specific status, enter those statuses here. Leave blank to sync all agreement statuses.

Variable 2: Agreement Type - If you would only like to sync agreements of a specific agreement type, enter the specific agreement types to sync here. Leave blank to sync all agreements.

Variable 7: Exclude Product Types - If there are specific product types in Connectwise that you do not want to sync over to eAutomate, enter those here. Leave blank to sync all product types. (For example, if you have cost items on the Connectwise agreement and do not want those products to sync over to eAutomate, enter the product type of those items here to exclude them.)


Variable 9: Contract #  Prefix - If you would like the contracts created by the sync to have a specific prefix (CW, MNS, IT, etc) enter that here. When the contract is created by the sync, it will add the letters from this variable to the beginning of the contract number. Leave blank to use the default contract number.

Variable 8: Renumber Invoices - You have the option to renumber the contract invoices in eAutomate to match the invoice number in Connectwise. Set this variable to Yes to renumber the invoices, choose No to not renumber the invoices. (Example, the invoice number in Connectwise is CW1234 and the invoice number in eAuomate for the contract invoice is INV123456. If you choose yes here, we will install a process that will change the invoice number in eAutomate from INV123456 to CW1234. This is especially helpful if you are sending the invoice from Connectwise, but applying the payment in eAutomate.)

Variable 12: Invoice Renumber Prefix - If you chose to have the invoices in eAutomate renumbered, you will need to select a prefix to use on the invoice. The default value is CW. If your invoices in Connectwise are ONLY numeric, you must select a prefix to add to the invoice number in eAutomate. (Example, your Connectwise invoice is 1234, to avoid possible duplicate invoice numbers in eAutomate, you must choose a prefix to add to the invoice so that the renumbering process will change the invoice number to CW1234 or MNS1234)

Variable 10: Invoice Status Trigger - If you only want agreement invoices in a specific status (Closed, for example) to sync over, enter that status in this variable. Leave blank to sync all agreement invoices regardless of invoice status.


Variable X: Push Invoice # to CW after billing - After the contract invoice is created in eAutomate, the invoice number will push to the invoice in ConnectWise. Not needed if you are using the invoice renumber option.

Variable 10: Invoice # Field - ConnectWise custom field to hold the eAutomate invoice number. Only needed if Variable X is set to yes and the invoice renumber option is not used.

*  *  *

Set Up

Set Up

1. Subscribe to both ID747 and ID964, being sure to update the variables as needed. If you don't have a login to our subscription site, you can email to have us set you up with a login. 

These next three steps may need an IT person with admin access to ConnectWise and eAutomate

2. Create API keys for CEO Juice in ConnectWise and enter them on the CEO Juice website (See this link for instructions on how to do that)  

3. We do require that the initial sync goes from your production ConnectWise database to a Test/Development EA database, so you will need to have a test eAutomate database set up for this process. If you have a test ConnectWise database, we can initially sync from that, but it is not required.   (This sync process only pushes information from ConnectWise to eAutomate while in test) **It's important that this test eAutomate database is not refreshed with new data during the testing process!!

**When creating a test eAutomate database be sure that you set up the company in eAdmin and don't just set the database up in SSMS. If you have questions on how to create a company in eAdmin, the ECI help page (16.1 | 17.2 | 20.1) has details under E-admin > Company Management > Creating and Restoring a Company:


 4. We also require a test copy of our CEO Juice database to be created for the testing phase. See this link for details on how to do that.  

The next set of steps revolve around your setup in ConnectWise and will involve users who know how agreements and customer information is set up in ConnectWise and how the contracts should bill in eAutomate.

5. Do you currently track the eAutomate customer number on the company record in ConnectWise?  

        If yes, we can update the custom property in eAutomate for you.

        If not, you’ll need to enter the ConnectWise Company Rec_ID in the custom property for the eAutomate customer.

6. There are also a few other custom fields that need to be created in ConnectWise:

        ZCJ_ContractNumber – On the agreement, to store the contract number from eAutomate.  

        ZCJ_ItemNumber – On the product ID, to store the item number from eAutomate.  

    See instructions on how to create these custom fields in CW here.

7. Review the Product types you currently have in ConnectWise, you will have one item template for each product type in ConnectWise. You'll need one product type for each GL code you want revenue to post to.

 8. Review the Agreement types you currently are using in ConnectWise, do you wish to sync all agreement types or only a few?  You will have one contract template for each agreement type that exists in ConnectWise.

Once all the above steps are completed, please let us know. We will then run our PreFlight app that will create the contract and item templates in your test eAutomate database.

9. After the templates are created, you will need to code the templates with the proper codes. Go here for notes on coding the item templates and here for coding the contract templates.

Once you have notified us that the templates are all coded properly, we will run the sync and pull all agreement invoices in the past 7 days into your test eAutomate database.

10. You will then review the contracts that were created, bill the contracts, and verify all information synced correctly from ConnectWise. A few things to note:

  • Review the contracts that were created, checking dates, base rate amounts, and item amounts.
  • Preview the next invoice, confirm that the totals match and that the tax status is in line.
  • Invoice contract and review the GL entries to verify that the amounts all posted to the correct accounts.

After confirming that everything is syncing properly, we will move the templates to your production eAutomate and repoint the sync to production to push in the agreement invoices.

*  *  *

Alert Functionality

Alert Functionality

Jump to: Existing Contracts | Billing Cycles | Serviceable as an ItemContract Tax | Contract Templates | Invoice Samples | Item Templates

The sync is triggered by the agreement invoice in ConnectWise. Changes made to the agreement in ConnectWise over the course of the month do not update the contract in eAutomate until the point when the agreement invoice is generated.

Once the sync is processing an invoice, the first step is to determine if the company on the agreement invoice matches a customer in eAutomate. If the sync can't find a matching customer, the invoice will not import. You will find customer not found errors on the ID954 report that you will receive each night detailing the invoices that have synced.

Once the sync has found the matching customer record, it next determines if the invoice should update an existing contract or insert a new one. The sync first looks to our internal tables; if the agreement has already been synced to a contract, that contract will be updated by this agreement. If there is no sync record for this agreement, the sync will look to the ZCJ_Contract Number custom field for a value. If there is a value here, the sync will attempt to sync to this contract. If this number does not exist in eAutomate the sync will create a new contract in eAutomate. If there is no sync record and the custom field is not populated, the sync will create a new contract into eAutomate. **Very important to note that once the sync record is created in our internal tables, you can not change the linking of the agreement to the contract in eAutomate. You must reach out to us by sending an email to to correct the mapping.

The contract in eAutomate will be updated to match the agreement invoice, each product listed on the invoice will be a serviceable item on the equipment/item tab of the contract. Base amounts billed in ConnectWise will show as a serviceable item in eAutomate. Any items that existed on the contract prior to the update but do not exist on the invoice will be terminated.

Once the contract has been updated in eAutomate, you will need to bill the contract in eAutomate to create the invoice and post the revenue.


Existing Contracts

Existing Contracts

The agreement sync can be set to push CW agreement invoices to existing contracts in eAutomate. If you would like to do this, please be aware that the sync cannot update existing line items on the contract. All existing line items will be terminated the first time that the contract syncs with a CW invoice. Additionally, you will need to manually enter the contract numbers in the custom field in CW, being sure to match the contract numbers exactly. (If the contract number is not an exact match, the sync will create new contracts.) See this post for further details on syncing to existing contracts.


Billing Cycles

Billing Cycles

Billing Cycles - Must Match between Connectwise and eAutomate!

The billing cycles that are set in Connectwise must match to the billing cycle options you have for the contracts in eAutomate exactly, both the code and the description. 

Billing cycles in eAutomate are found in Tools/Lists and Codes/Billing Cycles:


Billing cycles in Connectwise found in setup tables/Billing Cycle


If you look at the quarterly billing cycle in the above examples, quarterly is shown as Quarterly in eAutomate and QU in Connectwise. This mismatch will cause an issue when the agreement invoice syncs to the contract in eAutomate. It doesn't matter what the billing cycle is named, as long as they match exactly in both systems. (Most likely, it is easier to change the Connectwise billing cycles to match what you have in eAutomate, though the Bill Cycle ID in Connectwise can only have a max of five digits.)

If the agreement in ConnectWise does not have a billing cycle (one-time bill agreement), the sync will create the contract with the default billing cycle of Monthly. You will need to manually terminate this contract once it has been billed in eAutomate.


Serviceable as an Item

Serviceable as an Item

The sync process will add the base and additions from the Connectwise agreement invoice to the eAutomate contract as individual line items. In order to add these items to the service contracts in eAutomate, you will need to enable the option to Allow items to contracts and service calls.

This option is located in Tools\Options:


Click on Contracts (1) and then check the option for Allow items on contracts and service calls (2). You will need to close eAutomate and reopen to see the change. 

Contract Tax

Contract Tax

For items to be eligible to be taxed in eAutomate, the additions on the agreement all need to be checked as Taxable:


If this option is NOT checked on the Addition product ID, the sync will check the Override taxable check box on the item on the contract in eAutomate:


When the Override taxable option is checked on the line item, no tax will be charged for that item, regardless of the other tax settings in eAutomate. To make sure that this box is unchecked in eAutomate, you'll need to make sure that the taxable option in ConnectWise is selected. 


The tax billed on the EA contract invoice is tied to the tax authority on the contract and the tax category that is on the contract base distribution code.

On the contract, the tax code is set on the Billing/Contact tab. For the contract to bill tax, there needs to be a billable tax code entered and the Taxable box must be checked. 


These two settings will default to the customer settings when the contract is created. 

Every tax code in eAutomate is made up of tax authorities, you can have multiple tax authorities on one tax code. The tax authority determines what to charge tax on, based on the tax flags that are added:


Each contract distribution code has a tax category listed:



In order for the contract to charge tax, the tax category on the base distribution code needs to match one of the categories to tax that is listed on the tax authority. For example, if the base distribution code is set with a tax category of MISC and that is NOT a category listed on the tax authority, eAutomate will not charge tax on the contract invoice.

Agreement/Contract Templates

Agreement/Contract Templates

You will have one contract template in eAutomate for each agreement type that you have in ConnectWise. We will create these initial templates for you in the testing phase, if you create new agreement types in Connectwise after the sync moves to production you will need to create a new template for the new agreement type. See this post for instructions on creating new templates.

You can see the list of agreement types that you have in Connectwise in the setup tables:


The preflight process will take every agreement type that you have in Connectwise and create a corresponding contract template in eAutomate. When reviewing your agreement types in Connectwise, things to consider:

1. Do you want every agreement type from Connectwise to sync to eAutomate? You can specify on variable 2 only the agreement types you want to sync.

2. Are there any agreement types that you are not using and could make inactive in Connectwise?

3. Is there an agreement type in ConnectWise to cover every "flavor" of billing? Are the proper defaults set so that you are not making manual overrides at the agreement level? See this post for more details on the agreement setup in ConnectWise.

Every template in eAutomate will be created with the format **CW AgreementType. The contract templates in eAutomate will be "shells" that are used to create contracts by the sync process. Once the contracts have been created in eAutomate, you'll need to update the contracts with the correct codes to be used.

You will need to update each contract with the following information:


1. Contract type - The contract type does not need to match to the agreement name from ConnectWise. The contract type will update the base distribution code on the contract automatically. The contract type can also automatically update the bill code, status, and report group if those settings are completed on the contract type. The contract type also drives whether the contract billing method is either installment based or deposit based.

2. Contract bill code - The bill code will come into play for service calls applied to the contract and what time on the service tickets is considered covered and what is billable. See here for more details on setting up advanced bill codes.

3. Status - Status is a required field on the contract and so must be set when making the other updates to the contract template. The sync will set the eAutomate contract status to equal the Connectwise agreement status, anytime that the status exists in both systems. If Connectwise has a status that doesn’t exist in eAutomate (Cancelled and Expired are statuses in ConnectWise that do not exist in eAutomate) the Sync will use the template’s status for inserts and just leave the status alone on updates.

4. Base distribution code - The base distribution code is required and determines if the contract will accrue; the distribution code is set on the contract type and will automatically update when you update the contract type. The distribution code used on the items added to the contracts is the primary driver of the revenue buckets, the distribution code entered here is only used if there is no distribution code on the items added to the contract. 

On the Billing/Contact tab of the contract:


1. Billing group: If you want IT contracts to have a separate billing group, you can add that here. It is not required, just a way to segregate the IT contracts into a separate group and something we recommend doing.

2. Tax code: You must choose a tax code for the template. When a contract is created from this shell, the tax code will be updated to match the tax code on the customer.

3. Report group: If you currently have (or would like to have) a different invoice template used for the IT contracts created by the sync, update the report group used for the template. **We do recommend sending the invoice from eAutomate**

In addition to the templates created for each agreement type, you will also see the default agreement template that is used when there is no matching template can be found in eAutomate. We recommend creating a new contract type for the default contract that you can easily search on and see that the contract was created from the default and needs to be updated.



For specific details on setting deposit/time block templates, see this post.

Invoice Samples

Invoice Samples

We have three different invoice templates that we can install for you. All of the standard invoice formats suppress the CW-Service item from showing on the invoice. **Option four on this list is still in development and not available for all customers currently**

A. CW No Base Rate: Show line items, with no pricing. This invoice template shows the quantity and description of each item on the contract invoice, but does not show the individual line item pricing:


B. CW Details: Show line items and line item pricing. This invoice template shows the line items on the contract, the quantity, and the line item pricing:


C. CW No Details: Only shows the billed amount. The last option does not show any of the line items on the invoice, just the total amount charged.


We will install all three options for you when running preflight and create a report group for each option.

D. CW Full Details: Shows the full details of each item pulled from the ConnectWise agreement. This format is best used when you have multiple items of the same product ID on an agreement as this invoice will show each item description instead of the one rolled up item from the EA contract. **This is a newer format and currently requires that the ConnectWise invoice number is moved from the PO field on the contract to the remarks field, please email to get it installed for you.




Product/Item Templates

Product/Item Templates

We will create these initial templates for you in the testing phase, you would only need to create new templates if you add additional product types to Connectwise. See this post for more details on how to create product templates.

You can see the list of product types that you have in Connectwise in the setup tables:


Each product type in Connectwise equates to one item template in eAutomate. In addition to the item templates for the product types, the preflight process will also add an item template for each agreement type. Agreements in Connectwise can have both a base amount and line items, contracts in eAutomate can only have one or the other. In order to add the base amount charged on the Connectwise agreement, that amount will be added to the eAutomate contract as a line item.

You will see these templates for the base amount in eAutomate with the format "**CWBase AgreementType". These item templates are only needed if you are charging base amounts on the agreement in CW, if you are using an addition item to charge a base, then these can be skipped.

The distribution code selected on the item template will drive the GL bucket used when the item is added to the contract. It's important to determine what GL breakout you want from the Connectwise items, and then make sure that you have one product type in Connectwise for each GL code to be used in eAutomate.

**The templates created by the sync default to Inventory items, though you can change these to expense items. Be aware that if you are going to use ID966 (Sales Order Sync) and use items on sales order with the same product type as an item used on an agreement, that you will need to fill in several more fields on the item templates. See this ID966 documentation for those additional fields needed.

On each template, you'll need to update the following items:


1. Category: Set the category as needed

2. Unit of Measure: Set the UM as needed

3. Contract base distribution code: This code will direct all revenue for items created of this product type when used on the contract.



1. Revenue account: The revenue account that will be used for the contract revenue when this product type is used.

2. Revenue department: Department that will be used

3. Revenue distribution: Default is set to 100%, to drive all revenue for the time to one revenue account. You can add multiple revenue accounts if you want to distribute the revenue across multiple accounts.

4. Tax category: Sets if the item will be taxed when used on a contract, very important that this is set correctly to ensure the contract is billing tax correctly.

**If you have items already set up in eAutomate that match a product ID in Connectwise, please review these items and verify that all have the correct contract base distribution code in place. If the sync finds a matching item already in eAutomate, it will use that item on the contract. If the distribution code is not set on the item, the revenue from that item will default to the GL account used on the contract distribution code (code set on the contract template).

In addition to the item templates for the product and agreement types, there will be one default template created. This template would only be used if no matching item template is found. We'd recommend creating a new category for this template to something you can easily search for so you know to change the codes on these items:



*  *  *


Best Practices & Tips

Best Practices & Tips

Jump to: Annual Agreements | Multiple Items | Canceled Agreements | EA Version 21 | Billing Cycle | Contract Not Updated | Product Type Recommendations | Custom Fields

Annual Agreements

Annual Agreements

To ensure that annual agreements sync properly, update the Batch settings in ConnectWise from 90 (default) to 400. In ConnectWise, go to System > Setup Tables > Batch:CWBatch.jpg


Multiple Items

Multiple Items

Connectwise allows you to put the same item on an agreement multiple times, this is not supported on contracts in eAutomate. When an invoice has the same item number multiple times, the sync will roll up the price from each of the items and add it to the eAutomate contract as one line item. The line item description will show all descriptions from Connectwise.

In ConnectWise you'll see the same product listed twice:


In eAutomate, there will be one item on the contract, with a quantity of 1 and the base rate will be the sum of the price from ConnectWise:



Canceled Agreements

Canceled Agreements

  • Agreements that are canceled AFTER THE LAST INVOICE IS GENERATED IN CONNECTWISE will need to be manually terminated in eAutomate.
    • The agreement invoice is the trigger to update the contract, if the agreement is canceled and no new invoices are generated, the contract in eAutomate will not be updated.
  • If the agreement in ConnectWise is marked as canceled PRIOR TO THE LAST INVOICE GENERATED IN CONNECTWISE, the sync will cancel the contract in eAutomate. A few things to keep in mind on these contracts:
    • The status in ConnectWise will show as 'Canceled', there is not a matching status in eAutomate so the sync will use the default value of 'Active'.
    • The termination code used in variable 11 will be used as the termination code on the contract. We recommend creating a new term code to use with the sync for CW Canceled. For other termination codes we recommend, see this post.
    • These contracts will need to be reviewed and properly terminated, as they will show with a status of Active and a termination code.

EA Version 21

EA Version 21

In EA version 21 and higher, there is an option for the serviceable item to inherit the base distribution code from the contract level:


When the sync adds an item to the contract and the item record has a base distribution code added, this option will be unchecked and the distribution code from the item will be used. If the item added to the contract does not have a distribution code, then this option will be checked and the distribution code from the contract level will be used. There are two scenarios where an item added by the sync will not have a distribution code: 1) There is an existing item in EA where the item number = product ID and this item does not have a distribution code set. 2) The template used to create the item does not have a distribution code set.

Billing Cycle

Billing Cycle - ConnectWise to eAutomate

Please note that you will not be able to bill an agreement in ConnectWise for multiple months at once and have each invoice sync properly over to eAutomate. If you are billing multiple months you will need to bill the first month and allow that invoice to sync over to eAutomate. Bill the contract in eAutomate, then go back to ConnectWise and bill the next month. Repeat the process for as many months as you need to bill.

The process to get your contracts billed properly in ConnectWise and eAutomate:

1. Agreements are billed in ConnectWise

2. The sync will pull the agreement invoices information into eAutomate.

     *If you are using variable 10 to only import agreement invoices of a certain status, review the agreement invoices and update the status. Then the sync will pull the agreement invoices into eAutomate and update the contracts.

3. Once in production, you'll receive a daily report of all invoices that have synced over. The report will also show any errors for invoices that did not sync correctly. (This is ID954). 

4. Bill the contract invoices in eAutomate.

     *We recommend setting all of the ConnectWise agreements to have a separate billing group to keep them segregated from your standard contracts and ensure they are not billed by accident.

     *We also include the message on the contracts with the next billing date in ConnectWise that has to be acknowledged to stop the contracts from being billed by accident.

5. Send the invoice to your customer. 

6. The contracts in eAutomate will be ready to be billed for the next month and will be updated with the next month's agreement invoices from ConnectWise and you'll go back to step 1.

**If you need to make corrections to invoices you'll need to void the invoice in eAutomate first, then rebill in ConnectWise and let the sync update the contract in eAutomate with the new invoice. Then bill the contract in eAutomate.

 Contract not Updated 

If you invoiced in Connectwise and don't see the contract updated in eAutomate:

1. Check the ID954 report for any errors. The ID954 report is accessed via the SSRS console, see here for more details on this report.

2. Sometimes the contract in eAutomate is marked as inactive or terminated, and therefore will not show up in the billing queue. Go to the contract list and search for the CW invoice in the Blanket PO field:


3. Check to see if the billing cycle used on the agreement in ConnectWise exactly matches the billing cycle in eAutomate. Details on matching the billing cycles here.

4. Have the default item and contract templates been made inactive or been deleted? Those default templates need to be in place in order for the sync to function properly.


Product Types

Suggested Product Types



See this post for how to set up an agreement in Connectwise with a minimum base.

Custom Field Setup

Custom Field Set-Up

To create the needed custom fields in Connectwise, first go to the Setup Tables and choose Custom Fields from the list:


For the custom field ZCJ_ContractNumber (used to store the EA contract number) enter "agreement" in the Screen column and then click Overview from the Pod Description column:


Click on the plus sign next to Custom Fields to add a new custom field:


1. Enter ZCJ_ContractNumber in the Field Caption.

2. Check the box for Display on Screen? 

3. Check the box for Include on List View?

4. Click the Save and Close button


To create the custom field ZCJ_ItemNumber (Used to store the EA item number), go back to Setup Tables > Custom Fields. Select Product Setup under the screen menu and then click on Overview:


Click on the plus sign by Custom Fields to add a new field and use the Field Caption ZCJ_ItemNumber:


Again, select the checkboxes for Display on Screen and Include on List View. Then click on the save and close button to save the new record.



*  *  *

Related Alerts

Related Alerts

ID747 - Connectwise Customer Sync

ID954 - SSRS Report for Agreement Sync details

ID965 - Connectwise Service Call Sync 

ID966 - Connectwise Sales Order Sync 


*  *  * 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk