The Purchase Order Query is used to review purchase orders and their associated invoices and payments. This query is extremely useful for AP staff that are reviewing purchase orders. This article shows how it can be used for that purpose.
- Select Purchase Order Query from the Queries sub-menu of Accounts Payable:
- Verify the Company and indicate if Closed PO's should also be shown then press the [Query Data] button:
- A summary of each purchase order by vendor is displayed. Use the [Query by Example] button to find specific purchase orders:
- Select a record, and the [Invoices] and [Payments] buttons will become active if there are any invoices or checks. The [PO Detail] button is always available:
- The [PO Details] button opens a window that displays each individual detail line of the Purchase Order:
- The [Invoices] button displays all invoices associated with the PO. Currently, the Outstanding Amount field will show asterisks if there is a partial payment against the invoice:
- After selecting one of the invoices above, [Payment Details] shows all payments against the invoice:
- The [Drill Down] button from the Invoices screen in step 7, shows how the invoice was allocated to the Purchase Order:
- Going back to the original Purchase Order Query screen from step 4, the [Payments] button opens a window showing all payments against a selected Purchase Order:
- The [Invoice Allocation] button, from the screenshot above, displays which invoices and were paid: