Generating an Approved Vendor List Report

The Approved Vendor List (AVL) report gives a list of vendors for manufacturer equivalent parts. All manufacturer equivalent parts (MEPs) for the enterprise parts in the bill of materials (BOM) are listed. The AVL report is essentially the BOM report, but included for each enterprise part in the BOM are the equivalents parts and the vendors who can supply them. You can generate either single or multiple-level AVL reports using the links in the BOM Actions menu.

On premises only: These reports are configurable by a Business Administrator in addition to, or optionally in place of, the existing BOM and Multi-Level BOM reports. The columns are not sortable.

Before you begin:

Access the EBOM page for the part you want to view. See Part Bill of Materials.

  1. From the page Reports menu or toolbar, click AVL Report.

    The AVL Report page opens, expanding on EBOM relationships from the current selected part level. It contains these columns:

    Column Description
    Ref Des The Reference Designator ID is used on Printed Circuit Cards to indicate the location an electronic component is to be inserted. Reference Designators are usually values like R1, R2, R7, or C1, C5 (R for resistor and C for capacitor).

    The BOM can show Reference Designators as a single value (for example, R3), a comma-separated sequence of values (for example, R2, R3, R4), a range of values (for example, R3-R6), or a mix of all three types.

    The Reference Designator value is shown as it was entered when the BOM was created. You can use the format of Reference Designators to collapse or expand the BOM display. For details, see Part Bill of Materials.

    Component Location Similar to Reference Designator, but is used to give additional location information. It can also be used by industries other than electronics. For example, it can be used to indicate which motor is failing all the time, the one by the window or the one by the furnace.
    Name Name of the part included in the BOM. Click any Name in this column to view the part.
    Rev Part revision number or code.
    Type Part type or subtype.
    Description Details about the part.
    State The current state of the part in its lifecycle.
    Qty The quantity of the selected part included in the BOM.
    U of M (Unit of Measure) LB (pound), IN (inch), GA (gallon), FT (feet), EA (each).
    Usage Standard, Reference, Per Sales Order, or As Required.
    Equivalent Names of MEPs for the enterprise part.
    Manufacturer The organization title of the MEP manufacturer.

    **Location Details: If the part has connected Manufacturer Equivalent Parts, then the location details are shown, otherwise the following columns are blank.

    Location The location that has allocation responsibility for the MEP. The company title, plant title, or location name is shown.
    Status Indicates whether the location has been approved to allocate the part in support of production: required, authorized, or not authorized.
    Preference Indicates if the location is preferred or not preferred.
    Edit Click to edit the status or preferences for each location. For details, see Manufacturer Equivalent Part Management User's Guide: Editing Location Status and Preference.

  2. You can filter the list using the Company/Location and Ref Des filters at the top of the page.
    1. To filter by location, click and select a location. By default, the filter value is Corporate. When the location is Corporate, the location-specific columns are blank and the Edit Location icon is not displayed. For details, see Predefined Queries.
    2. The Reference Designator value is displayed as it was entered when the BOM was created. You can use the format of Reference Designators to collapse or expand the BOM display. For details, see Part Bill of Materials.
    3. Click Filter.

      The AVL report shows filtered data specific to the location and format chosen.

  3. Optional: To create an application part, click Create New Application Part. See Creating an Application Part.