Field descriptions: Sales invoice

Field Description
Bill-to customer

The bill-to customer defined on the shipment, or the customer you create the invoice for.

You can select from a list of active customer records.

Invoice date Defaults to the date you create the invoice. You can edit it.
Number

The final invoice number. It is generated when you create and save the sales invoice. It is based on the sequence number assigned to the sales invoice document type.

Depending on your legislation, it can be updated when you post the invoice so that posted invoices have a chronological and sequential number. This updated number is generated from a second sequence number having the Chronological control checkbox selected. In addition, this second sequence number is assigned to the invoice type document having the Assign on posting checkbox selected.

This number is used in the financial flow in your financial solution.

The original number is displayed in the Creation number field in the Information tab.

Sales site

The site that manages the sales.

  • For an invoice created from a shipment, it defaults to the shipment sales site.
  • For a direct invoice, select a site. You can select from a list of sites defined as sales sites on the Site page.

Lines tab

Field Description
Customer order reference The purchase order number used by the customer when they placed the order.
Gross price The item price before applying the charge or discount percentages.
Item description Defaults to the description on the item record. You can edit it if needed.
Item name

The ordered item.

Jurisdiction The jurisdiction only applies if you are using the Avalara tax calculation. It displays the state, county, or town for which the tax is collected.
Net price The net price of the item. It's the result of the gross price minus the discount plus the charge percentages.
Origin

The origin of the line.

  • It defaults to Shipment when the invoice is created from a shipment.
  • It defaults to Direct when the line is a direct line.
Quantity in sales unit The ordered quantity in the sales unit.
Sales unit The sales unit.
Total excluding tax The total amount for the order line without tax. It's the quantity multiplied by the net price.
Total including tax The total including tax amount for the order line. It's the sum of the total excluding tax and the total tax amount.
Total tax The total tax amount in the order currency.

Detail panel of a sales invoice line

Information tab

Field Description
Entity use code The entity use code only applies if you are using the Avalara tax calculation. It is related to the customer address and provides information about the type of customer they are, and whether they are exempt from tax.
Item description The item description defaults to the item description on the item record. If there's no description on the item record, it defaults to the item name. You can edit it if necessary.
Item name

The ordered item.

When you create a direct line, you can select an item from a list of services and not stock managed items.

Origin

The origin of the line.

  • It defaults to Shipment when the invoice is created from a shipment.
  • It defaults to Direct when the line is a direct line.
Provider site
  • For lines created from a shipment, it's the stock site.
  • For direct lines, it's the sales site. It's the invoice sales site by default.

Sales block

Field Description
Quantity in sales unit

The quantity shipped on the shipment line, or the invoiced quantity for a direct line. The quantity displays in the sales unit.

Sales unit The sales unit.

Stock block

Field Description
Quantity in stock unit The quantity in the stock unit.
Stock unit

The stock unit.

Stock unit conversion factor The sales to stock unit conversion factor.

Price tab

Field Description
Charge The percentage of the item gross price added as a charge.
Discount The percentage of a special discount applied to the item gross price.
Gross price The item price before applying the charge or discount percentages.
Net price The net price is the result of the gross price minus the discount plus the charge percentages.
Price origin
  • Base price: When the customer does not have a price list for the item, and the item base price is used for the gross price.
  • Manual: When the gross price is entered or updated manually.
  • Price list: When the customer has a price list which is used along with any associated discount or charge percentages.
Price reason

This field applies only when the invoice is created from a shipment. It displays the price reason if a customer price is used for the order line.

Customer price reasons are managed on the Customer price reason page.

Totals block

Field Description
Gross profit amount The gross profit for the line in the order currency. It's the total excluding tax amount minus the stock cost amount.
Stock cost amount The stock cost for the line in the order currency. It's the line quantity multiplied by the item unit cost.
Total excluding tax

The total excluding tax amount in the invoice currency. It's the quantity multiplied by the net price.

Total excluding tax company currency

The total excluding tax amount converted to the sales site company currency. It displays only when the company currency differs from the transaction currency.

Total including tax

The total including tax amount in the invoice currency. It's the sum of the total excluding tax and the total tax amount.

Total including tax company currency The total including tax amount converted to the sales site company currency. It displays only when the company currency differs from the transaction currency.
Total tax The total tax amount in the invoice currency.

Address tab

Field Description
Consumption address
  • For an invoice created from a shipment, the consumption address is the ship-to address defined on the shipment. You cannot edit it.
  • For an invoice created manually, the consumption address defaults to the bill-to customer primary address. You can replace or edit it.
This address is important because it is used to know which taxes apply to the items.

Origin tab

Field Description
Document type The origin document type such as sales shipment.
Origin document number The origin document number and a link to this document.
Status The origin document status.

Progress tab

If credit memos have been generated from the invoice, you can track their statuses and quantities from this tab.

Field Description
Credit status

Indicates if the invoice is credited or not.

  • Not credited: No credit memo is created for the invoice line.
  • Partially credited: Only a portion of the line amount is credited.
  • Credited: One or more credit memos are created for the invoice line.
Credited quantity

The number of items credited for the invoice line. If there are several credit memos for this line, it's the total quantity of items of all the credit memos.

Quantity in progress

The number of items that need to be credited for the invoice line.

The information related to the credit memos is displayed in a grid. There are as many lines as credit memos.

Field Description
Amount credited

The amount credited on the credit memo.

Credit memo number

The credit memo number and a link to this credit memo.

Credit memo status

The credit memo status.

  • Draft: The credit memo is created.
  • In progress: Post has been selected on the credit memo. The credit memo is going through the posting process.
  • Posted: The credit memo is posted. The journal entries have been created.
  • Error: An error is occurring in the posting process.
Quantity credited

The quantity credited on the credit memo.

Line notes tab

The notes you enter on this tab relate to the sales invoice line. If you want to add notes for the sales invoice in general, go to the Notes tab of the sales invoice.

Field Description
Add notes to customer document

The switch to make the customer note text box available. If you keep this switch on, the notes print under the corresponding line on the PDF sales invoice.

Customer line notes The text box where you can add customer notes. If the Add notes to customer document switch is on, these notes print under the corresponding line on the PDF sales invoice.
Internal line notes

The text box where you can add notes you want to share with your colleagues about the sales invoice line. Those notes are only for internal purposes. Customers cannot see them.

Taxes window

Field Description
Amount The amount that is charged on the line after applying the tax rate to the taxable base.
Category

The tax category. For example, Value added tax. It's determined by the legislation linked to the sales site company.

Tax categories are managed on the Tax category page.

Tax

The tax is determined by the following elements:

  • The stock site address
  • The customer ship-to address
  • The item tax group defined on the Item page, and the tax determination rules defined on the Tax determination rules page

You can change the tax. For example, the system has selected Normal rate collected on debits but you can change it to Intermediate rate collected on debits.

 

Tax and tax rates are managed on the Tax page.

Tax rate

The tax rate associated with the tax. It is used to calculate the tax amount to be charged on the line.

 

Tax and tax rates are managed on the Tax page.

Taxable base The amount for the line without the charge.
Total excluding tax The total amount for the line without tax.
Total including tax

The total including tax amount for the line.

Total tax

The total tax amount to be charged on the line, in the invoice currency.

Information tab

Field Description
Creation number

A creation number can be used when creating the credit memo. When the credit memo is posted, the final credit memo number populates on the Number field on the header. The final number is used in the financial flow in your financial solution.

Sequence number rules are managed on the Sequence number assignment page.

Due date The invoice payment due date.
Incoterms rule The Incoterms® rule defined on the shipment, or the Incoterms® rule for the bill-to customer.
Payment term The bill-to customer payment term.
Printed This checkbox is selected when you print a posted invoice.
Sent

This checkbox is only selected when you send the invoice to the recipient through the automatic email sending system.

There's no indication if you send a printed invoice by email or by mail.

Transaction currency

The bill-to customer currency. It defaults to the currency of the bill-to customer on the shipment, or the bill-to customer you have selected.

Bill-to address

The bill-to address defaults to the customer's primary bill-to address. You can edit the address, or replace it by selecting another one. You can select from a list of active bill-to addresses listed on the customer record.

Field Description
Address line 1 and 2

The address details.

City

The city or town where the address is located.

Country

The country where the address is located.

Name

The company or person at this address.

Phone number

The phone number for the address.

State
County
Region
Division
Department

The field label and formatting change according to the selected country.

ZIP code
Postal code

The postal code or ZIP code according to the selected country.

Totals tab

Field Description
Excluding tax Total excluding tax amount of all the lines in the invoice currency.
Gross profit The gross profit for the sales invoice. It's the sum of the gross profit amount of all the lines.
Including tax Total including tax amount of all the lines in the invoice currency.
Tax Total tax amount of all lines in the invoice currency.

Summary by tax

This grid displays the total taxable base and amount, per tax, and per rate.

For example:

  • All the invoice lines whose tax is Normal rate collected on debits are summed up on one line.
  • All the invoice lines whose tax is Reduced rate deductible on debits are summed up on another line.
Field Description
Amount The total tax amount for the invoice lines matching the tax.
Category

The tax category.

Tax categories are managed on the Tax category page.

Jurisdiction The jurisdiction only applies if you are using the Avalara tax calculation. It displays the state, county, or town for which the tax is collected.
Rate

The tax rate associated with the tax .

Tax and tax rates are managed on the Tax page.

Tax

The tax.

Tax and tax rates are managed on the Tax page.

Taxable base The total excluding tax amount of all the invoice lines that use the same tax.

Amounts in company currency block

Field Description
Excluding tax Total excluding tax amount of all the invoice lines in the company currency.
Including tax Total including tax amount of all the invoice lines in the company currency.

Posting tab

Field Description
Accounting integration reference The reference in your financial solution.
Diagnoses An explanation of the error or errors that occurred during the posting process.
Document number The document number and a link to the document.
Document type The document type such as journal entry or accounts receivable invoice.
Status The posting status.
  • Posting in progress: The posting is in progress.
  • Posting error: An error occurred during the posting.
  • Posted: The posting was done with no error.

Notes tab

The notes you enter on this tab relate to the sales invoice. If you want to add notes for a particular line, go to the Line notes tab of the line detail panel.

Field Description
Add notes to customer document

The switch to make the customer note text box available. If you keep this switch on, the notes print on the PDF sales invoice for the customer.

Customer notes The text box where you can add customer notes. If the Add notes to customer document switch is on, these notes print on the last page of the PDF sales invoice.
Internal notes

The text box where you can add notes you want to share with your colleagues about the sales invoice. Those notes are only for internal purposes. Customers cannot see them.

Repeat all the line notes on new documents.

If it's switched on, the line notes are repeated on the corresponding credit memo lines.

Repeat the document notes on new documents.

If it's switched on, the notes at document level are repeated on the sales credit memo.