The contracts module takes agreement invoices from ConnectWise and uses the data to create/update contracts in e-automate. The ConnectWise agreement is the master for the contract information, the contract in e-automate is updated when the agreement is invoiced.
Jump to: Overview | Samples | Setup | Variables | Testing | Alert Functionality | Best Practices & Tips | Related Alerts
Click here for our ID964 videos!
Overview
Overview
ConnectWise Manage and the RMM tools do an excellent job of tracking products included in agreements, so we recommend that the ConnectWise Agreement be the master for contract billing. This sync process will take the agreement invoices from ConnectWise and create matching contracts in e-automate. The base amount and additions from the ConnectWise agreement will push to e-automate and update the line items on the contract when the agreement is billed in ConnectWise. This sync does not push any information from e-automate 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 e-automate. For example, the ConnectWise invoice can have an item with a quantity and extended price and show a billed amount of zero. E-automate 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 e-automate, and create the items on the contract if they also do not exist. You can choose to create the contracts and items yourself in e-automate 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 e-automate 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 e-automate to be added to the contract. We create these templates for you as part of the testing process for the sync.
Run Schedule: Every 15 minutes
Type of Output: Data Push
* * *
Sample
Sample
Jump to: Contract Header | Contract Item Details | Contract Billing/Contact | Contract Message | Email Output
Contract Header
Contract Header
1. The contract number will be the next number from e-automate, combined with the optional prefix from variable 9. The e-automate contract number posts back to ConnectWise in the custom field ZCJ_ContractNumber. More details on the contract number are here.
2. The customer on the contract will match the company from ConnectWise. The customer field is touched on both contract creation. Details on company matching are here.
3. The contract type is copied from the contract template used to create the contract. This field is only touched on contract creation. More details on the contract type in e-automate are here.
4. The contract bill code is copied from the contract template. This field is only touched on contract creation. More details on contract bill codes are here.
5. The status of the contract will be set to active unless the start date of the contract is in the future. Contract status is updated when the contract is updated by the sync.
6. The billing method will be copied from the contract template. This field is only touched on contract creation.
7. The start date of the contract will be the start date of the agreement in ConnectWise. This field is only touched on contract creation.
8. If there is an end date set on the agreement in ConnectWise, that date will be used as the expiration date on the contract in e-automate. This field is updated when the sync updates the contract, so if an expiration date is added in ConnectWise it will be updated on the contract.
9. The billing cycle on the contract will match the billing cycle from ConnectWise. This field is only touched on contract creation. More details on billing cycles are here.
10. The sync will set the billing period on the contract to match the period from the ConnectWise invoice. This field is updated each time the sync updates the contract. More details on the contract billing period are here.
11. The option to use equipment base rates is set when the contract is created by the sync. This field is only touched on contract creation.
12. The base rate on the contract is set to the total amount billed in ConnectWise when the contract is created and on each update of the contract.
13. The contract base distribution code will be copied from the contract template. This field is only touched on contract creation.
14. The activated on date will be set to match the contract start date when the contract is created. This field is only touched on contract creation.
15. The terminated on date field is touched on contract updates if the agreement has been set to a status of Expired or Cancelled in ConnectWise.
16. If the terminated on date is set, the sync will apply the default termination code to the contract.
17. An accrual cycle is set on the contract if the billing period is greater than one month. This field is only touched on contract creation. (If you have a practice of accruing all contracts regardless of the billing period length, there is an option to accommodate this in the sync. You'll need to email help@ceojuice.com and ask to have this option turned on)
Contract item Details
Contract Item Details
Each product from the additions tab of the agreement in ConnectWise will have a matching serviceable item on the Equipment/Items tab of the e-automate contract.
1. The item number on the contract will match the product ID from ConnectWise. The item number is only touched when the item is added to the contract.
2. The description of the item will match the invoice description from ConnectWise. This field is updated each time the sync touches the contract.
3. The quantity will match the quantity to bill in ConnectWise. This field is updated each time the sync touches the contract.
4. The unit base rate is the unit price of the item from ConnectWise. This field is updated each time the sync touches the contract.
5. The base rate is the ext price for the item. This field is updated each time the sync touches the contract.
**Note that ConnectWise allows the unit price and ext price to have up to 6 decimal places, while e-automate only allows for 2. If you are using the full six decimal places in ConnectWise, you may see slight discrepancies where items are a penny or two off in the total amount.
6. The start coverage date is set to the first day of the month that the item is added to the contract. This date is only touched when the item is added to the contract
7. If the product is canceled on the ConnectWise agreement, the end coverage date will be updated to the last day of the month for that billing period.
8. If the item is terminated, the default termination code will be applied.
9. The base distribution code is pulled from the item record. This field is updated each time the sync touches the contract.
10. The bill code is pulled from the bill code set on the contract. This field is only touched when the item is added to the contract.
11. The tax code is pulled from the customer record. This field is only touched when the item is added to the contract.
12. The option to override the taxable status is touched when the item is added to the contract and each update. See notes here on how this option is set in ConnectWise.
13. The branch on the item is pulled from the customer record and only touched when the item is added to the contract. If you need to set the branch to a specific value for all contracts, there is an option to accommodate that. You'll need to email help@ceojuice.com to let us know to enable that, along with the specific branch to be used on all contracts.
14. There is an option to link agreement additions to locations in e-automate. To do this, you'll need to add a custom field to the agreement additions in ConnectWise and then populate this field with the customer number from e-automate for that location.
Contract Billing/Contact
Contract Billing/Contact Tab
1. The bill to customer will match the bill to company from the ConnectWise agreement. If the bill to company can't be matched to a customer in e-automate, the contract will be created with the bill to customer set as the same customer on the contract. More details on the bill to company are here. The bill to company is touched on creation of the contract and subsequent updates. Starting with the 2023.06.16 version of the sync, if the billing site on the agreement is linked to a customer in e-automate, that customer will be used as the bill to company.
2. The contact name will match the contact name from ConnectWise. This field is only touched when the contract is created.
3. The branch is pulled from the customer record in e-automate. This field is touched on creation of the contract and subsequent updates. If you need to set the branch to a specific value for all contracts, there is an option to accommodate that. You'll need to email help@ceojuice.com to let us know to enable that, along with the specific branch to be used on all contracts.
4. If you have checked the option to Group invoices on the contract template, this option will be checked on the contract created by the sync. This field is only touched on the creation of the contract. More details on group billing of invoices can be found here.
5. The bill contract box is checked upon creation of the contract and not updated after that. Starting with the 02.12.2024 version of the sync, once the contract invoice is created, the sync will uncheck this box so that the contract will not come into the billing queue again until the next time it is updated by the sync.
6. The billing group will be pulled from the contract template. This field is only touched on the creation of the contract. See more details on billing groups here.
7. The tax code on the contract will be pulled from the customer record. See more details on contract tax here. (This field is not touched on contract updates, if you need to set the tax code to a different code than the one set on the customer you just need to do that one time when the contract is created.)
8. The taxable check box is based on the taxable status of the customer on the contract, this field is touched on creation of the contract and subsequent updates.
9. The option to use the equipment tax codes is set on creation of the contract. If you do not want this option set, you can uncheck the box on the templates. With this option unchecked, the contract tax code will be used to calculate all tax on the contract invoice.
10. The terms on the contract will pull from the customer record. This field is only touched when the contract is created.
11. Starting with version 2023.06.16, there are two options for updating the sales rep on the contract. The first option is to pull the sales rep from the customer record, the second option is to pull the sales rep from a custom field in ConnectWise. See here for more details on the sales rep linking. The default option is not to update the sales rep, send an email to help@ceojuice.com if you want to enable one of these options.
12. The report group will be pulled from the contract template. This field is only touched when the contract is created. See more details on the different report groups CEO Juice will install here.
13. The invoice number from ConnectWise will sync to the PO field on the contract. This field is updated with the new invoice number from ConnectWise each time the sync updates the contract. You do have the option to post the invoice number to the contract remarks if needed. More details on that are here. If you post the ConnectWise invoice number to the remarks field, if there is a PO number on the agreement, that will post to the PO field of the contract.
Contract Message
Contract Message
1. The sync automatically adds a billing queue message with the next billing date from the ConnectWise agreement. More details on this message are here.
2. This message is set to require acknowledgment in the billing queue.
Email Sample
Email Sample
An email will be generated whenever the default contract or item template is used.
An email will be generated when a contract is added or updated by the sync.
* * *
Set Up
Set Up
Jump to: EA-CW Mapping | EA Setting | CW Settings | Subscribe to Alerts
EA-CW Mapping
1. The ID747 sync is required to be running, so that all companies in ConnectWise are mapped to the proper customer record in e-automate. See more details on ID747 here.
2. The billing cycles need to match between the two systems, more details on billing cycles can be found here.
EA Settings
1. Verify that the option to add items to service contracts is enabled. More details on that here.
2. The sync needs a default termination code to use when items on the contract are canceled, you'll enter this default in variable 11. More details on terminating items are here.
CW Settings
1. There are a few custom fields that need to be created in ConnectWise:
ZCJ_ContractNumber – On the agreement, to store the contract number from e-automate.
ZCJ_ItemNumber – On the product ID, to store the item number from e-automate.
ZCJ_EASalesRep - Optional field to link a sales rep on the agreement to a sales rep in e-automate.
ZCJ_EALocation - Optional field to link additions to location customers in e-automate.
See instructions on how to create these custom fields in CW here.
2. 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.
3. 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.
Subscribe to Alerts
1. Once you have the settings in ConnectWise and e-automate determined, subscribe to ID964 on our website. If you don't have a login to our subscription site, you can email help@ceojuice.com to have us set you up with a login.
2. If you are not already subscribed to ID747, you'll need to subscribe to that alert as well. See this link if you have questions on the variables for ID747.
* * *
Variables
Variables
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, more details here. **Required, the default value is CW-Service, we will create this item during the preflight process.
Variable Z: Mark Invoices Paid - Option to mark invoices as paid in ConnectWise when the invoice is paid in e-automate. The default option is No, switch to Yes if you want the sync to update the invoices in ConnectWise and mark them as paid.
Variable 4: Default Contract Template - the name of the default contract template in e-automate. 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 e-automate 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 e-automate. 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 e-automate 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 e-automate contract. See here for further details on the termination code. **Required**
Variable 1: ConnectWise Credentials - Select the credentials to use from the drop-down. Only needed if you have more than one set of API credentials on the CEOJuice website.
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. You can flip the functionality of this variable by beginning the string with (!). For example, entering Managed Services in this variable will ONLY sync agreements with the type of Managed Services. If you enter (!) Managed Services then ALL agreement types EXCEPT for Managed Services will sync.
Variable 7: Exclude Product Types - If there are specific product types in ConnectWise that you do not want to sync over to e-automate, 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 e-automate, 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. Leave blank to use the default contract number. See here for more details on the contract number.
Variable 8: Renumber Invoices - You have the option to renumber the contract invoices in e-automate to match the invoice number in ConnectWise. Set this variable to Yes to renumber the invoices or No to not renumber the invoices. See here for more details on the invoice renumbering process.
Variable 12: Invoice Renumber Prefix - If you choose to have the invoices in e-automate 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 e-automate. See here for more details on the invoice renumbering process.
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 e-automate, the invoice number will push to the invoice in ConnectWise. Not needed if you are using the invoice renumber option, see here for more details on this option.
Variable 10: Invoice # Field - ConnectWise custom field to hold the e-automate invoice number. Only needed if Variable X is set to yes and the invoice renumber option is not used.
* * *
Testing
Testing
The first step in testing the agreement sync is to set up the testing environment. ID964 must be tested from your production ConnectWise database to a TEST e-automate database. Agreement invoices created in ConnectWise can be deleted after testing.
Once the testing environment is set up, we will run our preflight process to create the item and contract templates for you. You'll then update the coding on each template, once that is done, we can sync agreement invoices to the test database to create contracts for testing.
Jump to: Testing Setup | Contract Templates | Item Templates | Testing Checklist
Testing Setup
1. API Keys in ConnectWise – These may already be in place if you are using other portions of the ConnectWise sync. New keys do not need to be created for the contract sync. Details on creating API keys here.
2. ConnectWise test Database – If using a test ConnectWise database, you’ll need to create a set of API keys for that database. Details on creating API keys here.
3. e-automate test Database – A test database is required to sync contracts initially for review. See this link for notes on creating a test e-automate database. **It's very important that this test database is NOT updated while the sync is being tested as this will overwrite the item and contract templates**
4. CEOJuice test database – If you have previously tested other parts of the ConnectWise integration, you may already have this in place. If not, see this link for notes on creating a test CEOJuice database.
Once these setup steps have been completed, please let us know and we will install the sync for testing and run the preflight process to create the item and contract templates.
Contract Templates
Contract Templates
You will have one contract template for each agreement type that you have in ConnectWise, plus one default contract template. You want to be sure to have at least one agreement type for every "flavor" of billing that you do.
Updates needed on the contracts:
1. Contract type - More details on the contract types in e-automate are here.
2. Contract bill code - More details on the contract bill code in e-automate are here.
3. Contract status - This is a required field on the contract that will need to be set, we'd recommend setting the status to Active.
4. Billing method - This is determined by the option set on the contract type. Be sure that any block of time agreement types are set to deposit-based and not installment based.
5. Billing cycle - Do NOT set a billing cycle on the templates.
6. Base distribution code - This is a required field on the contract, it's only used when items added to the contract do not have a distribution code set. See more details on the base distribution code here.
**You can check either the bill in arrears (1) or bill in advance (2) options on the template, to do so you'll first need to add a billing cycle:
The contract sync will automatically force the billing period to match the billing period from ConnectWise, so these settings are NOT required. More details on the billing period are here. If you do check either of these options, remove the billing cycle after you have set them.
On the Billing/Contact tab of the contract, these codes need to be set:
1. Group invoices - If you would like to group bill contracts in e-automate, check this option on the template. See notes on group billing here.
2. Billing group - This is not a required field, but we do recommend setting up a billing group to be used on all contracts created by the sync. See more details on the billing group here.
3. Tax code - The tax code is a required field and so you must set a tax code on the template. This tax code DOES NOT transfer to the contracts created by the sync, the tax code is pulled from the customer on each contract created.
4. Report group - The report group is a required field, we will add several report group options for you to use. See more details on those here.
Item Templates
Item Templates
You'll have one item template for each product type in ConnectWise, these item templates all begin with **CW and then the product type. You want to have at least one product type for each GL account that you want revenue to post to. Additionally, you'll have one item template for each agreement type. These item templates will start **CWBase and then the agreement type. These base templates are only used if you are billing a base amount on the agreement in ConnectWise. See here for more details on base charges on the contract.
These codes need to be updated on the item templates:
1. Description - The description will default to ID964 Item Template, you can leave this as is or change it. When the sync creates an item, it will use the description from the product in ConnectWise.
2. Category - This is a required field on the item, the sync will create the template with the first category option it finds so you'll most likely want to change it.
3. Unit of measure - This is a required field on the item, the default when the item is created is EA. You can change the unit of measure or leave as is.
4. Contract base distribution code - This is the most important code to set on each item template as this determines what revenue account will be used when the item is billed on a contract. More details on the distribution code are here.
If you are going to be using the sales order sync with ConnectWise (ID966) these same templates will be used to create items and will need additional codes added. See the documentation here on the other codes you'll need to set.
**If you have items already set up in e-automate 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 e-automate, 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).
If you do not use base amounts on the agreements in ConnectWise, you do not need to update the base item templates. If you do use a billing amount on the ConnectWise agreement, you'll need to code the distribution code on the base templates to the appropriate revenue account and you will want to change the description of the item as that will show on the invoice from e-automate. See here for more details on the base billing amount.
Testing Checklist
Testing Checklist
Once the templates have been updated, you're ready to begin syncing invoices to the test database for review. Verify the following are all working as expected:
- 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.
- Bill an additional month in ConnectWise to verify that the contract is updated properly with the next month's invoice.
- Terminate an agreement and additions from the agreement to verify the termination code is applied properly in e-automate.
After confirming that everything is syncing properly, we will move the templates to your production e-automate and repoint the sync to production to push in the agreement invoices.
* * *
Alert Functionality
Alert Functionality
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 e-automate until the agreement invoice is generated.
Once a new agreement invoice is created, the sync will check:
1. Is the customer linked in ConnectWise? If a customer match can't be found, the invoice will not import.
2. Is the agreement in ConnectWise linked to a contract in e-automate? (Either manually via the custom field in ConnectWise or automatically by the sync from a previous invoice). If the agreement is linked to a contract in e-automate, 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 e-automate 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 e-automate. It's very important that you do not cycle the contract through the billing queue in e-automate before it is updated by the sync as this will cause multiple issues in e-automate.
Jump to: Contract Number | Customer Mapping | Contract Branch | Contract Type | Contract Bill Code | Contract Status | Contract Dates | Contract Billing Period | Contract Accruals | Billing Cycles | Base Distribution Codes | Contract Base Amount | Items on Contract | CW-Service Item | Locations | Bill to Customer | CW Invoice # | Contract PO | CW Invoice Status | Invoice Renumber | EA Invoice # to CW | Billing Groups | Sales Reps | Report Groups | Invoice Samples | Contract Message | Serviceable as an Item | Contract Tax | Terminating Items | Terminating Contracts | Proration of Items | Invoice Paid in CW | Attachments | Bill Contract Checkbox | E-views
Contract Number
Contract Number
The sync will use the next contract number from e-automate, this is set in Options:
You do have the option to add a prefix to all contracts created by the sync, which we recommend doing. This allows for easy filtering in the contracts screen for the contracts created by the sync. This prefix is set in variable 9. In the example below, variable 9 is set to CW-
You can change the contract number after the sync has created the contract, that will not affect the linking of the agreement to the contract. Creating a new revision of the contract in e-automate will not cause the sync to update the revised contract, it will continue to update the initial revision of the contract. If you need to break the linking in our background tables between an agreement in ConnectWise and a contract in e-automate you will need to email help@ceojuice.com with the contract number from e-automate.
Customer Mapping
Customer Mapping
ID747, the customer sync, is required for ID964. You do have the option to use ID747 in No Update mode, that will only update the background mapping in the custom property in e-automate and not make any changes in ConnectWise. See here for more details on ID747.
The agreement sync matches customers based on the ConnectWise company recID being in the custom property ZCJ_CW_CompanyID on the customer record in e-automate. Additionally, the agreement sync will check for customer matches based on the e-automate customer number in the Account ID, Company ID or the custom field ZCJ_CustomerNumber. (Note: The service sync (ID965) and sales order sync (ID966) match customers solely on the custom property in e-automate.)
If the sync is unable to match the company from ConnectWise to one in e-automate, the invoice will not be inserted. If the sync creates a contract under the wrong customer, or you need to change the customer on the contract at any point, you MUST reach out to help@ceojuice.com with the details of the changes needed so that we can update the background tables. Changing the customer at the contract header or item level will cause issues the next time that the sync updates the contract.
See the documentation here on how to map the customers based on the custom property in e-automate.
Contract Branch
Contract Branch
The branch assigned to the contract will be pulled from the customer record in e-automate.
If needed, there is an option to specify which branch to assign to every contract created by the sync. With this option, you will specify ONE branch that will be assigned to EVERY contract created by the sync. If this is an option that you want to use, please send an email to help@ceojuice.com requesting that this be turned on with the name of the branch to be used.
Contract Type
Contract Type
Contract types in e-automate are used to set the defaults used when a contract is created, these are similar to agreement types in ConnectWise though you do not need to have the contract types match exactly to the agreement types.
When creating a contract type in e-automate, go to Lists and Codes then Contract Types.
There are four fields required on the contract type:
1. Contract type - The name of the contract type.
2. Description - A description of the contract type.
3. Base distribution code - The default distribution code used at the contract level when this contract type is used on a contract.
4. Billing method - The contract type determines if the billing method will be Installment based or Deposit based.
The remaining fields are optional when setting up the contract type, you may want to set a default bill code (5) or a report group (6).
**When setting the contract type on the contract templates, you can override the defaults for everything except the contract type name and the billing method.**
Contract Bill Code
Contract Bill Code
The contract bill code will determine what is billable and what is covered for service tickets applied against the contract. When the sync creates a new contract it sets each item added to the contract with the contract bill code on the template.
Contract level bill code:
Item level bill code:
If this bill code is later changed on the contract, that change DOES NOT push to the items existing on the contract and will need to be manually changed.
Depending on how you are billing for service, you may need to set up advanced bill codes so that what's billable in ConnectWise is also billable in e-automate. See here for more details on setting up advanced bill codes. See the documentation here for more details on how the bill code functions in relation to the service call sync.
Contract Status
Contract Status
The sync will set the e-automate 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 e-automate (Cancelled and Expired are statuses in ConnectWise that do not exist in e-automate) the sync will use the template’s status for inserts and just leave the status alone on updates.
If a contract is created in e-automate where the start date is in the future, the status will be inactive when the contract is created. To bill the contract, you'll need to manually change the status to active.
Contract Dates
Contract Dates
The sync will populate the start date of the contract to match the start date in ConnectWise:
On the e-automate contract:
The only time the start date in e-automate will not match the start date in ConnectWise is if the agreement is set to start billing mid-month. Then the sync will set the start date of the contract back to the first of the month to avoid e-automate attempting to prorate the billing amount.
Examples:
1. The start date of the agreement is 1/22/25 and the agreement has a billing start date of 2/1/25: The start date in e-automate will be 1/22/25, all items added to the contract will have a start coverage date of 2/1/25.
2. Both the start date AND billing start date in ConnectWise are set to 1/22/25: The start date of the contract in e-automate will show as 1/1/25, all items added to the contract will have a start coverage date of 1/1/25.
Contract Billing Period
Contract Billing Period
ConnectWise contracts only allow for billing on the first of the month through the end of the month.
Each month when the sync updates the contract, it takes the billing period from the ConnectWise invoice and sets the e-automate contract to match that billing period. You can check the ConnectWise billing period by going to the Invoices tab of the agreement:
The sync uses the Month and Year for the invoice to set the billing period in e-automate:
Due to the sync matching the billing period from ConnectWise, it's not necessary to have the bill base rate in arrears or bill base in advance options set, as the sync will force the billing period to match regardless of those settings.
One of the reasons that it is VERY important that you do not bill the contract prior to the sync updating the contract is due to the sync resetting the billing period when it touches the contract. The sync will uncheck the bill contract box once the contract has been invoiced to prevent the contract from billing prior to the next invoice from ConnectWise.
In e-automate, once you have billed the contract, the billing period is automatically rolled forward. If the sync updates the contract AFTER it has been billed for the period, the billing period will get rolled back and the contract will go back to showing in the billing queue.
To correct this issue, you need to manually reset the billing period on the contract by clicking on the pencil edit button and then clicking on the green arrow to reset the period:
After you click on the OK button, you'll need to make another change to the contract for the OK button on the contract to not be greyed out. Adding a space in the remarks section should be enough to get e-automate to recognize that changes were made.
Contract Accruals
Contract Accruals
When the billing cycle on the contract is greater than one month, the sync will automatically use the accrual settings for the contract, those are set in Options here:
If the billing cycle is one-month, the sync will default to NOT setting an accrual cycle on the contract. If for any reason you need contracts with monthly billing cycles to accrue, you'll need to send an email to help@ceojuice.com to request the sync be modified to always set an accrual cycle.
Billing Cycles
Billing Cycles
The billing cycles that are set in ConnectWise must match the billing cycle options you have for the contracts in e-automate exactly.
Billing cycles in e-automate are found in Tools/Lists and Codes/Billing Cycles:
Billing cycles in ConnectWise are found in setup tables/Billing Cycle
The sync is matching the billing cycle description from e-automate to the description in ConnectWise. If the sync can't find an exact match for the billing cycle it will use the default of Monthly.
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 e-automate.
Contract Base Distribution Code
Contract Base Distribution Code
The base distribution code determines if the contract will accrue and sets the GL account that revenue will post to; the distribution code is set on the contract type and will automatically update when you update the contract type.
1. The check box Use accruals needs to be checked if the contract should accrue.
2. Revenue account - The GL account that the revenue will be posted to.
3. Revenue department - The GL department that the revenue will be posted to.
4. Revenue distribution - The percentage of revenue to be posted to the account. You can split the revenue among several accounts, the total distribution needs to add up to 100%.
When posting revenue, e-automate checks for the distribution at the item level, if no code is found there, the code at the contract level is used.
The contract base distribution code on the item template is copied to each item created by the sync, and therefore will be used at the item level of the contract (1). You'll want to check for any existing items in e-automate where the item number matches a product number in ConnectWise and verify that these items all have a base distribution code set.
Contract Base Amount
Contract Base Amount
If you are billing a base amount on the ConnectWise contract, that amount will show as a serviceable item on the contract in e-automate. ConnectWise allows you to bill both a base rate and additions, but e-automate does not have the same functionality, contracts either bill a contract base rate or a base rate by equipment/item.
The base amount on the ConnectWise agreement shows in the Recurring Invoice Parameters pod as the Billing Amount:
This amount will show on the e-automate contract as a line item, using the **CWBase template that matches the agreement type:
Items
Items on Contract
Each product that is listed as an addition on the agreement in ConnectWise will be listed as a serviceable item on the contract in e-automate.
To add the items properly to the contract, you will need to have the option to add items to contracts checked in e-automate, further details on that are here.
When the sync processes the additions on the ConnectWise invoice, it checks for a match between the product ID from ConnectWise and an item number in e-automate. If there is an exact match between the product ID and the item number, the sync will use that item. If you have products in ConnectWise that do not exactly match the item number in e-automate, you can manually link those items together using the custom field ZCJ_ItemNumber and entering the e-automate number in that field on the product in ConnectWise.
For the above product, when the addition Managed Workstation is used on a ConnectWise agreement, the sync will add item Mngd WkSt to the e-automate contract.
Details on how to create this custom field in ConnectWise are here.
If there is no match between the product ID and item number, and no value populated in the ZCJ_ItemNumber custom field, the sync will create a new item in e-automate using the item template that matches the product type from ConnectWise for that product.
CW-Service Item
CW-Service Item
Every contract created by the sync will have the item CW-Service added to the contract.
This item is used in conjunction with the ID965 service call sync as a way to link service calls to the contract. This item is added with a price of $0.00 and is suppressed from showing on the custom invoice formats we provide.
Locations
Locations
There is an option to link the additions on the agreement in ConnectWise to a location in e-automate. This will allow you to properly charge tax based on the location of the item, as the tax code on the line item will pull from the location customer. If you want to add the locations to the line items on the contract, you MUST use this process. Manually updating the location on the contract line items will cause the sync to terminate those items and add new items at the main customer.
To add this option, you'll first need to create a custom field in ConnectWise named ZCJ_EALocation to the agreement additions. In this field, you'll enter the exact customer number from e-automate that the product should be linked to:
When the contract is updated in e-automate, the sync will set the location on the item to match the customer number in the custom field:
To enable this option you'll need to email help@ceojuice.com and ask to have an updated version of the sync installed and specify that you want to use the location feature.
If you are using this option and have the same product ID listed more than once on the agreement in ConnectWise, with the products set to different locations, the product description for each item must be unique. This will ensure that the sync will add the items to the contract in e-automate as two separate items.
Bill To Customer
Bill To Customer
The bill to company from the agreement in ConnectWise will be used as the bill to customer on the contract in e-automate. If the sync can not match the bill to company to a customer in e-automate, the contract will be created with the customer from the contract header.
If the billing address on the customer record in e-automate is not the same as the physical address, the sync will pull the address from the Billing Address field on the customer record:
The sync can link the billing site on the ConnectWise agreement to the bill to on the contract in e-automate:
In order for this to work, you'll need to be sure that the site in ConnectWise is linked to the proper location record in e-automate:
See this link for more details on linking sites in ConnectWise to locations in e-automate.
ConnectWise Invoice Number
ConnectWise Invoice Number
The ConnectWise invoice number will post in the PO field on the contract in e-automate. You can see the last invoice number for the agreement in the Agreement Recap pod:
This number posts to the PO field of the contract:
You can search by the PO field and see this column in the contracts screen in e-automate, making it easy to search for the invoice number and use this field to verify that the contract has been updated by the latest invoice from ConnectWise.
You do have the option to instead post the invoice number in the remarks field if you have customers that need to populate the PO field.
You will need to contact CEOJuice by emailing help@ceojuice.com to have this switched.
Contract PO
Contract PO
If you utilize the PO field on the agreement in ConnectWise, you can choose to have the invoice number from ConnectWise post to the remarks field. When the ConnectWise invoice posts to the remarks field, anything from the agreement PO will post to the PO field on the contract in e-automate.
The PO field on the agreement in ConnectWise has a character limit of 50, while the PO field on the contract in e-automate has a character limit of 32. If you have PO's in ConnectWise that are longer than 32 characters, and the sync is posting the ConnectWise invoice number in the remarks field of the contract, the sync will fail to create or update contracts in e-automate. You'll need to truncate the PO number on the agreement in ConnectWise, or there is an option to not sync the PO field for any contracts. If you'd like to turn off updating the PO field in e-automate with the data from the agreement PO, please send an email to help@ceojuice.com to have us update the sync.
CW Invoice Status
ConnectWise Invoice Status
There is an option to update the status of the invoice in ConnectWise after it has synced into e-automate. There is not a variable option for the name of the status to use, you will need to reach out to us to set this up by emailing help@ceojuice.com with the name of the status that you wish to use. The sync will process the invoice from ConnectWise and then on the next run of the sync (approximately 15 minutes later) the status of the invoice in ConnectWise will be updated.
If you have the invoice status update set, but you notice invoices that are not updating, check that the company in ConnectWise for those invoices has an Account ID set. ConnectWise does not allow the status to change on invoices where the company record does not have an Account ID set.
To correct this, simply need to go to the finance details section of the company record and add the Account ID:
Invoice Renumber
Invoice Renumber
The sync does offer the option to renumber the invoices in e-automate to match the invoice number from ConnectWise. This is recommended only if you are sending the invoice to the customer from ConnectWise, if you are sending the invoice from e-automate, there is no reason to renumber the invoices.
When the invoice renumber option is enabled, the sync will renumber the contract invoice in e-automate to match the invoice number from ConnectWise. If the invoice numbers in ConnectWise are numeric only, you'll need to also enter a prefix option to ensure that the sync doesn't try to renumber the invoice to a number that already exists in e-automate.
A few things to keep in mind when using the invoice renumber:
1. You MUST wait until the sync has updated the contract with the new invoice number from ConnectWise prior to billing the contract in e-automate. If the contract is billed prior to the sync updating the contract with the new invoice number from ConnectWise the sync WILL NOT renumber the invoice in e-automate.
2. If you are sending invoices from e-automate and using the renumbering process, you must wait at least 15 minutes after creating the invoices before sending them to the customer. If you send the invoices immediately after creating them, the sync will not have time to renumber the invoices and they will send with the original e-automate invoice number.
3. Contracts that are set to group bill will not have the invoices renumbered.
4. When a contract invoice is voided in e-automate, the sync will renumber the voided invoice to be the CW invoice number with a -V1 at the end. The new invoice will be renumbered to the original ConnectWise invoice number.
EA Invoice Number to CW
EA Invoice Number to CW
If you are not using the invoice renumber functionality, you do have the option to push the e-automate contract invoice number pushed to a custom field in ConnectWise. To use this option, set variable X to Yes and then enter the name of the custom field to be used in variable Y. Once the contract invoice has been created in e-automate, the sync will push the invoice number to the custom field in ConnectWise.
The custom field will need to be created in the notes section of the invoice:
The field caption should be entered into variable Y.
Once the invoices are created in e-automate, this field will be updated in ConnectWise:
Billing Groups
Billing Groups
If you want IT contracts to have a separate billing group, you can add one to the contract templates. It is not required, just a way to segregate the IT contracts into a separate group and something we recommend doing.
To create a billing group in e-automate, go to Lists and Codes and select Contract bill groups from the drop-down list:
Assign the bill group to the contract templates and it will then be copied over to contracts created from that template.
Sales Reps
Sales Reps
There are options for updating the sales rep on the contract in e-automate, if that is a field that you would like to update. The default setting is to not update the sales rep, send an email to help@ceojuice.com if you would like to use one of these two options:
1. Pull the sales rep from the customer record in e-automate.
2. Pull the sales rep from a custom field on the agreement in ConnectWise.
For option one, if there is a sales rep assigned to the main customer on the contract, that sales rep will populate in the sales rep field on the contract.
For option two, you'll first need to create a custom field in ConnectWise on the agreement overview called ZCJ_EASalesRep. This field will be populated with the employee number from e-automate for the sales rep:
You'll need to be sure to use the employee number from e-automate and that the employee record is set as a sales rep:
To enable this feature, you'll need to email help@ceojuice.com and specify which option you want to use to update the sales reps.
Report Groups
Report Groups
The report group on the contract determines what invoice format is used when printing/viewing the invoice in e-automate. We will create five optional report groups for you that you can assign to the contract templates. See notes here on how to create report groups if you need to create these groups in e-automate.
The report groups are:
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.
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, please email help@ceojuice.com to get it installed for you.
E. CW Rollup: Shows the full details of each item pulled from the ConnectWise agreement, items that have a billing amount of zero only show the description. **This is a newer format, please email help@ceojuice.com to get it installed for you.
Invoice Samples
CW No Base Rate:
CW Details
CW No Details
CW Full Details
CW Rollup
Contract Message
Contract Message
The sync will populate a message on the contract with the next billing date from ConnectWise (1). This message is set to require acknowledgment in the billing queue (2).
The message is intended to be used as a way to confirm that the contract has been updated by the sync prior to invoicing the contract in e-automate. If the next invoice date in the message matches the billing period date, the invoice has not been updated by the sync and should not be billed. In the above example, the message on the contract indicates that the next billing date in ConnectWise is 8/1/23, meaning that in e-automate the contract should be billing for the 7/1-/31 period. If the contract in e-automate is billing for the 8/1/8/31 period, the contract has not been updated by the sync and should not be billed in e-automate.
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 e-automate, 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 e-automate:
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 e-automate. To make sure that this box is unchecked in e-automate, you'll need to make sure that the taxable option on the addition in ConnectWise is selected. (The taxable default for a product is set on the product, this can be overridden on the addition.)
The contract in e-automate needs to have the option to 'Use equipment tax codes' checked:
If this option is unchecked, the tax code set on the contract will be applied to all items on the contract. This option is checked by default when the contract templates are created, but if it's unchecked on the template, the contract created from the template will have this option unchecked.
The tax billed on the e-automate 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 e-automate 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, e-automate will not charge tax on the contract invoice.
Terminating items
Terminating Items
The sync will use the default termination code in variable 11 to terminate items that are no longer on the contract. When the item is no longer billed on the contract, the sync will use this termination code and show the item as canceled:
The sync will set the end coverage date and end base billing date to the last day of the month, this is done to stop e-automate from automatically prorating the billing amount for the item, as that proration has already been done in ConnectWise.
Expired and Canceled Agreements
Expired and Canceled Agreements
The sync will also check for agreements that are in the status of either Expired or Canceled and update the linked contracts to be terminated. The terminated on date will reflect the date that the sync updated the contract and the default term code will be applied to the contract. (You can use ID617 to see a list of contracts canceled each day.)
Any terminations of contracts must begin in ConnectWise so that the sync will update the linked contract in e-automate.
Proration of Items
Proration of Items
ConnectWise will automatically prorate additions added mid-month, the sync takes this proration into account and makes adjustments to these items on the e-automate contract so that the item on the contract is not prorated again by e-automate. **PRORATED ITEMS TO BE BILLED IMMEDIATELY IN CONNECTWISE WILL NEED TO BE MANUALLY ADJUSTED IN E-AUTOMATE, SEE NOTES HERE*
In ConnectWise, to prorate the additions on the agreement, you need to have the option to prorate checked:
When this option is checked, when additions are added with an effective date of mid-month (1), ConnectWise will automatically calculate a prorated price (2):
When the new item is added to the contract in e-automate, the sync will set the start date on the item to the first of the billing month. This has to be done so that e-automate will not automatically prorate the amount, since the billing amount has already been prorated in ConnectWise.
Invoice Paid in CW
Invoice Paid in CW
The sync has the option to update the invoice in ConnectWise and show it as paid when the invoice in e-automate is paid in full. To utilize this option, set variable Z to yes. When the invoice in e-automate is paid in full:
The sync will then update the invoice in ConnectWise to show that it has been paid in full:
This piece of the integration only works when the invoice has $0.00 due in e-automate. The sync will not post partial payments to the invoice.
Attachments
Attachments
Any attachments to the agreement in ConnectWise will sync to the contract in e-automate. By default, attachments will sync to e-automate, if you do not want to sync attachments, please email help@ceojuice.com to have this option turned off.
Attachments in ConnectWise are on the Attachments tab of the agreement:
The files attached to the agreement will be visible on the attachments screen for the linked contract in e-automate:
Bill Contract Checkbox
Bill Contract Checkbox
Once the contract invoice has been created the sync will uncheck the bill contract box on the contract in e-automate.
When this box is unchecked, the contract will not pull into the contract billing queue. When a new invoice is created in ConnectWise and the sync updates the contract in e-automate it will check the Bill contract box so that the contract will pull into the billing queue.
This is intended to stop contracts from getting billed in e-automate before the next invoice from ConnectWise updates the contract. If you need to void and reset an invoice in e-automate and will NOT be creating a new invoice in ConnectWise, you will need to manually check this box on the contract to bill the contract.
E-views
E-views
There are four custom e-views available in the System section, these views can be used to verify that contracts have been updated by the sync and also to check amounts between ConnectWise and e-automate.
Jump to: Contract Invoice Log | Contract Details | Contracts Created | Items Created
Contract Invoice Log
CEO Juice ID964 Contract Invoice Log
This e-view shows a log of every time the sync creates or updates a contract in e-automate and the history of any invoice renumbering that was done.
This e-view contains some columns pulled from the CEO Juice background tables:
[Log Type] - This column indicates if the contract was created (SYNC ADD) or if the contract was updated (SYNC UPDATE). This column also indicates when the billing is matched between e-automate and ConnectWise.
[UsePONumber_CWInvoice] - If the ConnectWise invoice number posts to the PO Number field on the contract, this column will have Yes.
[UseRemarks_CWInvoice] - If the ConnectWise invoice number posts to the remarks field on the contract, this column will have Yes.
[OrgInvoiceNumber] - The original invoice number from e-automate.
[NewInvoiceNumber] - The updated invoice number in e-automate.
[CWInvoiceNumber] - The invoice number from ConnectWise.
[LastSync] - Last sync date for contract/invoice.
[ErrorLog] - Any errors logged for the invoice renumber.
Contract Details
CEO Juice ID964 Contract Details
This e-view shows the line item details for contracts updated by the sync.
Contracts Created
CEO Juice ID964 Contracts Created
This e-view shows the contract header level details for the contracts updated by the sync.
Item Created
CEO Juice ID964 Items Created
This e-view shows all items created by the sync.
* * *
Best Practices & Tips
Best Practices & Tips
Jump to: Annual Agreements | Existing Contracts | Renewing Contracts | Bill Prorated Items Immediately | Multiple Items | EA Version 21 | Billing Multiple Months | Billing Cycle | Rebilling Contract | Contract Not Updated | Zero Dollar Invoices in EA | Invoice Renumber Issues | Bundled Agreements | Product Type Recommendations | Custom Fields
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:
Existing Contracts
Existing Contracts
The agreement sync can be set to push CW agreement invoices to existing contracts in e-automate, though we do not recommend this practice. 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.
Renewing Contracts
Renewing Contracts
The agreement sync DOES NOT support renewing contracts in e-automate! If a contract that is linked to an agreement is renewed in e-automate, subsequent invoices from ConnectWise will NOT update the renewed contract, but continue to update the original contract. If a contract must be renewed, you will need to send an email to help@ceojuice.com with the contract number so that we can break the background linking and allow the agreement to update the renewed contract.
The majority of MNS contracts are set with no end date and are allowed to keep billing until the contract is canceled. If an agreement in ConnectWise is set with an expiration date, the best practice to renew the contract is to simply update the end date on the agreement in ConnectWise. When this date is updated, the expiration date on the linked contract in e-automate will be updated when the next invoice is generated.
Billing Prorated Items Immediately
Billing Prorated Items Immediately
The agreement sync DOES NOT support billing prorated items immediately! If the agreement in ConnectWise is billed monthly, the prorated items will be picked up on the next monthly invoice generated. If the agreement in ConnectWise is billed annually or quarterly, the sync WILL NOT automatically update the contract in e-automate to bill the proper prorated amounts. To bill these prorated items, you will need to manually add them to the contract in e-automate:
1. Set the start coverage date to match the effective date for the item.
2. Click on the Proration settings button.
3. Check the option to Bill immediately.
Then you will be able to process the contract in the billing queue to generate the invoice for the prorated amount.
**Do not sync the prorated invoice from ConnectWise as the sync will reset the billing period and not update the contract correctly.**
Multiple Items
ConnectWise allows you to put the same item on an agreement multiple times, this is not supported on contracts in e-automate. 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 e-automate 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 e-automate, 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:
EA Version 21
In e-automate 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 Multiple Months
Billing Multiple Months
If you are billing multiple months you will need to bill the first month and allow that invoice to sync over to e-automate. Bill the contract in e-automate, then go back to ConnectWise and bill the next month. Repeat the process for as many months as you need to bill. If the sync picks up multiple invoices for one agreement in the same 'batch', it will only process the first invoice chronologically by billing month and skip the remaining invoices for that agreement. **If you need to bill more than three months of invoices for one agreement, it's best to do that manually in e-automate as the sync is not intended for back billing or catch-up billing.
Be sure that each invoice created for the agreement in ConnectWise has a different date, if multiple invoices are created for the same agreement with the same invoice date, the sync will only process the first and then ignore any other invoices. By default, ConnectWise will use the current date as the invoice date. You can change that date here prior to creating the invoices:
You can also change the date on the specific invoice after it has been created here:
Billing Cycle - ConnectWise to e-automate
The process to get your contracts billed properly in ConnectWise and e-automate:
1. Agreements are invoiced in ConnectWise, the sync pulls the invoice information into the CEO Juice background tables.
*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 e-automate and update the contracts.
2. The sync will attempt to match the company and bill to company on the agreement to customer records in e-automate. If the sync is unable to match these customers, the invoice will not import and you'll see either customer not found or bill to customer not found on the ID954 error report.
3. Once the customer is matched, the sync will check to see if the agreement is linked to an existing contract in e-automate (1. In the CEOJuice background tables, 2. Via the ZCJ_EAContractNumber custom field on the agreement). If an existing contract is found, that contract will be updated. If there's not an existing contract, the sync will create a new one based on the matching agreement type template.
4. The sync will go through and set the items on the contract in e-automate to match the ConnectWise billing.
5. The contract will need to be cycled through the contract billing queue to generate a contract invoice and post the revenue.
6. Once the contract invoice has been created in e-automate, the sync will uncheck the Bill contract box so that the contract will not pull into the billing queue again until the next time it is updated by the sync.
CREATING THE CONTRACT INVOICE IN E-AUTOMATE PRIOR TO BILLING THE NEXT MONTH IN CONNECTWISE IS THE MOST IMPORTANT THING THAT NEEDS TO BE DONE IN THIS PROCESS!!
**If you need to make corrections to invoices you'll need to void the invoice in e-automate first, then rebill in ConnectWise and let the sync update the contract in e-automate with the new invoice. Then bill the contract in e-automate.
Rebilling Invoices
Rebilling Invoices
If you need to make changes to an invoice in ConnectWise that has already synced to e-automate and been billed in e-automate, follow these steps:
1. Void and Reset the invoice in e-automate, being sure to select the invoice for the billing period that needs to be rebilled.
2. Delete the invoice in ConnectWise, make changes to the agreement, and rebill.
3. If you are using an invoice status to sync to e-automate, update the new invoice in ConnectWise to that status.
4. The new invoice will sync to e-automate and update the contract to match the adjusted billing from ConnectWise. (When updating the contract in e-automate with the new invoice, the sync will check the Bill contract box on the contract so that it will come into the billing queue to be billed.)
5. Bill the contract in e-automate.
Contract not Updated
Troubleshooting a contract that didn't update:
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 e-automate 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 e-automate. Details on matching the billing cycles here.
4. Have the default item or contract templates been made inactive or deleted? Those default templates need to be in place in order for the sync to function properly.
5. Try updating the invoice in ConnectWise to get it to sync again. The sync checks for invoices that have been updated in ConnectWise since the last time that the sync ran. Updating the invoice in ConnectWise moves the Last Updated date forward and causes the sync to "see" the invoice again. The easiest way to do this is to change the billing status on the invoice (1) and click on the save button (2):
You can then switch the billing status back to what it was to begin with and save and close the invoice.
If none of these tips get the invoice to sync, please send the invoice number to help@ceojuice.com.
Zero Dollar Invoices
Zero Dollar Invoices
If you are billing contract invoices in e-automate and notice that the invoice shows for zero dollars, the most likely reason is that the contract was billed in e-automate before the sync updated the contract. To check for this, open the contract and see if the Billed through date is AFTER the billing on date:
If the Billed through date is AFTER the billing on date, this indicates that the contract was invoiced in e-automate for the billing period, and then updated by the sync. In the example above, the contract was billed for the 11/1 to 11/30 period and then updated by the sync. The sync will set the billing period back to match the billing period on the ConnectWise invoice. For more details on the billing period, see this link.
Check the contract invoices for the contract and see if there are multiple invoices for the same billing period.
These invoices will all need to be voided and reset, then the contract can be billed with the correct information to match ConnectWise.
Invoice Renumber Issues
Invoice Renumber Issues
If the invoice renumber process didn't change the invoice number in e-automate, the most likely reason is that the contract was billed in e-automate prior to the sync updating the contract. To check for this, open the invoice that didn't renumber and check the PO number:
Is the PO number the current invoice number from ConnectWise, or is it the previous month's invoice number? If the PO number is the previous month's invoice number, the sync will be unable to renumber the invoice as it's trying to renumber to an invoice number that already exists in e-automate.
If you are not sure, check the PO number that is currently on the contract:
If the PO number on the contract does not match the PO number on the invoice, that means that the sync has updated the contract since the invoice was created. This usually indicates that the contract was billed prior to being updated by the sync.
To correct this issue, you will need to void and reset the invoice in e-automate and then rebill the contract. The new invoice should be generated with the new invoice number in the PO field and the sync will be able to renumber the invoice.
If the contract invoice that didn't renumber does show the current invoice number from ConnectWise, please send an email to help@ceojuice.com with the invoice number from e-automate.
Child Agreements
Bundled Agreements/Group Billing
ConnectWise allows you to bundle agreements together so that your customer will only receive one invoice. To bundle the agreements together, they must have the same billing cycle, tax code, and terms. You'll have one parent agreement and then assign other agreements to be billed with that agreement. The bundled agreements will be child agreements to the main agreement.
To bundle the agreements in ConnectWise, go to the agreement that will be the parent agreement and click on the Agreements tab. This will show you all agreements for the company:
Select the agreements that will become the child agreements by checking the box in the Attach column. Once the agreements are set as a child agreement, you'll see that the additions from the child agreements show on the Addititions tab:
The level column will show the specific agreement name for any child agreements. The level column will be blank for any additions that are on the parent agreement.
Once an agreement is set as a child agreement, it will no longer show in the main agreement search.
When this agreement is billed in ConnectWise, the additions from all agreements will bill on one invoice. The sync will then create ONE contract in e-automate, with the additions from all child agreements listed. (Everything from the ConnectWise invoice will match to the items on the e-automate contract.)
If you have agreements in ConnectWise that can't be bundled, you can also group bill the contracts in e-automate so that your customer will only receive one invoice. Contracts in e-automate can be group billed as long as they have the same customer (1), bill to customer (2), and billing group (3). The contracts must all have the same billing cycle. To group bill, you'd check the option to Group invoices according to customer, bill to, etc (4):
To use the group billing in e-automate, you would keep each agreement in ConnectWise separate and bill them on separate invoices. The sync would create individual contracts for each agreement in e-automate, when the contracts are processed in the billing queue, one invoice would be created for all contracts that are grouped together.
If you use the group billing option in e-automate, the invoice renumber process and invoice paid process will not work.
**One thing to note, e-automate will not allow block time (deposit) contracts to be group billed with recurring monthly (installment) contracts.
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
There are two required custom fields: ZCJ_ContractNumber and ZCJ_ItemNumber and two options fields ZCJ_EASalesRep and ZCJ_EALocations.
To create the custom fields, go to the Setup Tables and choose Custom Fields from the list:
ZCJ_ContractNumber
ZCJ_ContractNumber
Section: Agreement Overview
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
ZCJ_EASalesRep
ZCJ_EASalesRep
Section: Agreement Overview
Click on the plus icon to create a new custom field
1. Enter ZCJ_EASalesRep in the Field Caption.
2. Check the box for Display on Screen?
3. Check the box for Include on List View?
ZCJ_EALocation
ZCJ_EALocation
Section: Agreement Additions
Click on the plus icon to create a new custom field
1. Enter ZCJ_EALocation in the Field Caption.
2. Check the box for Display on Screen?
3. Check the box for Include on List View?
ZCJ_ItemNumber
ZCJ_ItemNumber
Section: Product 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
* * *
0 Comments