Retrieving materials
Use these formats to retrieve materials.
INGRMULTI
Retrieves unexploded materials
INGRMULTIRM
Retrieves materials and exploded raw materials. This is the same as selecting Explode to Constituents on the Item Contributions form.
INGRMULTINM
Retrieves materials and non-materials. This is the same as selecting Display Non Materials on the Item Contributions form.
INGRMULTINMRM
Retrieves raw materials and non-materials. This is the same as selecting Explode to Constituents and Display Non Materials on the Item Contributions form.
This script retrieves the materials in a formula BOM. It shows the same information as the Item Contribution form.
Dim BOMXML As String = ObjectXML("FORMULAADJUST", _ObjectKey,
"HEADER;INGRMULTI")
This script retrieves the exploded materials in a formula BOM. It shows the same information as when you specify Explode to Constituents on the Item Contribution form.
Dim BOMXML As String = ObjectXML("FORMULAADJUST", _ObjectKey,
"HEADER;INGRMULTIRM")
This script retrieves the material and non-materials items in a formula BOM. It shows the same information as when you specify Display Non-Materials on the Item Contribution form.
Dim BOMXML As String = ObjectXML("FORMULAADJUST", _ObjectKey,
"HEADER;INGRMULTINM")
This script retrieves the exploded materials and non-materials items in a formula BOM. It shows the same information as when you specify Explode to Constituents and Display Non-Materials on the Item Contribution form.
Dim BOMXML As String = ObjectXML("FORMULAADJUST", _ObjectKey,
"HEADER;INGRMULTINMRM")
You must include a format code and a parameter type to retrieve parameters. For example, INGRMULTI
retrieves the material ingredients, but you must request “INGRMULTI.A\PARAM ROLLUP”
to see the rollup parameters.
Dim BOMXML As String = ObjectXml("FORMULAADJUST", _objectKey,
"INGRMULTI.A\PARAM ROLLUP")
You can specify "INGRMULTI.A\PARAM COST"
to retrieve the cost parameters.
Dim BOMXML As String = ObjectXml("FORMULAADJUST", _objectKey,
"INGRMULTI.A\PARAM COST")