Additional Setup for Generating Revenue Schedules

This topic assumes that you are familiar with the setup tasks explained in Setting up Revenue Management and therefore explains only the additional setup required to generate revenue schedules.

Note:

If you are upgrading from a version prior to Spring 2021, you must enable Revenue Management's Upgrade to Spring 2021 feature in Feature Console before performing the setup below. For more information, see Upgrade to Spring 2021.

Setup to Generate Revenue Schedules for Your Own Source Objects

These steps refer to an example scenario where your source object is InvoiceLine, its parent object is Invoice, and there is an Account lookup on the Invoice object.

You must be signed in as an administrator to perform these steps:

  1. On the Revenue Schedule object, create a lookup to each source object for revenue schedules.
    For the example scenario, create a lookup field on the Revenue Schedule object to the InvoiceLine object and name it RS_InvoiceLine.
  2. On the Revenue Schedule Line object, create a lookup to each source object's primary object or other related object. This allows you to have visibility of all the scheduled revenue associated with a primary record or other related record. You can create lookups on the Revenue Schedule Line object to objects that are related to the source object by a relationship path of up to 5 lookups.
    For the example scenario, you want to see all the scheduled revenue associated with an invoice and with an account. Create lookup fields on the Revenue Schedule Line object to the Invoice object and to the Account lookup on the Invoice object. Name these lookup fields RSL_Invoice and RSL_Account.
  3. On the settings record for your source object, complete the following fields:
    1. In the Revenue Schedule Lookup field, enter the API name of the lookup you created in step 1.
      For the example scenario, enter: RS_InvoiceLine__c
    2. In the Revenue Schedule Line Lookups field, enter the API names of the lookup fields you created in step 2. When specifying multiple fields they must be comma separated.
      For the example scenario, enter: RSL_Invoice__c, RSL_Account__c
    3. In the Parent Relationship Paths field, enter the API names of the lookup fields that will populate the Revenue Schedule Line Lookups. When specifying multiple fields they must be comma separated and they must be in the same order relative to the fields in the Revenue Schedule Line Lookups.
      For the example scenario, enter: Invoice__c, Invoice__r.Account__c
    4. In the Owner field, enter the API name of a field that identifies the owner of the source record. This can either be the API name of a field on the source object, or using lookup relationships you can reference a field on an object linked by a path of up to five lookups. When revenue schedules are generated for a source record, the owner identified by this field is set as the owner of the resulting revenue schedule. For more information, see Permissions and Sharing when Working with Revenue Schedules.
  4. To view a list of revenue schedule lines on each primary record or related record, edit the object's page layout and add a related list for Revenue Schedule Lines.
    For the example scenario, add a Revenue Schedule Lines related list to the page layouts for the Invoice and Account objects.

Setup If Your Source Objects are Billing Contracts and Billing Contract Line Items

If you intend generating revenue schedules from billing contract line items, the setup you need to perform depends upon whether Revenue Management and Billing Central are already integrated in your org.

  • If you have not previously enabled the integration between Revenue Management and Billing Central, and you have not manually configured your org to run revenue recognition on billing contracts or billing documents, follow the instructions in Enabling Revenue Recognition for Billing Contracts.
  • If you have enabled the Enabling Revenue Recognition for BC feature in a version of Revenue Management prior to Spring 2021, follow the instructions in Upgrade RM-BC Integration to Spring 2021.
  • If you have manually configured your org to run revenue recognition on billing contracts or billing documents, follow the instructions in the previous section "Setup to Generate Revenue Schedules for Your Own Source Objects". For example, if your source records are billing contract line items, complete the steps in the previous section using these details:
    StepDescription
    1On the Revenue Schedule object, create a lookup to Billing Contract Line Item. Ensure the API name of this lookup is ffrrBCContractLineItem__c

    This will allow revenue schedules to be picked up by Business Analytics, for example, to create the deferred revenue waterfall report.

    2On the Revenue Schedule Line object, create lookups to Billing Contract and Billing Contract Line Item. You can set the API names of these fields however you want, but we suggest using ffrrBCContract__c and ffrrBCContractLineItem__c respectively.
    3

    On your settings record for billing contract lines, complete the following fields:

    Revenue Schedule Lookup: ffrrBCContractLineItem__c

    Revenue Schedule Line Lookups: ffrrBCContract__c,ffrrBCContractLineItem__c

    Parent Relationship Paths: ffbc__Contract__c,Id

    Owner: ffbc__Contract__r.OwnerId

    4Add a Revenue Schedule Lines related list to the page layouts for the Billing Contract and Billing Contract Line Item objects.
    Optional

    Create a formula field on the Revenue Schedule Line object to display the Product or Service from the billing contract line item. Create the field using this formula: ffrrBCContractLineItem__r.ffbc__ProductService__r.Name

    This will allow you to see the product that each revenue schedule line relates to when viewing them in a related list.

Setup If Your Source Objects are Revenue Contracts and Performance Obligations

If you intend generating revenue schedules from performance obligations, you must update your performance obligation's settings record to reference lookup fields on the Revenue Schedule and Revenue Schedule Line objects.

Edit the following fields on your performance obligation's settings record:

  • Revenue Schedule Lookup. Enter the API name of the Performance Obligation lookup field on the Revenue Schedule object: ffrr__PerformanceObligation__c
  • Revenue Schedule Line Lookups. Enter the API names of the Revenue Contract and Performance Obligation lookup fields on the Revenue Schedule Line object: ffrr__RevenueContract__c,ffrr__PerformanceObligation__c
  • Parent Relationship Paths. Enter the API names of lookup fields that will populate the Revenue Schedule Line Lookups: ffrr__RevenueContract__c,Id
  • Owner: Enter the path to the OwnerId field on the Revenue Contract object: ffrr__RevenueContract__r.OwnerId
Note:

If you use a custom page layout for Revenue Contract, edit it to include a related list for Revenue Schedule Lines. This enables you to view related revenue schedule lines on each revenue contract.