Accounts Payable - Purchase Order Query

Pgm: APPOQRY – Purchase Order Query; standard Treeview path: Accounts Payable > Queries > Purchase Orders

The Purchase Order Query screen is used to view outstanding purchase orders and their associated PO, invoice, and payment details.

Selection Criteria

This section’s fields are used to filter the list of purchase orders in the Purchase Order Details section.

Company

Enter/select a company code.

Vendor

Enter/select a vendor code.

PO Number

Enter/select a purchase order number.

Show Closed POs

If checked, closed purchase orders will be displayed.

Query Data

Press this button to run the query. If one of the parameters is changed, click this button again to refresh the list.

Purchase Order Details

This section lists the details of the purchase orders filtered via the Selection Criteria section.

PO Detail

Press this button to review details for the selected purchase order.

Invoices

Press this button to review invoices for the selected purchase order.

Payments

Press this button to review payments for the selected purchase order.

NOTE The Paid Amount column brings forward the ‘Invoice Paid’ column value found in the Payments pop-up window. The Outstanding PO Amount column is calculated as the PO amount minus the paid amount. This is to ensure the outstanding PO amount is represented correctly in cases where there is a difference during voucher entry, with the invoice amount being not entirely allocated to the PO receipts details. Also, partial payments on the invoices need to be accounted for when calculating outstanding PO amount. Users should be aware that the Outstanding PO Amount column may have negative values when the paid amount is in excess of the PO amount.