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. From the Primary Object drop-down list of the Select Object tab, select Purchase Order Master. Other objects are not selected for this sample rule.
  3. Click the Build Conditions tab to add the conditions listed in the table below.

    To build this rule condition, you have the option of selecting rule templates from the Select Template drop-down list. For this rule you can select one of the following templates:

Default template

  1. Under Value Set 1 of condition 1, right click Select Value and select Replace with Math Function > Sum of
  2. Under Value Set 1, click Select Value and select value as listed in the table below.
  3. Right click Sum of and select Add Where Clause.
  4. Click Select Operator and select the operator as listed in the table below.
  5. In the same way, select values and operators for other conditions.
  6. Click Save to save the rule condition or click Save and Close to exit after saving the rule condition.
    Condition Value Set 1 Operator Value Set 2
    Condition 1 (Math function) Purchase Order Master ~ Tot-prd-amt    
    Condition 2 Purchase Order Master ~ Closed-fl Exactly matches From the Literals and Dates & Logicals tab, add N.
    Condition 3 Purchase Order Master ~ Cancelled-fl Exactly matches From the Literals and Dates & Logicals tab, add N.
    Group by Purchase Order Master ~ Company    

Math function - where clause

For building the rule condition with this template,

  1. Click Select Operator and select the operator as listed in the table above.
  2. In the same way, select values and operators for other conditions.
  3. Click Save to save the rule condition or click Save and Close to exit after saving the rule condition.

    When an analysis is performed using this rule, the total amount of open purchase orders is displayed on the Exceptions browser. Click the amount  to view all the open purchase orders and their details.