|
Process BOM Numeric Columns |
Scroll |
Sometimes when working with BOMs, it is necessary to perform certain arithmetic operations on the values in the BOM columns (for example, to automatically fill in the Cost column if the price and quantity of items are known).
The library is used to perform these actions (file komlib.rtw). It is included in the standard kit of KOMPAS-3D and doesn't require separate licence, connect the Service Tools library Then call the Applications — Service Tools — BOM operations — Numeric column processing command. The command can be called in subordinate mode when working with a specification.
To calculate values in columns connect the library Service tools, if it is not already connected. Then call the command Applications — Service tools — BOM Operations — Numeric column processing. The command can be called in subordinate mode when working with the BOM.
After calling the command, the Numeric columns and Variables columns are displayed in the Parameter panel.
The Numeric columns column lists the numeric columns of the active BOM (columns with the data type “Integer” or “Real”). The list includes both primary and secondary columns. Columns are grouped into sections that correspond to the sections of the BOM. The set of sections and the composition of columns in them depends on the style settings of the current BOM. The For all sections section is common and is displayed for BOMs of any style, but the composition of its columns also depends on the style.
The Variables column is used to enter variables that represent the values being entered and expressions for calculating the values being calculated. For example, if you designate the quantity and price of items as n and k, respectively, then to calculate the cost, you need to enter the expression «c=k*n».
To start processing numeric columns, click the Create object
button.
The BOM columns will contain the calculated values.The calculated values will be entered into the BOM columns.
|
To recalculate the values in the columns (for example, after changing the source data), you need to re–invoke the Processing numeric columns of BOM command. |