Enter the following parameters for the plan header of every set of OLIs or Line Items:

Enter the following parameters for every line item of the plan:

For example, the requirement is to bill the customer in three installments, 40.33333333%, 25.33333333%, and 34.33333334.%, enter the following parameters for the plan header:

Because there are three installments, you must provide the line item details for three plan lines. If the Fee Amount Rounding Schedule setting is enabled in Billing Settings, the engine auto-computes the first or last value in the percent field. For more information, see Round-off and Auto-Computation.

When you initiate billing, the billing header will have three Billing Schedule Records (BSRs) containing 40.33333333%, 25.33333333%, and 34.33333334% of the Total Contract Value (TCV (sales)) respectively.

When you activate the OLI on which the above custom plan is created, and initiate the billing process, the BSRs, and BSDs guided per the custom plan are created. These milestone BSRs and BSDs are slightly different from the recurring products.

On the BSRs:

• The Actual Fee Amount field is Null.
• The Ready for Invoice Date field is Null.
• The Status is Pending Milestone.
• The Payment Term field has the same value indicated in the plan line item.

On the BSDs:

• The Record Type field is Milestone.
• The Milestone Expected Date field has the same value indicated in the plan line item.
• The Milestone Percent field has the same value as the plan line item.
• The Milestone Status is Expected
• The Derived Invoice Status field is Pending.

Consider the example:

A new sale is initiated for a service with a TCV (Sales) of USD 1,200.00. The above direct milestone custom plan is created on the OLI before its activation. The start date is 01-January-2024 and the end date is 31-December-2024.

You have activated the order (OLI-1) and initiated the billing to create three BSRs and BSDs per the custom plan.

BSRs have the following data:

BSDs have the following data:

You must complete the milestone-type BSDs to compute the actual fee amount. The process to complete the milestone-type BSDs is given in Completing the Milestone.

Before you complete the milestone, you must query the milestone-type BSDs using an API.

You can query the milestone BSDs based on Order Line Item ID, Billing Header ID, or Billing Schedule Records ID. To query for milestone-type BSDs, pass the values for the following parameters:

Object: Pass the Order Line Item ID, Billing Header ID, or Billing Schedule Records ID.

Milestone Expected From Date: Pass a date or keep it as Null.

Milestone Expected To Date: Pass a date or keep it as Null.

Show Data For: Select from All or Pending.

When you initiate the API to query milestone-type BSDs based on the input criteria in the above fields, it filters the relevant results.

If in the above example, you entered OLI-1 in the Object field and selected All in the Show Data For field, you can see the following data for the filtered BSDs:

The actual fee amount is not computed instantly when the milestone-type BSDs are created. You must complete the milestone to invoke the logic to compute the actual fee amount of the BSD. The logic computes the actual fee amount based on the value in the Milestone Percent field of the BSD.

To complete the milestone of a BSD you must enter the following values:

• Billing Schedule Detail Record ID
• Milestone Completion Date
• Milestone Completed By - Default for logged-in users

When you call the API to complete the milestone with the above set of data, the following fields are updated:

On the BSD:

• The Actual Fee Amount field on the BSD is updated to a value equal to the product of Milestone Percent and the Current Unbilled Amount.
• The Milestone Status is updated to Complete, the Derived Invoice Status is updated to Pending, and the Milestone Completion Date is updated to the date you entered.

On the BSR:

• The values for the Actual Fee Amount and Ready for Invoice Date fields are fetched from the Actual Fee Amount and Milestone Completion Date fields of the BSD.
• The Invoice Status is updated to Pending Billing.

On the BH, the Pending Invoice Amount field is updated based on the rolled-up amount from the BSR.

In the above example, to complete the BSD-1 milestone, you entered "BSD-1" for the BSD ID and "05-March-2024" for the Milestone Completion Date. On execution, the BSD shows:

The BSR is populated with the following data:

The actual fee amount is calculated and updated on the BSD after it is completed, then this amount is rolled up to the BSR. From the BSR the value is fetched and updated on the BH. So the Pending Invoice Amount field on the BH is updated to USD 483.99 which is equal to 40.33333333% of USD 1,200.00.

For any of the computation methods (Even Distribution or Custom), the engine auto-computes either the first or last installment value. It ensures that the sum of the percentage of all the installments is always equal to 100. Depending on whether the Fee Amount Rounding Schedule setting is set to First or Last, the engine also rounds off the value to eight decimal places. This is described in the following table:

Considering the above example and assuming that you have enabled the Fee Amount Rounding Schedule setting to either First or Last at the Billing Setting level, the milestone BSDs show the following milestone percentage for a Custom computation method: