For Data Entry Workflow, an integration is available to Data quality studio.
The Data Entry Workflow-Data Quality Studio integration is automatically activated if Data Quality Studio is installed in the same environment as Data Entry Workflow.
General data quality check
When the Data Entry Workflow-Data Quality Studio integration is active, the applicable data quality policy rules are applied automatically to data entry workflows.
By default, if you run a data entry workflow, all active data quality policy rules that exist for the tables in the data entry workflow are applied. However, if, for a data entry workflow template, specific data quality policies are defined, only these data quality policies are applied when you run a data entry workflow.
These data quality policy rules can be applied:
Rule type | Description |
|---|---|
Validation rule | A validation rule checks if the data is in line with the defined standards. When a validation rule is applied depends on the validation rule event setup:
|
Duplicate check rule | A duplicate check rule checks if the data doesn't already exist in a table. For a data entry workflow, duplicate check rules of type 'Basic matching' are applied when entered data is transferred from the staging table to the applicable target tables. This can be for a task with Transfer to target enabled or for the last task of the data entry workflow. To have duplicate checks done earlier, you can indicate if duplicate checks must be done for an earlier step. If you have enabled duplicate checks for a step and a related task is completed, all applicable duplicate checks are done. The applicable duplicate checks are the ones that apply to the tables and fields for which data is entered so far in the data entry workflow. If duplicate checks are applicable for a step, on task completion, these checks are done:
|
Enrichment rule | An enrichment rule sets a field value in a target field in D365 F&SCM. When an enrichment rule is applied depends on the enrichment rule event setup:
|
Note
If no active data quality policy rules exist for the tables of a data entry workflow, no data quality policy rules are applied.
Fuzzy duplicate check
In Data Quality Studio, you can set up and use a fuzzy duplicate check. This option checks for duplicates applying fuzzy logic. A fuzzy duplicate check compares values from several fields. Based on the comparison, a duplicate score is calculated.
If Data quality studio is installed on the same environment as Data entry workflow, you can apply a fuzzy duplicate check in Data entry workflow.
For each data entry workflow template, you can define a fuzzy duplicate check step. Use a fuzzy duplicate check step to automatically check if the data, as entered in the previous workflow tasks, is a possible duplicate record.
During data entry workflow execution, for a fuzzy duplicate check step, the fuzzy duplicate check is done automatically. As a result of the fuzzy duplicate check, it can be that:
No possible duplicates are found. In this case, when the fuzzy duplicate check is finished, the data entry workflow is continued automatically.
Possible duplicates are found. In this case, the assigned user gets a task to compare the entered data with the found possible duplicates. To solve duplicate issues, you can merge field values from the found duplicate records to the entered record. The entered record is called the master record. For more information on merging duplicates, refer to Check for, review, and merge duplicates.
For each fuzzy duplicate check step, define which options a user has when possible duplicates are found:
Approve: You can approve that the newly entered data is not a duplicate. When you click Approve, the data entry workflow is continued.
Delegate: You can assign the possible duplicates evaluation task to another user.
Reject: You can reject the newly entered data because it is a duplicate. When you click Reject, the data entry workflow is canceled.
During data entry workflow execution, first merge field values from the found duplicate records to the master record. When merging is finished, click the applicable option: Approve, Delegate, or Reject.
Configurable lookups
In Data quality studio, you can set up a configurable lookup to define the possible options in a field.
A configurable lookup can be one of these types:
User defined list: The desired options are set up manually.
Dynamic query: A dynamic query is used to define the desired options.
Web service: A web service is used to define the possible options.
In Data Quality Studio, you can apply a configurable lookup in a data quality policy, in a validation rule of type Configurable lookup.
In a data entry workflow template, you can add a field for which a validation rule with a configurable lookup exists in Data Quality Studio. If the data quality policy is active, on a workflow task, the configurable lookup is applied automatically to the field. Also, the validation rule conditions for the configurable lookup are considered.