During the renewal of a product or service, users may want to switch the billing of a recurring subscription from Custom Plan A to Custom Plan B. The switching from custom plan A to custom plan B happens in the upstream system during the renewal of the product or service and is passed to a Conga order. When the billing is initiated for this Conga order, the application creates the renewal billing schedule records (BSRs) per the new custom plan (Custom Plan B) updated on the billing header.

For example, a new sale with a Custom Plan A  (plan ID CP-1) is initiated for a service with a TCV (Sales) of USD 1,200.00. Custom Plan A has three line items with 30%, 40%, and 30% of the TCV (Sales). The start date is 01-July-2024 and the end date is 30-June-2025.

The milestone dates are 01-August-2024, 15-November-2024, 01-May-2025. You completed the BSD milestones and initiated the Billing, creating three BSRs. All the BSRs are invoiced.

New Sale

The billing header has the following data:

BH ID

Current OLI

Parent OLI

ALI

Custom Plan ID

Billing Start Date

Billing End Date

TCV (Sales)

Billable Amount for Current OLI

Total Invoiced Amount

Pending Invoice Amount

Status

BH-1OLI-1OLI-1ALI-1CP-101-July-202430-June-2025USD 1,200.00USD 1,200.00USD 1,200.00USD 0.00Active

The BSRs are as follows:

BSR IDBSD IDPeriod Start DatePeriod End dateReady for Invoice DateActual Fee AmountInvoice Status
BSR-1BSD-1

NA

NA

01-August-2024

USD 360.00Invoiced
BSR-2BSD-2

NA

NA

15-November-2024

USD 480.00Invoiced
BSR-3BSD-3

NA

NA

01-May-2025

USD 360.00Invoiced

After renewal

During the renewal of the service, there was a change in the payment requirement and the customer decided to proceed with Custom Plan B (plan ID CP-2) rather than Custom Plan A (plan ID CP-1). Hence the renewal is initiated with Custom Plan B associated to the billing header. The renewal term is one year starting from 01-July-2025 and the renewal TCV is USD 1,200.00. 

Custom Plan B has four line items with the following details:

Custom Plan ID

Plan line item ID

Percent

Milestone Expected Date

Payment Term

CP-2PLI-120

01-August-2025

Term 1
CP-2PLI-215

15-November-2025

Term 1
CP-2PLI-325

01-May-2026

Term 1
CP-2PLI-440

01-June-2026

Term 1

Initiating the billing updates the Custom Plan B's ID on the BH. The Billing Start Date and Billing End Date fields are updated with the renewal start date and the last milestone-expected dates. The TCV (Sales) field is updated with the sum of previous sales and the renewal amount. The billing header fields are updated as follows:

BH ID

Current OLI

Parent OLI

ALI

Custom Plan ID

Billing Start Date

Billing End Date

TCV (Sales)

Billable Amount for Current OLI

Total Invoiced Amount

Pending Invoice Amount

Status

BH-1OLI-12OLI-1ALI-1CP-201-July-202530-June-2026USD 2,400.00USD 1,200.00USD 1,200.00USD 1,200.00Active

Suppose you completed the BSD milestones and initiated the billing to create the BSRs as follows:

BSR IDBSD IDPeriod Start DatePeriod End dateReady for Invoice DateActual Fee AmountInvoice StatusRemarks
BSR-1BSD-1

NA

NA

01-August-2024

USD 360.00InvoicedExisting BSR from Custom Plan A
BSR-2BSD-2

NA

NA

15-November-2024

USD 480.00InvoicedExisting BSR from Custom Plan A
BSR-3BSD-3

NA

NA

01-May-2025

USD 360.00InvoicedExisting BSR from Custom Plan A
BSR-4BSD-4

NA

NA

01-August-2025

USD 240.00Pending BillingRenewal BSR from Custom Plan B
BSR-5BSD-5

NA

NA

15-November-2025

USD 180.00Pending BillingRenewal BSR from Custom Plan B
BSR-6BSD-6

NA

NA

01-May-2026

USD 300.00Pending BillingRenewal BSR from Custom Plan B
BSR-7BSD-7

NA

NA

01-June-2026

USD 480.00Pending BillingRenewal BSR from Custom Plan B

The BSDs are as follows:

BSD IDBSR IDRecord TypeCategoryPeriod Start DatePeriod End dateMilestone StatusActual Fee AmountDerived Invoice StatusRemarks
BSD-1BSR-1

Milestone

Fee

NA

NA

Completed

USD 360.00InvoicedExisting BSD from Custom Plan A
BSD-2BSR-2

Milestone

Fee

NA

NA

Completed

USD 480.00InvoicedExisting BSD from Custom Plan A
BSD-3BSR-3

Milestone

Fee

NA

NA

Completed

USD 360.00InvoicedExisting BSD from Custom Plan A
BSD-4BSR-4

Milestone

Fee

NA

NA

Completed

USD 240.00PendingRenewal BSD from Custom Plan B
BSD-5BSR-5

Milestone

Fee

NA

NA

Completed

USD 180.00Pending Renewal BSD from Custom Plan B
BSD-6BSR-6

Milestone

Fee

NA

NA

Completed

USD 300.00Pending Renewal BSD from Custom Plan B
BSD-7BSR-7

Milestone

Fee

NA

NA

Completed

USD 480.00Pending Renewal BSD from Custom Plan B

: