Skip to main content
A
Amirtharaj_K17-Peridot
17-Peridot
May 12, 2026
Question

Muti Bom Report generation (CAD Structure)

  • May 12, 2026
  • 4 replies
  • 49 views

Hi Guys,

I am looking for a way to generate multiple individual BOM reports in a single run through Report Management. I have more than 100 object numbers, and each object has its own BOM structure.

If anyone has a solution or knows how to achieve this, kindly share the details.

Regards,

Aj

4 replies

T
TDT17-Peridot
17-Peridot
May 12, 2026

Hi ​@Amirtharaj_K,

Is there any specific use case for passing multiple objects at the same time?

A
Amirtharaj_K17-PeridotAuthor
17-Peridot
May 12, 2026

​@TDT Thanks for the response.

Through the API, we can export the BOM to Excel. However, the requirement is to generate individual BOM reports based on a list of FG (Finished Goods) part numbers.

In this case, non-engineering teams like Sales or Manufacturing will have a list of main FG product numbers. They want to use those numbers to generate and download the complete BOM for each item individually in Excel format.

 

Regards,

Aj

T
TDT17-Peridot
17-Peridot
May 12, 2026

This is not possible through Report Management out of the box.
If you need to generate BOM reports for multiple objects in a single run, you would likely need a customization.
I would suggest creating an action under Quick Links that accepts multiple object numbers as input. The Form Processor can then handle the processing based on your specific requirements.

joe_morton
18-Opal
joe_morton18-Opal
18-Opal
June 8, 2026

Are the BOMs single level, or multi-level? 

If they are single level, Report Management can help. If you need Multi-Level reports, Report Management is not a good fit, without further customization.

If you report is configured appropriately, you can return the single level BOM for multiple part numbers at once by using criteria like this:

Parent Part Number like: PN1|PN2|PN3

The “|” symbol will cause the report to return data for all 3 part numbers entered.

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
May 12, 2026

Create a fake part and add 100 objects to it to make a fake BOM. Run a multilevel report against it. Delete when done.

    C
    ckiley6-Contributor
    6-Contributor
    June 5, 2026

    I do this often. i have it set to a state that will not pass on a Change Notice to eliminate “opportunities” for someone else to grab it and release it.

    D
    DavidBigelow17-Peridot
    17-Peridot
    June 8, 2026

    This is easier than it seems.

     

    The key to this is to get the data in to Excel and then use Power Query to filter the various BOM reports you want.

     

    I recommend Nitro-BOM as it extracts the FULL BOM from the active assembly and writes to an Excel Table directly.  Then you can setup a Power Query workflow using that exported Table to derive the other BOMs you need (filter based on part number or level or whatever).   

     

    Power Query can export multiple Tables of the transformed data to new Excel Tables - and each time you run a new export to that worksheet (with a modified or different assembly) Nitro-BOM can force an update of Excel Data (which re-runs the Power Query workflow(s) and updates the BOM tables.)…

     

    The same process can also be done with Nitro-CELL - but Nitro-BOM is more straight forward IMHO (because 90% of the legwork is already done, and you just need to focus on the final filtering and transformation in Power Query).

     

    But Excel is the key to streamlining this export and transformation of BOM data.

     

    BTW - Both Nitro-BOM and Nitro-CELL have FREE licenses that can be used for smaller projects if you want to test things - only requires JLINK to be installed with Creo Parametric.

     

    Dave

    Terms & ConditionsAccessibility statement