Skip to main content
Question

Multiple parts BOM extraction


Forum|alt.badge.img+2

Hello,

I am looking for a way to export the BOM (structure, components, etc.) from multiple parts into a .csv or .xlsx file. I realize this may require a macro. Reason: I need this list for 1000’s of parts for analytics.

The list should have the PN tied to the structure (repeat the part number for each component; see column B)

Example:

Inputs: List of 1000’s of parts

Process: ???

Output: List of 1000’s of parts with corresponding structure

See image for a basic example.

Thanks for any help or direction!

-Shockwave

 

4 replies

Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1482 replies
  • August 23, 2022

Try this thread:

 


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • August 24, 2022

@ShawnBerk - Thanks for the response and suggestion. I looked at that thread but it is only for 1 BOM. However, my admin showed me a way to get the output without a macro. 

  1. >Engineering>Structure>Manufacturing Structures
  2. Search: Enter the top level parts in “Parent part no:”
  3. I copied and pasted my list from excel into word and replaced all paragraph returns with a “;”. Then I copied that semi-colon delimited list into the “Parent Part No:” field.
  4. The result is 1000+ top levels with BOM’s in one list
  5. I can now determine where parts are used across the platform using manually filtering or pivot tables in excel

Search for multiple parts here: >Engineering>Structure>Manufacturing Structures


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • October 5, 2023

Is there a way to do this but get the cost of each part (add column)? 🤔

I can get the costed BOM for a single part from “Product Structure”, but I would like to extract multiple parts in one shot similar to the above.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • October 5, 2023

I figured out something that works: “Manufacturing structures” and add cost columns. 

Right click in column headers and select “column chooser”.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings