PO Query

The PO Query program is a powerfull SQL query and reporting tool.  It allows you to run standard and customized queries against your purcahsing and other related data, and to quickly output the information using several different export and reporting options. 

The PO Query program also allows you to drill down into the details for the purchase orders and vendors displayed in the program, and to perform some PO processing tasks (based on system security).

The PO Query program allows you to quickly produce and run queries against your Purchase Order, Vendor and other related data.   Standard Query reports are provided in the Query Library, and additional queries can be created and saved from the Query program (again based on security).

The PO Query program is called from the Purchasing Lookups Menu, and it uses some standard components that are shared by other  Query, Lookup and processing programs in the system.   This section of the document describes features and options that are specific to the PO Query program. 

The following links can be used to access more information about the standard SQL tools and objects used by the PO Query program.

SQL Report Selector

Sql Edit Panel


PO Header Detail

PO Lines

Vendor Detail

Select PO to Invoice Vendor Shipment

View Vendor Shipment Comment