Build the rule condition

Build conditions for this rule as follows:

  1. On the Select Objects tab, select 'Item 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 Description and Item Group, select the option Exact Match. This enables the rule engine to search for items with identical description or item group. For all the other fields, select the option Do Not Check.
  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
    Condition 1 Item Master ~ Item Master ~ Description is none of
    • NULL
    • EMPTY
    Condition 2 Item Master 1~Item Master ~ Description Is none of
    • NULL
    • EMPTY
    Condition 3 Item Master ~ Item Master ~ Item Group Is none of
    • NULL
    • EMPTY
    Condition 4 Item Master1 ~ Item Master ~ Item Group Is none of
    • NULL
    • EMPTY
    Condition 5 Item Master ~Item Master ~ Item Does not equal Item Master 1~Item Master ~ Item
    Condition 6 Item Master ~Item Master ~ Item Location Reference ~ Company Equals Item Master 1 ~Item Master ~ Item Location Reference ~ Company
    Condition 7 Item Master ~Item Master ~ Item Location Reference ~ Company Does not equal Null
    Condition 8 Item Master 1 ~Item Master ~ Item Location Reference ~ Company Does not equal Null
    Condition 9 Item Master ~Item Master ~ Active Status Exactly matches A
    Condition 10 Item Master 1 ~Item Master ~ Active Status Exactly matches A

    Click Save.

    When an analysis is performed using this rule, all item masters having exact values or having values as NULL or empty are displayed as exceptions. Items deleted from the ERP system are not considered in the analysis, so they are not displayed as exceptions.