Displaying Unmatched Invoices in the Reconciliation Queue

To begin the reconciliation process, you display unreleased and unmatched invoices and receipts in the reconciliation queue using Reconciliation Queue (MA60.1). You can also go directly to Invoice Level Match (MA60.2) and Detail Level Match (MA60.3).

With Match Add-On Cost, the total quantities display when you reconcile. For invoices, the invoice number, goods, add-on charge, and quantity display. For receipts, the receipt number, goods, add-on charge, and quantity display.

To display unmatched invoices in the reconciliation queue

  1. Access Reconciliation Queue (MA60.1). Invoices displayed will be listed in due date order; the oldest due date listed first. This lets you work invoices that are due first.
  2. You can display all unmatched invoices for a specified company or a vendor. Use the following guidelines to enter field values:
    Company

    Required. Enter the company number to display unmatched invoices for that company.

    Vendor

    You can enter a vendor number to narrow the display to unmatched invoices for the specified vendor only.

    When the vendor number is left blank, all unmatched invoices for all vendors, purchase orders, and ship-to locations are displayed for the company specified.

  3. Click the Filter button to open the Invoice Filter subform. Use the subform to display unmatched invoices according to the criteria that you enter. The criteria include:

    • Purchase order number

    • Purchase order code

    • Ship-to code

    • Receiver operator

    • PO buyer

    • Invoice

    • Match reference number

    • Invoice operator

    • Invoice approver

    • Range of due dates

    • Error type

    • Exclude invoices with open PO Cost messages

    • Exclude invoices with no receipts

  4. Select an invoice for reconciliation after you have displayed the list of unmatched invoices and receipts.
    If you want to Then
    Match at the invoice level

    Click the IM button to access Invoice Level Match (MA60.2).

    Reconciling at the Invoice Level

    Match at the invoice detail level

    Click the DM button to access Detail Level Match (MA60.3).

    Reconciling at the item detail level

    Match prepaid invoices to receipts at the line level

    Click the P button to access Reconciliation Queue - Prepaids (MA68.1).

    Matching Prepaid Invoices to Receipts

Related Reports and Inquiries

To Use
List unmatched invoices Unmatched Invoice Listing (AP252)
List released (and unreleased) invoices for a vendor group, pay group, or Invoice Matching company Open Payables Report (AP230)
Display all invoice-related transactions at the line level All Transactions for Invoice (MA90.2)
View all receipt or invoice details Match Analysis Details (MA90.3)
Display all receipts that are partially matched and are ready to be archived Ready to Archive Receipts (MA90.4)
View miscellaneous add-on charges for an invoice Misc AOC for an Invoice (MA90.5)
Display all receipt or invoice related transaction details at the summary or header level. Summarization (MA90.6)
Related topics