Lawson Inventory Insight - Duplicate rule

Duplicate type rules are created when you need to view duplicate data. Data analyzed using these rules generate exceptions only if duplicate data exists.

Duplicate type rules can be created in one of the following ways:

  • By providing the same value set while building the rule condition on the Conditions > Build Condition tab.
  • By selecting the check box Check Duplicate Objects on the Conditions > Select Objects tab.

Provide the Same Value Set

This type of duplicate type rule can be created by providing the same value set while building the rule condition in the Build Condition tab of the Conditions tab.

Check Duplicate Objects

This type of duplicate type rule can be created by selecting the Check Duplicate Objects check box on the Select Objects tab on the Conditions tab. When you select this check box, a template to build the rule condition is displayed on the Build Condition tab.

The template lists all the fields of the selected primary object. You can select one of the following options to build the duplicate rule.

  • Exact Match: Select this option to view exactly matching data. For example, two or more vendors with exactly matching tax ID.
  • Fuzzy Match: Select this option to view partially matching data. For example, two or more vendors with fuzzy matching tax ID. This option is available only for String Data types.
  • Do Not Check: IDs marked Do not Check will not be considered in rule condition.
Note: When building a duplicate type rule with fuzzy match criteria, select the Fuzzy Match option next to the required field in the template above. If, however, you do not want to use a template but create a manual fuzzy condition, the condition using the fuzzy logic should be added at the end of the condition.

Sample Duplicate type of rule for  Inventory Insight for Lawson

This rule helps you identify duplicate items that may cause data integrity issues and can adversely affect purchase requisitions, purchase orders, production orders and inventory costs.

  • Rule Book Name: Lawson Inventory Process Insight rules
  • Rule Control Number: Lawson-INVENTORY-003
  • Rule Name: Duplicate items - exact match on item description
  • Rule Type: Process Rule (Duplicate)
  • Primary Object: Item Master
  • Build the rule condition

Reporting Fields

Click the Reporting Fields tab to select additional fields you want displayed in the Business Process Exceptions report as well as the order in which these fields are to be displayed on the Exceptions browser.

The Rule Summary tab enables you to provide high level information about the reason for the exceptions generated by the primary object in a rule. This information is displayed on the third level of the Exceptions page.