Field dictionary

This module explains the utility of the invoice object which is part of our application.
You will learn more about the use cases, the implementation and the actions that can be triggered from this object.

Invoice Definition

Let's go back to the definition we saw in the article First steps in Frisbii - main objects in Frisbii.

Object	Description
Invoice	An invoice is a general accounting document that proves a purchase or sale. An invoice is proof of a creditor's claim against a debtor, i.e. a customer's debt to a supplier.

Relationship with other objects

After this rather technical introduction, we will learn more about the different invoice fields.

Object fields by section

Here is a list of fields by section.

Details

Reference

Text

Depends on the Invoice Prefix indicated on the Corporate Name tab.
Automatically enters a reference for this invoice, if the box is checked in the Administration tab.
From the Summer 21 release, this field is not displayed before issuance.

Corporate Name

Lookup (Corporate Name)

Associated with the object Frisbii Corporate name.
Displayed on the PDF of the Quotation.

Account

Lookup (Account)

The invoice must be linked to an Account.
Associated with the Salesforce Account object.
Information displayed on the Invoice PDF.

Accounting Data

Lookup (Accounting data)

Accounting billing information of an Account.
Associated with the Frisbii Accounting Data object.

Contact

Lookup (Contact)

Associated with the Salesforce Contact object.
Information displayed on the Invoice PDF.
Required if you want to send the PDF of the Invoice by email.

Payment method

Picklist

The agreed payment method for the Invoice.
To be customized from the global value set in the list.

Term of payment

Picklist

The agreed-upon time period for payment of amounts due.
Refers to a set of global values, including:
- X days net: X days from the start date
- X days end of month: X days from the last day of the month
From the Summer 21 release, the field Custom term allows you to customize the payment term (since the payment terms are very restricted in France)

Invoice date

Date

By default, the creation date of the invoice.
Used in the billing automation.
Displayed on the PDF of the invoice.

Due date

Date

Date on which the invoice amount becomes due.

Delivery date

Date

To be displayed if needed on the Invoice PDF.

Type

Picklist

Used to distinguish an invoice from a credit note.

Subtype

Picklist

Allows you to distinguish the possible subtypes of an invoice (Advance payment/ Sold) or a credit note (Refund/ Cancellation/ Discount/ Additional discount). You can add subtypes in the list according to your business needs
Depends on the Type field used.
Can be displayed on the Invoice PDF.

Status

Picklist

Record Status: Draft, Pre-Validated (from Spring'20), Issued.
Depending on your business needs you can add values to the selection list.
Can be used in automations to avoid processing draft or issued invoices.

Stage

Picklist

Allows you to indicate the actions related to an invoice.
Steps proposed by Frisbii: To be validated, Validated, Sent, To be restarted, Cancelled. To be customized according to business needs
Can be used in automations.

Origin

Picklist

Indicates the origin of the invoice (in the context of a subscription)
- Ex-nihilo : Invoice not generated from a billing schedule, created ex-nihilo.
- Schedule: Invoice from a billing schedule.
- Regularisation: Billing Regularisation (please find more information here : Subscriptions - Billing regularisation.
Refers to a set of global values.

Presentation

Subject	Text Field	To be filled in to be displayed as a title on the Invoice PDF. Conditional field on the PDF template: if the field is empty, it will not be displayed on the PDF.
Special terms	Text Area	Allows you to fill in the special terms of the Invoice in order to display them on the PDF template.
Your Ref.	Text Field	Reference of the purchase order or signed estimate.
Comments	Text Area	Conditional field on the PDF template: if the field is empty, it will not be displayed.
Other Template	Lookup	Allows you to set up a different PDF template for the Invoice than the one entered in the Corporate Name. This template will only be applied to this Invoice.
Show product details	Checkbox	Allows you to display the details of the products on the PDF of the Invoice. Attention : the Description field must be filled in the Product linked to the Invoice Line of the concerned Invoice.
Show detailed description	Checkbox	Allows you to display the details of the products on the PDF of the Invoice. Attention : the Detailed Description field must be filled in the Invoice Line of the concerned Invoice
Show percentage	Checkbox	Displays the percentage applied to the Invoice Lines on the Invoice PDF (this field concerns partial invoicing).
Show discount	Checkbox	If this box is checked, the Discount Rate is displayed as a column in the main table of the Invoice. From the Summer 21 release, checked by default for companies based in France, please see also: Invoices - Mandatory information for invoicing from a french corporate name.
Show Bank Details	Checkbox	If this box is checked, the bank details entered in the Corporate Name tab will be displayed on the Invoice PDF. From the Summer 21 release, checked by default for companies based in France, please see also: Invoices - Mandatory information for invoicing from a french corporate name

Amounts, discounts and special conditions

Amount excl. VAT	Roll-Up Summary	Amount of the Invoice Line items, after application of the discounts. 2 decimals.
Amount incl. VAT	Formula (currency)	Amount including VAT after all discounts on the Invoice. Formula : Total before tax + Total other taxes + VAT amount after discount 2 decimals.
VAT (%)	Formula (percentage)	VAT percentage of the Invoice. The VAT rate is indicated on the Invoice Lines. VAT amount after discount / VAT amount after discount.
VAT amount	Formula (currency	Resume the VAT field after any discounts on the Invoice. If the box Old VAT calculation is checked : VAT amount (rows) * (1-Footer discount rate)
Bottom line discount rate	Text Field	Indicates the bottom line discount applied on the Invoice
Discount reason	Text Field	Reason for a discount at the bottom of the page. Field included in the PDF of the Invoice. From the Summer 21 release, not displayed if the Bottom line discount rate field is blank.
Discount amount	Formula (currency)	Sum of the discount defined on the Invoice Line items (line discount + bottom line discount) 2 decimals.
Discount Amount (Lines	Roll-Up Summary	Sum of the discount amounts of the Invoice Lines. 2 decimals.
Discount total	Formula (currency)	Total discount amount of the Invoice. Sum of the discount defined on the Invoice Line items and the bottom line discount of the Invoice. 2 decimals.
Discount total (%)	Formula (percentage)	Indicates the discount rate taking into account the footer discount and the line discount. If Amount before all discounts = 0, then 0% is displayed Otherwise: Total discount/ Amount before all discounts.
Amount excl. VAT before discounts	Roll-Up Summary	Sum of the amounts of the Invoice Line items before any discount. 4 decimal places.
Amount excl. VAT after discounts	Formula (currency)	Amount after discount. Total amount before all discounts - Total discount 2 decimals

Recovery

From Summer '21 release, this tab is only displayed when the invoice is issued.

Age	Formula (number)	Age of the Invoice. Takes into account: Date of invoice, Date of last payment, Due date.
% Paid	Formula (percentage)	Percentage paid of the invoice amount. Formula: If the Omitted box is checked the percentage paid is considered as 100%. If the Omitted box is not checked and the Total including VAT is higher than 0€. (Cumulative settlements + Cumulative charges)/ Total including VAT 2 decimals.
Force Invoice Balance	Checkbox	Allows you to force the balance of an Invoice, independently of the Payments.
Reason for Clearing Invoice	Text Area	This is why the Invoice is marked as cleared.
Omitted	Checkbox	If the box is checked, the Invoice or Credit note will not be taken into account in the reports and dashboards.
Debt Collection	Formula (Text)	Indicates the progress of the payment of the Invoice (progress bar).
Balance Due	Formula (Currency)	Payment amount expected on the Invoice. Formula: If the Force Invoice Balance check box is checked or the invoice is in draft 0€ is displayed If the check box Force Invoice Balance is not checked and the invoice is issued Total including VAT - Accumulated payments - Accumulated charges
Payable Balance Due	Roll-Up Summary	Indicates the amount of Payment due on the Invoice. Sum of the Pending and Due Payment amount
Payment Due on	Date Field	Date on which the next payment is expected. Automatically filled in by the due date, if empty when the Invoice is issued. Value taken into account in the automated dunning process. Here is an article on this subject: Automation - Dunning: fields
Last Payment Date	Roll-Up Summary	Date of the last payment received for the Invoice. If the Pending box is not checked in the Payment.
Next Expected Payment Date	Roll-Up Summary	Date of next payment of the Invoice (according to schedule). If the Pending box is checked on the Payment.
Last Dunning Date	Date	Date of the last reminder on the Invoice. Field to be filled in by the automatic dunning process. This field can also be used to store information for manual dunning.
Dunning Level	Picklist	Indicates the steps of the dunning performed. By default: R0 : no incident R1 : 1st e-mail sent R2 : 2nd e-mail sent R3 : 3rd e-mail sent (last reminder before formal notice) R4 : formal notice Here is an article on this subject: Automation - Dunning: fields
Cumulated Payments	Roll-Up Summary	Accumulation of Payment on the Invoice. The Pending checkbox is not checked in the Payment. 2 decimals.

Related objects

Quotation	Lookup	Displays the quotation related to this invoice.
Opportunity	Lookup	Displays the opportunity related to this invoice.
Accounting data	Lookup	Displays the accounting data related to this invoice.
Initial Invoice	Lookup	Only displayed if the invoice is a credit note The initial invoice links to the invoice on which the credit note was created.
Subscription	Lookup	Subscription linked to this invoice.
Start Date	Date	Start date of the subscription linked to this Invoice.
End Date	Date	End date of the subscription linked to this Invoice.

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 .

Accurate amount incl. tax	Formula (Currency)	Precise amount including VAT (after any discounts on the Invoice). 4 decimal places.
Accurate total VAT after all discounts	Formula (Currency)	Precise VAT amount (after any discounts on the Invoice). 4 decimal places.
Automatic Issuance	Checkbox	Used in the automations. If the box is checked, the invoice is issued automatically. Here is an article on this subject: Automation - Invoices issuance
Automatic Dunning	Checkbox	Used in the automations. If the box is checked, the dunning is done on the Invoice. Here is an article on this subject: Automation - Dunning: fields
Amount excl. VAT (Lines)	Roll-Up Summary	Sum of the amounts of the Invoice Lines. Before footer discount. 2 decimals.
Coefficient	Number	This field is used to calculate the amounts. If it is a Credit note, the calculation is made with a coefficient of "-1". If it is an Invoice, the calculation is made with a coefficient of "1".
Credit Note?	Formula (Checkbox)	Indicates if the Invoice is of type Credit Note. Useful for filters in list views on the Invoice object.
Cumulated Apportionments	Currency	The sum of payments that are not pending on the credit.
Customer	Lookup	Allows you to display a second account on the Invoice / Invoice PDF. Useful, for example, if you have a final customer and a paying customer.
Discount (%)	Formule (Percent)	Discount rate applied on the Invoice. 2 decimal places.
Draft Invoice	Formula (Checkbox)	Indicates if the Invoice Status is Draft.
Duplicate	Checkbox	Allows to display on the PDF of the invoice if it is a duplicate (PDF created on an issued invoice).
External ID	Text Field	If the Invoice is associated with a record in a third party system, you can fill in the Invoice ID from that third party system here.
Forecast Invoice Amount excl. VAT	Formula (Currency)	Displays the amount before tax if the Invoice is in draft. Used for the Billing Plan on the Quotation or Opportunity. 2 decimals.
Incl. VAT (Old Calculation)	Checkbox	Summary of cumulative amounts before tax after discount, old calculation method less accurate than the one implemented from Spring '20.
Index (ID)	Formula (Text)	Index identification code, if the Invoice is linked to a Subscription.
Index Coefficient to Date	Number	Value of the index coefficient, at a specific date.
Index date	Date	Date used to calculate the index value (index revision).
Invoice Date Index	Lookup	Index taken into account on the Invoice, at a precise date.
Invoicing Period (Days)	Number	Number of days of the period during which the Invoice is taken into account.
Issueable	Formula (Checkbox)	Conditions for issuing the Invoice. Used in the automations. Formula: If the invoice is in draft and Either there is no subscription linked to the invoice Or the subscription is activated
Issued Invoice	Formula (Checkbox)	Indicates if Invoice Status is Issued.
Issued Invoice Amount	Formula (Currency)	Displays the amount before tax if the Invoice is issued. Used for the Billing Plan on the Quotation or Opportunity. 2 decimals.
Language	Picklist	By putting this tag language="{!sofactoapp__Client_Invoices__c..sofactoapp__Language__c}" in your Invoice template, the language chosen on the Invoice will be applied to PDFs created from this Invoice. Attention: Like VAT, the language can be configured at several levels (inheritance). You can also configure it at the level of the Account, the Accounting Data, the Corporate Name or the Quotation.
Late	Formula (Checkbox)	Indicates if the Invoice is overdue. Formula: If Either the due date is less than today Or the expected payment date is less than today And The balance was not Forced on the Invoice The Invoice is issued The Invoice is not of the Credit type
Ledger Entry	Lookup	Record the accounting entries related to this Invoice.
Locked Invoice	Checkbox	Indicates whether the Invoice is locked.
Number of Lines with Percentage	Roll-Up Summary	Number of Invoice Lines with a percentage applied. Different from 100% applied.
Number of PDF Invoices	Roll-Up Summary	Number of Invoice PDFs generated on the Invoice.
Other Bank Details	Lookup	Allows you to add other bank details than those set by default in the Corporate Name. These bank details will only be applied to this Invoice.
Paid	Checkbox	Indicates if the invoice is balanced. Checked if the balance due is equal to 0.
Paid Invoice?	Formula (Checkbox)	Indicates if the amount of the Invoice is fully paid. Checked if the invoice is issued and the balance is 0€.
Payment Schedule	Lookup	Allows you to link a Payment Schedule. Here is an article on this subject: Payment schedule - generating a payment schedule
Percentage	Percent	Invoiced percentage (of the Invoice).
PDF reference	Lookup	Registration number of the Invoice PDF. Automatically filled in after saving the PDF.
Price Book	Lookup	Displays the price book related to this Invoice.
Product Configuration	Lookup	Indicates the product configuration possibly applied on the Invoice.
Record Name	Auto Number	Number used by Frisbii to identify the Invoice. Chronological numbering.
Recurring Invoice	Formula (Checkbox)	Indicates whether the Invoice is from a Subscription.
Regularise Payments?	Formula (Checkbox)	Allows you to update the Payment on the Invoice. The box is checked if : Balance not due is different from this accumulation: Total including VAT - Accumulated settlements - Balance due due - Accumulated charges
Show Percentage	Formula (Checkbox)	Displays on the Invoice PDF the percentage applied to the Invoice Line items.
Unmatured Balance Due	Roll-Up Summary	Balance of the invoice still to be paid. The Pending box is checked in Payment. Payment Due is not checked in Payment.
VAT Amount before Discount	Roll-Up Summary	VAT amount of the Invoice Line items. 4 decimal places.
VAT total after all discounts	Formula (Currency)	Total amount of VAT, once discounts are applied.

Frisbii API package extension fields

These fields are only available if Frisbii Support France has set you up with the Frisbii API extension package in order to use Stripe or Frisbii Payments payment methods.

Payment URL

Text area

Entered by Stripe or Frisbii Pay
Frisbii Pay - Change your custom Invoice PDF Template