Skip to main content

EDI 945 - Warehouse Shipping Advice - Knowledgebase / SalesPad / EDI - Cavallo Technical Support

EDI 945 - Warehouse Shipping Advice

Authors list

Overview

The EDI 945 Warehouse Shipping Advice transaction confirms a shipment. A warehouse can use this transaction to notify a trading partner that a shipment has been made.

Prerequisites

Before continuing with the EDI 945 configuration, make sure EDI is properly configured in SalesPad by reviewing the following documentation:

Data Cross Reference

Select the EDI tab on the ribbon and open the Data Cross Reference screen.

tb9YXdo-UXY2-7Xl72gcW4KYT816LVEnlHBzqISuu8y_PELmN2TtO_BKByBXZ92_NYB3C-uHWDozVBN24ocdLsgn8XUDsViOdHI.png?access_token=sncl9f-vfwofufdgz-2e2219cc0745de97687498f29ec4057eb5593bf7

Click the New button to add a new trading partner and set the following columns:

Column

Value

Trading Partner ID

Trading partner ID from the EDI order header, such as 000ALLCERT

Partnership

“Warehouse”

Customer Num

(Leave blank)

Warehouse

Warehouse/location

EDI

945 Warehouse Shipping Advice


Make sure the new trading partner is selected and then fill out the following mapping tabs as needed:

  • Addresses

  • Items

  • Units of measures

  • Currencies

  • Payment terms

  • Shipping methods

Save all changes and close the Data Cross Reference screen.

Business Object Mapping

Select the EDI tab on the ribbon and open the Business Object Mapping screen.

4pC1IDQQA8kETrTMyZ7-7ZBrLMiQioCRBNK5oM_fHugU0JkM2Dp4WZPWKac6PoZdRIte8f4p4k5y0dwaC_C6Zejp-U7JHRlUFPjs.png?access_token=sncl9h-djrbiynnpy-0d39231b53f3197488723123004d58f9147a7eae

Click the New button to add a new transaction and set the following columns:

Column

Value

Mapping Name

Name of the 945 transaction mapping

Provider

SPS Commerce

EDI

945

Schema Name

Shipments

Direction

In

Document Type

Sales Document

Document Subtype

Sales document type and ID in Dynamics GP, e.g. “ORDER WMSORDER”

Trading Partners

Trading partners to which the mapping applies (trading partners are configured on the Data Cross Reference screen)

Complete Fulfillment

Enable this to update fulfillment on the sales document


The EDI 945 (Warehouse Shipping Advice) and EDI 856 (Ship Notice Manifest) business object mappings share the same default fields. To get the 945 to work correctly, remove the following fields:

  • All fields mapped to SalesDocument in the Business Object column except DepositorOrderNumber and PurchaseOrderNumber under the OrderLevel > OrderHeader node. Even the TradingPartnerId field needs to be removed.

  • The Static Values under the Shipment > Header > ShipmentHeader node.

  • Any fields with a blank Property Name column value. For example, the Shipment > Header > Address node has various lines with CustomerAddr in the Business Object column, but it has a blank cell in the Property Name column because it isn't used in the 945.

Save all changes and close the Business Object Mapping screen.

EDI Processing

Select the EDI tab on the ribbon and open the EDI Processing screen.

Steps

To process an EDI 945 transaction, follow these steps:

1. Click the Send button and select the relevant EDI provider in the prompt.

ZxrukwLC5fCqK73qm51HnTrytHG5GLrhkaojbn8Vu_xoAVZ2kQ1kcPBqv2houOF3162R8UWNHFELUN-JRDJgplcgw3Eejxsgc8mo.png?access_token=sncl9f-zmfyunxwlt-c13e7e4a2ab732019ba7ed936fa424e57281e558

8iKuhSQ6JIkUobI5q99rs9L3ncmJJJ0mFAjNS_uGVqa9v09SACj6UJqnZHuPn0gC8Jr6X_Hq6X3fHE7Ct85kdPf8qYNy6N-BXX3k.png?access_token=sncl9h-awrjyczeru-6f088d7bbd6ab6f7feba106502b326f7801b0d49

2. Select the 945 XML file that should be processed and click Open.

GIMJCpypmPtthfpvnMXoJRmwhMw_iKQKw7I2Zyk1w3mV7EodiYRby3uZqRuWsuUN2rEif9P74YghHYw8R5nYI05IaCtqHnSgdM5A.png?access_token=sncl9f-tfuvcrvaac-2a244a4e66f491f7ec4e3922301848aa634b78b7

3. Select the directory and click OK.

1_8UuX-Hhokk0p1Ra0nyDBTaPDIuDn-wVEcTeUn7MQ3e5qKCCfqTVuml6UpKT3MRmmS4JAraFw9WxDXeBwOT8oEmkZ3y2LsOsqBs.png?access_token=sncl9f-qqxdmplagc-935b8630dd166bf17f7ee0834b2cc271c9f3b613

4. Click the Retrieve button to process the transaction. A message should appear in the Transaction Log grid that the transaction was processed successfully.

dpXZ4zYoEeCy55o7qrqaD6qtC_4vQokGUOsWk-DSD-qT1FTsp_ekc4IT-ex4KdNphSmcVB33KNqC8RtEoGF-hKGDTSHIVtic4x-g.png?access_token=sncl9j-tlwyenderj-682216fe7a972c5c57c2711238f64059745a138b

Note: Processing errors are usually caused by missing mappings on the Data Cross Reference screen or missing serial/lot numbers in Dynamics GP. Ensure that the packing information in the 945 XML file, such as serial/lot numbers, exists in GP before processing the 945 transaction.

B5W7I3PwBJHIOzWLBQCVATFnDBKH_eCibe7euiurTgR_akvQHeyp3vj95BnSA_CmWD_qYBzrKGD5nHokkAJd1qkXTeEeRK9ardGg.png?access_token=sncl9h-huyqmysupr-c1d53ea565fcb1d05ee7a2160c957d9514a5ca34

Example

A sample order ORD1010 for the AARONFIT0001 (Aaron Fitz Electrical) customer has a non-tracked item 128 SDRAM, lot-tracked item WIRE-MCD-0001, and serial-tracked item 100XLG. All items have a quantity of 2 and are fully allocated but not yet fulfilled.

vn9td6kABJJfVPBSTgtdTSdQlL8qorabNdmWx8oiuromkajE6479RMix_-_D51t9KWSSh2EJAQMpMor43OtJSI75F_vJ8nwHOsLg.png?access_token=sncl9p-gjnavaoehw-be68390a6a66a166d3e2933d5352bac4bef7be69

The following 945 XML will fulfill and pack order ORD1010:

<?xml version="1.0" encoding="utf-8"?>




000ALLCERT
SQDSHIP000005
2019-06-23
0001
TESTBILL0001
TESTPRO0001


011
2018-07-07


CN
PRO123


SE
SEAL123


SI
EQU123


ST
AMYS KITCHEN INC
AMYS DRIVE THRU RESTAURANT
58 GOLF COURSE DR W
ROHNERT PARK
CA
94928-801
US


WH
PACIFIC COAST WAREHOUSE
3601 Jurupa
ONTARIO
CA
91761
US


M
UPS
UPS
NVAL


PP




ORD1010
ORD1010


1



P
00076543210000020000
12345678900001


CP
BXI
05
175.00000
LB


1



128 SDRAM
2
1
EA
0




WIRE-MCD-0001
2
1
FT
0


LT
LOT B
2




100XLG
2
1
EA
0


CL


SE
5
2





P
00076543210000020001
12345678900002


CP
COL
72
175.00000
LB


2



128 SDRAM
2
1
EA
0




WIRE-MCD-0001
2
1
FT
0


LT
LOT1
2




100XLG
2
1
EA
0


CL


SE
6
2





3
2251



Non-tracked item fulfillments will be updated to show the assigned quantities:

vWZmUxilya5KXNGXZGbYfnO_BA6mZyLVkkygMT3Lm8djji-JuictJ3Jyg4lf_BFnUy0kTeMJvMH_IxH8ZU6iw-Nlj90SOsgMRkEA.png?access_token=sncl9n-khiovxobrj-9b19ff1db0b1efa5fefcd799529dead6ceb81262

Lot-tracked item fulfillments will be updated to show the quantities for the specified lots:

t9w4an5Q8uY0Kg8169gMCRSHLVBwjR4Rn_Q02gFtXKUR5OC7AzjZFt1AhuXYUdENovMZFcJoN-G8q77g0qvoVSSdZfKxjy-3f3Ik.png?access_token=sncl9g-qadbbflwvy-923f5dfca78364e85fc28a2d52400717f2f35d54

Serial-tracked item fulfillments will be updated to show the specified serial items:

0m_gz2rbAPo39hvKTDSffGt0F-UJMEhrdu2OnUOzP6nNvYOMS9G5MOcuQC_p8rNQhOnGWUrKgXi54IKXr1OanQJXcLNCmsX5fbx0.png?access_token=sncl9m-bnlvayudna-8fd61516c838b0cd4fb4e34ed0324cb66b8c0b6b

The order shipment and packages will be created to match what is detailed in the 945:

0bcw-9wYXbUR_j6a9q9DegVAXvYuGx9nGovyhGpPHkJ3EJDd4On7kBMKovXVJN_sjPdAyMX6HJadiGmO8kInTBPQ6MI0NeR13Mh0.png?access_token=sncl9n-dtkspwpefg-c707069459ee3bb31e5375ff3d43df9ef65c1a15


Helpful Unhelpful