Reconciling vendor statements

Use this procedure to compare imported vendor statements against existing values to determine discrepancies.

  1. Select Vendors and click Reconcile Statements.

    A table of incoming vendor statements is displayed. Statements that are sent electronically from the vendor are imported into the table using Infor Spreadsheet Designer (ISD). Incoming vendor statement rows are automatically displayed when you use ISD to create a record.

  2. Open a statement record.

    The fields with data from vendor statements that are in existing invoices are grouped in the Matched On column.

    If the record in the incoming statement detail table is found in an invoice in the system, an alert is displayed on the Invoice Exists column:

    • Yes with a green alert. Data from a single invoice is found. Click the link of the invoice number to view the invoice.
    • Yes with a yellow alert. Data from multiple invoices is found. Right-click and select View Multiple Invoices.
    • No with a red alert. No invoice data is found.