Build the rule condition

This condition enables you to compare records based on the field Tax Number 1 to identify duplicates and to exclude any records where the value in the Tax Number field is NULL or EMPTY.

Build conditions for this rule as follows:

  1. On the Select Objects tab, select 'Vendor Master' as the primary object.
  2. Select the other objects that will participate in the rule condition. It is not mandatory to select other objects as they are not the cause of the exceptions.
  3. Select the check box Check Duplicate Objects.
  4. In the Select Template field, select Default Template.
  5. Click the Build Conditions tab.
  6. On the Duplicate Object Conditions panel next to Tax Number 1, select  Exact Match. This enables the rule engine to search for vendors with identical tax numbers.
  7. To build the first condition, left click Select Value under Value Set 1. Browse and select objects and operators as listed in the table below.
  8. To build other conditions, right click the Condition 1 and select Add Condition, to add other rule conditions. The objects and the operators to be added to these conditions are listed in the table below:

    Select values and operators as listed in the table below:

    Condition Value Set 1 Operator Value Set 2 Comments
    Condition 1 Vendor Master ~Tax Number 1 is none of
    • NULL
    • EMPTY
    		All false positive records, that is vendor masters with Null or EMPTY records are not considered in the analysis
    Condition 2 Vendor Master 1~Tax Number 1 Is none of
    • NULL
    • EMPTY
    		Select the check box Use Alias. This creates a virtual table against which the records are compared.
    Condition 3 Vendor Master~Central Deletion Flag for Master Record Does not equal Select Y from the Literals and Logicals tab. This means that only those records that are present in the ERP system are considered in the analysis. The deleted records are not considered.
    Condition 4 Vendor Master 1~Central Deletion Flag for Master Record Does not equal Select Y from the Literals and Logicals tab. This means that records from the alias (virtual) table that are not deleted from the ERP system are considered in the analysis.
    Condition 5 Vendor Master~Created By Reference~Person ID Does not equal Select NULL  from the Literals and Logicals tab. This means that the Vendor master records that do not have a valid creator ID are not considered in the analysis.
    Condition 6 Vendor Master 1~Created By Reference~Person ID Does not equal Select NULL  from the Literals and Logicals tab. This means that the Vendor master records from the alias (virtual) table that do not have a valid creator ID are not considered in the analysis.

  9. Click Save.

    When an analysis is performed using this rule, all vendors with identical tax numbers and with valid creator Reference IDs are displayed as exceptions. Vendors deleted from the ERP system are not considered in the analysis, so they are not displayed as exceptions.