Use the Posted A/P Transactions Viewer (AVIQ) to:
View posted transactions by vendor, and optionally display their distributions to General Ledger. If you want to print posted transactions rather than view them on the screen, you can print the A/P Open Item Report (Report RAOI).
(System Audit and Reporting Tools users only) View archived A/P transactions (transactions purged by report APGI).
If you want to look up unposted transactions, click here for the procedure. For an explanation about the difference between posted and unposted transactions, click here.
To look up transactions by vendor, do one or more of the following, and then press Enter to process your request:
In the Vendor box, enter the vendor for which you want to view transactions.
If you know the remit-to vendor rather than the purchasing vendor, click Lookup (F5), and select Remit-To Vendor. Then enter the remit-to vendor for which you want to view transactions.
(Optional) In the Start Date box, enter the first date for which you want to view transactions.
(Optional) In the End Date box, enter the last date for which you want to view transactions.
(Optional) In the Show Paid Invoices box, enter a Y or an N, depending upon whether or not you want to view paid invoices in addition to unpaid ones.
(Optional) In the Invoice # box, enter an invoice number. The system will use this invoice number as the starting point when displaying this vendor's transactions.
(Optional) (A/P Transaction Archive users only— ID#848 is set to Yes). If you want to see archived A/P transactions (transactions purged by report APGI) as well as "live" A/P transactions, click the box next to the field "Include archived transactions" so that a checkmark appears. Note that "APGI" will display in the "Archive Source" column for all archived transactions, so you can distinguish them from live transactions.
To look up a particular invoice number, click Misc and select "View List by Invoice." This displays a list of invoices, in invoice number order, across all vendors. Highlight the desired invoice and press Enter (or F4) to paste that invoice and vendor back into the AVIQ viewer. The grid displays all invoices for that vendor from that point forward.
To look up an invoice by PO number, do one of the following:
Click Lookup on the toolbar and select “PO Number.” Enter the PO Number in full in the PO Number field (Note: if you use Advanced Receiving, include the sequence number), and press Enter to refresh the screen. If you don't know the PO Number, enter an asterisk (*) at the end of the number entered to do a wild card search.
Click Misc and select "View List by PO." This displays a list of invoices, in PO number order, across all vendors. Highlight the desired invoice and press Enter (or F4) to paste that invoice number and vendor back into the AVIQ viewer. The grid then displays all invoices for that vendor from that point forward.\
(Optional) If you want to view General Ledger distributions for a particular voucher, highlight the voucher, click Misc, and select Show Distributions. The distributions display.
Tip: If you use the A/P reconciliation feature, and a check has been reconciled, the reconciliation date is available as a column in the viewer. This allows you to quickly see that a check has cleared.