Variable for Unit Cost/Unit Price

In the Configure to Order Setup page, two separate variables can be configured to transfer formula-based values from Master BOM lines to generated BOM lines and sales documents (see Dynamic BOM FastTab):

Variable for Unit Cost: Specifies the variable whose calculated value is transferred to the Unit Cost (CC) field of Document BOM and Construction Line lines when the Master BOM is requested. If Variable for Unit Price is not configured, the same variable is also used to set the Unit Price on the Sales Line during Document BOM creation.
Variable for Unit Price: Specifies the variable whose calculated value is transferred to the Unit Price field of Document BOM, Construction Line, Service BOM, and Sales Line when the Master BOM is requested. When configured, this takes priority over Variable for Unit Cost for setting the Sales Line unit price.

The assignment of the variables is similar to the variable for components in the Master BOM lines. In the Formula Value field on the Master BOM Attributes page, enter a formula for price calculation that relates back to the variable on the checklist.

When the Master BOM is requested, the result of the calculation is transferred to the:

Unit Cost (CC) field in the Document BOM and Construction Line (via Variable for Unit Cost).
Unit Price field in Document BOM, Construction Line, and Service BOM lines (via Variable for Unit Price; if not configured or no matching attribute found, standard price calculation applies).
Unit Price field in the Sales Line during Document BOM creation (via Variable for Unit Price if configured; otherwise via Variable for Unit Cost if configured).

The Variable for Unit Cost field can also be used in the Assembly lines to calculate the Unit Cost using a formula.

Freeze Unit Price

When a value is transferred to the Unit Price field of a Document BOM or Construction Line by the Variable for Unit Price mechanism, the Freeze Unit Price field is set automatically on the line. When Freeze Unit Price is selected, the Update Unit Price process is skipped for that line – automatic unit price updates no longer apply.

If the Unit Price is entered manually on a line, the Freeze Unit Price field is also set automatically.

For Service BOM lines, the Unit Price is populated from the Variable for Unit Price mechanism but the Freeze Unit Price field is not available (no automatic protection against later updates).

For more information, see Document BOM and Construction Order.

Example: Variable for Unit Cost

In the following video, a checklist template is set up with a line for calculating a price factor. The line is set with Input Type = Integer and the Variable for Dynamic BOM value (CL_PRICE) for interacting with the dynamic Master BOM.

A Master BOM is set up with the item component. The Master BOM Attributes is set with the UNITCOST value from the Variable for Unit Cost field in the Configure to Order Setup page as well as the corresponding variable from the checklist (CL_PRICE) in the Formula Value field with a calculation for multiplying the input value by PI (3.1415926535).

To automatically calculate the unit price in the sales order, a Sales Line Attribute is added with the UNITCOST variable as well as the corresponding variable from the checklist (CL_PRICE) in the Formula Value field with a calculation for multiplying the input value by 5.

In the document checklist, a value of 3 is entered in the Input field. When the Document BOM is created, the system multiplies the value in the Input field by:

PI (3.1415926535), as defined in the Master BOM Attribute, and 9.42478 (rounded) is transferred to the Unit Cost (CC) field in the Document BOM.
5, as defined in the Sales Line Attribute, and 15 is transferred to the Unit Price field in the Sales Order line.

Table of Contents

Variable for Unit Cost/Unit Price

Freeze Unit Price

Example: Variable for Unit Cost

See Also