I'm trying to figure out a multi-level BOM export so that I can figure out the buildable quantity of a product. I have several products that extend beyond 2 levels, and I'm having a hard time determining based on the data in Netsuite if it is even possible to build, let alone how many. When I do an export of member and member items I get all the components, but not necessarily in order, but the order is important because if the member quantity rolls up to the next level and I have inventory on that level I could potentially build. This has been a frustrating exercise and based on what I've seen in Netsuite so far I'm not sure there is a work-around. Currently the BOM's I'm working with go 5 levels deep and several hundred components, and trying to figure out if it's possible to build something has been quite difficult to answer.
How can I achieve this? Looking for a little guidance on this complex topic. Thank!