Rounding Schedule for Fee Amount
This feature rounds the decimal balances arising from proration in the very first billing schedule record. This method is used for a recurring order line item applicable for a new sale transaction.
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
orLast
.
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. You can see that by virtue of the Fee Amount Rounding Schedule setting
being defined, billing rounds the decimal values in the first billing schedule.
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 01 Jan 2024 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 |
01 Jan 2024 |
31 Mar 2024 |
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 |
01 Jan 2024 |
31 Mar 2024 |
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 |
01 Jan 2024 |
31 Jan 2024 |
USD 333.34 |
01 Jan 2024 |
Pending Billing |
BSR-002 |
BH-001 |
01 Feb 2024 |
29 Feb 2024 |
USD 333.33 |
01 Feb 2024 |
Pending Billing |
BSR-003 |
BH-001 |
01 Mar 2024 |
31 Mar 2024 |
USD 333.33 |
01 Mar 2024 |
Pending Billing |
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 |
01 Jan 2024 |
31 Jan 2024 |
Fee |
USD 333.34 |
BSD-002 |
BSR-002 |
Regular |
01 Feb 2024 |
29 Feb 2024 |
Fee |
USD 333.33 |
BSD-003 |
BSR-003 |
Regular |
01 Mar 2024 |
31 Mar 2024 |
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 |
01 Jan 2024 |
31 Jan 2024 |
USD 333.33 |
01 Jan 2024 |
Pending Billing |
BSR-002 |
BH-001 |
01 Feb 2024 |
29 Feb 2024 |
USD 333.33 |
01 Feb 2024 |
Pending Billing |
BSR-003 |
BH-001 |
01 Mar 2024 |
31 Mar 2024 |
USD 333.34 |
01 Mar 2024 |
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 |
01 Jan 2024 |
31 Jan 2024 |
Fee |
USD 333.33 |
BSD-002 |
BSR-002 |
Regular |
01 Feb 2024 |
29 Feb 2024 |
Fee |
USD 333.33 |
BSD-003 |
BSR-003 |
Regular |
01 Mar 2024 |
31 Mar 2024 |
Fee |
USD 333.34 |
Since the Fee Amount Rounding Schedule is set to Last, the last record has rounded decimal values.