2017 Build 256: Can't export all BOM levels of main assy to Excel

2017 Build 256: Can't export all BOM levels of main assy to Excel

WHolzwarth
Mentor Mentor
3,898 Views
12 Replies
Message 1 of 13

2017 Build 256: Can't export all BOM levels of main assy to Excel

WHolzwarth
Mentor
Mentor

Only first sub-level is selectable. Option for all levels is grayed out.

 

Thanks for hints

Walter

Walter Holzwarth

EESignature

0 Likes
3,899 Views
12 Replies
Replies (12)
Message 2 of 13

S_May
Mentor
Mentor
0 Likes
Message 3 of 13

WHolzwarth
Mentor
Mentor

Hmm ..

Walter Holzwarth

EESignature

0 Likes
Message 4 of 13

johnsonshiue
Community Manager
Community Manager

Hi Walter,

 

Did you change the BOM View properties? Right-click on Structured tab in BOM dialog -> View Properties -> select All Levels. Does it work for you?

Many thanks!

 



Johnson Shiue ([email protected])
Software Test Engineer
Message 5 of 13

WHolzwarth
Mentor
Mentor

Good morning Johnson,

after sleeping some hours, I'm near a solution.

The problem seems to be caused by sub-assys like weldments being set as inseparable. This is good for having a clean overview with some sub-levels, but same parts in several sub-assys can't be added to a total number. The option mentioned by you is grayed out.

 

For manufacturing purposes I'm trying to get the summed up quantity for each different part in the main assembly. I won't disturb the existing structure, but I think, I can make a copy of the main assy, and set all existing inseparable occurences back to normal. Exporting that resulting BOM should do it.

 

Do you have another proposal?

 

Thanks

Walter

 

Shortly later: Seems to be a problem, because sub-assys come to normal everywhere. I need to P&G into a new project. Undesirable, and lots of work.

Walter Holzwarth

EESignature

0 Likes
Message 6 of 13

johnsonshiue
Community Manager
Community Manager

Hi Walter,

 

I am not seeing the issue here. Could you take a look at attached image and see if it is set to "All Levels"?

Many thanks!

 



Johnson Shiue ([email protected])
Software Test Engineer
0 Likes
Message 7 of 13

WHolzwarth
Mentor
Mentor

Perhaps I'm missing the final step, Johnson.

I've tried your proposal, and I can see all sub-levels in the screenshot. But I'm having two identical motor-gear combinations in this assy. I don't want to see them listed at different rows of my Excel export, but I need them and all other identical parts summed up into a general BOM for this main assy.

 

 

Walter Holzwarth

EESignature

0 Likes
Message 8 of 13

johnsonshiue
Community Manager
Community Manager

Hi Walter,

 

I think it is probably the way it works. When you use Structured BOM view, the components are all listed based on the tree structure. Same Part Number merging only applies to the parts within the same subasssembly. Or, Part-Only view.

Many thanks!



Johnson Shiue ([email protected])
Software Test Engineer
Message 9 of 13

WHolzwarth
Mentor
Mentor

johnsonshiue schrieb:

 

... Same Part Number merging only applies to the parts within the same subasssembly. Or, Part-Only view.


But I can't access these Export options, Johnson. They are grayed out.

Export options grayed out.jpg

Walter Holzwarth

EESignature

0 Likes
Message 10 of 13

helge_brettschneider
Autodesk Support
Autodesk Support

Hi Walter and all,
I checked the issue and and I can confirm the Jonson is right and to keep things a little easier here a full tutorial on how it works from the Grabcad portal.

 

https://grabcad.com/tutorials/tutorial-adding-sub-assembly-parts-to-an-assembly-parts-list

 

I hope this helps, regards,

 

Helge Brettschneider

 

Technical Support Specialist CAD/CAM

Message 11 of 13

WHolzwarth
Mentor
Mentor

Thanks, Helge and Johnson

I'll make a new attempt with another main assembly. This main IAM is too crowded for placing all parts in it, therefore I need sub-assemblies.

But for manufacturing and purchasing purposes , all different parts in the main IAM shall be summed up to needed amounts for each occurrence.

Walter Holzwarth

EESignature

0 Likes
Message 12 of 13

Anonymous
Not applicable

Have you looked to see if your files are "Read-Only".

This is an issue if you are using vault.

0 Likes
Message 13 of 13

WHolzwarth
Mentor
Mentor

I've found a solution for my special needs, already some time ago. I'm exporting two BOMs.

 

1. Parts Only BOM with summed up parts

2. Structured BOM with View Properties set to All Levels. This way Sub-Assys and welded parts are visible, too.

 

-

Walter Holzwarth

EESignature

0 Likes