Exclude Existing Material in USA Bill of Material
Not version-specific
Tekla Structures
Environment
United States (Imperial)
United States (Metric)
Question:
How can I exclude secondary material I mark as "Existing" from showing up in my Bill of Material for my assembly?
Answer:
If you have secondary parts marked as "Existing" in the model, you can exclude them from the BOM (Bill of material) by adding a rule that excludes items marked with that UDA.
The example I will use below is using the TypeA-Drg_BOM.tpl from the USA environment. If you open your assembly drawing that contains your assembly that has existing secondary parts, you can then double click on the BOM. By double-clicking on the BOM, you should be presented with an option that says "Edit in the Template Editor." Click it and it will open the BOM in the template editor.
In this example, we will use Style 1. There are five default styles within the out of the box BOM template for assembly drawings.
Click the expand (Plus Sign +) option on the STYLE1 row in the Sorting and Drawing Order pane on the left. Then expand the STYLE1-Assembly, and you should see the STYLE1-Part.
Image
Next, double click either on the STYLE1-Part row in the pane to the left or the row itself in the page view. It will open the Row Properties dialog box. In the properties dialog click "Advanced" and that will open the Rule Contents dialog.
Image
As shown above, we add the rule GetValue("USERDEFINED.EXISTING") == "Existing" || to the beginning of the existing rule. This rule will tell the part row that if a part equals EXISTING then it will lead to StepOver.
From here click Ok on the Rule Contents dialog, and then Ok on the Row Properties dialog and save your template. Now you can reopen the drawing in Tekla (or right-click> refresh the template if the drawing is opened) and it should not list any Existing parts.