SAP Concur Invoice to SAP Business One Integration Points
First published on: 06/26/2024/9:04 am
Workflow Description
This workflow creates a new order in ShipStation when a sales order is created in SAP Business One.
The workflow then updates the SAP Business One order with the ShipStation order ID using UDF U_V33SB_ShipStationOrderId.
Workflow Diagram
Vendors
Mapping
The following mapping will be applied:
(Please consider this as a base mapping. Mapping can be changed during collaborative sessions.)
|
SAP Business One
|
Concur |
Comments/ Hardcoded Values
|
|---|---|---|
|
Header |
|
|
|
OCRD.CardCode |
VendorCode |
|
|
OCRD.CardName |
VendorName |
|
|
CRD1.Address |
AddressCode |
|
|
CRD1.Street |
Address1 |
Default Billing Address |
|
CRD1.City |
City |
Default Billing Address |
|
CRD1.State |
State |
Default Billing Address |
|
CRD1.ZipCode |
PostalCode |
Default Billing Address |
|
CRD1.Country |
CountryCode |
Default Billing Address |
| OCRD.Phone1 | ContactPhoneNumber | |
| OCRD.E_Mail | ContactEmail | |
| OCRD.Currency | CurrencyCode | |
|
|
PaymentMethodType |
‘CLIENT’ |
|
|
Approved |
‘true’ |
Workflow Description
This workflow creates a new order in ShipStation when a sales order is created in SAP Business One.
The workflow then updates the SAP Business One order with the ShipStation order ID using UDF U_V33SB_ShipStationOrderId.
Workflow Diagram
Items/List Items
Mapping
The following mapping will be applied:
(Please consider this as a base mapping. Mapping can be changed during collaborative sessions.)
|
SAP Business One |
Concur |
Comments/ Hardcoded Values |
|---|---|---|
|
|
ListID |
To be supplied |
|
OITM.ItemCode |
Level1Code |
|
|
OITM.ItemName |
Name |
Workflow Description
This workflow creates a new order in ShipStation when a sales order is created in SAP Business One.
The workflow then updates the SAP Business One order with the ShipStation order ID using UDF U_V33SB_ShipStationOrderId.
Workflow Diagram
Purchase Orders
Mapping
The following mapping will be applied:
(Please consider this as a base mapping. Mapping can be changed during collaborative sessions.)
|
SAP Business One
|
Concur |
Comments/ Hardcoded Values
|
|---|---|---|
|
OPOR.DocNum |
PurchaseOrderNumber |
|
|
OPOR.DocDate |
OrderDate |
|
|
OPOR.CardCode |
VendorCode |
|
|
OCRD.Currency |
CurrencyCode |
Vendor Currency |
| OPOR.DocDueDate | RequestedDeliveryDate | |
| OPOR.TotalExpns | Shipping | |
| OPOR.VatSum | Tax | |
| OPOR.PayToCode | BillToAddress/ExternalID | |
| POR12.StreetB | BillToAddress/Address1 | |
| POR12.CityB | BillToAddress/City | |
| POR12.StateB | BillToAddress/StateProvince | |
| POR12.ZipCodeB | BillToAddress/PostalCode | |
| POR12.CountryB | BillToAddress/CountryCode | |
| OPOR.ShipToCode | ShipToAddress/ExternalID | |
| POR12.StreetS | ShipToAddress/Address1 | |
| POR12.CityS | ShipToAddress/City | |
| POR12.StateS | ShipToAddress/StateProvince | |
| POR12.ZipCodeS | ShipToAddress/PostalCode | |
| POR12.CountryS | ShipToAddress/CountryCode | |
| POR1.VisOrder | LineItem/LineNumber | |
| POR1.LineNum | LineItem/ExternalID | |
| POR1.ItemCode | LineItem/SupplierPartID | |
| POR1.Dscription | LineItem/Description | |
| POR1.Quantity | LineItem/Quantity | |
| POR1.Price | LineItem/UnitPrice |
Workflow Description
This workflow creates a new order in ShipStation when a sales order is created in SAP Business One.
The workflow then updates the SAP Business One order with the ShipStation order ID using UDF U_V33SB_ShipStationOrderId.
Workflow Diagram
Purchase Invoices
Mapping
The following mapping will be applied:
(Please consider this as a base mapping. Mapping can be changed during collaborative sessions.)
|
SAP Business One
|
Concur (PaymentRequest) |
Comments/ Hardcoded Values |
|---|---|---|
|
OPCH.CardCode |
VendorRemitAddress/VendorCode |
|
|
OPCH.NumAtCard |
InvoiceNumber | |
|
OPCH.DocDate |
PaymentDueDate |
|
| OPCH.TaxDate | InvoiceDate | |
| OPCH.DocCur | CurrencyCode | |
| PCH1.ItemCode | LineItem/Custom3 | |
| PCH1.Dscription | LineItem/Description | |
| PCH1.Quantity | ||
| PCH1.Price | LineItem/UnitPrice | |
| PCH1.TaxCode | LineItem/Custom6 | |
| PCH1.BaseType | ‘20’ | |
| PCH1.BaseEntry | LineItem/Custom1 | Base GRPO DocEntry |
| PCH1.BaseLine | MatchedPurchaseOrderReceipt/GoodsReceiptNumber + LineItem/PurchaseOrderNumber | use to find the Base GRPO Line Number |
Assumptions
- ShipStation SKU will match SAP Business One ItemCode.
- The default username and email for ShipStation orders must be provided.
|
Last modified: 08/30/2024/6:07 pm |