Product Extended Product Cross Reference Setup - Customer overview

Product > Setup > Extended Product Cross Reference

Use this function to create and maintain records that cross reference customer product numbers with products in your inventory.

If you set up these records, customers can place orders using their product numbers. When the customer product number is specified in Sales Order Entry, it is interchanged with your product.

The quantity and unit values on cross-reference records also update the corresponding fields in Sales Order Entry. For example, when a customer product is specified in Sales Order Entry, the quantity value from the cross-reference record updates the Quantity field on the order. You can override this value.

Note:  When specifying the quantity before the product in Sales Order Entry, the quantity from the cross-reference record does not update the order. If you specify a quantity of 1 on the order the quantity from the cross-reference record updates the order.

You can also specify additional customer product information, such as the bin location and receiving instructions, on the cross-reference record. This information prints on sales order invoices, acknowledgments, and pick tickets. For example, if you specify the customer’s bin location on the record, both the customer’s product number and bin location print on the packing list. The customer receiving the shipment knows where the product should be stored.

Note:  Infor recommends that you print order acknowledgments, pick tickets, and invoices with your product number and the customer product number.

You can cross-reference an unlimited number of customer products with one of your products.

Example

You create a cross-reference record for Customer 101 with these values:

  • Customer Product = 1014
  • Your Product = X445 - Blk Friction Tape

You also have Product Setup and Product Warehouse Product Setup records for 1014 - Voltage Tester.

In Sales Order Entry, Customer 101 orders 1014. Because of the cross-reference record, they receive X445 - Blk Friction Tape. Assuming that a similar cross-reference record was not created for any other customer, all other customers that order product 1014 receive the 1014 - Voltage Tester.