HomeTutorialsShipment Import SolutionXML Format
 

Shipment Import XML Format

The Shipment Import Solution returns third-party warehouse shipment information into SYSPRO and provides ASN and shipment information to the EDI Solution for SYSPRO. To accomplish this, third-party warehouse shipment information is provided to Shipment Import in a standard XML-formatted document and in turn the Shipment database is populated with the shipment configuration as well as updating the sales order with the shipped quantities. 

After preparing the XML-formatted input documents (see further below), launch the Shipment Import menu by pressing Ctrl+R, then type EDISSI and click OK, or, alternatively, access it from the EDIMNU as shown below:

Shipment Import menu

The following are specifications for the Shipment Import's XML-formatted input file.

XML Tag Parent Description
Shipments Root Beginning of Shipment Information (not required if there is only one shipment per import file)
Shipment Shipments (or Root) Start of a shipment

Attributes:
Number Shipment Number (1-9 Digits)
Note: If not included, shipment number will be assigned
Date Shipment Date and Time
Status "Complete" = Shipment is Complete;  also, note this "Status" attribute should not be used together with the "Release" tag below
Handheld Informational name of device used for collection of shipment
Freight Freight Charge
Release Shipment

If the first character is "N" (or "n"), the shipment is set to a status of "Incomplete"; otherwise, it is set for "Released"

Note: there is an attribute "Status" in the "Shipment" tag.  If the "Status" attribute is set to "Complete", then the shipment will be placed in a "Released" status.  The "Release" tag and Shipment "Status" attribute should not be used together.

BOL Shipment Bill of Lading Number
Cartons Shipment Order Total Carton/Package Count
Order Shipment Start of an order within a shipment
Dispatch Shipment Start of an dispatch within a shipment
Line/Item Order
Tare
Pack
Start of a item line within an order

Attributes:
Item Stock Code Shipped (information only at this time)
Number Sales Order Line Number
Tare Tare number items are on
Pack Pack number items are in
Quantity Quantity Shipped
UOM Sets UOM for Quantity
Pack Shipment
Order
Tare
Defines a Pack/Carton

Attributes:
Number Pack/Carton Number
SSCC SSCC-18 Serialized Shipping Container Code
Tracking Small Carrier Package Tracking Number
User1 Pack level User Defined 1
SSCC Tare
Pack
SSCC-18 Serialized Shipping Container Code
Tracking Pack Small Carrier Package Tracking Number
User1 Shipment
Pack
User Defined 1
User2 Shipment User Defined 2
PRO Shipment PRO Number
Appointment Shipment Appointment Number
Trailer Shipment Trailer Number
Load Shipment Load Number
Seal Shipment Seal Number
Employee Shipment Sets the "Employee" field on the shipment master record
Quantity Line/Item Quantity Shipped
SCAC Shipment SCAC of Carrier
Serial Line/Item Serial Numbers

Attributes:
Number Serial Number
Quantity Quantity of this serial number shipped
Shipped Line/Item Quantity Shipped
Tare Shipment
Order
Tare/Pallet Information

Attributes:
Number Tare/Pallet Number
SSCC SSCC-18 Serialized Shipping Container Code
Tracking Small Carrier Package Tracking Number
Counted Line/Item The lowest level quantity information and must be the lowest level after Item, Lot, and Bin are used, as necessary

Attributes:
Quantity Quantity counted (in the UOM specified)
StockingQty Used for "Catch Weight", where the conversion between the order quantity and the stocking quantity is not fixed.
UOM Unit of Measure (UOM) for the "Quantity" attribute.  If UOM is not supplied, then order UOM is assumed.
Weight Order Pack Total Weight for Order or Pack
Freight Shipment Freight Cost
Invoice

Order

Allows an invoice number and/or date to be set on the sales order
VIA

Shipment

Allows the "Ship-Via" on the order to be set.  The information here will be run through the inbound Ship-Via X-Ref to get a Ship-Via for the sales order.
Lot

Line/Item

Lot Information; used only if needed and may be used in any order with respect to the Line/Item

Number Lot Number
Quantity Record Quantity
UOM UOM for Quantity
Bin

Line/Item

Bin Information; used only if needed and may be used in any order with respect to the Line/Item

Number Bin Number
Quantity Record Quantity
UOM UOM for Quantity

Samples

Simple Shipment with two shipped lines:

<Shipment Date="2017-10-01 10:41:26" Status="Complete">
   <Order Number="000045">
     <Line Number="2">
       <Shipped Quantity="5"/>
     </Line>
     <Line Number="5">
       <Shipped Quantity="3"/>
     </Line>
   </Order>
</Shipment>

Multiple Shipments with Multiple orders per shipment and Pack information:

<Shipments>
  <Shipment Date="2017-06-16 22:08:27.810">
    <BOL>CT-June16</BOL>
    <PRO>4444444444</PRO>
    <SCAC>CVEN</SCAC>
    <Order Number="000072">
      <Cartons>1</Cartons>
      <Weight>32</Weight>
      <Pack Number="1" SSCC="00040611104791057771">
        <Weight>11</Weight>
        <Line Number="1" Item="1003-01240">
          <Quantity>1</Quantity>
        </Line>
        <Line Number="2" Item="1003-01251">
          <Quantity>2</Quantity>
        </Line>
        <Line Number="3" Item="1003-123456789">
          <Quantity>3</Quantity>
        </Line>
        <Line Number="4" Item="1003-01255">
          <Quantity>4</Quantity>
        </Line>
      </Pack>
    </Order>
    <Order Number="000073">
      <Cartons>1</Cartons>
      <Weight>32</Weight>
      <Pack Number="1" SSCC="00040611104791057761">
        <Weight>32</Weight>
        <Line Number="1" Item="1003-01240">
          <Quantity>1</Quantity>
        </Line>
        <Line Number="2" Item="1003-01251">
          <Quantity>2</Quantity>
        </Line>
        <Line Number="3" Item="1003-123456789">
          <Quantity>3</Quantity>
        </Line>
        <Line Number="4" Item="1003-01255">
          <Quantity>4</Quantity>
        </Line>
      </Pack>
    </Order>
  </Shipment>
  <Shipment Date="2017-06-16 22:09:36.513">
    <BOL>GB-JUne16</BOL>
    <PRO>4444444422</PRO>
    <SCAC>GBEA</SCAC>
    <Order Number="000086">
      <Cartons>1</Cartons>
      <Weight>32</Weight>
      <Pack Number="1" SSCC="00040611104791057751">
        <Weight>22</Weight>
        <Line Number="1" Item="1003-01240">
          <Quantity>1</Quantity>
        </Line>
        <Line Number="2" Item="1003-01251">
          <Quantity>2</Quantity>
        </Line>
        <Line Number="3" Item="1003-123456789">
          <Quantity>3</Quantity>
        </Line>
        <Line Number="4" Item="1003-01255">
          <Quantity>4</Quantity>
        </Line>
      </Pack>
    </Order>
  </Shipment>
</Shipments>

Small Carrier Shipment also showing Pack information separate from Item information.  This is a valid format, however, the 856 document will NOT be able to show pack configurations.

<Shipments>
  <Shipment Date="2017-09-20 00:00:00">
    <SCAC>FEDX</SCAC>
    <Order Number="079181">
      <Cartons>22</Cartons>
      <Weight>22.00</Weight>
      <Pack Number="1" Tracking="650390090315" Freight="5.65">
        <Weight>12.00</Weight>
      </Pack>
      <Pack Number="2" Tracking="650390090326" Freight="4.92">
        <Weight>10.00</Weight>
      </Pack>
      <Line Number="1" Item="1004-06642">
        <Quantity>24</Quantity>
      </Line>
      <Line Number="2" Item="1004-06714">
        <Quantity>42</Quantity>
      </Line><Line Number="3" Item="1004-06718">
         <Quantity>42</Quantity>
      </Line>
    </Order>
  </Shipment>
</Shipments>

Shipment showing "Counted" tag when used with Bins.

<Shipment Number="000000114" Date="2017/03/18 12:42:06 AM" UseSYSPRODate="Yes" Status="Complete" Station="1" >
 <Handheld>Main</Handheld>
 <Release>Yes</Release>
 <Order Number="000000000050123" >
  <Item Line="1" StockCode="325" Warehouse="14" >
   <Lot Number="5293-18541" >
    <Bin Location="100" >
     <Counted Quantity="1.000000" StockingQty="69.600000" UOM="CS" />
    </Bin>
   </Lot>
  </Item>
 </Order>
</Shipment>

Notes:

  • The tags "Item" and "Line" are synonymous.
  • The attributes "Item" and "StockCode" are synonymous.  
  • Any place where the attribute "UOM" is used is the same-- it sets the UOM for quantity.  If UOM is not supplied, "order" UOM is assumed.
  • Lots and bins may be used in any order.  For example, within a Line/Item tag could be Lot, Bin, and Counted; or, within a Line/Item tag could be Bin, Lot, Counted.  The order is according to user requirements.
  • A number of tags may optionally add a corresponding comment line to the sales order based on the "Comments" tabs in the Shipping Station Maintenance.

Why CADACUS SOLUTIONS FOR SYSPRO?

Since 1991, as developer of the standard EDI, Shipping, and Freight Calculator Solutions for SYSPRO, our products are fully integrated with SYSPRO and drive efficiencies for hundreds of users worldwide.

Why SYSPRO?

For 35 years, SYSPRO has had a single product focus resulting in an award-winning ERP system with a track record of success for over 14,000 customers worldwide.