Skip to main content
Sep 1, 2023 4:59 PM UTC
Acknowledged

Sort drawing BOM to be in order of assembly (by 1st instance of each component)

Related products:Creo Parametric

Please include detailed documentation such as screenshots, images or video.

1. What product and version are you running?
Creo Parametric 8


2. What is the problem?
Because managing the proper sorting of BOM on drawing is not intuitive most user do it differently. Which is prone to error when a different user updates a drawing. It also cause issues if an item number was referenced to in the notes and the BOM is automatically reordered after an update in the assembly.

3. Are you using a workaround? If yes, please describe it.
The workarounds are highlighted in the following post from the community:

https://community.ptc.com/t5/3D-Part-Assembly-Design/Changing-BOM-to-be-in-order-of-assembly/m-p/765222/highlight/true#M122200


4. What is the use case for your organization? Describe how your idea would work in context or how it would apply to a practical situation.
Here is the dream:

By default (or less ideal via a config option) the BOM on drawings is sorted following the order the components are showing in the assembly.

Right now this only work when the "No Duplicates" option is set. Which doesn't work for most organizations as few people want to see the same screw listed as 20 separate lines on the BOM.

The logic for my suggestion is pretty straight forward. Simply look at the first instance of each part to determine its position in the BOM. Any duplicate of this part will simply be added to the QTY of the first one.

This would make it much more intuitive and logical.

5. What impact does this problem currently have on your organization? (Number of users affected, hours of lost productivity, etc.)
Thousands of hairs pulled, cracks in monitors from head-banging, premature aging, etc.

4 replies

Sep 1, 2023 5:44 PM UTC

By default, the BOM is displayed with the parts in the order they are added to the assembly. Duplicates are removed and the first instance in the BOM gets its quantity increased.

Model tree of assembly:

BenLoosli_0-1693589945661.png

BOM on drawing:

BenLoosli_1-1693589983939.png

 

If you are not seeing this as the default for a repeat region table, then the table may be created with a default sort option.

If I add a sort region, using the Number column, the BOM sorts. Clear All removes the sort and the BOM returns to the assembly order state.

 

This is with Creo 7.0.10.0, so maybe PTC screwed this up in 8+!

MagTargetAuthor
Sep 6, 2023 12:34 AM UTC

Hi Ben,

 

Thanks for sharing the facts that it works for you in Creo 7!

This is giving hope, as there's got to be a way to make it happen out-of-the-box.

 

There is no sorting applied to the BOM. I tried sorting by a specific parameter and then removing all sorting but still no luck.

One thing I noticed is that Creo was sorting the BOM by the description column. So I deleted that column and it went to sorting by the &asm.mbr.name column instead. So there seem to be an auto-sorting going on, which prevents it from following the assembly tree order.

Creo repeat region sorting.jpg

 

If I change the repeat region attribute to "Duplicates" it does follow the assembly tree order correctly. But then we get duplicate listing of items in the BOM.

For reference here is what the attribute selections look like on my end.

Repeat region attributes.jpg

To eliminate the possibility that this was somehow tied to the imported table I am using. I deleted my existing BOM/repeat-region and started over with a brand new one using the following report parameter names to replicate what you showed.

repeat region report parameter names.jpg

But still no luck.

 

Now that you've given me hope that there may be a way to do this within the existing features I am going to open a ticket with PTC. I'll report back in here on what comes out of it.

 

Cheers,

JM

Sep 6, 2023 6:12 AM UTC
Status changed to: Acknowledged

Hi @MagTarget!

Thank you for your idea. Based on the information you provided, we are acknowledging it as the Community management team. This is not a commitment from the Product team. Other users may comment and vote your idea up.

MagTargetAuthor
Sep 6, 2023 5:38 PM UTC

Hi @achirila,

Thanks for acknowledging my request!

 

I think I just figured out a better workaround! Thanks in part to @BenLoosli who made me realize, it was probably possible to sort the BOM properly via some setting changes.

BUT PLEASE DON"T CLOSE THIS REQUEST YET. Because:

1) The "No Duplicates" attribute should be fixed to work as described below..

2) I wasted so much time looking for this better workaround that the documentation needs to be updated. See my recommendation on which documentation to update below.

 

The solution

Set the attribute to BOTH "No Dup/Level" AND "Flat"

Repeat region attributes to match assy sorting.jpg

 

This makes the repeat region correctly follow the assembly order.

Repeat region matches assy sorting.jpg

 

How CREO should be updated

The current workflow is really not intuitive, since the "No Dup/Level" was clearly meant to apply when components in sub-assemblies are shown in the BOM. The fact it works in a single level BOM is a nice "accident" in this case, but the "No Duplicates" option should be fixed to work as it should.

 

Which documentations should be updated

Creo Parametric documentation section - About Formatting Repeat Regions by Attribute

Showing an example of how a BOM/Repeat-Region can be sorted to match the order of the assembly.

 

CS51354 How to generate BOM listing of components in order of assembly, and also keep the No Duplicates attributes in Pro/ENGINEER and Creo Elemenst/Pro

It currently shows "Not part of the Pro/ENGINEER functionality", and should be updated to show that this is supported on newer versions of Creo (5+ ?) and point to the relevant documentation showing how it is done.

 

CS23600 How to display bill of materials (BOM) table in drawing the same as the assembly model tree structure within Creo Parametric

Currently show the wrong resolution, asking the user to "Set attribute values to Duplicates and Recursive" which does not work.

 

CS134738 How to sort components in a repeat region table by their assembled order in the mode tree in Creo Parametric

Currently show the wrong resolution, asking the user to "Set Table > Repeat Region > Attributes, select the table region and set > No dup/Level > Recursive > bin by part > No cbl Info > Done/Return > Done"

 

Thanks in advance for pushing to have these updates made!

 

Cheers,

JM