Find Every Assembly That Uses a Component in NetSuite with Component Where Used Inquiry

The quick answer

Go to Transactions > Manufacturing > Component Where Used Inquiry, choose a Subsidiary, then pick the Component. NetSuite lists every assembly, bill of materials and BOM revision that uses it. Level 1 rows list the component directly. Level 2 and deeper rows are assemblies that use one of those assemblies. Quantity per Assembly is the BOM quantity divided by Component Yield.

The screenshots show sample data. Person and operating-company names are fictional. Use your own records and values when following the steps.

Before you start

You need Advanced Bill of Materials and Assembly Items enabled, BOMs with revisions that list the component, and permission to view the inquiry. The inquiry reads BOM revisions, so an assembly only appears if one of its revisions lists the component and is effective on the Date you set. Date defaults to today. This example uses 10/14/2026.

01. Open the inquiry

From the Transactions menu, point to Manufacturing and choose Component Where Used Inquiry. The page has Subsidiary, Component and Location filters, the Single Level Only and Include inactive BOMs and revisions check boxes, and Date. The grid stays empty until you set a subsidiary and a component.

The empty Component Where Used Inquiry page shows the filters and the fifteen result columns. — Before any filter is set, the grid reads No records to show.

02. Choose the subsidiary and component

Select Alder Creek US in Subsidiary. It is required. Then select HW-440 in Component and leave Location at - All -. The grid fills on its own, with no run button. It lists three rows. CD-100 uses the hinge on Door Rev B at Level 1, with a BOM quantity of 2 at 95.0% Component Yield, so Quantity per Assembly is 2.10526. TC-300 uses it on Chest Rev A at Level 1. SC-200 shows at Level 2, indented under CD-100, because its BOM uses the CD-100 door rather than the hinge itself.

On Hand, Available, Back Ordered and On Order describe the assembly in each row, not the component. Here CD-100 has 120 on hand and 96 available. Stock follows the subsidiary you chose, so stock in a location that belongs to another subsidiary does not count. Check the assembly's Locations subtab if a row reads zero.

The inquiry lists CD-100 on Door Rev B, SC-200 on Cabinet Rev 1 at Level 2, and TC-300 on Chest Rev A for component HW-440 in Alder Creek US. — HW-440 turns up in three assemblies, one of them at Level 2.

03. Show direct users only

Check Single Level Only. The grid refreshes and SC-200 disappears, leaving CD-100 and TC-300, the assemblies whose own revisions list HW-440. Clear the box to bring the Level 2 row back.

With Single Level Only checked, the grid lists CD-100 and TC-300 only. — SC-200 drops out because it reaches the hinge only through CD-100.

04. Include inactive revisions

Check Include inactive BOMs and revisions. The list widens to inactive BOMs and revisions, which the default list hides. In this example a fourth row appears, TC-300 on Chest Rev P with a BOM quantity of 6. That revision is marked inactive. Treat it as history or a draft rather than the revision TC-300 would build from. The inquiry does not label which rows are inactive, so check the revision record if you are not sure.

With Include inactive BOMs and revisions checked, a fourth row lists TC-300 on Chest Rev P. — The inactive Chest Rev P appears below Chest Rev A.

05. Confirm a row on its revision

Click Door Rev B in the CD-100 row. The Bill of Materials Revision record opens. On Components, HW-440 Brass Hinge 40mm shows Component Yield 95.0%, BOM Quantity 2 and Quantity 2.10526, the same figures the inquiry showed.

The Door Rev B record lists HW-440 Brass Hinge 40mm with Component Yield 95.0%, BOM Quantity 2 and Quantity 2.10526. — The revision shows the same yield and quantities as the inquiry row.

Check the result

Every assembly that lists HW-440 on an effective revision appears, including the Level 2 row.
Single Level Only removes the Level 2 row and nothing else.
The inactive revision appears only when its check box is on.
The revision record shows the same yield and quantities as the inquiry row.

Common questions

What do Level 1 and Level 2 mean?

Level 1 is an assembly whose own BOM revision lists the component. Level 2 is an assembly whose revision lists a Level 1 assembly, so it uses the component indirectly. Deeper levels follow the same pattern.

Why is Quantity per Assembly larger than BoM Quantity per Assembly?

Quantity per Assembly is the BOM quantity divided by Component Yield. At 95% yield, a BOM quantity of 2 becomes 2.10526. At 100% yield the two match.

Why do On Hand and Available show zero for an assembly that has stock?

Those columns count stock in locations that belong to the subsidiary you chose. If the stock sits in a location under another subsidiary, the inquiry reads zero. Check the assembly's Locations subtab and the location's subsidiary.

Why is an assembly I expected missing?

The inquiry only lists revisions that are effective on the Date field and, by default, active. Check the revision's effective dates and its Inactive box, and try Include inactive BOMs and revisions.

Does the inquiry change any records?

No. It is a read-only inquiry. The links open the assembly, BOM and revision records, where you can edit them.