For each duplicate check rule, you can set up conditions. The duplicate check rule is only applied if the conditions are met.
To define a duplicate check rule condition, you use a query. The duplicate check rule is applied only to the records that are found by the query.
You can use these types of queries:
Inquiry: Use the standard D365 F&SCM Inquiry (SysQueryForm) page to define the records to which the duplicate check rule applies. The inquiry only queries the table as defined for the duplicate check rule.
Dynamic query: Use a dynamic query to define the records to which the duplicate check rule applies. Before you can set up a condition 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 duplicate check rule table, to define table relations, and to have only one record returned.
Flow diagram
Note
In the flow diagram, clicking ‘Set up dynamic queries’ opens the corresponding section under ‘General setup’.