Opportunity Records in ConnectWise contain calculated Revenue Fields that are available to map in your integration. Below is an overview of how these Fields work and can be used in your integration.
Revenue Fields are Read-Only
First, it's important to understand that Revenue Fields are read-only by default and can only sync in one direction from ConnectWise to another System. You can never write directly into these Fields from another System. This is due to how these Fields are calculated, which is based on the products and services that are associated to an Opportunity in ConnectWise.
Revenue Field Types
There are a few different Revenue Fields that you can choose from. Here is a list:
- Total Forecast Cost
- Total Forecast Revenue
- Total Forecast Profit
- Total Recurring Cost
- Total Recurring Revenue
- Total Recurring Profit
- Recurring Start Date
- Recurring End Date
- Recurring Cycles
- Recurring Cycle Type
These Fields all come from the Forecast table found on the Opportunity record.
The Revenue and Cost Fields are obvious in terms of where they come from but the Profit Field can be a tricky, as it is actually called Margin on the Opportunity Record.
For the above Opportunity example, here is what the Fields and values look like in the Formstack Sync schema:
The Recurring Fields are related to any products and services that are listed as a "recurring" in your ConnectWise quote. If you don't have any recurring revenue then these Fields will have a value of $0. Same goes for the Recurring Start/End Date, Recurring Cycle, and Recurring Cycle Type Fields.
Here is an example of how you could map this information back to your Opportunity Record in another System.
Example Revenue Field Mapping