This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How do i query an item assembly item and also join to the bill of material revesion to get the items that make up that item?

```select i1.itemid, brc.bomquantity, i.id
from item i
    inner join bomAssembly ba on ba.assembly = i.id
	inner join bomRevision br on br.billofmaterials = ba.billofmaterials
	inner join BomRevisionComponent brc on brc.bomRevision = br.id
	inner join item i1 on i1.id = brc.item
where i.id in ((?))
	and masterdefault = 'T'```