Export assembly parts list (BOM) to Excel File

[subhashmecha]

Hi, I have different configuration/ iassemblies  or iparts under Table in my inventor file. I am trying to expert BOM for active iassembly or configuration only. I tried with external rules and it gave me BOM for all different configuration/ iassembly under TABLE. 

I have attached picture for reference. I need BOM for only "Complete Structure-03" in the picture.

Please help me to export BOM into Excel 

Many thanks in advance!!!

Subhash.

[JoyceZhou]

Hi Subhash,

You could export the top level component of the active iassembly member via BOM, please take a look at the image below:

If you want to get the part level BOM of the active iassembly member, here is the workaround.

1. Open the top assembly, generate the active iassembly member
2. Open the iassembly member from folder, e.g Complete Structure-03.iam
3. Select the Table from browser, RMB, Break Link.

Then the iassembly member will convert to normal assembly, now we could invoke the BOM, go to Structure tab, set view properties to all levels, then we could export the BOM information. Or go to Part only tab, activate it, then export  BOM.

4. Then undo the step 3, now the iassembly member will back.

Could you try the the above workflows and check whether it works for you?

Thanks,

[subhashmecha]

Thank you so much Joyce-Jinghua Zhou for reply. I follow your steps but still I can't select the "Export all levels" BOM after enable BOM view in "Parts Only". I have attached screenshot.

Please advise.

Thank you.

[JoyceZhou · Accepted solution]

Please change the View properties of Structure tab to All levels before export BOM.

You could do it as shwon in the attached image.

As to Parts only tab, there is no First level or all level export option

Thanks,