I am trying to make a BAQ/Dashboard that will match the order of the tree view in Quote Entry

Kinetic ERP
,
1

I am trying to make a BAQ/Dashboard that will match the order of the tree view in Quote Entry Manufacturing Details tree for materials.

There are many fields available in the QuoteMtl table but I am having trouble figuring out how to sort these fields in order to get my BAQ/Dashboard to match the tree view in Quote Entry.

The screen shot below shows the fields available for sorting.

Please help!

Thank you,
Richard

quotemtl

2

I can have multiple BOM levels, the one quote has up to BOM level 4.

3

Here is a example of the tree view sort order that I am trying to duplicate in a BAQ/Dashboard.

qm2
qm2468×838 11.8 KB

4

I am afraid you are in for a CTE. I am certainly not the person to help with that. Me and CTEs don’t get along for some reason. I think that is the only way to create the kind of nested structure you need. I Still Don’t Understand CTEs - Kinetic ERP - Epicor User Help Forum

5

See the BOM_explode BAQ in this comment. This will do what you want…in terms of showing a way to create an indented view, even if its not a true “tree view”.