To run a P/O Reconciliation Report:Run a P/O Reconciliation Report to list all of the details of both vendors' invoices and the associated purchase orders, including line item data for payables. In addition, this report can provide a way to verify whether there are discrepancies between the cost of a product at the time a P/O was entered, and the cost of the product on the landing date. You can also use this report for purchasing functions and can be accessed from the purchasing menu. For more information, see Purchasing Reports Overview.
To run a P/O Reconciliation Report:
From the A/P > Reports menu, select P/O Reconciliation to display the P/O Reconciliation Report screen.
In the Br/Tr/All field, enter the branch or branches for which you want to run the report. Enter All to run the report for all branches.
In the Start Date field, enter the first date of the period to include in this report. By default, the system populates this field with the current date, but you can change it. Press Enter to select the current date or press F10 to display a calendar from which you can select a new date.
In the As of Date field, enter the date that determines which invoices will be selected for this report. Only invoices dated up to and including the as of date will be included.
By default, the system populates this field with the current date, but you can change it. Press Enter to select the current date or press F10 to display a calendar from which you can select a new date.
In the Vendor field, do one of the following to determine which vendor invoices to include in the report:
To include all vendor invoices, leave this field blank.
To include a single vendor's invoices, enter the vendor's name.
In the P/O # field, do one of the following to determine which purchase orders to include in the report:
To include all purchase orders, leave this field blank.
To include a single purchase order, enter that purchase order number in this field.
In the Unapproved Only (Y/N) field, enter one of the following to determine whether to include in the report only those invoices that are unapproved:
Y – Includes only unapproved invoices.
N – Includes all invoices, whether or not they have been approved.
Note: You determine whether or not invoices are approved using the A/P Preview Queue. For more information, see Approving Payable Invoices.
Use the Slct key to display the Additional Selection Input screen, where you can enter additional criteria, for example, to select orders associated with a particular batch number.
See Also: