Scenario 10: Usage Calculation Using Multi-Dimensional Price Matrix
In the previous scenarios, we have considered only one dimension that is quantity. However, it is possible to configure the PLI to have multiple dimensions.
Consider a case where you need to bill your customer based on the volume of the quantity consumed. The price for each volume tier varies as per the customer rating. In such a scenario, you need two dimensions, quantity and customer rating.
For example, the customer is billed at a flat rate based on the volume consumed for a product 'StarKit'. As per the customer rating, different flat rates are defined for each volume slab as per the following:
|
Units |
Customer Rating |
|
|---|---|---|
|
Gold |
Silver |
|
|
1 - 10 |
100 |
120 |
|
11 - 20 |
180 |
200 |
|
21 - 30 |
255 |
275 |
|
31 + |
480 |
500 |
Ensure that following prerequisites are satisfied:
- A field named Customer Rating on the Account object.
- New price dimension called Customer Rating created on the basis of the above field.
- A field named Customer Rating on the Usage Input object.
Configuring PLI
Do the following steps to configure PLI:
Applying Price Matrix
Do the following steps to apply price matrix:
Processing the Usage Inputs
- Enter the Asset Number. This asset number must match with the corresponding asset number that you have specified in the Asset Line Item Detail page.
- Enter a Usage Date that corresponds with the Billing Schedule.
- Enter the Product UOM. This value should match the value provided on the Product PLI.
- Ensure that Status is Loaded.
- Enter the Quantity and click Save.
After saving the input, click Process Usage Input to process the amount against the entered quantity.
When the usage is processed successfully, the Status will change to Rated and you will see the amount under Rated Amount.
- For example, if you specify Quantity as
15 and Customer Rating as Gold, you will see the
Rated Amount as $ 180.
- And if you specify Quantity as 15 and
Customer Rating as Silver, you will see the
Rated Amount as $ 200.
