Use this transaction to retrieve new purchase orders entered into your system. You can retrieve new purchases by creation date range, supplier, vendor, PO type, and PO number range. This transaction only retrieves Purchase Orders that fit the above criteria and have not been marked as printed. The acknowledgment SQL marks the specified PO 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 purchase orders returned by the query. Each purchase order 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 purchase order to show it has been processed. It marks the PO as printed and updates the print date, edi_processed_flag, and the last update date. It also performs the necessary archive procedures. It updates and archives a single PO at a time.

The inputs define which PO to update.

There is no output generated by this SQL.