Skip to main content

SSP determination based on SO line group


SSP determination based on SO line group

Zuora Billing - RevPro Integration is in Limited Availability

In Zuora Billing scenarios, a percentage discount charge can be created after the regular charge is created. In RevPro, both the regular charge and the percentage discount charge are collected as individual sales order lines. However, the percentage discount charge line has an impact on the allocation of the revenue contract that contains the regular charge line. The allocatable value of the discount charge line determines whether the original regular charge line is within the SSP range or not, which has a significant impact on allocation.


To support this scenario, you can enable the Zuora Billing - RevPro Integration feature by setting the ZBILLING_INTEGRATION profile to Yes in Zuora Billing.

When the integration is enabled, SSP determination in RevPro is improved to derive SSP values based on a group of multiple SO lines. After the regular charge line is collected in RevPro as the original SO line, the discount charge can be collected as a separate SO line with being associated with the original SO line. Then, the net value between the original SO line and the associated discount SO line is considered for comparison to determine whether the original SO line is within the SSP range.

If the original SO line is eligible for allocation, the SSP derivation at the SO line level still follows the same processing logic when the integration is disabled. The SSP value for the discount charge line will be set to 0 during SSP allocation. For more information about SSP at the line level, see SSP setup.

The SSP_WITHIN_FV_GRP_BY_COL profile is also introduced in RevPro to support this scenario. You can use this profile to specify the name of the field or the combination of fields with concatenated values, which will be used to associate the discount charge line with the original regular charge line. The value from the profile DELIMITER used to concatenate the field specified.


In the following example, both the regular charge and the discount charge are collected in RevPro as SO transaction type. The SSP_WITHIN_FV_GRP_BY_COL profile is set to be Parent Charge. So, when the C-00002 discount charge line is collected in RevPro, it is associated with the C-00001 regular charge line based on the Parent Charge field value. The discount charge line provides a discount of $120 for the original regular charge line.

Billing Charge Type RevPro Transaction Type Charge# Parent Charge List Price Contractual Value
Regular SO C-00001   $1400 $1200
Discount -10% SO C-00002 C-00001   -$120

When SSP is to be determined and validated within the defined SSP range, the contractual values of all the associated lines are considered for the regular charge line to derive the net contractual value. In this example, the net contractual value is $1080, which equals $1200 minus $120.

The following SSP range is uploaded to RevPro, which is based on the percentage of list price.

Stratification Group Below % Mid Point Above %
License 70 85 100

Then, RevPro can derive the price range as follows. The regular charge line in this example is within the SSP range.

Charge # Net Contractual Value Below Price Midpoint Price Above Price
C-00001 $1080 $980 $1190 $1400

Then, if the SO line is determined to be eligible for allocation, only the regular charge line will participate in the SSP allocation. The SSP value of the discount charge line will be set to 0. For more information about SSP allocation for the regular SO line, see SSP setup.