Skip to main content
5-Regular Member
November 30, 2021
Question

Report a parts parent part number on a table Creo 7.0

  • November 30, 2021
  • 2 replies
  • 2797 views

Hello all.. I am in the process of exporting all of my assembly bills of materials to an MRP system. this system requires the BOM format to report the part number and its parent part number.

Reporting the part number is easy... creating an indented BOM with level is easy... is there any way to create a column next to a part and report its parent?

Thanks all.

Aaron

2 replies

24-Ruby III
December 1, 2021

@awilson-2 wrote:

Hello all.. I am in the process of exporting all of my assembly bills of materials to an MRP system. this system requires the BOM format to report the part number and its parent part number.

Reporting the part number is easy... creating an indented BOM with level is easy... is there any way to create a column next to a part and report its parent?

Thanks all.

Aaron


Hi,

I do not understand what is parent part number. Do you mean parent assembly number ?

I think Creo is not able to create repeat region satisfying your needs. I guess you have to export the contents of repeat region into text file and then process its contents (and add requested "column") using specially developed application.

awilson-25-Regular MemberAuthor
5-Regular Member
December 1, 2021

Currently my BOM reports asm.mbr.PN for every part. I wish to have the BOM report the PN of its parent in a separate column. I can do this manually in excel by exporting a CSV, but I have hundreds of BOMs to import into the MRP system. I am looking for something a little less manual. All the MRP system cares about it a part number (name) and its parents part number (name). it does not need any other level or structure.

Aaron

24-Ruby III
December 1, 2021

@awilson-2 wrote:

Currently my BOM reports asm.mbr.PN for every part. I wish to have the BOM report the PN of its parent in a separate column. I can do this manually in excel by exporting a CSV, but I have hundreds of BOMs to import into the MRP system. I am looking for something a little less manual. All the MRP system cares about it a part number (name) and its parents part number (name). it does not need any other level or structure.

Aaron


Hi,

please explain the term its parents part number (name) ... and provide some example.

23-Emerald III
December 2, 2021

Creo parts/assemblies do not track where they are used.

 

You could add a column to your BOM table to include the assembly name. But that doesn't work with indented BOMs

&asm.name

 

Maybe once you get the data in to excel, you could easily manipulate it to find the indented parent??