Invoice Sales

You create a sales invoice or sales order to record your agreement with a customer to sell certain products on certain delivery and payment terms.

There are a couple of scenarios where you must use a sales order instead of a sales invoice:

  • If you need to ship only part of an order quantity, for example, because the full quantity is not on hand.
  • If you ship products after you post the corresponding sales invoices.
  • If you sell items that your supplier delivers directly to your customer, known as drop shipment. For more information, see Make Drop Shipments.

In all other aspects, sales orders and sales invoices work in the same way. For more information about how to use sales orders, see Sell Products.

You can negotiate with the customer by first creating a sales quote, which you can convert to a sales invoice when you agree on the sale. For more information, see Make Sales Quotes.

Create sales invoices

If the customer decides to buy, you post the sales invoice to create the related quantity and value entries. When you post the sales invoice, you can also email the document as a PDF attachment. You can have the email body prefilled with a summary of the invoice and payment information, such as a link to PayPal. For more information, see Send Documents by Email. When the customer then pays the invoice, you can register that payment in different ways, depending on the size and preferred workflows of your organisation. For more information, see the Registering Payments section.

Items cards can be of type Inventory, Service, and Non-Inventory to specify if the item is a physical inventory unit, a labour time unit, or a physical unit that is not kept on inventory. For more information, see Register New Items. The sales invoice process is the same for all three item types.

You can fill customer fields on the sales invoice in two ways depending on whether the customer is already registered. See step 2 in the following procedure.

To create a sales invoice

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Sales Invoices, and then choose the related link.

  2. In the Customer field, enter the name of an existing customer.

    Other fields on the Sales Invoice page contain standard information about the selected customer. If the customer is not registered, follow these steps:

    1. In the Customer field, enter the name of the new customer.
    2. In the dialogue box about registering the new customer, choose the Yes button.
    3. On the Select a template for a new customer page, choose a template to base the new customer card on, and then choose the OK button.
    4. A new customer card displays the information on the selected customer template. Fill in the remaining fields. For more information, see Register New Customers.
    5. When you have completed the customer card, choose the OK button to return to the Sales Invoice page.

    Several fields on the sales invoice are now filled with information that you specified on the new customer card.

  3. Fill in the remaining fields on the Sales Invoice page as necessary. Hover over a field to read a short description.

    Note

    If you allow the customer to pay immediately, for example, by cash or by PayPal, then fill in the Payment Method Code field. The payment is then recorded as soon as you post the sales invoice. If you select CASH, then the payment is recorded in a specified balancing account.

    You are now ready to fill in the sales invoice lines for products that you are selling to the customer or for any transaction with the customer that you want to record in a G/L account.

    If you have set up recurring sales lines for the customer, such as a monthly replenishment order, then you can insert these lines on the order by choosing the Get Recurring Sales Lines action.

  4. On the Lines FastTab, in the Type field, select what type of product, charge, or transaction that you will post for the customer with the sales line.

  5. In the No. field, select a record to post according to the value in the Type field.

    You leave the No. field empty in the following cases:

    • If the line is for a comment. Write the comment in the Description field.
    • If the line is for a catalogue item. Choose the Select Catalogue Items action. For more information, see Work With Catalogue Items.
  6. In the Quantity field, enter how many units of the product, charge, or transaction that the line will record for the customer.

    Note

    If the item is of type Service, or the Type field contains Resource, then the quantity is a time unit, such as hours, as indicated in the Unit of Measurement Code field on the line. For more information, see Set Up Item Units of Measurement

    The value in the Line Amount field is calculated as Unit Price x Quantity.

    The price and line amounts are with or without sales tax, depending on what you selected in the Prices Including Tax field on the customer card.

  7. If you want to give a discount, enter a percentage in the Line Discount % field. The value in the Line Amount field updates accordingly.

    If special item prices are set up on the Sales Prices and Sales Line Discounts FastTab on the customer or item card, the price and amount on the sales line automatically update if the price criteria is met. For more information, see Record Sales Price, Discount, and Payment Agreements.

  8. Repeat steps 9 through 12 for every product or charge that you want to invoice the customer for.

    The totals fields under the lines are automatically updated as you create or modify lines to display the amounts that will be posted to the ledgers.

    Note

    In very rare cases, the posted amounts may deviate from what is displayed in the totals fields. This is typically due to rounding calculations in relation to GST or US sales tax.

    To check the amounts that will actually be posted, you can use the Statistics page, which takes into account the rounding calculations. Also, if you choose the Release action, the totals fields will be updated to include rounding calculations.

  9. In the Invoice Discount Amount field, enter an amount that should be deducted from the value shown in the Total Incl. US Tax field.

    If you have set up invoice discounts for the customer, then the specified percentage value is automatically inserted in the Invoice Discount % field if the criteria are met, and the related amount is inserted in the Inv. Discount Amount Excl. Tax field. For more information, see Record Sales Price, Discount, and Payment Agreements.

  10. When the sales invoice lines are completed, choose the Post and Send action.

The Post and Send Confirmation dialog box displays the customer's preferred method of receiving documents. You can change the sending method by choosing the lookup button for the Send Document to field. For more information, see Set Up Document Sending Profiles.

The related item and customer ledger entries are now created in your system, and the sales invoice is output as a PDF document. The sales invoice is removed from the list of sales invoices and replaced with a new document in the list of posted sales invoices.

Calculating invoice discounts on sales

When all the items have been entered as lines, you can calculate the invoice discount for the entire sales document by choosing the Calculate Invoice Discount action.

The discount is calculated based on all the lines in the sales document for items where the Allow Invoice Disc. field on the sales order line contains Yes. This is the default setting for items. Lines with item charges, for example, are not included in the calculation of the invoice discount. If you want to apply a discount to such lines, you must set the Line Discount % field on the relevant lines.

Tip

If the Calc. Inv. Discount field is selected in the Sales and Receivables Setup page, then the invoice discount is calculated automatically when you do either of the following on a sales document:

  • View statistics
  • View a test report
  • Print
  • Post

The invoice discount terms for a customer are defined in the Cust. Invoice Discounts page for the customer. The currency code on the sales document is used to find the invoice discount terms in the corresponding currency.

If invoice discounts have not been defined for foreign currencies, then the invoice discount terms defined in the Cust. Invoice Discounts page with amounts in your local currency and the exchange rate on the posting date on the sales document are used to calculate the invoice discount in the foreign currency.

Posted invoices

Once the invoice has been posted, you can find it in the list of posted invoices. Both the Posted Sales Invoices list and the Posted Purchase Invoices list show the posted invoices with the final invoice numbers. From the list, you can look up each posted invoice, and you can correct or cancel a posted invoice.

For each posted invoice, you can look up statistics, dimensions, and the ledger entries that are the result of the posted invoice. You can also print or send the posted invoice.

You can easily correct or cancel a posted sales invoice before it is paid. For example, this is useful if you want to correct a typing mistake or if the customer requests a change early in the order process. For more information, see Correct or Cancel Unpaid Sales Invoices. If the posted sales invoice is paid, then you must create a sales CR/Adj note to reverse the sale. For more information, see Process Sales Returns or Cancellations.

Open the Posted Sales Invoices list in Business Central.

Registering payments

Depending on your business needs, you can get paid and register that payment in different ways: manually, automatically, and through payment services.

You can process the payments straight from the customer card. Use the Register Customer Payments action to get an overview of unpaid invoices for that customer. Then, mark the invoice as paid partially or in full. This payment reconciliation processes your customer payments by matching amounts received on your bank account with the related unpaid sales invoices, and then posts the payments. For more information, see To reconcile payments individually.

In business environments where the customer pays some time after delivery, according to the payment term, a posted sales invoice remains open (unpaid) until the Sales Ledger department verifies that payment is received and applies the payment to the posted sales invoice. This can be done manually or automatically. For more information, see Reconcile Customer Payments with the Cash Receipt Journal or from Customer Ledger Entries and Reconcile Payments Using Automatic Application.

In business environments where the customer pays immediately, for example by PayPal or cash, payment is recorded immediately when you post the sales invoice, that is, the posted sales invoice is closed as fully applied. You select the relevant method in the Payment Method Code field on the sales order. See under step 8. For electronic payments, such as PayPal, you must also fill in the Payment Service field. For more information, see Enable Customer Payments Through Payment Services.

You can even create directly-paid invoices for non-registered customers by first setting up a "cash customer" card, which you point to on the sales invoice. For more information, see Set Up Cash Customers.

Tip

If you want to send your customers reminders of overdue payments, you must set up reminder levels and terms. For more information, see Set Up Reminder Terms and Levels.

External document numbers

On sales documents and journals, you can specify a document number that refers to the customer's numbering system. Use this field to record the number that the customer assigned to the order, invoice, or CR/Adj note. You can then use the number later if, for some reason, you need to search for the posted entry using this number.

The Ext. Doc. No. Mandatory field on the Sales & Receivables Setup page specifies whether it is mandatory to enter an external document number in the External Document No. field on a sales header and the External Document No. field on a general journal line.

If you select this field, it will not be possible to post an invoice or a general journal line without an external document number.

The external document number is included in posted documents where you can search by the relevant number. You can also search using the external document number when navigating on customer ledger entries.

A different way to handle external document numbers is to use the Your Reference field. If you use the Your Reference field, the number will be included in posted documents, and you can search by it in the same way as for values from External Document No. fields. But the field is not available on journal lines.

See Also

Sales
Setting Up Sales
Print the Picking List
Inventory
Send Documents by Email
Collect Outstanding Balances
Bulk Invoicing from Microsoft Bookings in Business Central
Work with Business Central