Hello Friends, What are people doing to offer reporting on a fully exploded bill of materials in an instance using advanced bill of materials? I know its always been a struggle and have many, many ideas of how to overcome but wanted to see what others were doing as well. Thanks!

I believe you can do this with SuiteQL. Otherwise, you have to do recursive searching.

SQL92 doesn't support recursive statements. Our boms are multi-level and go down as far as 5 levels

There is no good solution for this, not even when is just a simple recursion problem, on top of that when you add multiple BOM Revisions and manufacturing routes it gets even worse. The only way I would approach this will be probably with a well designed set of custom records and a couple of chained map reduces to update those records.

@alien4u I like the custom record approach but I'm struggling in getting suiteanalytics to show any of the hierarchy I built into the custom record. It is almost as if workbooks can only handle the hierarchy if it is a natively hierarchal field.