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 Raw Materials 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 Raw Materials 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 Raw Materials 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 Raw Materials 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")