Salesforce Order to SAP Business One Order
First published on: 08/18/2023/11:26 pm
Workflow Description
In this workflow, a scheduled job will call Salesforce at regular intervals (configurable) to retrieve new or updated sales orders since the last integration run.
When a sales order is added or updated in Salesforce, the integration will check a UDF on the SAP Business One sales order document called ‘U_V33SB_SFOrderId’, which contains the Salesforce sales order ID.
If a value exists, the existing SAP Business One sales order will be updated.
If the sales order doesn't exist, it will be created and the ‘sales order id’ from Salesforce will be saved to SAP Business One's sales order UDF ‘U_V33SB_SFOrderId.’
Workflow Diagram
Mapping
The following mapping will be applied:
|
Salesforce Order |
SAP Business One Order |
Comments |
|---|---|---|
|
CreatedDate |
DocDate |
|
|
CreatedDate |
DocDueDate |
|
|
AccountId |
CardCode |
Get CardCode from query “GetCardCodeByAccountId” based on UDF ‘U_V33SBAccountId’ |
|
OrderNumber |
NumAtCard |
|
|
Id |
U_V33SB_OrderId |
|
|
Lines |
||
|
Product2Id |
ItemCode |
Get ItemCode from query “GetItemCodeByProductId” based on UDF ‘U_V33SBProductId’ |
|
Quantity |
Quantity |
|
|
UnitPrice |
UnitPrice |
|
|
Id |
U_V33SB_SFLineId |
|
|
Last modified: 11/15/2023/8:24 pm |
On this page