Transaction Rating Before Billing

The system provides the flexibility to rate the transaction legs either prior to billing or during billing. Based on the business requirements, you can configure the system such that transactions mapped to some price items can be rated at a frequency which is different than the account's billing frequency. For example, daily, weekly, etc. This will help to reduce the performance issues which are caused when large volume of transactions are rated at the time of billing.

The system offers the following ways in which a transaction leg can be priced, rated and billed:

  1. Rate the Transaction Leg During Billing - In this approach, you can use either of the following ways:

    1. Determine effective pricing for a transaction leg, create a billable charge for the transaction leg, and then determine the rate during billing.

    2. Determine effective pricing for a transaction leg, create a billable charge for aggregated transaction legs, and then determine the rate during billing.

  2. Rate the Transaction Leg Prior to Billing - In this approach, you can use either of the following ways:

    1. Determine effective pricing and rate for a transaction leg, and accumulate pre-calculated charges in a pass through billable charge based on the distribution code, currency code, description on bill, aggregation parameter group ID (which is created based on the rate component characteristics). The pass through billable charge is then billed during billing.

    2. Determine effective pricing for a transaction leg, aggregate the transaction legs, determine rate for aggregated service quantities, and then accumulate pre-calculated charges in a pass through billable charge based on the distribution code, currency code, description on bill, aggregation parameter group ID (which is created based on the rate component characteristics). The pass through billable charge is then billed during billing.

    3. Determine effective pricing and rate for a transaction leg and create a pass through billable charge for the transaction leg which is billed during billing.

  3. Ignore the Transaction Leg for Billing - In this approach, you can use either of the following ways:

    1. Determine effective pricing for a transaction leg, but the billable charge is not created for the transaction leg.

    2. Determine effective pricing and rate for a transaction leg, but the billable charge is not created for the transaction leg.

Note:

Once the rate is determined for transaction legs, a set of rate component characteristics and their values are grouped. For example, if a price assignment has the following rate components, the system creates two groups - Group A and Group B:

  • RC1, Char1=Y, Char2=Y

  • RC2, Char1=N, Char2=Y

  • RC3, Char1=Y, Char2=Y

Group A contains Char1=Y, Char2=Y and Group B contains Char1=N, Char2=Y. These groups are used for accumulating pre-calculated charges. A unique aggregation parameter group ID is generated for each group. If a group with a set of rate component characteristics and their values already exists in the system, a new group is not created. Instead, the existing group is used for accumulating pre-calculated charges. The aggregation parameter group ID is created when you attach an algorithm of the C1_​RTCL_​POPC algorithm type on the TFM - Rate Post-Processing algorithm entity in the Algorithms tab of the Division screen. Note that the system invokes the algorithm which is attached on the derived account's division and not on the division to which the transaction belongs.

While defining a price item pricing, you need to specify the rating criteria which indicates how and when you want to the rate the transaction legs. The valid values are:

  • Do Not Rate Transactions (DNRT)

  • Aggregate transactions and then rate aggregated SQs (AGTR)

  • Rate individual transactions and aggregate calc lines across transactions (RITA)

  • Rate Transactions (RITX)

Along with the Rating Criteria field, the Ignore Transaction and Aggregate Transaction fields help the system to determine how and when the corresponding transaction leg must be rated. The following table indicates how to configure the system in order to use the above mentioned ways:

Transaction Rating Approach and Way Ignore Transaction (Yes or No) Aggregate Transaction (Yes or No) Rating Criteria Batch in which the Rate is Determined
3a Yes Not applicable Do Not Rate Transactions (DNRT) Not applicable because ignored transactions are not considered for billing.
3b Yes Not applicable Rate Transactions (RITX) Update Status (C1-TXNEX)
1b No Yes Do Not Rate Transactions (DNRT) Not applicable because the rate is determined during billing.
2b No Yes Aggregate transactions and then rate aggregated SQs (AGTR) Service Quantity Calculation (C1-TXNSQ)
2a No Yes Rate individual transactions and aggregate calc lines across transactions (RITA) Update Status (C1-TXNEX)
1a No No Do Not Rate Transactions (DNRT) Not applicable because the rate is determined during billing.
2c No No Rate Transactions (RITX) Service Quantity Calculation (C1-TXNSQ)

Let us understand the following transaction rating ways with the help of an example:

  • 2a

  • 2b

  • 2c

The following table lists the account, price item, and price item parameters combination to which transaction T1 and T2 are mapped:

Transaction Transaction Volume Transaction Date Account Price Item Price Item Parameter Group ID Price Assignment ID Aggregation Schedule
T1 300 01/01/2015 A1 P1 PG1 PA1 Monthly
T1 300 01/01/2015 A2 P1 PG1 PA2 Monthly
T2 200 15/01/2015 A1 P1 PG1 PA1 Monthly
T2 200 15/01/2015 A3 P1 PG1 PA3 Monthly

The following table lists the rate components available on the PA1, PA2, and PA3 price assignments:

Transaction Price Assignment ID Rate Component Currency Code Distribution Code Description on Bill Aggregation Parameter Group ID (Rate Component's Characteristics)
T1 PA1 RC1- 0.1*Transaction Volume USD BK-AR1 XYZ Char1=Y
T1 PA1 RC2- 0.2*Transaction Volume USD BK-AR2 ABC Char2=Y
T1 PA2 RC3- 0.3*Transaction Volume USD BK-AR3 XYZ Char1=Y
T1 PA2 RC4- 0.2*Transaction Volume USD BK-AR4 ABC Char2=Y
T2 PA1 RC1- 0.1*Transaction Volume USD BK-AR1 XYZ Char1=Y
T2 PA1 RC2- 0.2*Transaction Volume USD BK-AR2 ABC Char2=Y
T2 PA3 RC3- 0.3*Transaction Volume USD BK-AR3 XYZ Char1=Y
T2 PA3 RC4- 0.2*Transaction Volume USD BK-AR3 XYZ Char1=Y

Now, if you use RITA (2a) approach, the system will rate a transaction leg and accumulate pre-calculated charges in a pass through billable charge based on the distribution code, currency code, description on bill, aggregation parameter group ID, as shown in the following table:

Billable Charge Start Date End Date Transaction Leg Rate Component Calculation Details Pass Through Charge ($) Comments
BC1 01/01/2015 31/01/2015 T1-A1P1PG1-PA1, T2-A1P1PG1-PA1 RC1 300*0.1 = 30, 200*0.1 = 20 30+20 = 50 The pass through charge is calculated for each transaction leg and then accumulated because the distribution code, currency code, description on bill, and characteristics of the rate components are same.
BC1 01/01/2015 31/01/2015 T1-A1P1PG1-PA1, T2-A1P1PG1-PA1 RC2 300*0.2 = 60, 200*0.2 = 40 60+40 = 100 The pass through charge is calculated for each transaction leg and then accumulated because the distribution code, currency code, description on bill, and characteristics of the rate components are same.
BC2 01/01/2015 31/01/2015 T1-A2P1PG1-PA2 RC3 300*0.3 = 90 90 The pass through charge is calculated for the transaction leg.
BC2 01/01/2015 31/01/2015 T1-A2P1PG1-PA2 RC4 300*0.2 = 60 60 The pass through charge is calculated for the transaction leg.
BC3 01/01/2015 31/01/2015 T2-A3P1PG1-PA3 RC3, RC4 200*0.3 = 60, 200*0.2 = 40 60+40 = 100 The pass through charges are calculated for the transaction leg and then accumulated because the distribution code, currency code, description on bill, and characteristics of the rate components are same.

In the above example, the BC1 and BC2 will have two pass through lines, whereas the BC3 will have one pass through line.

Now, if you use RITX (2c) approach, the system will rate a transaction leg and calculate charges for each transaction leg in a separate pass through billable charge, as shown in the following table:

Billable Charge Start Date End Date Transaction Leg Rate Component Calculation Details Pass Through Charge ($) Comments
BC1 01/01/2015 31/01/2015 T1-A1P1PG1-PA1 RC1 300*0.1 = 30 30 The pass through charge is calculated for the transaction leg.
BC1 01/01/2015 31/01/2015 T1-A1P1PG1-PA1 RC2 300*0.2 = 60 60 The pass through charge is calculated for the transaction leg.
BC2 01/01/2015 31/01/2015 T1-A2P1PG1-PA2 RC3 300*0.3 = 90 90 The pass through charge is calculated for the transaction leg.
BC2 01/01/2015 31/01/2015 T1-A2P1PG1-PA2 RC4 300*0.2 = 60 60 The pass through charge is calculated for the transaction leg.
BC3 01/01/2015 31/01/2015 T2-A1P1PG1-PA1 RC1 200*0.1 = 20 20 The pass through charge is calculated for the transaction leg.
BC3 01/01/2015 31/01/2015 T2-A1P1PG1-PA1 RC2 200*0.2 = 40 40 The pass through charge is calculated for the transaction leg.
BC4 01/01/2015 31/01/2015 T2-A3P1PG1-PA3 RC3, RC4 200*0.3 = 60, 200*0.2 = 40 60+40 = 100 The pass through charges are calculated for the transaction leg and then accumulated because the distribution code, currency code, description on bill, and characteristics of the rate components are same.

In the above example, the BC1, BC2, and BC3 will have two pass through lines, whereas the BC4 will have one pass through line.

Now, if you use AGTR (2b) approach, the system will determine effective pricing for a transaction leg, aggregate the transaction legs, determine rate for aggregated service quantities, and then accumulate pre-calculated charges in a pass through billable charge based on the distribution code, currency code, description on bill, aggregation parameter group ID (which is created based on the rate component characteristics), as shown in the following table:

Account-Price Item-Price Item Parameter Group-Price Assignment-Aggregation Schedule Total Transaction Volume Billable Charge Start Date End Date Rate Component Calculation Details Pass Through Charge ($) Comments
A1P1PG1-PA1-Monthly 300+200 = 500 BC1 01/01/2015 31/01/2015 RC1 500*0.1 = 50 50 The transaction volume of T1 and T2 legs having the same price item and price item parameters combination and whose transaction date falls between the aggregation schedule is first aggregated and then pass through charge is calculated for aggregated service quantities.
A1P1PG1-PA1-Monthly 300+200 = 500 BC1 01/01/2015 31/01/2015 RC2 500*0.2 = 100 100 The transaction volume of T1 and T2 legs having the same price item and price item parameters combination and whose transaction date falls between the aggregation schedule is first aggregated and then pass through charge is calculated for aggregated service quantities.
A2P1PG1-PA2-Monthly 300 BC2 01/01/2015 31/01/2015 RC3 300*0.3 = 90 90 The pass through charge is calculated for the transaction leg.
A2P1PG1-PA2-Monthly 300 BC2 01/01/2015 31/01/2015 RC4 300*0.2 = 60 60 The pass through charge is calculated for the transaction leg.
A3P1PG1-PA3-Monthly 200 BC3 01/01/2015 31/01/2015 RC3, RC4 200*0.3 = 60, 200*0.2 = 40 60+40 = 100 The pass through charges are calculated for the transaction leg and then accumulated because the distribution code, currency code, description on bill, and characteristics of the rate components are same.

In the above example, the BC1 and BC2 will have two pass through lines, whereas the BC3 will have one pass through line.