Build BOM in Query

[bordway (Bruce Ordway)]

@mjfwagner

Incorrect syntax near ‘(’.

Are you really running 10.1.4… what version of SQL?
Reason I ask, some BAQ examples will only work using the same or later versions they were built in.

Also, have you tried searching Indented"? I think you’ll find a lot of examples for BOM’s.
e.g.

Need an Indented BOM BAQ

So I am VERY inexperienced at creating complex BAQs, and I need a report that explodes our indented BOMs. I am trying to follow the steps in this training: Sign In I cannot get past the first step to create the CTE because Epicor says my query contains no top level subquery. Are there steps in front of this training that I am missing? Is there anyplace this process is spelled out completely from start to finish? Thank you!