The quick answer
Go to Transactions > Manufacturing > Bill of Materials Inquiry, choose a Subsidiary and an Assembly, and NetSuite fills in the Bill of Materials, Bill of Materials Revision and Effective Date and lists every level of that revision. Set Location to read On Hand and Available for one location. A component with no stock there stays in the list with zeros. The inquiry is read-only.
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 the Assembly Items and Advanced Bill of Materials features, Multi-Location Inventory if you want stock by location, and a role that can open the inquiry. In a OneWorld account you also choose a subsidiary. The assembly needs to be built, not purchased, at the location, with an active BOM that applies to the subsidiary and a revision that covers the date you are looking at. The revision choices in this guide assume the assembly uses revision control. This example is an assembly called TBL-420 Trestle Dining Table, built at Reno Plant, with a second warehouse called Boise Warehouse. Component Yield is 100 on every line, so the quantity columns match where the yield doesn't change them.
01. Check how the revisions are dated
Open the assembly record and click the Manufacturing subtab. In the Bills of Materials sublist, Trestle Table BOM is the master default. Current Revision is Trestle Table Rev B, Effective Start Date is 08/03/2026, and Effective End Date is blank, so the revision has no end.
Click Trestle Table BOM. On the Bill of Materials record, the Revisions subtab lists Trestle Table Rev A, which ran from 02/02/2026 to 08/02/2026, and Trestle Table Rev B, which starts on 08/03/2026. Revision date ranges can't overlap, so at most one revision applies on a date, and a date outside every range has no active revision. A revision is a complete list of components, so Rev B repeats what Rev A carried instead of describing a change to it.
02. Open the inquiry and choose the assembly
From the Transactions menu, point to Manufacturing and choose Bill of Materials Inquiry. The grid reads No records to show until you pick an assembly. Select Tamarack US in Subsidiary and TBL-420 Trestle Dining Table in Assembly, and leave Location at - All - with Top Level Only cleared. Bill of Materials usually fills in from the assembly's default BOM, so check each field and pick the BOM yourself if it stays blank. Here it fills with Trestle Table BOM, Bill of Materials Revision with Trestle Table Rev B, and Effective Date with 08/03/2026. BoM Display Control stays on By Revision, so you choose the revision yourself and the date follows it. The grid refreshes in place, with no run button.
Rev B has ten rows. HW-310 Hardware Kit, FIN-050 Finish Pack, LEG-220 Trestle Leg Assembly and TOP-210 Tabletop Assembly are at Level 1. A component that is itself an assembly appears as a row, and its own components follow, indented. Under the leg assembly are BRD-310 Oak Board, BRK-120 Bracket Assembly and FLT-030 Felt Pad at Level 2, with BLT-080 Carriage Bolt at Level 3 under the bracket. Under the tabletop are another BRD-310 Oak Board line and STN-045 Wood Stain, both at Level 2.
BoM Quantity per Assembly is the quantity on the revision line for one unit of its parent, and Quantity per Assembly is that quantity after Component Yield. Quantity per Top Level Assembly multiplies it down through every level. The oak board under the legs needs 2.5 per leg and the table has 2 legs, so it shows 5. The carriage bolt shows 16, which is 4 per bracket, 2 brackets per leg and 2 legs. With Location at - All -, On Hand and Available are aggregated across locations: 64 and 58 for the hardware kit, 40 and 40 for the finish pack, 300 and 290 for the oak board. On a subassembly row they describe the stock of the subassembly itself, 18 and 18 for the leg assembly and 6 and 4 for the tabletop. Back Ordered and On Order are 0 on every row in this example.
03. Compare the earlier revision
In Bill of Materials Revision, choose Trestle Table Rev A. Effective Date changes to 02/02/2026, the start date of that revision, and the grid shrinks to the two components Rev A carried, HW-310 Hardware Kit at 2 and FIN-050 Finish Pack at 1. There are no subassembly rows. Choose Trestle Table Rev B again to bring back the ten rows and 08/03/2026.
04. Scope stock to one location
Choose Boise Warehouse in Location. Trestle Table BOM has no Default for Location setting, so in this example the same BOM and revision apply at both locations and all ten rows stay. Only the stock changes. The hardware kit drops to 0 and 0, the finish pack stays at 40 and 40, the oak board is 80 and 80, the carriage bolt 150 and 150, and the felt pad 300 and 300.
Now choose Reno Plant, where the table is built. The hardware kit is back at 64 and 58, the oak board is 220 and 210 and the carriage bolt 400 and 400. FIN-050 Finish Pack and FLT-030 Felt Pad read 0 and 0. Those two parts are stocked at Boise Warehouse, so they would have to be transferred or purchased before a Reno Plant build. The inquiry doesn't create the transfer.
05. Show only the top-level components
Check Top Level Only. The grid keeps the four Level 1 rows, HW-310, FIN-050, LEG-220 and TOP-210, with their Reno Plant stock, and drops the six rows beneath the subassemblies. Clear the box and the subassembly rows come back.
06. Confirm where the stock sits
Click FIN-050 Finish Pack in the grid. The inventory item record opens. On the Purchasing/Inventory subtab, the Locations list shows Boise Warehouse with Quantity On Hand 40 and Quantity Available 40, and no row for Reno Plant. A missing row doesn't prove an item can never be stocked at that location, so confirm with an inventory report if it matters. In this example the finish pack has no Reno Plant balance to build from.
Check the result
- Bill of Materials, Bill of Materials Revision and Effective Date fill in after you choose the assembly.
- Rev B lists ten rows and Rev A lists two.
- In this example, changing Location keeps every row and changes only the stock figures.
- At Reno Plant, FIN-050 and FLT-030 read 0 and 0, and the FIN-050 item record shows its stock at Boise Warehouse.
Common questions
Does Bill of Materials Inquiry change anything?
No. It is a read-only view of the BOM and stock. It doesn't edit the assembly, the BOM or its revisions, and it doesn't reserve stock or create a transfer or a work order.
What do Level and Quantity per Top Level Assembly mean?
Level 1 rows are the lines on the revision you chose. A component that is an assembly is followed by its own components, indented at Level 2 and deeper. BoM Quantity per Assembly is the quantity on the component's own parent line, and Quantity per Top Level Assembly multiplies the quantities down every level, so two legs per table and 2.5 board feet per leg is 5 board feet per table.
Why does a component still appear when it has no stock at my location?
The list comes from the BOM, not from stock. A zero means there is no stock at the chosen location. It doesn't remove the component from the BOM, so the row stays and shows zeros.
Why did Effective Date change when I chose another revision?
With the assembly on revision control and BoM Display Control set to By Revision, Effective Date follows the revision you choose and shows its effective start date. If a revision has no start date, the field can show the current date, so check it before you rely on it.
Why is Bill of Materials blank after I choose an assembly?
The assembly may not have an active BOM that applies for that subsidiary and location. Check that the assembly is built at the location, that it has a master default or a Default for Location BOM, that the BOM is active and available to the subsidiary, that a revision covers the date, and that your role can see it. A Default for Location BOM can take precedence over the master default, so changing Location can change the BOM or leave it blank.
Does a positive Available on every row mean I can build the assembly?
No. Available is an inventory figure, not a buildable quantity. Whether you can build also depends on the quantities required, yield and units, commitments, inventory status and the work order's own rules. Check the Buildable quantity on a work order, or use a transfer or purchase, before you act on what you find here.
Do Back Ordered and On Order change with Location?
They are zero in this example, so the screens don't show it. Check how your account treats them by location before you rely on them, and read On Hand and Available as the figures for the Location you chose.