Read Document BOM Attributes in Sales Lines with GETBOMVALUE

In a Sales Line Attribute for which Calc. after Line is selected, the GETBOMVALUE(<VarName>) function reads the value of an attribute from the Document BOM created for the sales line, regardless of the BOM level the attribute is assigned to. Enter the attribute code as the parameter, or, in the Formula Editor, choose the GETBOMVALUE action to open a lookup on the Variable/Attribute Types page and insert the function call automatically.

GETBOMVALUE searches the Document BOM components by attribute code only; it does not filter by BOM level, so an attribute on any level can be returned. It returns a single matching attribute value (its numeric value and, where used, its alphanumeric value). Use an attribute code that is unique within the Document BOM: if the same code exists on more than one component, which component's value is returned is not guaranteed. If no component has a matching attribute, GETBOMVALUE returns 0.

Note

GETBOMVALUE can only be used in a Calc. after Line formula on a Sales Line Attribute, and only takes effect when the Document BOM is created for the sales line. Using GETBOMVALUE in a Calc. after Line formula on a Construction Line Attribute or Service BOM Line Attribute results in an error, because the function is not available in those Calc. after Line evaluation contexts.

See Also

Assignment and Use of Attributes and Variables

Feedback
Submit feedback for this page .