You are here:

Billing Document Line Item Fields

Products and services are applied to billing documents as billing document line items. The Billing Document Line Item object is a core component of FinancialForce Enterprise Resource Planning (ERP). Other FinancialForce applications use this object and add fields, buttons and functionality to it. Here is a description of the Billing Document Line Item fields and buttons grouped by the FinancialForce product to which they belong.

FinancialForce Enterprise Resource Planning (ERP)

Here is a description of the Billing Document Line Item fields and buttons that are part of FinancialForce Enterprise Resource Planning (ERP).

Key: * – Mandatory field; R – Read-only in all contexts.

The number indicates the number of characters that are allowed in this text field, where appropriate.

Field Name			Description
Billing Document			Billing document to which this billing document line item belongs.
Billing Document Status	R		Status of the billing document to which this billing document line item belongs.
Description		255	Description of the billing document line item.
Discount Total			The total discount for this billing document line item. If the related contract line item has a percentage discount, this field is calculated using the formula Percentage Discount x Net Value Before Discount. If the related contract line item has a fixed value discount: If the Net Value Before Discount is greater than the Fixed Value Discount, this field equals the Fixed Value Discount. If the Net Value Before Discount is less than the Fixed Value Discount, this field equals the Net Value Before Discount. If there is no discount on the line, this field contains zero.
Document Line			Number of this billing document line item.
Match Type	A		Match Type of the FinancialForce Accounting transaction to which this billing document line item relates.
Net Value			Total value of this billing document line item before tax to two decimal places. If the Total Discount is greater than the Net Value Before Discount, this field is zero. If the Total Discount is less than the Net Value Before Discount, this field is calculated using the formula Net Value Before Discount - Total Discount.
Net Value Before Discount			The net value of the billing document line item before the discounts are applied. If the related contract line item has no pricing structure, this field is calculated using the formula Unit Price x Quantity. If the related contract line item has a pricing structure, this field is calculated using that pricing structure and the usage records or quantity associated with that contract line item. This field contains a value regardless of whether there is a discount on the related contract line item.
Net Value Override			Contains the value that the Net Value is overridden with. This field contains a value if the product belongs to a tiered pricing structure. Additionally, you can enter a value to override the Net Value. See Net Value.
Outstanding Value	A		Outstanding Value of the FinancialForce Accounting transaction to which this billing document line item relates.
Product or Service	*		Lookup to the Salesforce product or service to which this billing document line item relates. If this billing document was created from a billing event (via the Billing Events Integration) this field will contain the product "Professional Services" if the field on the corresponding billing event item was blank.
Quantity	*	12.6	Number of items included in this billing document line item to six decimal places. This is used to calculate the Total Value of the billing document line item.
Reporting Net Value	R		Total Value of this billing document line item before tax based on the Document Type of the billing document. If the billing document is an invoice, the value is the same as the Net Value. If the document is a credit note, the value is calculated using the formula: Net Value * -1.
Reporting Tax Value Total	R		Total tax for the billing document line item based on the Document Type of the billing document. If the billing document is an invoice, the value is the same as the Tax Value Total. If the document is a credit note, the value is calculated using the formula: Tax Value Total * -1.
Reporting Total Value	R		Total Value of this billing document line item including tax based on the Document Type of the billing document. If the billing document is an invoice, the value is the same as the Total Value. If the document is a credit note, the value is calculated using the formula: Total Value * -1.
Tax Rate Total			Total tax rate for the billing document line item.
Tax Value Total			Total tax for the billing document line item to two decimal places. On the enhanced Billing Document Detail page, click this field to open a dialog box showing the breakdown of tax on the line.
Total Value			Total Value of this billing document line item including tax to two decimal places. The formula used to calculate this is Net Value + Tax Value Total.
Unit Price	*		Price of one item for the billing document line item to nine decimal places. This is used to calculate the Total Value of the billing document line item. Note: The Unit Price Field is field ignored if Net Value Override contains a value. In this scenario, the value in the Unit Price field is shown with a line through it. See Net Value Override.

Tax Breakdown

Key: A – If you enter a value, the Tax Rate and Tax Value are calculated from the tax code; M – You can enter values manually, but when you do so these fields are no longer calculated.

Note:

Tax is calculated against the Net Value, not the Net Value Before Discount.

Field Name		Description
Reporting Tax Value 1-3		Tax Value of the corresponding Tax Rate based on the Document Type of the billing document. If the billing document is an invoice, the value is the same as Tax Value 1. If the document is a credit note, the value is calculated using the formula: Tax Value 1 * -1.
Tax Code 1-3	A	Tax code to use when calculating tax for this billing document line item. You can use these to represent the state, county and city tax authorities.
Tax Rate 1-3	M	Tax rate to use when calculating tax for this billing document line item. Tip: Tip Leave the field blank if you want this to be calculated using the tax code.
Tax Value 1-3	M	Tax value calculated from the corresponding tax rate using the formula: Net Value * (Tax Rate / 100). Note: Note Changing the Tax Value does not change the tax rate. Tip: Tip Leave the field blank if you want this to be calculated using the tax code.

Billing Central

Here is a description of the fields that FinancialForceBilling Central adds to the Billing Document Line Item object.

Key: R – Read-only in all contexts; C – Only available on the Salesforce Billing Document Detail page.

The number indicates the number of characters that are allowed in this text field, where appropriate.

Field Name			Description
Contract Line Item		C	Lookup to the contract line item to which this billing document line item relates. This field is populated when the billing document is complete and is used to calculate the Total Billed field of the related contract line item.
Contract Status	R	C	Formula field containing the status of the contract to which this billing document line item belongs.
Contract Type		C	Type of contract to which this billing document line item belongs.
Document Date	R	C	Formula field containing the document date of the billing document to which this billing document line item belongs.
End of Period			Last day of the billing period for this billing document line item. Editable if the billing document's status is "Draft".
Original Billing Document			Lookup to the original billing document that this line came from before consolidation.
Plan Name		C	Lookup to the plan to which this billing document line item belongs.
Start of Period			First day of the billing period for this billing document line item. Editable if the billing document's status is "Draft".
Unit of Measure		C	Lookup to the unit of measure used to determine customer usage on this billing document line item.

FinancialForce Accounting

Here is a description of the fields and field sets that FinancialForce Accounting adds to the Billing Document Line Item object. They are only available if you are using the integration between Billing Central and Accounting.

Note:

These fields are only available if they have been added to the billing document line item page layout.


Field Name	Description
Match Type	Match Type of the FinancialForce Accounting transaction to which this billing document line item relates.
Outstanding Value	Outstanding Value of the FinancialForce Accounting transaction to which this billing document line item relates.
Product GLA Override	Lookup to a FinancialForce Accounting general ledger account to use on this product line. If this field is left blank, the sales revenue account on the product is used.

Field Sets

Field Set Name	Description	Default Fields	Object
Community Printed Document Fields	Contains additional billing document line item fields to appear on billing documents when printed from FM Communities.	Net Value Quantity Tax Rate Total Tax Value Total	Billing Document Line Item

Field Set Name

Description

Default Fields

Object

Community Printed Document Fields

Contains additional billing document line item fields to appear on billing documents when printed from FM Communities.

Net Value
Quantity

Tax Rate Total

Tax Value Total

Billing Document Line Item

PSA

Here is a description of the fields that FinancialForce PSA adds to the Billing Document Line Item object for use with the Billing Events integration.

Field Name	Description
Billing Event Item	Lookup to the PSA Billing Event Item from which this billing document line item was created.
Billing Event Item Correlation ID	A unique ID used internally to correlate messages between the billing event item and billing document line item.
Project	The project on the associated billing event item.
Summary	The summary information on the associated billing event item.