Product Cross Reference Master List Report overview

Product > Reports > IC Reports > Cross Reference Master List Report

Function acronym: ICREC

Use this report to print all information from Product Extended Product Cross Reference Setup records.

The cross-reference file is an open-ended file of products that cross-reference all interchangeable products to the products in your inventory. The cross-reference file is useful to sales representatives during order entry.

The cross-reference master list is organized similarly to Product Availability Inquiry-Xref.

Ten cross-reference types are available in Product Extended Product Cross Reference Setup. You can print all types or one type. You can also use the report ranges and option to determine which information to include on the report. This table shows you which cross-reference types print, depending on the cross-reference method that you use.
Method Example Type
Product by reference This method generally results in one product being found. The reference you enter in the Product range should be a non-inventory product that crosses to a stocked inventory product.

For example, a customer may request Brand A spark plugs that you do not carry but could be interchanged with Brand B spark plugs contained in your inventory. A legend at the bottom of the report lists the various types represented as: b-Barcode; c-Customer product; i-Interchange; t-Auto pricing.

Bar Code

Customer Product

Ship To Product

Interchange

Auto Pricing

References to a product You must provide a product contained in your inventory and all cross reference type numbers that reference to it. This method is the exact opposite of product by reference. Bar Code

Customer Product

Ship To Product

Interchange

Auto Pricing

Alternates to a product After specifying a product, you can choose to display all alternates for this product or one specific type at a time.

For example, a customer may require a 15 amp electric receptacle that is currently out of stock. You can display all substitutes for that receptacle.

Options

Substitutes

Superseded

Upgrades

Alternate Vendors

Where used as alternate This method is the opposite of alternates to a product. Specify an alternate product to find where the product is used. If you specify Brand X spark plug, it may be used as a substitute for a Brand Y spark plug or a supersede for an old Brand X part number. Options

Substitutes

Superseded

Upgrades

Note: If you are searching using the Product by reference method, then specify valid stock products in the Product range. If you are searching using References by product and specify valid stock products in the Product range, then No Records Found is displayed. References by product require that you specify non-inventory products that are cross-referenced to stocked products. Alternates require that you specify your stock product, and Where Used requires that you specify an alternate product.