REQ....BOM HELP

What I'm looking to do is create custom BOM'S in SW or excel. these bills need to be able to recognize the part/assembly/wldm level. so that it shows the correct description/part number/ and whatever required information correctly in the bom. currently we use custom steel that uses configurations. at the 2nd level of the part the bom shows the raw steel number which is ok. because I now have a manufactured part with holes and, a new number(level). the bom shows that I used a level 1 piece of raw steel to create it. now I create and assembly (level 3). I have this level 2 part used in an the assembly(level 3) the bom should show the 2nd level information not dig down to the base part.

-level 1 raw steel(angle, hr, 2 X 2 X 1/4 X 12" lg p/n 6575-0000

-level 2 level 1 part with hole(s)(bracket, mtg, post p/n 1044-0000

-level 3 post, assy (that uses 1044-0000 as an item in the bom)

now level 3's bom should show description and part number of level 2 item not show level 1 item description unless theres another raw steel part used that has that number.

I am not sure what the problem is since this seems to be the basic function of the BOM. If you specify that the BOM is single level it will accomplish everything you want at both levels. That is if your second level is an assembly and not a part file, but you said the second level is showing correctly. I presume that you are currently getting the steel part numbers added to the bill.

There are 3 options for the old Excel Bill

Show parts only. (This will show the lowest level parts and not their assemblys)

Show top level subassemblies and parts. (this will show only models and assemblies inserted directly into this assembly. This is the option you want if I understand you correctly)

Show assemblies and parts in an indented list. ( this will show you every Model and Assembly in a heierarchy that will look much like the design tree with subassembly parts indented under the subassembly they belong to)

Another thing that will help if funny situations come up is in the Properties of each configuration in an assembly you can specify wether you want the components to be blocked from uplevel bills. This would override ShowParts only and Show Assemblied and parts in an indented list.

In the new style BOM these options are called

Parts only Top Level Only Indented Assemblies

Respectively. They are found under BOM Type in the Property Manager

Clear as mud?

Corey