To process Open EDI Sales Orders, use the standard SAP Business One Sales Order window and follow the instructions below.

Open Sales Orders can be selected for processing as described in Open Sales Orders.

The following table defines Sales Order Header fields, which are updated when an EDI Sales Order is loaded in SAP Business One. These fields are described below. Note that these fields also apply to the processing of Delivery documents.

Sales Order UDFs can be used to process the order, as described below.
Sales Order UDFs can be used to process the order, as described below.
Sales Order Definitions
Fields used to process a Sales Order, Delivery or Invoice

Expand the details below for a detailed description of the fields used in SAP Business One documents Sales Order, Delivery or Invoice.

Fields used to Process a Sales Order, Delivery or Invoice
Field Name Database Field Name Type Definition
CustomerCardCodeTextThis field identifies the SPS Trading Partner, as identified on the EDI PO (850). It is matched with the Trading Partner ID field (U_ZSPS_TPID) on the Business Partner Master Data.
Customer ref. No.NumAtCardTextLoaded from EDI PO (850). This field is mandatory for processing EDI Invoices (810) without an EDI PO (850).
Ship-To AddressAddress2TextLoaded from EDI PO (850) if on 850. Otherwise SAP Business One default is used.
Bill-To AddressAddressTextLoaded from EDI PO (850) if on 850. Otherwise SAP Business One default is used.
Freight - AllowancesVarious fieldsNumericLoaded from EDI PO (850) if on 850 and SPS Use Allowances on the BP Master Data (U_ZSPS_Use850All) is set to Yes.
Freight - ChargesVarious FieldsNumericLoaded from EDI PO (850) if on 850 and SPS Use Charges on the BP Master Data (U_ZSPS_Use850Chg) is set to Yes.
SPS Trading Partner IdU_ ZSPS_TPIDTextLoaded from EDI PO (850). Note: This field is mandatory for processing EDI Invoices (810) without an EDI PO (850).
Warehouse NumberU_ZSPS_DepoOrdNumTextLoaded from EDI PO (850). Identifying number for a warehouse shipping order assigned by the depositor. Reference only.
Document PurposeU_ZSPS_TsetPurposeCdTextLoaded from EDI PO (850). 00 = Original Order (R1.00 supports only 00). Reference only.
PO TypeU_ZSPS_POTypeCodeNumericLoaded from EDI PO (850).
PO Type DescriptionU_ ZSPS_POTypeDescTextLoaded from EDI PO (850).
Order TypeU_ZSPS_BlanketRefTextLoaded from EDI PO (850).
PO DateU_ ZSPS_PODateDateLoaded from EDI PO (850).
PO TimeU_ ZSPS_POTimeTimeLoaded from EDI PO (850).
Contract NumberU_ ZSPS_ContractNumTextLoaded from EDI PO (850).
Invoice TypeU_ ZSPS_InvTypeCodeNumericLoaded from EDI PO (850).
DepartmentU_ ZSPS_DepartmentTextLoaded from EDI PO (850).
Department DescriptionU_ ZSPS_DeptDescTextLoaded from EDI PO (850).
Vendor NumberU_ ZSPS_VendorTextLoaded from EDI PO (850).
DivisionU_ ZSPS_DivisionTextLoaded from EDI PO (850).
Promo NumberU_ ZSPS_PromoDealNoTextLoaded from EDI PO (850).
Promo DescriptionU_ ZSPS_PromoDealDescTextLoaded from EDI PO (850).
Terms TypeU_ ZSPS_TermsTypeTextLoaded from EDI PO (850).
Terms PeriodU_ ZSPS_TermsBDateCodNumericLoaded from EDI PO (850).
SPS Payment Terms DescriptionU_ ZSPS_TermsDescTextLoaded from EDI PO (850).
Shipped DateU_ ZSPS_ShippedDateDateLoaded from EDI PO (850).
Estimated Delivery DateU_ ZSPS_EstDelDateDateLoaded from EDI PO (850).
Earliest Ship DateU_ ZSPS_EarliestShpDtDateLoaded from EDI PO (850).
Latest Delivery Ship DateU_ ZSPS_LatestShpDtDateLoaded from EDI PO (850).
Earliest Delivery DateU_ ZSPS_EarliestDelDtDateLoaded from EDI PO (850).
Latest Delivery DateU_ ZSPS_LatestShpDtDateLoaded from EDI PO (850).
Scheduled Delivery DateU_ ZSPS_SchedDelDtDateLoaded from EDI PO (850).
Scheduled Ship DateU_ ZSPS_SchedDelDtDateLoaded from EDI PO (850).
Requested Ship DateU_ ZSPS_ReqShpDtDateLoaded from EDI PO (850).
Doc Due TimeU_ ZSPS_DocDueTmTimeLoaded from EDI PO (850).
Earliest Ship TimeU_ ZSPS_EarliestShpTmTimeLoaded from EDI PO (850).
Latest Ship TimeU_ ZSPS_LatestShpTmTimeLoaded from EDI PO (850).
Contact TypeU_ ZSPS_ContactTypeCdTextLoaded from EDI PO (850).
Contact NameU_ ZSPS_ContactNameTextLoaded from EDI PO (850).
Contact PhoneU_ ZSPS_ContactPhoneTextLoaded from EDI PO (850).
Contact FaxU_ ZSPS_ContactFaxTextLoaded from EDI PO (850).
Contact EmailU_ ZSPS_ContactEmailTextLoaded from EDI PO (850).
FOB Pay CodeU_ ZSPS_FOB_PayCodeTextLoaded from EDI PO (850).
FOB Location QualifierU_ ZSPS_FOB_LocQualTextLoaded from EDI PO (850).
FOB DescriptionU_ ZSPS_FOB_DescTextLoaded from EDI PO (850).
WeightU_ ZSPS_WeightNumericLoaded from EDI PO (850).
VolumeU_ ZSPS_VolumeNumericLoaded from EDI PO (850).
Weight Unit of MeasureU_ ZSPS_WeightUOMTextLoaded from EDI PO (850).
Volume Unit of MeasureU_ ZSPS_VolumeUOMTextLoaded from EDI PO (850).
Transportation CodeU_ ZSPS_TransCodeNumericLoaded from EDI PO (850).
Routing DescriptionU_ ZSPS_CarrierRoutTextLoaded from EDI PO (850).
Special InstructionsU_ ZSPS_SpecialInstTextLoaded from EDI PO (850).
Packing Slip NoteU_ZSPS_PackSlipInstTextLoaded from EDI PO (850).
Shipping NoteU_ ZSPS_ShipNoteText

Loaded from EDI PO (850).

General NoteU_ ZSPS_GenNoteText

Loaded from EDI PO (850).

SPS Order TypeU_ SPS Order TypeText

Updated by SPS Commerce Cloud EDI Add-On.

NA – Not Applicable

BO – Bulk Order

DS – Drop Ship

MS – Multi-Store

SPS Purchase Order Ack StatusU_ ZSPS_POAckStatusText

Updated by SPS Commerce Cloud EDI Add-On.

NOC – Not Complete

AD – Acknowledgement – With Detail No Change

AK – Acknowledgement – No Detail or Change

RD – Reject with Detail

RJ – Rejected – No Detail

MN - Manual

SPS ASN 856 StatusU_ ZSPS_ASNStatusText

Updated by Connector Add-On.

NOC – Not Complete

SNT – Sent

Man - Manual

SPS Invoice 810 StatusU_ ZSPS_InvStatusText

Updated by Connector Add-On.

NOC – Not Complete

SNT – Sent

Man - Manual

SPS OrderU_ ZSPS_OrderText

Updated by Connector Add-On.

Y – Yes

N - No

Sales Order Line Details

Expand the details below for field definitions of Sales Order Line fields which are updated when an EDI Sales Order is loaded in SAP Business One.

Line Detail Fields used to Process a Sales Order, Delivery or Invoice
Field Name Database Field Name Type Definition
Item No.ItemCodeTextLoaded from EDI PO (850). The ItemCode is determined using the logic described in the Item Cress Reference section of this document.
QuantityQuantityNumericLoaded from EDI PO (850).
PricePriceNumericLoaded from EDI PO (850) if the field SPS Use Price on the Business Partner Master Data (U_ZSPS_Use850Price) is set to Yes.
Number of the line itemZSPS_EDI_LineNoNumericUpdated by Connector Add-On.
Buyer's primary product idZSPS_BuyerNoTextLoaded from EDI PO (850).
Buyer's units of measurementZSPS_BuyerUOMTextLoaded from EDI PO (850).
Agreed priceZSPS_BuyerPriceNumericLoaded from EDI PO (850).
Type of unit price for an itemZSPS_PriceBasisStringLoaded from EDI PO (850).
Desc of the product colorZSPS_BuyerColorTextLoaded from EDI PO (850).
Color primary descriptionZSPS_NRF_ColorTextLoaded from EDI PO (850).
Size primary descriptionZSPS_SizeTextLoaded from EDI PO (850).
Contact NameZSPS_BuyerNameTextLoaded from EDI PO (850).
Requested Ship DateZSPS_ReqShipDateDateLoaded from EDI PO (850).
Estimated Ship DateZSPS_EstShipDateDateLoaded from EDI PO (850).
Retail PriceZSPS_RetailPriceNumericLoaded from EDI PO (850).
Retail Price - UOMZSPS_RetailPricUOMNumericLoaded from EDI PO (850).
Product DescriptionZSPS_ProdDescTextLoaded from EDI PO (850).
Color DescriptionZSPS_ColorDescTextLoaded from EDI PO (850).
Size DescriptionZSPS_SizeDescTextLoaded from EDI PO (850).

Warnings

To view all warnings associated with the validation of the SAP Business One Documents, press the Warnings button, marker 2 in the above screenshot. This will bring up the warnings screen shown below.

Within the details, an error code is provided at the end of each message. Use this code to look up resolution instructions for each error in the Error Codes documentation.

Warnings related to sales orders.
Warnings related to sales orders.

Additional EDI Documents Button

Additional EDI Documents button which can be found on the sales order screen.
Additional EDI Documents button which can be found on the sales order screen.

For sales orders which originated from an SPS integrated purchase order, the “Additional EDI Documents” button will be shown. This button will open the default web browser and navigate to the SPS Portal. The customer purchase order number (Customer Ref No) will be used to find the related purchase order document in the SPS Portal. See Additional EDI Documents for more information.