Subscription line items

Linda continues her training on the Frisbii subscription for Candace and Axel, detailing the fields of the Subscription line item, which is linked to the Subscription in the same way that the Opportunity Product is linked to the Opportunity.

Definition of the subscription line item

This definition points to the purpose and description of the subscription line item

Object	Description
Subscription line item	The subscription line item allows us to quantify the subscription by specifying: the quantity, the unit price, the VAT and a discount rate. A Subscription can be linked to one or more Subscription line items.

The connection with other Frisbii objects

Here is the extract from the Conceptual Data Model showing the Subscription line item object and its connection with the other Frisbii objects. It shows you the connections between the objects mentioned and others that we will discover as we read the articles.

The object fields

Here is a list of fields by tab.

Details

Description	Textarea (255)	To be filled in, except if you use the Manage products button to create the subscription line item: in this case, the Product name field of the Product object is included.
Product	Lookup (Product)	Allows you to search for the product linked to the subscription line item, if applicable. If the product is deleted, the reference is removed from the field.
MRR	Formula (Currency)	Monthly Recurring Revenue (from Summer '21). Displays the monthly revenue of this subscription line item (if not First invoice only).
Subscription	Master - Details (Subscription)	Displays the subscription linked to the subscription line Item.
Change order	Lookup (Change order)	Displays the change order related to the subscription line item. A change order is automatically created when the subscription is renewed to indicate the conditions for extending the subscription.
Status	Picklist	Allows you to change the status of the Subscription line item. Picklist Values: Active, Cancelled, Completed.
Position	Number (4, 0)	Allows you to put the subscription line items in a certain order for display on the subscription PDF.
Detailed Description	Textarea (4000)	To be filled in unless you use the Manage Product button to create the subscription line item: then the Product Description field of the Product object is included.

Quantities & Amounts

Unit Price excl. VAT	Currency (16, 2)	Unit price excluding VAT. Field to be filled in. Automatically filled in if the Subscription is created from another object (Quotation, Opportunity).
Quantity	Number (10, 2)	Quantity. Field to be filled in. Automatically filled in if the Subscription is created from another object (Quotation, Opportunity).
Discount amount	Formula (Currency)	Discount amount of the Subscription line item. Formula: Quantity * Unit price excluding VAT * Discount rate. 2 decimal places.
Discount rate	Percentage (4, 6)	Discount rate applied to the Subscription line item. Field to be filled in. Automatically filled in if the Subscription is created from another object (Quotation, Opportunity).
Amount excl. VAT	Formula (Currency)	Amount before all discounts. Formula : (Quantity * Unit price before tax) - (Quantity * Unit price before tax * Discount rate). 2 decimal places.
VAT (%)	Picklist	VAT (in percentage) applied to the Subscription line item. This is a managed field, but you can add values to the list or restrict the list to those values necessary for your business needs.
VAT amount	Formula (Currency)	VAT amount of the Subscription line item. Formula : Amount before all discounts * VAT rate. 2 decimal places.
Amount incl. VAT	Formula (Currency)	Amount including VAT. Formula: Amount before tax + (Amount before all discounts * VAT rate). 2 decimal places.

Invoicing period

Start date	Date	Start date of validity of the Subscription line item.
End date	Date	End date of validity of the Subscription line item.
First invoice only	Checkbox	Allows this subscription line item item to be displayed only on the first invoice as an invoice line. This is the case, for example, for the registration fee for a gym or a material supplied at the start of a service - Internet box). If the subscription was created from a quotation, then this information is taken over from the Quotation line Item.
Invoicing Period Start Date	Formula (Date)	Indicates the start of billing for this Subscription line item. Formula: Takes over the Start field. If the Start field is not filled in and there is an active change order, the Start date of the change order is included. If the Start field is not filled in and there is no active change order, the First invoice date of the subscription is included.
Invoicing Period End Date	Formula (Date)	Indicates the end of billing for this Subscription line item. Formule : If The field Actual date of interruption of the linked subscription, And the End date field of the subscription line item are not filled in, And if there is an active change order linked to the subscription, The End date field of the change order is displayed. If The field Actual date of interruption of the linked subscription, And the End date field of the subscription line item are not filled in, And if there is no active change order linked to the subscription, The Billing Period End Date field of the subscription is displayed. If The field Actual date of interruption of the linked subscription is blank, And the End date field of the subscription line item is filled in, The End date field of the subscription line item is displayed. If The field Actual date of interruption of the linked subscription is filled in, And the End date field of the subscription line item is not filled in, The field Actual date of interruption is displayed. If The field Actual date of interruption of the linked subscription, And the End date field of the subscription line item are filled in, And the End date of the subscription line item is before the Actual date of interruption of the linked subscription, The End date field of the subscription line item is displayed. If The field Actual date of interruption of the linked subscription, And the End date field of the subscription line item are filled in, And the End date of the subscription line item is after the Actual date of interruption of the linked subscription, The field Actual date of interruption is displayed.
Do not distribute	Checkbox	Reduces the billing period to 1 day by setting the billing end date = start date. If the Periodic distributions license is activated (paid feature license) and this relevant box is ticked, only one periodic distribution will be generated with the end date = start date. Please note: if prorating is activated, the Subscription line item will automatically be prorated, so the Do not prorate box on the Subscription line item must also be checked. You will find the result of the prorating on the Invoice line item from this Subscription line item.
Do not prorate	Checkbox	Allows you not to apply the automatic prorating (if activated on the Corporate Name) for this subscription line item.

Accounting

Revenue account	Lookup (Accounting account)	Account in which the company records its financial actions according to the rules of the General Accounting Plan (GAAP). Displays the accounting account linked to the Subscription line item. Automatically filled in if the Subscription is created from another object.
VAT accounting account	Lookup (VAT accounting account)	Accounting account for Value Added Tax. Displays the VAT accounting account linked to the Subscription line item. Automatically filled in if the Subscription is created from another object.
Analytics 1 / Analytics 2	Text (255)	Information to be filled in according to your specific needs. It can be used in the reports, in order to make analyses on the different axes.

Fields to be added on the page layout if needed

If you want to add fields in this page, please follow the steps here: User interface - The new dynamic page layouts and how to change them from Summer '21.

Account	Formula (Text)	Takes over the account entered on the subscription.
Accurate Quantity	Number (8, 10)	Takes the value from the Quantity field. Quantity displayed with 10 decimal places. Used when exporting Sales Entries, as some accounting software requires more than 2 decimal places.
Accurate unit price excl. VAT	Currency (8, 10)	Takes the value of the Unit Price excluding tax field. Unit price before tax displayed with 10 decimals. Used when exporting Sales Entries, as some accounting software requires more than 2 decimal places.
Applicable Index?	Checkbox	Indicates whether or not the index should be applied to the invoice line items from this Subscription Item. Used in the formula to determine the Reference Index Coefficient.
Discount (%)	Formula (Percentage)	Takes the value from the Discount Rate field to two decimal places.
External ID	Text (255) (external ID) case sensitive, unique	If the Subscription line item is associated with a record in a third party system, you can enter the Subscription line item ID from that third party system here.
ID index	Formula (Text)	Takes the ID of the index entered on the Subscription. Reminder: the index is used to recalculate the total amount of invoices including tax from a certain date.
Index Reference Date	Formula (Date)	Date used for the calculation of the Reference index value. Formula: If there is no change order related to the Subscription, the Reference Index Date of the Subscription is adopted. If there is a change order linked to the Subscription, the index reference date of the change order is used.
Opportunity Product	Text (18)	If the Subscription was created from an Opportunity, this field is the link between the Opportunity Product and the Subscription line item.
Price Book Entry	Text (18)	Displays the price book linked to this Subscription. Allows you to associate a price book manually.
Price Book Price	Currency (16, 2)	Returns the price from the price book, if you are using price books and a product is linked to the Subscription line item.
Product code	Text (255)	If the product code is filled in on the product and you have created the Subscription line item by clicking on Manage Products, this field is filled in automatically.
Product rule	Lookup (Product rule)	Displays the product rule related to the Subscription line Item, if applicable. The product rule provides more information on the context of the product sale (product-related accounting accounts / product configuration).
Quotation Line Item	Lookup (Quotation Line Item)	If the Subscription was created from a Quotation, this field is the link between the Quotation line item and the Subscription line item.
Record Name	Auto number	This number is filled in automatically when the Subscription line item is created. Displayed by default in the button bar at the top of a record.
Reference for Calculating Index	Formula (Text)	Indicates which record the index calculation is based on. Formula: If the subscription line item is not linked to a change order: takes the Subscription ID. If the subscription line item is linked to a change order: includes the change order ID.
Reference Index Coefficient	Formula (Number)	Reference coefficient in the calculation of the revised price. Formula : If the Applicable Index? box is not ticked, the number 1 is filled in. If the Applicable Index? box is ticked and there is a change order linked to the Subscription, the Reference Coefficient of the change order is used. If the Applicable Index? box is ticked and there is no Subscription-related change order, the Subscription's Reference Coefficient is used.
VAT rate	Percentage (4, 4)	Displays the VAT rate that was set by the VAT% picklist with 4 decimal places.