Forecast Billing for Order Line Items and Line Items (CPQ)

You can forecast the billing for new sales of products with one-time and recurring billing, merge the schedule information into the quote document, and send it to the customer. You can forecast the same line item multiple times with or without changing the dates, price, or billing frequency details. Each time you forecast the billing for an order or line item, the previous records are deleted, and new records are created with the latest forecast information.

The forecasted billing data is stored in the ForecastBillingScheduleRecord object. 

Prerequisites

• The order line item is not active.
• The quote/proposal of the line item is not finalized/accepted.
• The price type is one-time or recurring.

To forecast the Billing

1. Call the Billing Management API, https://<URL_of_the_Instance>/api/billing/v1/schedules/forecast.
2. Enter the API input values in the payload:
   
   1. Transaction Source: Conga or External.
   2. Business Object Type: Orderlineitem or lineitem.
   3. Business Object ID: Line item or order line item IDs.
      The API returns the following response:
      

      [
        {
          "IsSuccess": true,
          "ErrorMessage": "string",
          "BusinessObjectType": "string",
          "BusinessObjectId": "string"
        }

      CODE
3. The API creates the forecast schedules and displays the data for the following fields:

   1. Line Item ID: The source transaction line ID.

   2. The ID of the forecasted BSR: The ID of the forecasted billing schedule record (FBSR).

   3. Period Start Date: The period start date of the billing schedule record (BSR).

   4. Period End Date: The period end date of the BSR.

   5. Forecasted Fee Amount: The actual fee amount of the BSR.

   6. Ready For Invoice Date: The ready for the invoice date of the BSR.

   7. Invoice Status: The invoice status of the BSR.

   8. Payment Term: The payment term on the BSR.

   9. Contracted: The contracted field on the billing header (BH) is True or False.

For example:

There is a new sale in discussion with TCV (Sales) of USD 1,200.00 and quarterly billing frequency. The contract start and end dates are 01-July-2024 and 30- June-2025. The order is not activated yet. The customer wants to see the forecasted billing schedules to have a better idea and understanding of the payment dates and fee amounts.

As a sales representative, you forecasted the billing, and the records are generated as follows: