Create RC grouping template
Create and configure an RC grouping template in Zuora Revenue to organize transaction lines into revenue contracts.
Complete the following steps to create and configure an RC grouping template in Zuora Revenue:
- From the main menu, navigate to Policies > RC Grouping Template .
- On the RC Grouping Template page, to create an RC grouping template, click the add new icon. The New Grouping Template window is displayed.
-
In the Definition tab, provide the following information and then click the save icon.
The RC grouping template is created.
- A unique name for the new template in the Template Name field (Required).
- The effective start date of the template in the Start Date field.
- A relevant processor from the Stage Processor list.
- A short description of the template.
-
To configure the grouping rules, complete the following steps in the
Primary Grouping Rules
section:
- In the Grouping Rules section, click to add a row.
- Enter a rule name in the Rule Name column.
- Click the Group By column. The Edit Grouping Criteria window is displayed.
- Select appropriate fields from the Available Fields list and click the right arrow icon to add them to the Selected Fields list. You can add as many fields as you want. The Sales Order Number is typically used along with other fields based on the business need. Only when the transaction lines have the same values for all the selected fields, they will be grouped together into one revenue contract.
- Close the Edit Grouping Criteria window.
-
In the
Duration Type
column, select the duration when this grouping rule is effective.
If you select
Day(s)
in the
Duration Type
column, also select the base date in the
Duration Field
column and specify the number of days in the
Duration
column.
For example, you can specify that this grouping rule is valid within 30 days after the Sales Order date, where Zuora Revenue is preset to count from the earliest Sales Order date within the revenue contract. This grouping rule will not be applied to any data that comes into Zuora Revenue outside the specified duration.
Note:
- If the RETAIN_SO profile value is set to Yes, it will override the time-based grouping. The subsequent line of a sales order line will always be grouped into the contract where the sales order line exists, and the grouping criteria are not going to be considered by the system.
- If the RETAIN_SO profile value is set to No, the group by functionality will not check the sales order number and will always have one entry for the revenue contract. Previously, the system considered the sales order line number for the revenue contract.
- To enable this grouping rule, make sure that the Enabled column is set to Yes .
- Click the save icon to save the grouping rule.
- Repeat the above steps to add as many grouping rules as you need.
- To set up a hierarchy of the grouping rules, organize the order in which the grouping rules are to be applied by editing the number in the Seq column.
- Click the save icon to save your configuration.
-
(Optional): To set secondary RC grouping rules, complete the following steps on the
Definitions
tab:
- Toggle the Secondary Grouping Rules switch to Yes .
- Select one field from the Associated Contract Reference list. A common selection is SO Number . When a contract modifying line comes, the system will examine the value for the selected field to determine whether there is an existing contract where the contract modifying line belongs. If yes, the contract modifying line will be grouped into the contract. Otherwise, the system will apply the primary grouping rules to group the line.
- Select one grouping option for the circumstances when the system identifies multiple contracts by examining the associated contract reference values for the contract modifying order lines.
-
(Optional): To filter the incoming data to which the current grouping template is to be applied, complete the following steps on the
Filters
tab:
- Click the '+' icon to add one filter.
- Select the filed name, operator, and operand to create the filter criteria.
- Make sure the Enabled column is set to Yes .
- Click the '+' icon to add as many filters as you need.
- Click the save icon to save your configuration.
-
(Optional): To set up the SSP hierarchy, complete the following steps on the
SSP Hierarchy
tab. For information about SSP setup, see SSP Setup
.
- Click the add new icon to add a hierarchy.
- Select appropriate values for SSP Template, SP Below Range, SP Above Range, and SP Within Range columns.
- Make sure the Enabled column is set to Yes.
- Click the add new icon to add as many hierarchies as you need.
- To organize the order in which the SSP hierarchies are to be applied, edit the number in the Seq column.
- Click the save icon to save your configuration.
The RC grouping template is created. When transaction data is uploaded to Zuora Revenue, Zuora Revenue will filter and group the transaction lines into revenue contracts based on the RC grouping template.