Examples of Custom BOM Reports

This section provides examples of customizing BOM Reports. These simple examples supplement the concept described in section Configuring BOM Reports.

In this example, the Multilevel BOM Report is customized. Using the following procedure, the Unit column is added between the Quantity and AML Status columns to display the Unit property of Part Items:

1. Search for the PE_multilevelReport Query Definition (QD) and open its item view for editing.

2. Click Show Editor on the PE_multilevelReport QD sidebar.
3. Click the Properties button on the top RootPart row. The Properties dialog box appears.

4. Add the Unit property to the Properties dialog box and click Save.

1. Repeat steps 3-4 on the Part row representing the Part Query Item.

1. Click Save, Unlock & Close on the PE_multilevelReport QD toolbar.
2. Search for the Multilevel BOM Report and open its Item view for editing.
3. Go to the Stylesheet editor tab.

9. Add the <th>Unit</th> table header cell element after <th>Quantity</th>.

1. Add a table data cell element for the unit property values after the one for quantity. <td rowspan="{$rowCount}" width="120px"> <xsl:value-of select="unit"/> </td>

1. Click Apply on the Stylesheet editor tab.
2. Click Done on the Multilevel BOM Report toolbar. The Unit column is added to the Multilevel BOM Report.

In this example, the BOM Costing Report is customized. Using the following procedure, the Reference Designator column is added as the last column to display the Reference Designator property of the Part BOM Relationship ItemType:

1. Search for the PE_costingReport Query Definition (QD) and open its item view for editing.

2. Click Show Editor on the PE_costingReport QD sidebar.
3. Click the Properties button on the Part BOM row. The Properties dialog box appears.
4. Add the Reference Designator property to the Properties dialog box and click Save.

1. Click Save, Unlock & Close on the PE_costingReport QD toolbar.
2. Search for the BOM Costing Report and open its Item view for editing.
3. Go to the Stylesheet editor tab.
4. Add the <th> Reference Designator</th> table header cell element after <th>Cost Basis</th>.

1. Add a table data cell element for the reference_designator property values after the one for cost_basis. <td> <xsl:value-of select="Relationships/Item[@alias='Part BOM’ and @info='parent’]/reference_designator"/> </td>

<td rowspan="{$rowCount}" width="120px"> <xsl:value-of select="Relationships/Item[@alias='Part BOM’ and @info='parent’]/property_name"/> </td>

1. Click Apply on the Stylesheet editor tab.
2. Click Done on the BOM Costing Report toolbar. The Reference Designator column is added to the BOM Costing Report.

In this example, the BOM Costing Report is customized. Using the following procedure, the Sequence column is added as the last column to show the Sequence property of the Part BOM Relationship ItemType:

1. Search for the BOM Costing Report and open its Item view for editing.

2. Go to the Stylesheet editor tab.
3. Add the <th> Sequence</th> table header cell element after <th>Cost Basis</th>.

1. Add a table data cell element for the sort_order property values after the one for cost_basis. <td> <xsl:value-of select="sort_order"/> </td>

<td rowspan="{$rowCount}" width="120px"> <xsl:value-of select="sort_oder"/> </td>

1. Click Apply on the Stylesheet editor tab.
2. Click Done on the BOM Costing Report toolbar. The Sequence column is added to the BOM Costing Report.