SAP Business One Price List to Salesforce Order
First published on: 08/18/2023/11:25 pm
Workflow Description
In this workflow, a scheduled job will run at regular intervals (configurable) to retrieve SAP Business One orders that have been added since the last workflow execution.
The workflow will create the orders in Salesforce.
The workflow will write back the order/entity ID of the sales order created in Salesforce to the UDF U_V33SB_SFOrderId on the SAP Business One order.
Workflow Diagram
Mapping
The following mapping will be applied:
|
SAP Business One Order |
Salesforce Order |
Comments |
|---|---|---|
|
Header |
||
|
|
Attributes/Type |
“Order” |
|
CardCode |
AccountId |
GetSFAccountId Query Result |
|
|
Pricebook2Id |
Salesforce Pricebook Id (Customer will provide which price book they want to update.) |
|
DocDate |
EffectiveDate |
|
|
|
Status |
“Draft” |
|
|
Type |
“Standard” |
|
Addresss |
||
|
BillToStreet |
BillingStreet |
|
|
BillToCity |
BillingCity |
|
|
BillToState |
BillingState |
|
|
BillToZipCode |
BillingPostalCode |
May require Lookup mapping |
|
BillToCountry |
BillingCountry |
|
|
RDR12.ShipToStreet |
BillingStreet |
|
|
ShipToStreet |
ShippingStreet |
|
|
ShipToCity |
ShippingCity |
|
|
ShipToState |
ShippingState |
May require Lookup mapping |
|
ShipToZipCode |
ShippingPostalCode |
|
|
ShipToCountry |
ShippingCountry |
May require Lookup mapping |
|
Lines |
||
|
|
Attributes/Type |
“OrderItem” |
|
U_V33SB_SFProductId |
Product2Id |
Lookup for ItemCode on order line |
|
Quantity |
quantity |
|
|
RDR1.Price |
UnitPrice |
|
|
|
PriceBookEntryId |
GetItemPriceBookEntryId Query Result Based on ItemCode |
|
Last modified: 08/30/2024/1:35 pm |
On this page