DesignSpark Mechanical Online Help

Bills of materials

 

You can insert a Bill of Materials (BOM)Closed onto your design or drawing sheet. BOM values are automatically populated for both internal and external components that are part of an assembly. DS Mechanical only itemizes components; if the design only has solids in the structure tree, they will not be included in the BOM. The QTY column in a design's BOM table shows the number of sub-components, not items, that are included in an assembly.

When a drawing includes a BOM table that contains data added with a newer service pack of DS Mechanical than you are using, the new columns are displayed in red. This indicates that the data cannot be changed, and can only be viewed.

You can include X, Y, and Z dimensions of components in a BOM table. The extents shown are the exact extents of all solid and surface geometry in the component, for both visible and hidden solids and surfaces. Sketch curves, bitmaps, and other entities are not included in the extents. Use these dimensions to create a cut list of parts in an assembly of panels in the BOM, along with their number and dimensions. See the instructions for adding a column to a BOM table below.

BOM table

To add a Bill of Materials to a document

  1. Click the arrow next to the Bill of Materials tool in the AnnotationClosed Investigate group on the Detailing DesignClosed tab and select a type:

    The last type of BOM you created is remembered and will be automatically chosen if you click the BOM icon instead of the drop-down arrow.

  2. (Optional) If you created a view of a component on the drawing sheet, select the component on the Options panelClosed to create a BOM for just that component.

  3. (Optional) Modify the Bill of MaterialClosed's properties in the Properties panelClosed.

     

  4. Click to place the Bill of Materials on the design or drawing sheet. The table appears in gray until you place it, and it changes to black after it is placed.

    To cancel, press the Esc key before you click to place the table.

    The BOM appears in the Structure treeClosed.

    You can copy and paste a BOM, and you can copy the contents from a BOM table and paste them into Microsoft Excel.

To edit a Bill of Materials

To add columns to a BOM table

  1. Right-click an existing column and select Insert > Insert Columns to the Left or Insert Columns to the Right.

  2. Select the new column by clicking above the first row of the column, like this:


     

  3. Select a Column Type in the Properties panelClosed.

  4. Select a Column Value if you selected DocumentClosed Property, MaterialClosed Property, or Custom Property for the column type. The values in the column will be automatically filled-in.

    If you select MaterialClosed Property for the column type and MassClosed or Volume for the column value, then the column data will only be filled-in when a material has been assigned to the object.

To export a Bill of Materials

  1. Click on a BOM table, then click its edge to select the entire table. The edge will change from a dashed line to a solid line when you have the entire table selected.

  2. Right-click the table and select Save Table As.

  3. Select HTML, XML, BOM Template (.scbomtemplate) for the Save as type.

If you choose 'BOM Template' as the type, all the formatting, header, table properties, and contents are saved to an .xml file which you can edit.

To use a BOM Template

  1. Click the arrow on the BOM tool.
  2. Select Template from the drop down list.
  3. Select the .scbomtemplate document and click the Open button.
  4. Place the BOM table.

Sorting a Bill of Materials

You can sort the columns in a BOM table.

  1. Select a column.
  2. Choose Sort by column in the RMB menu.
  3. The values are sorted numerically and then alphabetically in ascending order.
  4. Sort the column a second time to sort in descending order.

You can manually edit any values in the BOM but any sorts have to be re-done to update the table.

Sorting works with indented and regular BOM's.

Sequential sorting is remembered across columns. Below is an example of two sequential sorts:

  1. First sort items alphabetically by name.
  2. Then sort numerically by Quantity.
  3. Result:
    1. Rows are put in ascending order according to Quantity
    2. Items with duplicate quantities are then put in alphabetical order according to their names. In the image below, items are sorted by Quantity (1, 2, 3). Then all items with a Quantity of 1 are sorted alphabetically.

Grouping Rows in a Bill of Materials

You can group rows in a BOM table based on a selected Custom Property.

 

  1. Add a column to the BOM
  2. Select the column and set the Column Type property to Custom Property
  3. Set the Column Value property to be the Property that you want to group
  4. Set the Group Using property to be the Property that you want to group
  5. You can control the row numbering for the grouped rows using the Start groups from property

Notes on row grouping:

Example:

BOM with "Part Type" custom property column added
Group Using property set to "Part Type" and default row numbering
Start groups from property set to Number rows sequentially

 


© Copyright 2020 Allied Electronics, Inc. All rights reserved.