PO to Invoice Reconciliation Report

Prev Next

The PO to Invoice Reconciliation Report shows all the purchased orders and invoices and the items that were received. This report also notes the POs that hasn't been received yet as well as the cost variance for each item listed. Viewing this can help a manager determine what the impact those cost changes will have on their business.


Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

  1. Open the Reports app. 
  2. Navigate to My Reports
  3. Enter all or part of the report name in the search bar.
  4. The Results tab will open with the list of search results.
  5. From beneath the report name, click Run to run the report with the selected report view.
    -OR-
    Click Customize to adjust the report parameters and run the report. 



Report Parameters

Field/Column

Description

Filter By

A listing of all the location categories.

Filter

A listing of all the locations in a selected category.

Vendor

A listing of all vendors associated with the selected locations.

Item

A listing of all items associated with the selected vendors.

Start Date

The beginning date for the report.

End Date

The end date for the report.

Item Categories

These categories can help filter through types of items.

Run Button

Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action.


Report Column

Field/Column

Description

Invoice Number

The invoice number of the reconciliation report.

Item

The purchased items on the report.

Qty Ordered

The amount of the item ordered.

Qty Received

The amount of the item received.

Qty Variance

The difference between the quantity ordered and the quantity received.

U of M Ordered

The ordered item's unit of measure.

U of M Received

The received item's unit of measure.

Price Ordered

The cost of the quantity ordered.

Price Received

The cost of the quantity received.

Price Variance

The difference between the price ordered and the price received.


Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.