Running the Component Where Used Inquiry

The Component Where Used Inquiry enables you to view where components are used in assembly items, including parent assembly and sub-assembly items.

For example, item#24567 (a table leg) is a component in items that you assemble. Run the Component Where Used Inquiry to learn where that component is used:

• item#44555, small square table, requires 4 table legs per assembly

• item#55666, medium console table, requires 3 table legs per assembly

• item#66777, large rectangle table, requires 6 table legs per assembly

Data is also returned for sub-assembly component requirements:

• item#77888, 3-piece table set, includes one small square table, one medium console table, and one large rectangle table.

• To produce one of item #77888 requires 13 table legs per assembly.

To run the Component Where Used Inquiry:

1. Go to Transactions > Manufacturing > Component Where Used Inquiry.

2. Enter criteria in the following fields to filter the results returned:

   1. Select a Component that is required for an assembly item or sub-assembly.

      Components represent level zero in the structure.

   2. If you use the Multi-Location Inventory feature, select a Location.

   3. Check the Single Level Only box to limit the display to only one level below the component.

      Clear this box to display all levels for the assembly.

   4. Enter an active Date for revision control and obsolete dating.

      This represents the date an assembly must be active to be included in the results list.

      If specified on the item record, assembly active dates start on the Effective Date and end on the Obsolete Date,

      For example, an assembly item Effective Date is January 1, 2017 and its Obsolete Date is December 31, 2019.

      • If you enter an active date of January 1, 2016, the assembly item does not appear in the results.

      • If you enter an active date of January 1, 2018, the assembly item appears in the results.

      Note:

      If a parent assembly item is not active for the specified date, then child item does not appear in the list.

3. Based on the criteria selected, you could see the following fields:

   • Assembly – The name of the assembly item that uses the component selected in the header.

   • Level – The level in the Bill of Materials (BOM) structure where the component resides.

     For example, a level 1 item is a sub-member of the parent (selected) component item. A level 2 item is a sub-member of the level 1 item.

   • Quantity per Assembly – The amount of the component required to build the assembly.

   • On Hand / Available / Back Ordered / On Order – Quantities are displayed for the selected location.

   • Units – The units for the component.

   • Effective Date – The date the assembly becomes effective.

   • Obsolete Date – The date the assembly is no longer effective.

The inquiry in the following example is run to determine where the Table Leg item is used as a component.

The following is selected in the inquiry header:

• Component: Table Leg

• Single-Level only: No

Item	Level	Qty Required per Assembly	Qty Required per Top-Level Assembly
Table: European	1	4	4
European Table Set Box	2	1	4
Table: American	1	6	6
American Table Set Box	2	1	6
Patio Side Table	1	4	4
Patio Table Pair Set	2	2	8
Patio Table Box Set	3	1	8

The following is the same inquiry, with Single-Level only set to Yes.

Item	Level	Qty Required per Assembly	Qty Required per Top-Level Assembly
Table: European	1	4	4
Table: American	1	6	6
Patio Side Table	1	4	4

Related Topics

• Assembly Items
• Enabling Assembly Items
• Assembly Item Records
• Assemblies on Purchase Transactions, Web Sites, and Work Orders
• Matrix Assemblies
• Phantom Assemblies
• Assemblies and Units of Measure
• Building Assembly Items
• Unbuild Assembly Items
• Marking Work Orders Built
• Printing an Item Bill of Materials
• Bill of Materials Inquiry
• Costed Bill of Materials
• Printing Assembly Item Materials on Transactions
• Printing Assembly Labels

General Notices