The columns to be displayed in the BOM on the drawing are defined on the BOM columns form. You can choose existing Isah fields as the columns, or you could use a script to fill columns with other data originating from Isah.
Fields
It is possible to include a line with additional information in the BOM on the drawing, to allow you to display more text in the BOM. Examples include a memo text with an assembly instruction, such as 'Fit gasket when dry'. To do so, select the Additional line check box. Only one field per BOM can be marked as an additional line.
The position in the list of columns determines the starting column for the additional line.
Examples
If the additional line is the first in the list, the line will appear at the top of the BOM over the full width.
Line number |
Quantity |
Description |
Assembly instructions: Fit gasket when dry |
||
10 |
5 |
Part A |
20 |
10 |
Part B |
30 |
5 |
Part C |
If the additional line is the second in the list, the line will appear below all columns, starting from the second column.
Line number |
Quantity |
Description |
|
10 |
5 |
Part A |
|
20 |
10 |
Part B |
|
|
Assembly instructions: Fit gasket when dry |
||
Note: Additional lines can be specified only if there is a link with AutoCAD.
You can choose existing Isah fields as the columns, or you could use a script to fill columns with other data originating from Isah. To use an existing Isah field for the column, select 'Field'. To control the contents of a column using a custom script, select 'Script'.
If you selected 'Field' in the Field type field, select the field that is to supply the contents for the column in the BOM on the drawing. The fields you can choose from depend on the settings made on the BOM definitions form.
If you selected 'Script' in the Field type field, enter the script that controls the contents of the column in the BOM on the drawing. The script can be executed only if it contains the following input parameters: IsahTableId, IsahPrimKey, and BomLineNr. Parameters allow you to retrieve additional information. The result of the script is the value shown in the cell of the column in the BOM. Please bear in mind that a script will be executed for every line, which may slow down the performance of Isah.
Example
To display the dimensions in the table, create a script such as the one below, to retrieve the part length, width and height. Also define the format in the script. If the dimensions of a part are 10.5 x 40.0 100.0 mm (LxWxH), the result will be '10.5x40.0x100.0'. This value is placed in the column for the part line in the BOM.
function Dimensions(IsahTableId, IsahPrimKey, BomLineNr)
Dim lQueryStr
Dim lQuery
Dim lDimension
lDimension = ""
lQueryStr = "SELECT Length,Width,Height FROM T_BillOfMat WHERE PartCode = '"& IsahPrimKey & "' AND BomLineNr = " & BomLineNr
Set lQuery = Application.Database.CreateQuery ( lQueryStr )
lQuery.Open
if lQuery.Fields.Count > 0 then
lDimension = lQuery("Length").Value & "x" &_
lQuery("Width").Value & "x" &_
lQuery("Height").Value
End if
lQuery.Close
Dimensions = lDimension
end function
If you selected 'Script' in the Field type field, enter the name of the function within the script that will determine the value of the column for the part line. If you leave this field blank, the function name 'Main' will be used.
In the Title field, enter the column name as you want it displayed in the BOM on the drawing.
Use the Horizontal alignment field to set the text alignment in a cell, for example 'Left' or 'Center'. Not all CAD applications support this option.
Use the Vertical alignment field to set the text alignment in a cell relative to the top and bottom of the cell, for example 'Top' or 'Center'. Not all CAD applications support this option.
Enter the width of the column. The unit depends on the CAD application, however.
Change the order of the columns. Click the icons to move the columns. Clicking
will move the column one position up in the list, and one position to the left in the BOM on the drawing. Clicking
will move the column one position down in the list, and one position to the right in the BOM on the drawing. The icons are available only if the Edit mode is disabled.
Additional line