Custom BOM Editor

Situation – Business Need

BOM is an important feature available in CAD software by default. Even though every CAD software has given the flexibility to the user to configure the BOM according to their requirement, most users want some additional options to be available in BOM. One of our clients was looking for a more powerful BOM feature which will save time and hence increase productivity.

The client’s business situation requires

  1. An editable BOM – user should be able to modify detail(s) from BOM
  2. Show Leaf level – Show items in BOM which are at Leaf level in the assembly
  3. Sorting capability – user should be able to sort based on any column in BOM
  4. Assigning of Part Sequence number in BOM based on user parameters
  5. User wanted size of the Part/SubAssembly as a column in the BOM

Challenges Faced

There were a range of challenges faced during the course of the project. Few of them are listed below

  1. Sorting capabilities were not available directly in ‘CAD API’ provided UI controls
  2. Only selected columns will be ‘Editable’, which should be configurable. To set certain columns as editable based on user preference was a challenge.
  3. Since the primary key like the part number can also editable, maintaining the map from the BOM row to the part was a challenge
  4. Providing dynamic highlight of the component(s) in the graphic area when the row(s) is selected was a challenge
  5. Another challenge was excluding the non topological entities like Dimension, Annotations, etc. while computing the bounding box.

Our Solution

After careful consideration of the client need and analysis of the API provided by the CAD system, we decided to develop an ADD-ON inside the CAD system named as “BOM List Editor”. It was also decided to develop the COM component using .Net technology after considering the UI flexibility expected by the client.

Some of the features we included are:

    1. Using the default BOM settings on the first usage of “BOM List Editor”
    2. The list of columns to be displayed can be configured in “BOM Settings”
    3. Shortcut to show “BOM Settings” is provided in “BOM List Editor” UI.
    4. context menu options on in the BOM list for Zoom and Hide Entities
    5. Option to change BOM Hierarchy Level (0, 1, 2… n, ‘All’ and ‘Leaf’)
    6. Option to make certain columns Editable is also provided inside the Settings dialog.
    7. Performance is high even for complex assemblies as the assembly is scanned and the data is cached to avoid repeated scans and hence lags were avoided when user makes modifications
    8. Exporting to excel along with the column headers information is provided. The check box columns are exported as True/False

      Screen Shot 2015-09-09 at 10.29.59 PM
    9. Properties displayed as checkbox are named with a suffix _BOOL
    10. Automatic size calculation was also displayed as a column in BOM List EditorScreen Shot 2015-09-09 at 10.32.07 PM

Results:

  • The client experienced great usage of this custom ‘BOM List Editor’.
  • The sorting provision was used by clients to add Weight and Cost as properties and then sort to do a cost analysis.
  • The automatic size computation and editing capability helped them to understand certain size parameters [Ex: how much length should a certain pin be trimmed?]
  • User was able to assign part numbers at a later stage while generating the BOM with weight and cost which will be later used in their ERP system.


Write to us