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=snx3ou-hzipooigwz-ffa69b8af84c40e1adf9363f9b5579e848dc28fc

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=snx3or-qtdufliwba-0d13ef37cbea7fcdd49b44f212f5b8fad2ee9598

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=snx3ov-jrnvbbgner-61e7f86255fc55908dae833d733bab6cbdf4bc55

8iKuhSQ6JIkUobI5q99rs9L3ncmJJJ0mFAjNS_uGVqa9v09SACj6UJqnZHuPn0gC8Jr6X_Hq6X3fHE7Ct85kdPf8qYNy6N-BXX3k.png?access_token=snx3oo-gypfxbapij-ae66a4ca4b812bd217cfd5c8cc3740e77e01884c

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

GIMJCpypmPtthfpvnMXoJRmwhMw_iKQKw7I2Zyk1w3mV7EodiYRby3uZqRuWsuUN2rEif9P74YghHYw8R5nYI05IaCtqHnSgdM5A.png?access_token=snx3on-odoorrundc-bfe7f0f518866c7aa021297d713b91ce5225cd20

3. Select the directory and click OK.

1_8UuX-Hhokk0p1Ra0nyDBTaPDIuDn-wVEcTeUn7MQ3e5qKCCfqTVuml6UpKT3MRmmS4JAraFw9WxDXeBwOT8oEmkZ3y2LsOsqBs.png?access_token=snx3op-shhvxamzfe-dca274e7f09f7bdd216eeb9e32a7713cc7495a0e

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=snx3on-zmrxzzqhvm-d0e3ea2c7f10ebba31a00e673997dc147c11acf9

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=snx3or-uucacqouat-2f0c832a048b832ac45b7bde8cfae1e0ef4b3923

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=snx3or-ytbbxwafuo-185761aac770b5a3c82d82c112cda01b75038a6c

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=snx3or-zbcwkcteqh-e90c2332501aee57702a0631d42fc1ea842f1c60

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

t9w4an5Q8uY0Kg8169gMCRSHLVBwjR4Rn_Q02gFtXKUR5OC7AzjZFt1AhuXYUdENovMZFcJoN-G8q77g0qvoVSSdZfKxjy-3f3Ik.png?access_token=snx3ou-yrophwuugb-d3f1d1ae556d900ae70ca3c4ec7380815568032e

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

0m_gz2rbAPo39hvKTDSffGt0F-UJMEhrdu2OnUOzP6nNvYOMS9G5MOcuQC_p8rNQhOnGWUrKgXi54IKXr1OanQJXcLNCmsX5fbx0.png?access_token=snx3op-vyfmnqubyj-586ad61b63aa1a63b5287ad9d01d4a887eb365d6

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

0bcw-9wYXbUR_j6a9q9DegVAXvYuGx9nGovyhGpPHkJ3EJDd4On7kBMKovXVJN_sjPdAyMX6HJadiGmO8kInTBPQ6MI0NeR13Mh0.png?access_token=snx3ox-ksuoqqdgrd-f2afa3144a7692b4e7bc81b5588020bed67d3207


Helpful Unhelpful