Billing Contract Subledger Report Configuration Reference

This topic describes the recommended configuration settings for the Billing Contract Subledger report. It is aimed at experienced Financial Report Builder users, enabling them to quickly create the report. If you do not have experience working with Financial Report Builder, see Setting up the Billing Contract Subledger Report for steps on how to create the report.

Report Values

Financial Report Record Field Values
Field Value Notes
Report Type General  
Report Name Billing Contract Subledger  
Number of Table Configurations 1  
Number of Filter Configurations None, or 2

If you select "2", you must manually create the required lenses in Financial Analytics. See the following:
Description View the total value, total billed, total revenue recognized, and deferred revenue for each billing contract and billing contract line item. All values are displayed in the corporate currency.  
Show Current Period Override Deselected (false)  
Show Soft Date Filter Configuration Deselected (false)  

Table Configuration 1

Table Configuration Tab Values
Field Value Notes
Pivot Table Deselected (false)  
Table Name Billing Contracts (All Values in [Corporate Currency]) [Corporate Currency] refers to the ISO code of the Integration User's currency.
Dataset Billing Contracts ([Name of Your Financial Analytics App])  
Lens Configuration Tab Rows
Row Section Alias Lens/Calculation
1 (blank) contractTotals Billing Contracts - Value, Billed, Recognized, Deferred ([Name of Your Financial Analytics App])
Dimension Columns Tab Rows
Row Dimension Custom Label
1 Company Name Company
2 Account Name Account
3 Contract Currency ISO Code Currency
4 Contract Number (blank)
5 Contract End Date Contract End Date
[Optional] Subtotal Columns Tab Rows
Dimension Custom Label Formatting
Company Name Total for {value} Italic
Account Name Total for {value} Single underline
Contract Currency ISO Code (blank)  
Contract Number (blank)  
Contract End Date (blank)  

Table Configuration 1 Formatting

Formatting Configuration
Section Field Value
Table Column Density Compact
  Table Height Fit Content
  Ignore Warnings No
  Show Grid Total and Subtotal Rows
Number Decimal Precision Two Decimal Places
  Number Scaling No Scaling
  Reverse Sign No
  Negative Number Color Red
  Negative Number Format Brackets
  Empty Values Format Zero
Calculations Divide by Zero Error Error Message

Drill Configuration

Table Configuration Tab Values
Field Value Notes
Pivot Table Deselected (false)  
Table Name Contract Line Details (All Values in [Corporate Currency]) [Corporate Currency] refers to the ISO code of the Integration User's currency.
Dataset Billing Contracts ([Name of Your Financial Analytics App])  
Drill Configuration Tab Mappings
Source Fields Target Field
Contract Number Contract Number
Lens Configuration Tab Rows
Row Section Alias Lens/Calculation
1 (blank) contractLineTotals Billing Contracts - Value, Billed, Recognized, Deferred ([Name of Your Financial Analytics App])
Dimension Columns Tab Rows
Row Dimension Custom Label
1 Contract Line Item Name Contract Line
2 Product Name Product
3 Contract Line Item Billing Term Name Billing Term
4 Contract Line Item End Date End Date

Company Filter

The Company filter is optional. Before you can configure it, you must manually create a compare table lens in Analytics.

Lens Configuration in Analytics
Setting Value
Datasets Billing Contracts
Columns Unique of Company Name
Group By Company Name
Filter Configuration in the Report
Setting Value
Filter Name Company
Filter Type Dimension
Lens [Name of the lens you manually created]
Dimension Company Name
Filter Logic Equals
Values (blank)

Account Filter

The Account filter is optional. Before you can configure it, you must manually create a compare table lens in Analytics.

Lens Configuration in Analytics
Setting Value
Datasets Billing Contracts
Columns Unique of Account Name
Group By Account Name
Filter Configuration in the Report
Setting Value
Filter Name Account
Filter Type Dimension
Lens [Name of the lens you manually created]
Dimension Account Name
Filter Logic Equals
Values (blank)