Invoice Matching Report

The Invoice Matching Report reports matched amounts for approved and unapproved buys as well as discrepant additions, and approved but not cleared buy items. The report also shows delinquent activity more than 30 days old that has not been matched. Comments that were keyed for the Estimator's Discrepancy Report that was generated from an unapproved match will also print in the Matched/Unapproved section of the report.

See also Managing Differences and Matching Statuses for detail matching information and discrepancies.

To request the report:

  1. Select Reports | Invoice Matching Report.

Invoice Matching Report Prompt

  1. Key a Client code, Client Group code or leave both fields blank and click the All Clients check box to display a check.

  2. Key a Product code, Product Group or leave both fields blank and click the All Products check box.

  3. Key a Media code or leave blank and click the All Media check box.

  4. Key a Vendor code, Vendor Group code or leave blank and click the All Vendors check box. When the requested Vendor Code prints, its description will also print next to it.

  5. To limit the report, key an Edition and/or Zone.

  6. Key a Start Date and an End Date for the activity to be included on the report.

  7. Select one or more Report Formats by clicking the check box next to the format.

  1. Once you have selected a report format, select the sort order Client/Vendor or Vendor/Client from the Sort Paying Discrepancy drop down list.

  2. To route this report to a user by having the userID print on the top of each page, key the user ID. Or, leave the Print User ID in Heading blank and only click All User IDs to report, on its own page, the name of each User who keyed and saved entries in clearances. Each user page will report that user's entries.

  3. Click Use UserID in selection criteria and select either Match UserID against Invoice, or the alternative, Match UserID against Buy.

  1. Select the types of discrepancies to include on the report by clicking one or more of the Type of Discrepancies check boxes. Refer to the Report Fields to see detailed report fields.

  1. Click the Exclude CD Adjustments check box to exclude discrepant buys that are only cash discount adjustments.

  2. To limit the report to buys with a cash discount, click the Cash Discount Buys Only check box.

  3. Complete the Report Formatting Options and click <Submit> for the report request to be processed..