Download PDF
Download page Use Case: Mid-Period Cancellation When the Impacted Schedule is Invoiced.
Use Case: Mid-Period Cancellation When the Impacted Schedule is Invoiced
When you execute the API for mid-period cancellation, Billing validates the amount to be canceled. 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 order line item's (OLI's) or asset line item's (ALI's) start and end date.
- The setting "Superseding the Schedules during Asset Management" is set to 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 and its accompanying BSDs in invoiced status also remain unchanged. The adjustment BSD also remains unchanged.
- A new BSR and accompanying BSD are created in Pending Billing status for the cancellation period. The fee amount reflects the refund amount due to cancellation. There is no refund for any adjustments during this period.
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 billing header's Billable Amount for 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.
Consider the 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-January-2025, and 01-June-2025 respectively.
Suppose you invoiced the first seven BSRs (BSR-1 to BSR-7). The billing header looks like a normal 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 Adjustment | 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 700.00 | USD 500.00 | USD 250.00 | USD 1450.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-6 | .... | .... | Fee | .... | .... | USD 500.00 | Invoiced | |
BSR-7 | BSD-7 | Regular | Fee | 01-January-2025 | 31-January-2025 | USD 100.00 | Invoiced | |
BSD-7.a | Regular | Adjustment | 01-January-2025 | 31-January-2025 | USD 100.00 | Invoiced | Adjustment | |
BSR-8 to BSR-11 | .... | ..... | Fee | .... | .... | USD 400.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 January 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 canceled amount. 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-January-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 Adjustment | Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BH-1 | OLI-12 | O-11 | OLI-1 | ALI-1 | 01-July-2024 | 15-January-2025 | USD 648.39 | (USD 551.61) | USD 700.00 | (USD 51.61) | USD 200.00 | USD 848.39 | Pending Inactivation |
At the end of the cancellation process, the BSRs and BSDs and adjustment BSDs before the cancellation date remain unchanged. The BSR that is impacted (here BSR-7 and its BSD) also remains unchanged because it is invoiced. In place of the impacted BSR, a new BSR-13 and BSD-13 are created in Pending Billing status for the canceled period. The fee amount of this BSR-13 is equal to the refund amount. No refund is granted for the adjustment for the impacted BSR-7, hence no adjustment BSD is created for refunding the adjustment amount in the cancellation period.
All other BSRs and 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.
BSR ID | Record Type | Category | Period Start Date | Period End Date | Actual Fee Amount | Invoice Status | Remarks |
---|---|---|---|---|---|---|---|
BSR-1 | Regular | Fee | 01-July-2024 | 31-July-2024 | USD 100.00 | Invoiced | |
BSR-2 to BSR-6 | .... | Fee | ... | .... | USD 500.00 | Invoiced | |
BSR-7 | Regular | Fee | 01-January-2025 | 31-January-2025 | USD 100.00 | Invoiced | Impacted BSR remains unchanged. A new BSR-13 is created for the canceled period. |
BSR-8 to BSR-11 | ... | Fee | ... | .... | USD 0.00 | Canceled | The roll-up amount of the actual and the counter BSD. |
BSR-12 | Regular | Fee | 01-June-2025 | 30-June-2025 | USD 0.00 | Canceled | The roll-up amount of the actual and the counter BSD. |
BSR-13 | Regular | Fee | 16-January-2025 | 31-January-2025 | (USD 51.61) | Pending Billing | Refund fee for the canceled period of BSR-7 |
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 | 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 | |
BSD-2 to BSD-6 | BSR-2 to BSR-6 | .... | Fee | ... | .... | USD 500.00 | Invoiced | |
BSD-7 | BSR-7 | Regular | Fee | 01-January-2025 | 31-January-2025 | USD 100.00 | Invoiced | Impacted BSD remains unchanged. A new BSD-13 is created for the canceled period. |
BSD-7.a | Regular | Adjustment | 01-January-2025 | 31-January-2025 | USD 100.00 | Invoiced | The impacted adjustment BSD remains unchanged. No refund adjustment BSD is created for the cancellation period. | |
BSD-8 to BSD-11 | BSR-8 to BSR-11 | ... | Fee | ... | .... | USD 400.00 | Canceled | |
BSD-8.a to BSD-11.a | ... | Fee | ... | .... | (USD 400.00) | Canceled | Counter BSDs for canceled BSDs-8 to 11, can be used as a source to offset the revenue forecast from the previous BSDs-8 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.a | 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 | 16-January-2025 | 31-January-2025 | (USD 51.61) | Pending Billing | Refund fee for the canceled period of BSR-7 |
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-January-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 Adjustment | Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BH-1 | OLI-12 | O-11 | OLI-1 | ALI-1 | 01-July-2024 | 15-January-2025 | USD 648.39 | (USD 551.61) | USD 700.00 | (USD 51.61) | USD 200.00 | USD 848.39 | Pending Inactivation |
At the end of the cancellation process, the BSRs and BSDs and adjustment BSDs before the cancellation date remain unchanged. The BSR that is impacted (here BSR-7 and its BSD) also remains unchanged because it is invoiced. In place of the impacted BSR, a new BSR-13 and BSD-13 are created in Pending Billing status for the canceled period. The fee amount of this BSR-13 is equal to the refund amount. No refund is granted for the adjustment for the impacted BSR-7, hence no adjustment BSD is created for refunding the adjustment amount in the cancellation period.
All other 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 | 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-6 | .... | .... | Fee | ... | .... | USD 500.00 | Invoiced | |
BSR-7 | BSD-7 | Regular | Fee | 01-January-2025 | 31-January-2025 | USD 100.00 | Invoiced | Impacted BSR remains unchanged. A new BSR-13 is created for the canceled period. |
BSD-7.a | Regular | Adjustment | 01-January-2025 | 31-January-2025 | USD 100.00 | Invoiced | The impacted adjustment BSD remains unchanged. No refund adjustment BSD is created for the cancellation period. | |
BSR-8 to BSR-11 | BSD-8 to BSD-11 | ... | Fee | ... | .... | USD 400.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 | Canceled | Adjustment | |
BSR-13 | BSD-13 | Regular | Fee | 16-January-2025 | 31-January-2025 | (USD 51.61) | Pending Billing | Refund fee for the canceled period of BSR-7 |