I want to be able to generate a BOM of the purchased parts from an assembly. If I make a property called "PURCHASED" (TRUE/FALSE) for every part, is there a simple way to filter BOM? I know I could export to excel, but I'd rather do it all in SW.
I want to be able to generate a BOM of the purchased parts from an assembly. If I make a property called "PURCHASED" (TRUE/FALSE) for every part, is there a simple way to filter BOM? I know I could export to excel, but I'd rather do it all in SW.
You can sort the SolidWorks BOM to make it easier for your purchasing people. Add a column for Purchased.
Anna had a great reply ,
another way to do this is with a simple IF statement in the BOM, create a new column and using the Equation manager to essential say
IF("purchased"="Y";"PURCHASED";"MANUFACTURED")
this means if the Purchased Property equals Y then it will show PURCHASED otherwise it will show MANUFACTURED
you can also change the manufactured to "" to show nothing.
its easy to do as you can choose the commands and properties from the equation manager dropdowns
Thanks for the tips. The end result I'm hoping for is a BOM that includes purchased parts only. I know that I could click the "exclude from BOM" for the non-purchased parts, but I don't want to do that because I will need to include those parts on BOM's elsewhere.
In excel, I would filter the table to remove the non-purchased parts. Is there similar functionality in SW?
Hi Chad,
you could sort along your criteria and then split the BOM above the section with the parts that meet your criteria:
With it, you could have a purchased parts section and a section with manufactured parts. If you do not need the manufactured parts section you could simply move it off the drawing and it would not be printed:
Hope this helps
Kind regards
Frank
SOLIDWORKS Product Definition Team
Thanks Frank, that's very helpful.
Hi Chad,
you could sort along your criteria and then split the BOM above the section with the parts that meet your criteria:
With it, you could have a purchased parts section and a section with manufactured parts. If you do not need the manufactured parts section you could simply move it off the drawing and it would not be printed:
Hope this helps
Kind regards
Frank
SOLIDWORKS Product Definition Team