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 Foundations. Other FinancialForce applications use this object and add fields, buttons and functionality to it.

Standard Items

Here is a description of the Billing Document Line Item fields and buttons that are part of FinancialForce Foundations.

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

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

Field Name

    

Description
Analysis Item 1-4     Used to sub-analyze billing document lines for reporting purposes. Analysis items can be used to represent a number of different business concepts, for example, Region, Group, or Project.
Billing Document     Billing document to which this billing document line item belongs.
Billing Document External Tax Status R   External Tax Status of the 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.
Company Site     Company site to which this billing document line item relates, representing the location the product is shipped from. The site must be a child of the company specified on the related billing document and contain complete address details.
Derived Unit Price    

Average price charged per unit before tax.

For more information about how Billing Central uses this field, see Billing Document Line Item Fields.

Description

  

255

Description of the billing document line item.
Discount Total    

The total discount for this billing document line item.

For more information about how Billing Central uses this field, see Billing Document Line Item Fields.
Document Line    

Number of this billing document line item.
Enter Shipping Address Manually    

Indicates that you want to enter and maintain the shipping address manually. If deselected and a shipping account is specified, the account shipping address is saved to the line.

For more information, see Specifying Addresses on Billing Document Line Items.
Invalid Company Site    

Indicates that the selected company site is not a child of the billing document company.

This checkbox is populated automatically when you make a change to the billing document that results in an invalid company site on the line item.
Invalid Shipping Account    

Indicates that the selected shipping account is not a valid descendant of the billing document account. Valid descendants include records up to five relationships deep in the hierarchy.

This checkbox is populated automatically when you make a change to the billing document that results in an invalid shipping account on the line item.

Net Value

    

Total Value of this billing document line item before tax to two decimal places. If Net Value Override is set, then Net Value is set to the override value.

For more information about how Billing Central uses this field, see Billing Document Line Item Fields.
Net Value Before Discount    

The net value of the billing document line item before the discounts are applied.

For more information about how Billing Central uses this field, see Billing Document Line Item Fields.
Net Value Override    

Contains the value that the Net Value is overridden with.

For more information about how Billing Central uses this field, see Billing Document Line Item Fields.

Product or Service

*

  

Lookup to the Salesforce product or service to which this billing document line item relates.

For more information about how Billing Central uses this field, see Billing Document Line Item Fields.

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 Net Value Number R   Contains the Reporting Net Value as a number to 2 decimal places. This field is used by FinancialForce Business Analytics.
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.

Shipping Account

 *  

Salesforce account to which this billing document line item relates, representing the location the product is shipped to. The account must be a descendant of the account specified on the related billing document and contain complete address details. Valid descendants include records up to five relationships deep in the hierarchy.

Tip:

We recommend that you derive shipping address details from a related account record. However, if your Billing Document Line Item object contains a lookup to Contact with the API name Ship_To__c, it is possible to use the contact to populate shipping address details. The following rules apply when you specify a contact and no shipping account and deselect Enter Shipping Address Manually:

  • Shipping address details are populated from the mailing address on the contact when you save the record
  • The mailing address on the contact must be complete

For more information, see Specifying Addresses on Billing Document Line Items.
Shipping Street    

Shipping address for this billing document line item, which can be entered and maintained manually or automatically populated from the shipping account.

For more information, see Specifying Addresses on Billing Document Line Items.
Shipping City    
Shipping State/Province    
Shipping Zip/Postal Code    
Shipping Country    
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.

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.

For more information about how Billing Central uses this field, see Billing Document Line Item Fields.

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.

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:

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: Changing the tax value does not change the tax rate.
Tip:

Leave the field blank if you want this to be calculated using the tax code.

Applications That Add Fields to the Billing Document Line Item Object

Several FinancialForce applications add fields to the Billing Document Line Item object. For more information about how other FinancialForce applications use this object, follow the relevant links.

Application

Further Information
FinancialForce Accounting Billing Document Fields .
Billing Central  Billing Document Line Item Fields.
PSA Billing Document Line Item Fields .
Revenue Management  Billing Document Line Item Fields.
Supply Chain Management Billing Document Line Item Fields .