HubSpot to Sage Intacct: Create/Update Contracts

Prerequisites

To fully utilize the Workflow Wizard, credentials will need to be set up beforehand. Both HubSpot and Intacct credentials will need to be set up first before users can utilize the workflow wizard.

Configuration

The Workflow Wizard can be accessed by navigating to Workflows and clicking the Wizard button

1. Choose Type

 Screenshot (965)-20240214-144205
 

Option 

Required/ Optional

Type

Description

Source

Required

Drop-down menu

Select HubSpot

Destination

Required

Drop-down menu

Select Intacct

Type

Required

Drop-down menu

Select Create/Update Contracts

 

2. HubSpot Setup

Screenshot (966)-20240214-144312

Option

Required/ Optional 

Type

Description

HubSpot Credential

Required

Drop-down menu

Select the source credential that has been set up beforehand (see: HubSpot Credential)

Select

Required

Select Arrow Button

Unsure that all desired fields are selected and move to the Fields to Collect section.

Filter

Optional

Filter Field

The customer filter auto-populates. This is removable for customization.

 

3. Query 1 Setup

 Screenshot (968)-20240214-144724

Option

Required/ Optional

Type 

Description

Distinct

Optional

Toggle

Enable or disable to make fields distinct

Source Fields

Required

Free Text

Select from the source column. The credential must be set up beforehand (see: Intacct Credential).

Target Fields

Required

Free Text

Select from the Target column. The credential must be set up beforehand (see: Intacct Credential).

Enter Value for LOCATIONID Column

Required

Free Text

Enter the desired Sage Intacct LOCATIONID.

Enter Value for TERMNAME Column

Required

Free Text

Enter the desired Sage Intacct TERMNAME.

 

 4. Query 2 Setup

 Screenshot (969)-20240214-145246

Option

Required/ Optional

Type 

Description 

Distinct

Optional

Toggle

Enable or disable to make fields distinct

Source Fields

Required

Free Text

Select from the source column. The credential must be set up beforehand (see: Intacct Credential).

Target Fields

Required

Free Text

Select from the Target column. The credential must be set up beforehand (see: Intacct Credential).

Enter Value for LOCATIONID Column

Required

Free Text

Enter the desired Sage Intacct LOCATIONID.

Choose Value for BILLINGMETHOD Column

Required

Drop-Down

This field is pre-populated for User ease. This can be edited.

Choose Value for BILLINGOPTIONS Column

Required

Drop-Down

This field is pre-populated for User ease. This can be edited.

Enter Value for REVENUE1TEMPLATE Column

Optional

Free Text

Enter the desired Sage Intacct REVENUE1TEMPLATE Column.

 

5. Sage Intacct Setup

Screenshot (971)-20240214-145652

Option

Required/ Optional

Type

Description

Sage Intacct Credential

Required

Drop-down menu

Required. Select from the source credential that has been set up beforehand. Sage Intacct Credential

Entity ID

Optional

Drop-Down

Enter the desired Sage Intacct Entity ID.

 

6. Review

Screenshot (972)-20240214-145840

The final step will display all elements that will get created in DataBlend based on options selected in the prior steps. The Back button can be utilized throughout the Workflow Wizard to make edits. Click Create to build all listed these elements.

Created Workflow

 

Once a Workflow is created via the Workflow Wizard, the final Workflow is displayed. From here, the Workflow can be executed, scheduled, or favorited.