SAP Business One Order to HubSpot Deal
First published on: 08/10/2023/6:54 pm
Workflow Description
In this workflow, a scheduled job will run at regular intervals (configurable) to retrieve SAP Business One sales orders created or updated since the last job run.
When a sales order is for a business partner with a company record in HubSpot (identified by a value in UDF ‘U_V33SB_EXTBPID’ on the business partner master record), this workflow will create or update a deal in HubSpot and associate it with that company.
The HubSpot deal ID will then be saved to a UDF on the SAP Business One order.
Workflow Diagram
Mapping
The following mapping will be applied:
|
SAP Business One Order |
HubSpot Deal |
Comments / Hardcoded Values |
|---|---|---|
|
Header |
|
|
|
|
isquote |
false |
|
ORDR.DocEntry |
dealname |
|
|
ORDR.DocTotal |
amount |
|
|
|
pipeline |
‘default’ |
|
|
dealtype |
‘newbusiness’ |
|
Lines |
||
|
|
ITM1.ItemCode |
Lookup by Product Code UDF on the Item master. |
|
properties/quantity |
ITM1.Quantity |
|
|
properties/amount |
ITM1.Price |
|
|
|
ITM1.Currency |
$ (default) |
|
properties/hs_quote_amount |
ITM1.LineTotal |
|
Assumptions
- Custom fields identified in the mappings will be created in HubSpot.
|
Last modified: 11/15/2023/8:21 pm |