Variable for Unit Cost/Unit Price
In the Configure to Order Setup page, an attribute for unit cost / unit price can be defined in the Variable for Unit Cost field (see Dynamic BOM FastTab). The assignment of the variables is similar to the variable for components in the Master BOM lines:
- For unit cost, 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.
- For unit price, in the Formula Value field on the Sales Line Attributes page, enter a formula for price calculation that relates back to the variable on the checklist.
When the Master BOM is requested in either the Document BOM or Construction Order, the result of the calculation is transferred to the:
- Unit Cost (CC) field in the Document BOM/Construction BOM.
- Unit Price field in the Sales line.
The Variable for Unit Cost field can also be used in the Assembly lines to calculate the Unit Cost using a formula.
Example
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.
See Also
Feedback
Submit feedback for this page .