Build the rule condition

On the Conditions tab, build the conditions for this rule as follows:

  1. On the Select Object tab, select the primary object. This is the object on which the exception count is based. Only one primary object may be selected for a rule. For this rule, the primary object would be Purchase Order.
  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. Click the Build Conditions tab.
  4. From the Select Template drop-down list select Math function Where clause.

    You may want to build your rule with just one group or multiple groups. A group is a set of conditions. Each group can have one or more conditions separated by an operator. Two or more groups are separated using the operator AND or OR. During analysis, Infor Risk & Compliance evaluates all the conditions in the first group sequentially and then the conditions in the second group depending on the operator.

  5. Under Value Set 1, left click Select Value. Use the autosuggest box or browse for the tables and fields required. For this rule, select the value Purchase Order ~ Purchasing Document Item Reference ~ Gross order Value in PO currency.
  6. Under Condition, left click Select Value. Use the autosuggest box or browse for tables and fields required. For this rule, select the value Purchase Order ~ Purchasing Document Item Reference ~ 'Delivery Completed' Indicator.  
  7. Right click Select Operator and select Does not equal.
  8. Left click Select Value. In the Literals & Dates & Logical tab, under the Null/Empty field, type Y click the OK icon.
  9. Right click on Condition to add condition. Another condition is added with an operator AND.
  10. Under the new condition, left click Select Value. Use the autosuggest box or browse for the tables and fields required. For this rule condition, select the value Purchase Order ~ Purchasing Document Type.
  11. Right click Select Operator to select Is any of.
  12. Under List, left click Select Value. In the Literals & Dates & Logical tab, use the auto suggest box or browse to select the attribute NB.
  13. Right click on List to add another attribute. Left click on the Select Value to add the attribute FO from the Literals & Dates & Logical tab.
  14. Right click on Condition to add condition. Another condition is added with an operator AND.
  15. Under the new condition, left click on Select Value. Use the autosuggest box or browse for tables and fields required. For this condition, select the value Purchase Order ~ Deletion Indicator in Purchasing Document.
  16. Right click on Select Operator to select Does not equal.
  17. Left click Select Value. In the Literals & Dates & Logical tab, under the Null/Empty field, type Y click the OK icon.
  18. Right click on Select Operator to select Greater than.
  19. Left click Select value under Value Set 2. In the Literals & Dates & Logical tab, type 0 and add click the OK icon.
    Note: For a math rule it is necessary to provide a comparison operator in the Value Set 2, failing to which the rule engine does not recognize the rule during analysis.