cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

What is fastest method/best practice to find BOM depth of a given assembly?

yxin
5-Regular Member

What is fastest method/best practice to find BOM depth of a given assembly?

We have custom BOM report page which by default shows only the first level of components. However, on the page the user is given the option to expand the BOM to any available depth. To display the available number of levels, the program needs to find the total number of levels. This is quite heavy on a big assembly, and many times unnecessary when a user wants to see the first level only. I wonder if there are better ways to get the total depth of a given assembly without walking the whole product structure tree.

1 ACCEPTED SOLUTION

Accepted Solutions

Hello @yxin 

There isn't better way then go through all levels because information about depth is not sorted in a database.

PetrH

View solution in original post

2 REPLIES 2

This is a great question. You can run the Multi-Level Bill of Materials report which includes the "Level" column and scan through it or export to excel to find the highest level. Would be nice if the total number of levels was displayed for the top level in the product structure or there was a way to add the Level column to the PS.

Hello @yxin 

There isn't better way then go through all levels because information about depth is not sorted in a database.

PetrH

Announcements