Secondary trade invoice matching

A second layer of automatic invoice matching can be enabled in Vendor Invoice Center Entry to reduce the number of unmatched invoices that require manual review. This applies to the matching logic that is run when data is received in the Inbound SupplierInvoice BOD or in the EDI810i flat file document.

Using the standard matching logic, automatic matching of vendor invoices to PO receipts in Vendor Invoice Center Entry is based on a three-way match of the product number, quantity received, and cost. For distributors who process a large number of invoices, this can result in many unmatched invoices when there is not a match on part number. If there is no cross reference record set up for the vendor's part number in Product Extended Product Cross Reference Setup, Product UPC Number Setup, or a Vendor Number defined for the product in Product Warehouse Product Setup, an exception is created in Vendor Invoice Center Entry that must be corrected manually.

Secondary trade invoice matching adds an additional, optional level to the matching hierarchy. When this feature is activated, the primary, three-way matching logic is applied first. Then a second matching process is run to match invoices on quantity received and cost only.

To activate this feature at the company level, select Perform Secondary PO Line Matching on Quantity and Cost (EDI 810/ION) in SA Administrator Options-Vendors-Invoice Defaults.

To activate for select vendors only, select Vendor in the Secondary PO Line Matching Level drop-down in the new EDI/ION Processing section in Vendor Setup-eCommerce. Then select the Perform Secondary PO Line Matching on Quantity and Cost (EDI 810/ION) option.