Cancel
Showing results for 
Search instead for 
Did you mean: 

Help: Making a Rolled up Bill of Material

Experimenter
Experimenter

Basically I want to have a "master" BOM wherein all of the parts needed to build a top level assembly appear in a single BOM.

 

Using the Exploded Report is good and all but this is 2019!

 

I should not be wasting my time looking at my report more than once if a single parts appears multiple time in dozen of assembly.

 

So, something like this structure:

Top-assy

     Part1

     Part2

     Sub-assy1

          Part3

          Part4

          Sub-sub-assy

               Part1

               Part5

               Part6

     Sub-assy2

          Part7

          Part2

 

Would become BOM:

Name               Qty

Top-assy          1

Part1                 2  

Part2                 2

Part3                 1

Part4                 1

Part5                 1

Part6                 1

Part7                 1

 

I would greatly appreacite to all who could solve my dilemma

6 REPLIES 6

Re: Help: Making a Rolled up Bill of Material

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

Hi there @Acva,

 

Does the "Atomic" report not get you what you're looking for?

 

Also, don't forget you can name the multiple report set ups, using the "Saved settings" on the General tab.

Sean Cresswell
Design Manager Streetscape Ltd
Solid Edge 2019 [MP8] Classic [x3 Seats - Cloud Enabled]
Windows 10 - Quadro P2000

Re: Help: Making a Rolled up Bill of Material

Gears Phenom Gears Phenom
Gears Phenom

Go into the Part List properties, under the List Control tab select the subassemblies you want to rollup. Then select the "Include assembly component" on the right under Subassemblies. It will pull the parts up to your parts list. Or you can select the Atomic list (all parts) option.

 

asm1.png

Jamie Griffis | PLM Solution Architect | Engineering USA

Re: Help: Making a Rolled up Bill of Material

Experimenter
Experimenter

Not really what I am looking for.

 

So I think Im gonna need to reclarifie again my fault sorry

 

So fist, imma going to make an exploded BOM and turn it into an excel sheet

 

Okay so you see the part colored in blue? (aka the lv.3)

 

So we see that I need 2 of them to make our 2 red selected sub. (the lv.2)

 

I am seeing that blue part twice on my list.

 

I do not want that.

 

I just want to see it once like on my custom list made by hand, But at the same time, I kinda need to know where that blue piece will go.

 

That is the end goal. Something similar to my custom list

 

Atomic does not fulfil my need because the sub assem (those 100 numbers part do not show in the atomic) is not included in the report and part list.

It does tell me how many but not where

 

While I could just look at 2 reports, I might as well just stick to my custom file which means I waste time if I have to juggle multiple machines which I do.

 

Thnking about it, this might need a micro.

 

=(

Re: Help: Making a Rolled up Bill of Material

Legend
Legend

Too bad you're not using an ERP/MRP that would give you the work order to make two of a part, and tell you where they each go to next! Then you could use the standard BOM reports like many do these days. Sounds like you're trying to do it in a manual way, which might require more work on your side.

 

I'm interested in what other folks might suggest to make this simple, I can't really wrap my head around it right now.

Re: Help: Making a Rolled up Bill of Material

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

Hi @Acva 

 

 

TBH I think Your request more goes into the direction of ERP rather than the BOM side as it is defined in engineering/construction literture/education/training.

 

I often have seen that, and the best answer I can give here is to not try mixing up different areas of design process/life cycle.

 

CAD is one side but ERP another.

 

Nevertheless, a new feature or function would be a very welcome enhancement for SE.

 

regards
Wolfgang

Re: Help: Making a Rolled up Bill of Material

Gears Phenom Gears Phenom
Gears Phenom

@Acva wrote:

 

So fist, imma going to make an exploded BOM and turn it into an excel sheet

 


I suggest to do some BOM post process directly in the excel sheet.

At least this is what I do, now I'm out of office but tomorrow I can post an example.