Download PDF
Download page Use Case: Mid-Period Cancellation when the Impacted Schedule Is Not Invoiced.
Use Case: Mid-Period Cancellation when the Impacted Schedule Is Not Invoiced
When you execute the API for mid-period cancellation, Billing validates the amount to be canceled due to cancellation. On successful validation, it invokes the cancellation process to execute the cancellation steps on the existing billing header.
Prerequisites
- The cancellation date is not null and is in the range of the OLI's or ALI's start and end date.
- The setting "Superseding the Schedules during Asset Management" is set to either Minimize or Always Supersede.
Contact your admin to make this functionality available in your application so that clicking a button calls the billing services API.
At the end of the cancellation process:
Billing schedule records before the cancellation dates remain unchanged.
- The impacted BSR is superseded and two new BSRs are created. The first BSR is created for the partial period before the cancellation date and the second BSR is created for the partial period from the date of cancellation. BSD and adjustment BSD is also superseded.
- The first BSR and its accompanying BSD are in Pending Billing status. Any adjustments that existed in the impacted BSR are copied with the full amount and status to the first partial period BSR.
- The second BSR and its accompanying BSD are in Canceled status.
- The fee amount of the first BSR is prorated and is calculated per the proration setting defined in the billing preference, while the fee amount of the second BSR is a difference between the fee amount of the original BSR and the first BSR created due to cancellation. The fee amount of adjustment BSD is not prorated. A new adjustment BSD with the entire amount is created under the first BSR.
All other BSRs in the cancellation period with a Pending Billing status are canceled. Accompanying BSDs are also canceled.
- The billing header shows the OLI that initiates the cancellation of the service and its status is updated to Pending Inactivation.
- The billable amount on the billing header's Current Order Line Item field shows the amount to be canceled.
- If any adjustment BSDs are canceled, the Total Adjusted Amount field is updated accordingly. For more information about the billing header fields, see Billing Header.
Example
A new sale is initiated for a service with a TCV (Sales) of USD 1,200.00. The billing frequency is monthly. The start date is 01-July-2024 and the end date is 30-June-2025. You initiate the billing to create a billing header and twelve BSRs with a fee amount of USD 100.00 each. You created three adjustment BSDs with a fee amount of USD 100.00, USD 100.00, and USD 50.00 for the period, starting 01-July-2024, 01-March-2025, and 01-June-2025 respectively.
Suppose you invoiced the first eight BSRs (BSR-1 to BSR-8). The billing header looks like a normal billing header (BH) showing the following data:
BH ID | Current OLI | Current Order No. | Parent OLI | ALI | Billing Start Date | Billing End Date | TCV (Sales) | Billable Amount for Current OLI | Total Invoiced Amount | Pending Invoice Amount | Total Adjusted Amount | Total Bill Including Adjustments | Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BH-1 | OLI-1 | O-1 | OLI-1 | ALI-1 | 01-July-2024 | 30-June-2025 | USD 1,200.00 | USD 1,200.00 | USD 800.00 | USD 400.00 | USD 250.00 | USD 1,450.00 | Active |
The data of the twelve BSRs and BSDs are shown in the table:
BSR ID | BSD ID | Record Type | Category | Period Start Date | Period End Date | Actual Fee Amount | Derived Invoice Status | Remarks |
---|---|---|---|---|---|---|---|---|
BSR-1 | BSD-1 | Regular | Fee | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | |
BSD-1.a | Regular | Adjustment | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | Adjustment | |
BSR-2 to BSR-8 | .... | .... | Fee | .... | .... | USD 700.00 | Invoiced | |
BSR-9 | BSD-9 | Regular | Fee | 01-March-2025 | 31-March-2025 | USD 100.00 | Pending | |
BSD-9.a | Regular | Adjustment | 01-March-2025 | 31-March-2025 | USD 100.00 | Pending | Adjustment | |
BSR-10 to BSR-11 | .... | ..... | Fee | .... | .... | USD 200.00 | Pending | |
BSR-12 | BSD-12 | Regular | Fee | 01-June-2025 | 30-June-2025 | USD 100.00 | Pending | |
BSD-12.a | Regular | Adjustment | 01-June-2025 | 30-June-2025 | USD 50.00 | Pending | Adjustment |
After Cancellation
You canceled the product or service such that the cancellation goes into effect from 16-March-2025. The Current OLI and Current Order Number fields on the BH are updated to the newly activated OLI used to initiate the cancellation process. The End Date field on the BH is updated to the product or service cancellation date. The TCV (Sales) field is updated to show the sum of Invoiced and Pending Billing BSRs. The Billable Amount for Current OLI field shows the amount to be canceled. The Total Invoiced Amount field shows the roll-up of the BSRs in the Invoiced status. The Status field on the BH is updated to Pending Inactivation.
Scenario 1: Setting "Superseding the Schedules during Asset Management" is set to Minimize
.
You have canceled the order such that the cancellation goes into effect from 16-March-2025. After cancellation, various fields on the BH are updated as follows:
BH ID | Current OLI | Current Order No. | Parent OLI | ALI | Billing Start Date | Billing End Date | TCV (sales) | Billable Amount for Current OLI | Total Invoiced Amount | Pending Invoice Amount | Total Adjusted Amount | Total Bill Including Adjustments | Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BH-1 | OLI-12 | O-11 | OLI-1 | ALI-1 | 01-July-2024 | 15-March-2025 | USD 848.39 | (USD 351.61) | USD 800.00 | USD 48.39 | USD 200.00 | USD 1,048.39 | Pending Inactivation |
At the end of the cancellation process, the BSRs before the cancellation date remain unchanged. The impacted BSR (here BSR-9 and its BSD) is superseded and two new BSRs are created (BSR-13 and BSR-14). The first BSR is created for the partial period before the cancellation date and the second BSR is created for the partial period from the date of cancellation. The fee amount of BSR-13 is prorated and is calculated per the proration setting defined in the billing preference. The fee amount of BSR-14 is USD 0.00 due to the roll-up amount of the actual BSD-14 and the counter BSD-14.a.
The BSRs are as follows:
BSR ID | BSD ID | Record Type | Category | Period Start Date | Period End Date | Actual Fee Amount | Derived Invoice Status | Remarks |
---|---|---|---|---|---|---|---|---|
BSR-1 | BSD-1 | Regular | Fee | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | |
BSR-2 to BSR-8 | .... | .... | Fee | ... | .... | USD 700.00 | Invoiced | |
BSR-9 | BSD-9 | Regular | Fee | 01-March-2025 | 31-March-2025 | USD 100.00 | Superseded | BSR-9 is superseded and two new BSR-13 and BSR-14 are created |
BSR-10 to BSR-11 | BSD-10 to BSD-11 | ... | Fee | ... | .... | USD 0.00 | Canceled | The roll-up amount of the actual and the counter BSD-10 to 11 and BSD-10.a to 11.a |
BSR-12 | BSD-12 | Regular | Fee | 01-June-2025 | 30-June-2025 | USD 0.00 | Canceled | The roll-up amount of the actual and the counter BSD-12 and BSD-12.b |
BSR-13 | BSD-13 | Regular | Fee | 01-March-2025 | 15-March-2025 | USD 48.39 | Pending | Partial fee before cancellation, split from BSR-9 |
BSR-14 | BSD-14 | Regular | Fee | 16-March-2025 | 31-March-2025 | USD 0.00 | Canceled | The roll-up amount of the actual and the counter BSD-14 and BSD-14.a |
The BSRs and adjustment BSDs in the Pending Billing status after the cancellation date are marked as canceled. Counter BSDs are created for records that are canceled in pending billing status. These BSDs can be used to offset the revenue forecast from the previous BSDs of the same period.
BSD ID | BSR ID | Record Type | Category | Period Start Date | Period End Date | Actual Fee Amount | Derived Invoice Status | Remarks |
---|---|---|---|---|---|---|---|---|
BSD-1 | BSR-1 | Regular | Fee | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | |
BSD-1.a | Regular | Adjustment | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | Adjustment | |
.... | BSR-2 to BSR-8 | .... | Fee | ... | .... | USD 700.00 | Invoiced | |
BSD-9 | BSR-9 | Regular | Fee | 01-March-2025 | 31-March-2025 | USD 100.00 | Superseded | |
BSD-9.a | Regular | Adjustment | 01-March-2025 | 31-March-2025 | USD 100.00 | Superseded | Adjustment | |
BSD-10 to BSD-11 | BSR-10 to BSR-11 | ... | Fee | ... | .... | USD 200.00 | Canceled | |
BSD-10.a to BSD-11.a | ... | Fee | ... | .... | (USD 200.00) | Canceled | Counter BSDs for canceled BSDs-10 to 11. can be used as a source to offset the revenue forecast from the previous BSDs-10 to 11 | |
BSD-12 | BSR-12 | Regular | Fee | 01-June-2025 | 30-June-2025 | USD 100.00 | Canceled | |
BSD-12.a | Regular | Adjustment | 01-June-2025 | 30-June-2025 | USD 50.00 | Canceled | Adjustment | |
BSD-12.b | Regular | Fee | 01-June-2025 | 30-June-2025 | (USD 100.00) | Canceled | Counter BSD for canceled BSD-12, can be used as a source to offset the revenue forecast from the previous BSD-12 | |
BSD-13 | BSR-13 | Regular | Fee | 01-March-2025 | 15-March-2025 | USD 48.39 | Pending | Partial fee before cancellation, split from BSR-9 |
BSD-13.a | Regular | Adjustment | 01-March-2025 | 31-March-2025 | USD 100.00 | Pending | Adjustment with the entire amount is created under the first BSR-13 | |
BSD-14 | BSR-14 | Regular | Fee | 16-March-2025 | 31-March-2025 | USD 51.61 | Canceled | Partial fee after cancellation, split from BSR-9 |
BSD-14.a | Regular | Fee | 16-March-2025 | 31-March-2025 | (USD 51.61) | Canceled | Counter BSD for canceled BSD-14, can be used as a source to offset the revenue forecast from the previous BSD-14 |
Scenario 2: Setting "Superseding the Schedules during Asset Management" is set to Always Supersede
.
You have canceled the order such that the cancellation goes into effect from 16-March-2025. After cancellation, various fields on the BH are updated as follows:
BH ID | Current OLI | Current Order No. | Parent OLI | ALI | Billing Start Date | Billing End Date | TCV (sales) | Billable Amount for Current OLI | Total Invoiced Amount | Pending Invoice Amount | Total Adjusted Amount | Total Bill Including Adjustments | Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BH-1 | OLI-12 | O-11 | OLI-1 | ALI-1 | 01-July-2024 | 15-March-2025 | USD 848.39 | (USD 351.61) | USD 800.00 | USD 48.39 | USD 200.00 | USD 1,048.39 | Pending Inactivation |
At the end of the cancellation process, the BSRs before the cancellation date remain unchanged. The impacted BSR (here BSR-9 and its BSD) is superseded and two new BSRs are created (BSR-13 and BSR-14). The first BSR is created for the partial period before the cancellation date and the second BSR is created for the partial period from the date of cancellation. The fee amount of BSR-13 is prorated and is calculated per the proration setting defined in the billing preference. The fee amount of BSR-14 is a difference between the fee amounts of BSR-9 and BSR-13. The BSRs and BSDs in the Pending Billing status after the cancellation date are marked as canceled.
BSR ID | BSD ID | Record Type | Category | Period Start Date | Period End Date | Actual Fee Amount | Derived Invoice Status | Remarks |
---|---|---|---|---|---|---|---|---|
BSR-1 | BSD-1 | Regular | Fee | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | |
BSD-1.a | Regular | Adjustment | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | Adjustment | |
BSR-2 to BSR-8 | .... | .... | Fee | ... | .... | USD 700.00 | Invoiced | |
BSR-9 | BSD-9 | Regular | Fee | 01-March-2025 | 31-March-2025 | USD 100.00 | Superseded | |
BSD-9.a | Regular | Adjustment | 01-March-2025 | 31-March-2025 | USD 100.00 | Superseded | Adjustment | |
BSR-10 to BSR-11 | BSD-10 to BSD-11 | ... | Fee | ... | .... | USD 100.00 | Canceled | |
BSR-12 | BSD-12 | Regular | Fee | 01-June-2025 | 30-June-2025 | USD 100.00 | Canceled | |
BSD-12.a | Regular | Adjustment | 01-June-2025 | 30-June-2025 | USD 50.00 | Cancelled | Adjustment | |
BSR-13 | BSD-13 | Regular | Fee | 01-March-2025 | 15-March-2025 | USD 48.39 | Pending | |
BSD-13.a | Regular | Adjustment | 01-March-2025 | 31-March-2025 | USD 100.00 | Pending | Adjustment with the entire amount is created under the first BSR-13 | |
BSR-14 | BSD-14 | Regular | Fee | 16-March-2025 | 31-March-2025 | USD 51.61 | Canceled |