EDI Part Number Matching

When the system receives an 810, 855, or 856, it tries to find an exact match for each line item listed on the invoice, acknowledgement, or ASN.

Use the EDI Product Matching Priorities control maintenance record to define the hierarchy in which you want the system to match product IDs for incoming EDI documents: 810, 855, and 856. Settings at the EDI Trading Partner level supercede this control maintenance record.

By default, the system uses the standard Eclipse product matching types. The system makes comparisons of inbound product information in the following order to try to find the matching product in your system:

UPC to the Primary UPC and Secondary UPC field of the Product file.
Vendor part/catalog# to the Vendor Part Number Cross Reference table.
Vendor part/catalog# to User Defined product IDs.
Vendor part/catalog# to the Catalog ID field of the Product file.
Vendor part/catalog# to the Key Words or Description field of the Product file.
Buyer PN to the internal Eclipse product number.

You can rearrange these priorities based on your warehouse needs.

To set EDI part number matching:

From the System > System Files menu, select Control Maintenance.
In the Filter Description field, enter EDI Product and select EDI Product Matching Priorities.

The system displays the available Product Matching Types in their current priority order.

Use the Enabled column check boxes to select which priorities you want the system to use for matching EDI documents.
Use the Move Up and Move Down buttons to rearrange the options in the order that you watch the system to match.
To include a cost variance match, use the Ledger Detail ID and Unit Cost Variance area to enter the values you want to use: None, Percentage, or Dollars. For example, if you want the system to ignore a dollar amount within a two cent difference, select Dollar Amount and enter .02.
To restore the original system values, click Default Values.
Click Save.

If a match is not found after the system runs through this query, the item is a NO MATCH.

Note: Prior to Release 9.0.3, to have the system check the internal Eclipse product number first rather than last, you set the Match on Eclipse Internal PN First field on the EDI Group Profile Global Info Table screen to Y. As of Release 9.0.3, use the EDI Product Matching Priorities control maintenance record to move the Eclipse Internal Part Number option to the top of the list.