Performing Auto Matching

This procedure describes the method for setting up and submitting an auto match process.

With Match Add-On Cost, you can include the total add-on charges, along with the total goods amount, when performing matching. You must have set up the handling code with the Cost Component Option set to Yes so that the application attempts to match invoices assigned the handling code.

To perform an auto match

Access Auto Matching (MA126).
Enter or select job parameters. Use the following guidelines to enter field values:
Company

Select the company number for which you want to match invoices.

Company Group

If you select company group, leave the Company field blank.

You can type or select a company group. A company group represent one or more companies.

Match Table Rule

Select a match rule group for the matching attempt. You can select the first, second, or third match rule group.

Rule Group Override

Decide whether to override the rule group assigned at the company or vendor level when attempting to match the invoices.

Vendor

Type or select a vendor number to match invoices for one vendor.

To match invoices for a range of vendors, select or enter a beginning vendor number and an ending vendor number.

Invoices to Process

Select whether to include or exclude prepay invoices, or include prepay invoices only. MA126 only allows 1-1 match for prepaid invoices.

Match Report Options
Decide the type of report to receive on invoices that were matched using the auto match process:
- Statistics only
- Print Unmatched Report
- Print Matched Report
- Print Unmatched and Matched
Date Type

Select the date for auto matching to use (invoice date or due date).

Run Date

Enter the run date for auto matching. If you leave this field blank, the system date defaults.

Note: If you select No in the Run Date and System Date fields, the program may take longer to process.

System Date

If you did not enter a run date, select Yes in this field so that the system date defaults for running the report.

If the run date is blank and the system date is set to No, all matches are attempted for the vendor.

Note: If you select No in the Run Date and System Date fields, the program may take longer to process.

Number of Days Before Run Date

This field is the number of days in the past for the run date to be included in the match. For example, if today is January 1 and the number of days before is entered as 30, the match includes invoices dated through December 1.

Number of Days After Run Date

This field is the number of days in the future from the run date to be included in the match. For example, if the number of days before is entered as January 1 and you enter 30 days here, the match includes invoices dated through February 1.
Access the Options tab to select report options. Use the following guidelines to enter field values:

Report Sequence Option(s)

Select the order in which the information is listed on the report.

On Accounts Payable Issues Report, report sequence can be sorted either by Vendor or Operator. On Procurement Issues Report and Match Invoices Report, report sequence can be sorted either by Vendor or Buyer.

Vendor Sequence field(s)

Select whether the report is sorted by Vendor Number or Vendor name.
Select the Add form action.
Click the Submit button to submit the job. The program produces the reports specified in the report options field.

Related Reports and Inquiries


To	Use
List match status of existing invoices that were matched online or in an auto match	Match Analysis Report (AP251)
List open receipts for a company, or for a company and a vendor	Unmatched Receipt Listing (MA231)
Compare the invoice unit cost to purchase order cost (or standard cost) and report the variances	Cost Variance Analysis (MA278)

Report sample: Auto Matching, Job Submission Parameters

Report sample: Auto Matching, Program Statistics

Report sample: Auto Matching, Accounts Payable Issues - Unmatched Invoices Report