Set up enrichment rule of type Data query

Prev Next

Use enrichment rules to set field values in D365 F&SCM.

To set a field value, you can use several value types. This topic explains how to set up an enrichment rule line of type Data query.

Use a data query enrichment rule line to find a value using a query and set the found value in the target field of the enrichment rule line.

Use a dynamic query to define the query that is used to find the value to be set in the target field. Before you can set up an enrichment rule line with a dynamic query, set up the dynamic query to be applied. You can use a dynamic query, for example, to query other tables than the enrichment source rule table, to define table relations, and to have only one record or value returned.

Flow diagram

Note

In the flow diagram, clicking:

  • ‘Set up dynamic queries’ opens the corresponding section under ‘General setup’.

  • ‘Set up enrichment rule conditions’ opens the corresponding section under ‘Set up enrichment rules’.