Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Creating Data Enrichment and Validation Rules

You can use the Purchase Order Admin (PO Admin) user interface to create and manage Data Enrichment and Validation rules for your Customer Purchase Orders.

A Data Enrichment and Validation Ruleset defines the target object (Customer PO or Customer PO Item), the source object (Quote/Proposal, Contract, Order, Proposal Line Item, Agreement Line Item, or Order Line Item), the criteria to be applied to the target and source objects, and any additional filter logic. When criteria for a ruleset is fulfilled, the Enrichment and Validation Rules defined in the ruleset are triggered and any actions specified in its rules are executed. Perform the following task to create a Data Enrichment and Validation Ruleset and its rules.

Note:

Do not click your browsers "Back" button when using the PO Admin.

To create Enrichment and Validation rules using the PO Admin

  1. Navigate to the PO Admin tab. The Customer Purchase Order Admin page is displayed.
    Note:

    If you cannot find the PO Admin tab, your administrator must add the tab in Salesforce. Refer to the Order Management for Administrators for steps.

  2. From the upper right-hand corner in the header, click Create New Rule.
    The Data Enrichment and Validation Setup wizard is displayed.
  3. Enter a Ruleset Name and the Sequence, which indicates the order in which this ruleset will be validated on confirmation of the customer purchase order (starts at "1").
  4. From the Target Object To Validate drop-down, select either Customer Purchase Order or Customer PO Item.
  5. If you selected Customer PO Item as the object to validate, click the Target Object Parent drop-down and select Customer Purchase Order.
  6. From the Source Data Object drop-down, select the source object on the price agreement you want to match to the customer purchase order.
  7. Click Next to display the Specify Target Data Filter Criteria screen.
  8. Click Add and define filter criteria to be applied to the target Customer PO or PO Item:
    1. Select a Field on the Target object (for example, Status).
    2. Select an Operator.
    3. Enter or select a Value for the field (for example, Draft. In this case, whenever the system finds a status in Draft, the rule is triggered for the Customer Purchase Order).
  9. Click Add to add another filter to the target and repeat step 8. You can remove defined filter criteria by clicking the Delete icon ().
  10. Add any Filter Logic as needed.
  11. Click Next to display the Specify Source Data Filter Criteria screen.
  12. Click Add and define the filter criteria to match a field on the source object (Quote/Proposal, Proposal Line Item, Agreement, Agreement Line Item, Order, or Order Line Item) with a field on the Customer PO or PO Item, or to validate a field on the source object against a field on the Customer PO or Customer PO Item:
    1. Select a Field on the Source object (for example, Proposal Line Item).
    2. Select an Operator.
    3. To match a field on the source object with a field on the Customer PO, click the Value Type drop-down and select Field Value. Then select one or more values from the Target Field drop-down.
    4. To validate a field on the source object against a field on the Customer PO, click the Value Type drop-down and select Constant. Enter the value for the field on the target object.
  13. Click Add to add another filter to the target and repeat step 12. You can remove defined filter criteria by clicking the Delete icon ().
  14. Click Save and Close to save the ruleset or click Next to display the Specify Enrichment Rules screen.
  15. Define an Enrichment rule to set a value on the Customer PO or PO Item to a value from the selected Source Object field:
    1. Select the Target Object Field (for example, Contract Item Number).
    2. Select the Source Object Field (for example, Record ID).
    3. Click the toggle to make the field a required field on the Customer Purchase Order or PO Item.
    4. Enter the Message to be displayed to the user when an error occurs (for example, when either the target or source object field is not found).
  16. Click Add to add another rule to the ruleset and repeat Step 15. You can remove a rule by clicking the Delete icon ().
  17. Click Save and Close to save the ruleset or click Next to display the Specify Validation Rules screen.
  18. Define a Validation rule to validate a value in the CPO or PO Item against the master data in the Source object field:
    1. Select the Target Object Field (for example, Quantity).
    2. Select the Match Operator (for example, "less than or equal to").
    3. Select the Source Object Field (for example, Quantity (2)).
    4. Select the Error Type to be triggered when the rule does not evaluate to true: Warning or Error.
    5. Enter the Message to display to the user when an error occurs.
  19. Click Add to add another rule to the ruleset and repeat step 18. You can remove a rule by clicking the Delete icon ().
  20. Click Next to display the Review screen. You can review the entire Data and Enrichment Validation Rule Setup on this page. If you need to make any changes, click Previous to return to the appropriate step.
  21. Click Done to save the ruleset and return to the PO Admin page.
  22. Click Activate to activate the ruleset.
    Note:

    When a rule is executed and any errors are found, they are recorded in the log.