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

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

WHolzwarth — Sun, 27 Aug 2017 18:40:43 GMT

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

Thanks for hints

Walter

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

S_May — Sun, 27 Aug 2017 19:59:15 GMT

Hi @WHolzwarth,

https://knoinventor-2017-updates-for-customers-subscription

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

WHolzwarth — Sun, 27 Aug 2017 20:07:42 GMT

Hmm ..

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

johnsonshiue — Mon, 28 Aug 2017 00:38:30 GMT

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!

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

WHolzwarth — Mon, 28 Aug 2017 04:42:10 GMT

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.

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

johnsonshiue — Mon, 28 Aug 2017 19:55:07 GMT

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!

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

WHolzwarth — Mon, 28 Aug 2017 20:43:12 GMT

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.

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

johnsonshiue — Mon, 28 Aug 2017 21:24:29 GMT

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!

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

WHolzwarth — Tue, 29 Aug 2017 06:41:58 GMT

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.

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

helge_brettschneider — Tue, 29 Aug 2017 14:40:06 GMT

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

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

WHolzwarth — Tue, 29 Aug 2017 15:59:04 GMT

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.

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

Anonymous — Tue, 31 Oct 2017 16:52:40 GMT

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

This is an issue if you are using vault.

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

WHolzwarth — Tue, 31 Oct 2017 17:34:32 GMT

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.