Build the rule condition

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

  1. On the Conditions tab, click Add/Edit Rule Conditions to build the rule conditions. A pop-up window is displayed with the Select Objects tab open by default.
  2. 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 'PO Receivers'.
  3. 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.
  4. Click the Build Conditions tab. 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. Select Template as Math function
  6. Right click Select Value under Value Set 1.
  7. Point the cursor to Replace with Math Function. All the available math functions are displayed.
  8. Select Date Difference of. The math function Day appears on the screen.
  9. Click Select Value. Use the autosuggest box or browse for the tables and fields required.
  10. For this rule select the table Shipment Header.
  11. Select the table Creation Date
  12. Click Select Value again. Use the autosuggest box or browse for the tables and fields required.
  13. For this rule select the table Billing Header.
  14. Select the table Creation Date
  15. Right click Date Difference to add the Where clause.
  16. Provide conditions as listed in the table below with the condition AND.
  17. Select values and operators as listed in the table below:
    Condition Value Set 1 Operator Value Set 2
    Condition 1 Shipment Header~ Shipment Item Reference~Sales Order ID Exactly Matches
    • Billing Header~Billing line Reference~Sales Order ID
    Condition 2 Shipment Header~Creation Date Before
    • Billing Header ~Creation Date
    Condition 3 Shipment Header~Accounting Entity of Shipment Exactly Matches
    • Billing Header~ Accounting entity of billing ID
    Condition 4 Shipment Header~Creation Date Not on
    •  Null
    Condition 5 Billing Header~Creation Date Not on
    •  Null
  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 10 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.