Invoice and sales order settings and defaults

Find this screen

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings

How to

Change your settings

These settings determine how orders and invoices can be processed.

To change the settings, click Edit.

Note: If you can't see the Edit button, then you don't have access to edit the settings. If you need to change settings, speak to your System Administrator.

Choose your settings on each tab:

  • Document numbering.

    Set the starting number to be used for the next purchase order, return, quotation, pro forma, despatch note, invoice, or credit note.

  • Invoice and Order Entry.

    Choose whether to use VAT inclusive or VAT exclusive prices on your invoices and orders.

    Choose how to process payments.

    Choose generic customer accounts to use for one-off sales and potential customers (prospects).

  • Sales Assistance.

    When you enter a full sales order or quotation, you can add other items that the customer might be interested in buying.

    • Use Suggested items to see items that are specific to the customer. These include the customer's preferred items (you can think of these as 'favourites'), and items that the customer has recently ordered and frequently ordered.
    • Use Cross-selling items to see items that are often sold together with an item you've added to the order or quotation. For example, if you sell a printer, you might want to show print cartridges or cables for that printer.
  • Printing and Tracking.

    Choose whether to print despatch notes when goods are despatch with sales orders.

  • Invoice Printing.

    Choose the text that you want to print on some types of invoice.

  • Intrastat.

    Set up Intrastat options for sales orders.

Document numbering

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Document Numbering.

You can set the starting number to be used for the next purchase order, return, quotation, pro forma, despatch note, invoice, or credit note.

Changing the numbering will not affect the numbering of any existing documents, it will only apply to subsequent documents that you create. Each time that a new document is created, the document number will be incremented by 1.

You can only use numbers in the reference (characters 0-9).

When you create a sales order or return, the document number will be displayed.

Use stock and/or free text lines

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Invoice and Order Entry.

You can choose to restrict the kind of lines that can be added to invoices and orders. You might want to do this if you're not using stock items (standard items), as this removes the Stock line type from the invoice and sales order screens.

  • Standard items only: Free text lines won't be available when entering invoices and sales orders.

  • Free text items only: Stock item lines won't be available when entering invoices and sales orders.

  • Both standard and free text items: You can enter both types of line.

Note: You can't add free text lines to Rapid entry or Trade counter entry sales orders. You can change these to full orders by selecting the Full Order Entry button when entering one of these types of order.

Payment with invoices and orders

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Invoice and Order Entry.

If you want to, you can record the receipt of a payment at the same time as entering an order or invoice. This is useful if your customers pay when goods are ordered.

If you never take payments with orders then you don't need to turn this on.

  • Allow payments to be recorded during invoice and order entry - select this to turn on the payment options. This adds a payment tab to the order entry screen.

  • Sales orders only - Invoice payment with sales order immediately - Choose this to make this option selected by default on the Payment with order or tab. You can change this on individual orders if you need to.

    See About invoicing payments with orders immediately.

  • Enable card processing - Allows you to enter card payments using Opayo (formerly Sage Pay). Once selected an Online card payment option is added to the Payment Methods.

Changing this:

These can be changed at any time. Once changed the new settings only affects subsequent invoices and orders.

Pricing

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Invoice and Order Entry.

Note - warning

You can change the settings you selected in the Configuration Assistant here, but once you save an invoice or sales order, pro forma or quotation, you cannot change whether your prices are inclusive or exclusive of VAT, so you should ensure you are happy with your choice before proceeding.

You must choose whether your selling prices are inclusive or exclusive of VAT.

Choose whether to use VAT inclusive or VAT exclusive prices on sales orders and invoices. This determines how prices are calculated.

  • Prices exclude VAT - VAT is added to the item price. For example, an item has a selling price of £100 and VAT is 20%. When this item is added to an order or invoice, £20 VAT is added making the total value £120.
  • Prices include VAT - VAT is deducted from the item price. For example: An item has a selling price of £100 and VAT is 20%. When this item is added to the order or invoice, the VAT is deducted from the selling price making the total value £83.33, after deducting £16.67 VAT.

Once set, this applies to all orders and invoices.

Changing this:

This can't be changed once any orders or invoices have been entered and saved.

Set accounts for cash sales and prospects

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Invoice and Order Entry.

The cash account account is a generic customer account that you use to record cash sales for one-off customers, so you don't have to create individual accounts for these customers.

The prospect account is a generic customer account that you use to record quotes or pro formas for prospects (prospective customers), so you only have to set up a customer account when the customer makes a purchase.

Note - warning

Do not use the same customer account for both the cash account and prospect account, as these are used for different purposes.

Set up and use a cash account

It's useful to set up a cash account if you make a lot of cash sales for one-off customers, so you don't have to create individual accounts for these customers. For example, you might use this account for a till in a shop, or for when customers pay at the point of sale and there's no need for you to keep a record of their name and address.

It's useful to set up a cash account when you don't want to keep a record of sales to individuals, such as for school uniform.

The cash account can't be used as regular account, so it doesn't show on the customer list. When you enter orders, invoices and quotes, choose Cash account instead of selecting the customer.

Note: You can't enter a VAT only invoice for the cash account as a VAT only invoice is a legal document which requires a name, address and VAT registration number.

The account you select here is only used the next time you select the Cash account when you enter an invoice or sales order.

Create a cash customer account
  1. First, create a customer account for cash customers.

    1. Open Customers > Create & Amend Accounts > Create Customer.
    2. Give the account the name Cash, or something more appropriate to your organisation.
  2. Set this account as the Cash account.

    1. Open Settings > Invoicing and Sales Orders > Invoice and Order Settings.
    2. Go to the Invoice and Order Entry tab.
    3. Select your cash account in Default Account for Cash Invoices and Orders.
Enter an invoice or order using the cash account
  1. Enter a new invoice or order and choose Cash account at the top. The 'Cash' customer account is automatically selected.

  2. If you need to enter an invoice address, you can do this on the Delivery & Invoicing tab.

  3. If you need to enter a payment, for a cash sale for example, enter this on the Payment with Invoice or Payment with order tab.

Set up and use a prospect account (sales orders only)

It's useful to set up a prospect account if you send quotes or pro forma invoices to prospective customers, so you only have to set up a customer account when the customer makes a purchase.

The account you select here is only used the next time you select the Prospect account when you enter a quotation or pro forma.

Create a prospect account

  1. First, create an account for prospect customers.

    1. Open Customers > Create & Amend Accounts > Create Customer.

    2. Give the account the name Prospect, or something more appropriate to your organisation.

  2. Set this account as the prospect account.

    1. Open Settings > Invoicing and Sales Orders > Invoice and Order Settings.

    2. Go to the Invoice and Order Entry tab.

    3. Select your customer prospect account in Quotations and Pro Formas For Prospects.

Enter a quotation or pro forma using the prospect account

  1. To enter a quotation for a prospect, use either:

    • Sales Orders > Quotations > New Quote for Prospect.

    • Sales Orders > Quotations > New Quote, and select Prospect account.

    You can then enter the customer's name and address details on the form.

  2. To enter a pro forma invoice for a prospect, use either:

    • Sales Orders > Proformas > Enter New Pro Forma for Prospect.

    • Sales Orders > Proformas > New Proforma, and select Prospect account.

    You can then enter the customer's name and address details on the form.

  3. When converting the quote or pro forma to a sales order, you can create a new customer account using the same details.

Sales Assistance

When you enter a full sales order or quotation, you can add other items that the customer might be interested in buying.

  • Use Suggested items to see items that are specific to the customer. These include the customer's preferred items (you can think of these as 'favourites'), and items that the customer has recently ordered and frequently ordered.
  • Use Cross-selling items to see items that are often sold together with an item you've added to the order or quotation. For example, if you sell a printer, you might want to show print cartridges or cables for that printer.

Printing and Tracking

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Printing and Tracking

  • Choose whether to print despatch notes when goods are despatched for sales orders.
  • To record tracking and shipping information when you despatch items in a sales order, enable Record tracking on despatch.

    • When you despatch an order, you will be prompted to add tracking and shipping information. For example, you can enter the courier, consignment number, Incoterm, reason for export, weight, number of pieces, and any notes for the shipment.

      You can skip this step if there is no tracking information to add, or you are not ready to enter it during despatch.

      To despatch an order item and record tracking information, see Record despatch of goods and services.

    • If you want to add or amend tracking and shipping information after you have despatched the order item, use Amend Tracking Information.

      To amend tracking information, see Tracking and shipping information for a despatch.

Invoice printing

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Invoice Printing

You can specify the following text to be printed on your invoices:

  • Text to indicate that the invoice has been paid. This defaults to Paid in Full, but you can change it if you want to.
  • Text that's included on invoices that you produce for Opayo (formerly Sage Pay), Sage Invoice Payments, and GoCardless.

    See Change the text displayed on invoices.

  • For invoices that contain EU zero rated sales, we supply a number of messages approved by HMRC that you that you can select from.

  • If you use domestic reverse charge VAT rates, we supply a number of HMRC approved messages you can choose from.

Note: EU zero rated sales and domestic reverse charge options only apply if your company is registered for VAT in the UK, so if your company's country is not GB, you won't see these options on the screen.

Domestic reverse charge (mobiles)

This applies to using domestic reverse charge VAT rates, to prevent carousel fraud.

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Invoice Printing

If you use these reverse charge VAT rates on your invoices:

  1. Select Apply domestic reverse charge VAT rules when printing invoice. This makes sure the appropriate processing is applied when printing the invoices.

  2. Select one of the approved messages to print on the invoices from Print the following text on invoice/credit note when reverse charge is applied. The HMRC recommends that this text is included on invoices that are eligible for reverse charge VAT.

    • VAT Act 1994 Section 55A applies.

    • s55A VATA 94 applies.

    • Customer to account for the VAT to HMRC.

    • Reverse charge supply - customer to pay the VAT to HMRC.

    • Customer to pay VAT to HMRC.

    • UK customer to pay VAT to HMRC.

Note: To apply the same rules to credit notes, you must specifically select the reverse charge VAT rate on the sales return line.

For more information, see Domestic reverse charge VAT rates for preventing carousel fraud in the UK.

Construction Industry Scheme (CIS) reverse charge

Note - warning

Sage 200 Standard does not support the Construction Industry Scheme (CIS).

You do not need to set the options for Print the following text on invoices when CIS reverse charge is applied and Print the following text on credit notes when CIS reverse charge is applied.

Intrastat (sales orders only)

Open: Settings > Invoicing and Sales Orders > Invoice and Order Settings | Intrastat

If your company buys or sells goods in the EU, then you may need to report on this if the total value of this trade is more that the an amount specified by HMRC (Northern Ireland), or the Revenue Commissioners (Ireland). This is called an Intrastat Declaration.

  • If you're required to complete an Intrastat declaration, select Generate Intrastat entries for sales orders/returns.

Note - warning

Invoices created through the Invoicing module are not included on Intrastat returns.


Useful Info

About entering payments with invoices and orders

If you want to be able add payments at the same time as entering an order or invoice, you'll need to make sure you've set up Sage 200 correctly.

You might want to do this if your customers pay at the time of ordering or if you take deposits.

Before you can enter a payment you will also need to set up Payment Methods. These describe the type of payment (cash, debit card, credit card, etc.), and the bank account the payment is to be paid into. You can set these up at any time once you have finished the Configuration Assistant. Use the Settings > Sales Orders > Payment Methods screen.

About invoicing payments with orders immediately (sales orders only)

This only applies to sales orders. If you're using Invoicing then you would generally expect to post the invoice within a few days of raising it.

The option here sets Invoice with payment immediately to be selected by default when an order is entered. You can change it on individual orders, if required.

HMRC rules state that VAT should be recorded on the VAT Return at the time of invoicing or on receipt of the payment, whichever is the first. When a payment is taken at the time of ordering, you need to decide whether the payment should be invoiced at the same time. This is because the payment must have a tax point date in the same period as the money was actually received.

About Opayo and card processing

Opayo (formerly Sage Pay) is an online card service provider similar to PayPal. Opayo integrates seamlessly with Sage 200 making it easier for your customers to pay you and easier for you to process those payments.

Once you've subscribed and integrated Opayo with Sage 200, you can:

  • Take card payments from your customers and input them directly into Sage 200. This is useful when a customer pays you over the phone.
  • Add Pay Now buttons to invoices, statements and debtor letters, so your customers can pay you immediately. Your customer just clicks the button and enters their card details.
  • Import payments made using the Pay Now option, directly into Sage 200.

See Take card payments using Opayo (formerly Sage Pay).

Note - information

Sage is providing this article for organisations to use for general guidance. Sage works hard to ensure the information is correct at the time of publication and strives to keep all supplied information up-to-date and accurate, but makes no representations or warranties of any kind—express or implied—about the ongoing accuracy, reliability, suitability, or completeness of the information provided.

The information contained within this article is not intended to be a substitute for professional advice. Sage assumes no responsibility for any action taken on the basis of the article. Any reliance you place on the information contained within the article is at your own risk. In using the article, you agree that Sage is not liable for any loss or damage whatsoever, including without limitation, any direct, indirect, consequential or incidental loss or damage, arising out of, or in connection with, the use of this information.