Generating a Multi-Level Approved Vendor List Report

The Multi-Level Approved Vendor List (AVL) Report includes subassemblies of enterprise parts in the bill of materials (BOM) to the level you choose. You can also choose whether to generate the report by expanding on only EBOM relationships, or on both EBOM and EBOM History relationships. The report is presented in table format.

Before you begin:

Access the bill of materials for the part you want to view. See Part Bill of Materials.

  1. From the page Reports menu or toolbar, click AVL Multi-Level BOM Report.

    The Select Levels to Display form opens.

  2. Type the number of levels you want to appear in the report.

    Or

    Click All Levels to see all parts and subassemblies included in the Bill of Materials.

  3. Click to select the Location.
    1. Enter a name. You can use wildcards.
    2. Click Search.
  4. Select the Relationship:

    Select EBOM and EBOM History to generate the report by expanding on both the EBOM and the EBOM History relationships.

    Select EBOM to generate the report by expanding on the EBOM relationships.

  5. Click Done.

    The Multi-Level AVL Report page opens.

    It contains these columns:

    Column Description
    Level The number in the first column indicates the level of the item. All Level 1 items are top-level; all Level 2 items are subitems of the Level 1 item immediately above it.
    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, C1, or 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 and/or can 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.
    EBOM History An icon is included next to all part names that are connected with the EBOM History relationship. These are shown in the same row shading as the original part. For a given connected part, the revisions connected by the EBOM History relationship appear immediately below the revisions connected by the EBOM relationship.
    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 he 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 Names of manufacturer of MEP.

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

    Status Indicates whether the location has been approved to allocate the part in support of production: required, authorized, or not authorized.
    Preference Indicates whether the location is preferred or not preferred.

  6. You can use the filter in the upper right of the page to view the report in any of the following formats: Stored Format; Expanded Format; Delimited Roll-up Format; Range Roll-up Format. For details, see About BOM Formats.