BOM with configurations
BOM with configurations
(OP)
How do I create a BOM for multiple configurations of my assmebly? I have the -01, -02, -03 configurations of the assembly that have 99% common parts. How do I show the uncommon parts in the automated BOM?






RE: BOM with configurations
RE: BOM with configurations
- Do you have an excel macro to create BOM's in assemblies? (if not, it is not very difficult to find one in the internet). You need to make some modifications
- Before the BOM is created, instead of simply selecting the ActiveDoc, you should select each of the configs. You can create the BOM, for each config, in the same sheet, with no blank lines between them. This BOM I am referring can be only one or two columns (I would think in the part code and config name, for example).
- After BOM creation, for all configs, you should add extra Excel code to compare the items. First you should order the Excel sheet (alphabeticaly, for example). Then see if each line is equal to the following line. Count the number of equal hits and write it on the next collumn. At the end, you will have a list of used qty and select those with n. of hits = 1
Regards
RE: BOM with configurations
Of course you can think in other things. For example, another way is to have each config on a different sheet (the sheet name can be the config name). This way you can have complete BOM's in different sheets. But the Excel code for components analysis will be more complex (I think!).
Regards
RE: BOM with configurations
RE: BOM with configurations
RE: BOM with configurations
If so, then open the part, RMB the config and go to Properties. At the very bottom it lists the option you have for showing them in the BOM.
The Config name will show up in the Part No. if done correctly.
Best Regards,
Scott Baugh, CSWP

3DVision Technologies
credence69@REMOVEhotmail.com
http://www.3dvisiontech.com
http://www.3dmca.com
*When in doubt always check the help*
RE: BOM with configurations
Unlese I'm missing something...
If you can view configs 01, 02 & 03 one-at-a-time in your assembly - then you can show each one one-at-a-time in the drawing BOM.
Make sure your drawing view that generated the BOM has the correct configuration in it.
Do this via right-click, properties and select the configuration.
Consume mass quantities...
tatej@usfilter.com
RE: BOM with configurations
Doing it manually, you'll need to save each BOM you mention as *.xls and then, with Excel functions, find the uncommon parts.
Have you other ideas?
Regards
RE: BOM with configurations
Set up your assembly configurations and HIDE rather than SUPPRESS the parts that aren't being used.
Is this what you want?
If not - then what do you mean by uncommon parts?
Consume mass quantities...
tatej@usfilter.com
RE: BOM with configurations
Regards
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.
Click Here to join Eng-Tips and talk with other members!