Additional Setup for Generating Revenue Schedules
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:
- 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. - 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. - On the settings record for your source object, complete the following fields:
- 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
- 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
- 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
- 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.
- In the Revenue Schedule Lookup field, enter the API name of the lookup you created in step 1.
- 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:
Step Description 1 On 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.
2 On 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
andffrrBCContractLineItem__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
4 Add 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