Propagate item number override from subassemblies to parent assembly

When you override the item number in the BOM of a subassembly, you expect to find that same item number back in the BOM of the parent assembly.

However this override does not propagate into the parent.

 

Example in the BOM of a first level sub

Result in the parent BOM

 

For solving the problem

• Download and unzip this VBA Macro to your local drive.
• Open the VBA editor.
• File > Import and insert the file SyncBomItemNumbersModule.bas into your application project.
• In the parent assembly, enable the Structured BOM and set the Properties to "All Levels".

 

• Run the macro called "Sub SyncBOMItemNumbers()" and get the result.

 
 

If this is a common workflow for you, you may find useful to place the macro as an icon in the ribbon as follow

• Go to Tools > Options > Customize.
• Locate the macro by name (in this case "SyncBOMItemNumbers") in the left pane.
• If you want the macro to show up in the Assembly Assemble ribbon, select Assembly|Assemble above the right pane.

 

• Hit the >> button and set the Text checkbox.

 

Comments

[Sam]

Will this script wok if I do all of my numbering on the parent most assembly?

What I want to do is override all of the numbering on the sub assemblies with the values that I assign on the parent most assembly.

[Ale]

No, if I have understood correctly your question.
This script works the other way around.
Regards,
Ale