Product: Sage 100

Article Link: http://help.truecommerce.com/en/articles/7937885-sage-100-exporting-a-warehouse-shipping-advice

A Warehouse Shipping Advice (945) is a transaction sent from your Warehouse or 3PL in response to you sending them a Warehouse Shipping Order (940) and informs you of the Shipping Information regarding any goods they packaged on your behalf.

This document creates Invoicing and Shipment information for you within Sage 100 which can then be imported into Transaction Manager in order to generate the Invoice (810) and Advance Ship Notice (856) data for you without the need to create or pack those manually

Whenever you receive a Warehouse Shipping Advice you'll find it inside the Inbox within Transaction Manager - in order to have it automatically create your Invoice Data Entry and your Shipping Data Entry you'll need to export it out.

Since the Warehouse Shipping Advice export is generating the Invoice/Shipping data by combining information from the Sales Order Entry and the Warehouse Shipping Advice it'll need to be able to match up your Order Number as well as the Item Information within Sage 100 in order to successfully find the original order information.

The received Warehouse Shipping Advice will need to provide the original Order Number from the Sales Order Entry within the transaction in order to find a match during export

This is often referred to as the Depositor Order # within an Warehouse Shipping Advice but can also be referred to as Originating # or Sales Order # based on your Warehouse Partner.

Each item on the Warehouse Shipping Advice will also need to be properly matched against an open and available item on the Sales Order Entry within Sage 100

Your Warehouse Shipping Advice should provide your Sage 100 Item Number directly on the transaction itself - otherwise it will need to be translated. Each Item Code must match exactly as it was ordered

Although not required for most shipments - if your Sales Order Entry has the same Item Codes split up across multiple lines - you will need to provide a Line Number in order to distinguish between the two.

If your Item has Lot/Serial information marked as required within Sage 100 then the Warehouse Shipping Advice will need to provide that information as well to be sent over during the export.

Once a Warehouse Shipping Advice is received from your Warehouse Partner it will show up within the Inbox inside of Transactions section of Transaction Manager.

You can select the transaction within this section and use the Export button to initiate the exporting of the selected transactions which will update the Sales Order Entry and create the Invoice/Shipping information automatically.

Navigate: Transactions → Inbox

Select: Transactions to Export

Select: Export

Any successfully exported Warehouse Shipping Advice will create both an Invoice Data Entry and a Shipping Data Entry with a Invoice No./Shipper No. matching the Document # located in your System Activity → Integration Activity

rev 5/23/2023