Use this transaction to retrieve new advance ship notices. You can retrieve new advance shipment notices by Customer Name, Picking Batch Number, and Pick Slip number range. This transaction only retrieves ship notices that fit the above criteria and have not been marked as printed. The acknowledgment SQL marks the specified shipment notice as printed so that the functional query will not retrieve it a second time.

The inputs are used to limit what Purchase Orders you want to retrieve. These SQL inputs are exposed as service inputs.

The output contains all advance shipment notices returned by the query. Each shipment notice consists of 1 header with 1 to N lines and each line contains 1 to N shipment records. The result looks like the following:

A header consists of the following fields. The content of most fields can be determined by their name. Where necessary, a description is provided.

Line Item details consist of the following fields:

Shipment details consist of the following fields:

Updates the specified pick slip number to show it has been processed. Marks the Sales Order as Send and updates the Ship Notice Sent flag to Y. Updates the Ship Notice Send Date and the last update date.

The inputs define which sales order to update.

There is no output generated by this SQL.

Sales Orders that have been picked up and not shipped are retrieved.