Download PDF
Download page Rounding the Decimal Values for New Sales.
Rounding the Decimal Values for New Sales
This feature rounds the decimal balances arising from proration in the first or last billing schedule record subject to custom setting. This method is used for a recurring order line item applicable for a new sale transaction.
To know how Billing works on the Conga Platform, it is recommended to familiarize yourself with its architecture mentioned in Understanding the Billing Architecture on Conga Platform.
Prerequisite
- An order line item is created for a recurring product.
The order line item is active.
- The Fee Amount Rounding Schedule is set to either First or Last.
When you call the Initiate Billing API for a recurring order line item with OrderLineItemIds
and ReadyForBillingDate
as the payload, it starts processing the OLI. It creates one billing header, a cascade of billing schedule records, and billing schedule details depending on the term and billing frequency of the order line item. The billing schedule records are created with "Pending Billing" status. Because the Fee Amount Rounding Schedule setting is defined, billing rounds the decimal values in the first or last billing schedules.
Let's understand this feature with the help of an example.
Example
Suppose you are selling computer servicing with a Total Contract Value of $1000. The billing term is for 3 months starting from with a recurring billing schedule. Billing creates three billing
schedules. The round-offs are adjusted in the first or last billing schedule depending on whether the Fee Amount Rounding Schedule is set to First or Last.
Scenario 1:
Suppose you have set the Fee Amount Rounding Schedule to First, and configured a recurring order line item with the following details:
Order No | Order Line No | Product | Price Type | Billing Frequency | Start Date | End Date | Quantity | Per Unit price | Net Price | Selling Term |
---|---|---|---|---|---|---|---|---|---|---|
O-001 | 1 | Service | Recurring | Monthly |
|
| 1 | USD 1000 | USD 1000.00 | 1.000 |
Contact your admin will make this functionality available in your application so that upon clicking a button you should be able to call the billing service API and get the result as shown. The API creates one Billing Header, three Billing Schedule Records, and three Billing Schedule Details.
The billing header uses the information from the order line item and contains the following data. Depending upon the information given for the pricing source, It will pick up the pricing information from the order line item or the asset line item. The Billing Header shows:
Billing Header ID | Order No | Order Line No | Product | Price Type | Billing Frequency | Billing Rule | Start Date | End Date | Quantity | Net Unit Price | Selling Term | Bill To | Pricing Source | Billing Preference |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BH-001 | O-001 | 1 | Service | Recurring | Monthly | Bill In Advance |
|
| 1 | USD 1000.00 | 1.000 | ABC Corporation | OLI | Billing Preference |
Three Billing Schedule Records are generated showing the following output:
Billing Schedule Record No | Billing Header ID | Period Start Date | Period End Date | Actual Fee Amount | Ready for Invoice Date | Status |
---|---|---|---|---|---|---|
BSR-001 | BH-001 |
|
| USD 333.34 |
| Pending Billing |
BSR-002 | BH-001 |
|
| USD 333.33 |
| Pending Billing |
BSR-003 | BH-001 |
|
| USD 333.33 |
| Pending Billing |
The Actual Fee Amount shown in the billing schedule record is the amount that is billed to the customer.
Billing Schedule Details show the following information:
Billing Schedule Detail No | Billing Schedule Record No | Record Type | Period Start Date | Period End Date | Category | Actual Fee Amount |
---|---|---|---|---|---|---|
BSD-001 | BSR-001 | Regular |
|
| Fee | USD 333.34 |
BSD-002 | BSR-002 | Regular |
|
| Fee | USD 333.33 |
BSD-003 | BSR-003 | Regular |
|
| Fee | USD 333.33 |
Since the Fee Amount Rounding Schedule is set to First, decimal rounding is done in the first record.
Scenario 2:
Suppose you have set the Fee Amount Rounding Schedule to Last, and configured a recurring order line item with the same details as above.
Three Billing Schedule Records are generated showing the following output:
Billing Schedule Record No | Billing Header ID | Period Start Date | Period End Date | Actual Fee Amount | Ready for Invoice Date | Status |
---|---|---|---|---|---|---|
BSR-001 | BH-001 |
|
| USD 333.33 |
| Pending Billing |
BSR-002 | BH-001 |
|
| USD 333.33 |
| Pending Billing |
BSR-003 | BH-001 |
|
| USD 333.34 |
| Pending Billing |
The Actual Fee Amount shown in the billing schedule record is the amount that is billed to the customer.
Billing Schedule Details show the following information:
Billing Schedule Detail No | Billing Schedule Record No | Record Type | Period Start Date | Period End Date | Category | Actual Fee Amount |
---|---|---|---|---|---|---|
BSD-001 | BSR-001 | Regular |
|
| Fee | USD 333.33 |
BSD-002 | BSR-002 | Regular |
|
| Fee | USD 333.33 |
BSD-003 | BSR-003 | Regular |
|
| Fee | USD 333.34 |
Since the Fee Amount Rounding Schedule is set to Last, the last record has rounded decimal values.