Billing Contract Subledger Report Configuration Reference

This topic describes the recommended configuration settings for the Billing Contract Subledger report. It is aimed at experienced Report Builder users, enabling them to quickly create the report. If you do not have experience working with 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: Company Filter Account Filter
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)