ShipStation Order to SAP Business One Sales Order
First published on: 08/03/2023/12:00 am
Description Workflow
In this workflow, a scheduled job will call ShipStation at regular intervals (configurable) to retrieve orders created since the last job run.
The import process will create the sales orders in SAP Business One.
Workflow Diagram
Mapping
The following mapping will be applied:
|
ShipStation Order |
SAP Business One Sales Order |
Comments |
|---|---|---|
|
Header |
|
|
|
orderNumber |
DocNum |
|
|
createDate |
DocDate |
|
|
orderDate |
DocDueDate |
|
|
|
CardCode |
Default BP |
|
orderTotal |
DocTotal |
|
|
orderNumber |
NumAtCard |
|
|
orderId |
U_V33SB_ShipStationOrderId |
|
|
|
U_V33SB_EXTERNALORDERSRC |
“ShipStation” |
|
Lines |
|
|
|
items.sku |
ItemCode |
|
|
items.name |
ItemDescription |
|
|
items.quantity |
Quantity |
|
|
items.unitPrice |
UnitPrice |
|
|
|
.TaxCode |
Exempt – to be supplied |
|
items.orderItemId |
U_V33SB_ShipStationLineId |
|
|
Expenses (Tax and Freight) |
|
|
|
|
ExpenseCode |
“ShipStationTax” code |
|
taxAmount |
LineTotal |
|
|
|
TaxCode |
Exempt – to be supplied |
|
|
ExpenseCode |
“ShipStationFreight” code |
|
shippingAmount |
LineTotal |
|
|
|
TaxCode |
Exempt – to be supplied |
|
|
|
|
|
Addresses |
|
|
|
billTo.street1 |
BillToStreet |
|
|
billTo.city |
BillToCity |
|
|
billTo.postalCode |
BillToZpiCode |
|
|
billTo.state |
BillToState |
|
|
billTo.country |
BillToCountry |
|
|
shipTo.street1 |
ShipToStreet |
|
|
shipTo.city |
ShipToCity |
|
|
shipTo.postalCode |
ShipToZipCode |
|
|
shipTo.state |
ShipToState |
|
|
shipTo.country |
ShipToCountry |
|
Tax and freight are created as expenses on the sales order. No tax code or rate mapping is required.
To accommodate the configuration, expense codes called ‘ShipStationTax’ and ‘ShipStationFreight’ must be created.
Assumptions
- ShipStation SKU will match SAP Business One ItemCode.
- The default business partner code must be provided.
- Expense codes called ‘ShipStationTax’ and ‘ShipStationFreight’ must be created.
- The exempt tax code must be provided.
|
Last modified: 11/15/2023/8:21 pm |