Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Recurring Product - Quarterly Billing Without Overlapping Period - Contract Term, TCV (Sales), or Both are Changed

The subscription is amended to push the contract's start and end dates out by one month. The amendment adds one month to the contract's end but doesn't truncate one month from the beginning of the contract. As a result, the contract term, TCV (Sales), or both are changed after the amendment. The billing periods after the amendment do not align with the existing periods, disrupting the billing schedule records (BSRs).

A subscription, with a quarterly billing frequency is sold for one year with a TCV (Sales) of USD 96,000.00. The contract start date is 01-July-2024 and the end date is 30-June-2025. The selling term is four (because the billing frequency is quarterly) and the net price is USD 24,000.00.

You want to move out (delay) the contract term by one month.

The subscription is amended to push the start and end dates by one month. Due to existing CPQ behavior, the start date remains 01-July-2024 (instead of 01-August-2024 ), however, the contract's end date is extended to 31-July-2025, resulting in a change in the contrac's term. Although TCV (Sales) has increased from USD 96,000.00 to USD 104,000.00, it remains unchanged because the net price for the period remains unaltered. The date range is changed so that the new periods do not overlap with the existing ones. This disrupts the existing BSRs and new BSRs are created for the amended period. It is illustrated in the following diagram:



Here, the billing application receives the payload for the amendment from an order or asset line item generated in Conga CPQ. When the application processes this line item per the request, it uses the value in the Effective Start Date field on the order line item (OLI) as the start date (null here) indicating that there is no change in the start date. As a result, the billing header fields are updated as follows:

BH ID

Current OLI

Parent OLI

ALI

Billing Start Date

Billing End Date

TCV (Sales)

Billable Amount for Current OLI

Total Invoiced Amount

Pending Invoice Amount

Status

BH-1

OLI-12

OLI-1

ALI-1

01-July-2024

31-July-2025

USD 104,000.00

USD 8,000.00

USD 0.00

USD 104,000.00

Active

The BSRs are:

Setting "Superseding the Schedules during Asset Management" to Always Supersede

BSR ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Invoice Status

Remarks

BSR-1

Regular

Fee

01-July-2024

30-September-2024

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-2

Regular

Fee

01-October-2024

31-December-2024

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-3

Regular

Fee

01-January-2025

31-March-2025

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-4

Regular

Fee

01-April-2025

30-June-2025

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-5

Regular

Fee

01-July-2025

31-July-2025

USD 8,000.00

Pending Billing

Additional BSR, BSR-5 is created for a newer period because of the change operation.

Setting "Superseding the Schedules during Asset Management" to Minimize

BSR ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Invoice Status

Remarks

BSR-1

Regular

Fee

01-July-2024

30-September-2024

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-2

Regular

Fee

01-October-2024

31-December-2024

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-3

Regular

Fee

01-January-2025

31-March-2025

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-4

Regular

Fee

01-April-2025

30-June-2025

USD 24,000.00

Pending Billing

Existing BSR from the new sale.

BSR-5

Regular

Fee

01-July-2025

31-July-2025

USD 8,000.00

Pending Billing

Additional BSR, BSR-5 is created for a newer period because of the change operation.

BSDs are:

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

30-September-2024

USD 24,000.00

Pending

Existing BSD from the new sale.

BSD-2

BSR-2

Regular

Fee

01-October-2024

31-December-2024

USD 24,000.00

Pending

Existing BSD from the new sale.

BSD-3

BSR-3

Regular

Fee

01-January-2025

31-March-2025

USD 24,000.00

Pending

Existing BSD from the new sale.

BSD-4

BSR-4

Regular

Fee

01-April-2025

30-June-2025

USD 24,000.00

Pending

Existing BSD from the new sale.

BSD-5

BSR-5

Regular

Fee

01-July-2025

31-July-2025

USD 8,000.00

Pending

Additional BSD, BSD-5 is created for a newer period because of the change operation.