Sales Invoices

Introduction

Codis' Sales Invoice Excelerator allows Sage 200 Sales Invoices and Credit Notes to be entered and amended from Excel.

Features include:

Entry of single or multiple sales invoices on a single sheet.
The download of existing sales invoices from Sage 200.
Browse Sage data and pick from browse to enter on the sheet.
Support for project accounting.
Optional extended validation to check for duplicate references.
The usual Excelerator features, as described in Introducing Excelerator.

Info

To create Sales Invoices using Sales Invoice Excelerator, the user must have access to the "Enter Sales Invoice" feature in Sage.

To create Sales Credit Notes using Sales Invoice Excelerator, the user must have access to the "Enter Sales Credit Note" feature in Sage.

Standard templates

Templates are working examples of Excel worksheets for use with Excelerator. You can use the standard templates as they are, amend them using the Template Designer, or create your own templates from scratch.

Codis provides a single template workbook: S200SLInvoiceTemplate.xlsx.

This workbook has four worksheets:

Single This worksheet allows the entry of a single invoice.

SingleGV This worksheet allows the entry of a single invoice using the Goods/VAT indicator.

Multiple This worksheet allows the entry of multiple invoices.

MultipleGV This worksheet allows the entry of multiple invoices using the Goods/VAT indicator.

Clear All

This menu option will clear down the data in the Excelerator ranges.

You can choose just to clear down the detail ranges by changing the "Don't Clear Header Ranges" under Options.

Options

Don't clear header ranges

If this is ticked, when the Clear All menu option is selected, the header ranges (single cell ranges) will not be cleared.

Transaction size

If this option is set to 0 (the default), Excelerator saves on an all-or-nothing basis, attempting to save all the invoices on the worksheet but saving none if an error is encountered.

This allows the worksheet to be corrected and a save attempted again without saved records being removed.

If set to a positive integer, the Transaction Size is the number of invoices saved in one batch. All invoices in a batch will be saved if all are valid or if none are. This should only be set to non-zero if you use the "Status from Save, Validation or Delete" range to track which invoices have successfully been saved. If you don't include this range, you will be warned:

See Validating and Saving in Batches.

Only process unsaved?

Used in conjunction with the "Status from..." range. If this option is ticked, invoices with "Saved" in the Status range will be ignored when validating. This can save time when validating larger datasets. See Validating and Saving in Batches.

Only process unvalidated?

Used in conjunction with the "Status from..." range. If this option is ticked, invoices with "Valid" in the Status range will be ignored when validating. This can save time when validating larger datasets. See Validating and Saving in Batches.

Continue save after error?

If this option is ticked, Excelerator will continue trying to save invoices after errors are found on other invoices. See Validating and Saving in Batches.

Populate nominal code after account browse?

If this option is ticked, then when browsing on customers, Excelerator will populate the first line of the nominal analysis of the invoice with the default revenue code for the selected customer.

Duplicate Reference Checking Options before Release 3.5.207

Check for reference duplication.

If this is ticked, then Excelerator extends the usual validation to check:

That a reference is entered.
The reference for the same invoice date doesn't already exist on an invoice item in Sage.

Check for second reference duplication.

If this is ticked, then Excelerator extends the usual validation to check:

That a second reference is entered.
The second reference for the same invoice date doesn't exist on an invoice item in Sage.

Duplicate Reference Checking Options from Release 3.5.207

From Release 3.5.207, the duplicate reference checking has been enhanced. The options are now:

Check for reference duplication.

This now has three options:

NoCheck
Warning
Disallow

If Warning or Disallow are selected, then Excelerator will check that a reference is entered, and then for duplicate invoice items in Sage. The check for duplicates is controlled by new options detailed below. If no value is entered or a duplicate is found, then the user will either be warned about saving the invoice or it will not be allowed.

Check for second reference duplication.

This now has three options:

NoCheck
Warning
Disallow

If Warning or Disallow are selected, then Excelerator will check that a second reference is entered, and then for duplicate invoice items in Sage. The check for duplicate second references is controlled by new options detailed below. If no value is entered or a duplicate is found, then the user will either be warned about saving the invoice, or it will not be allowed.

Check Reference Duplication by:

This option controls how duplicate references are detected. You can choose either:

Reference - just check if there is already an invoice with the same reference number.
ReferenceAndInvoiceDate - check if there is already an invoice with the same reference number and invoice date.

Check 2nd Reference Duplication by:

This option controls how duplicate references are detected. You can choose either:

Reference - just check if there is already an invoice with the same second reference number.
ReferenceAndInvoiceDate - check if there is already an invoice with the same second reference number and invoice date.

Calculate Values

This menu option will calculate tax values for invoices and credit notes on your sheet. Only invoices with lines with values will be processed.

It will look at all invoices and credit notes and their nominal analysis, calculate the following values and populate the sheet with the new values.

Invoice (gross) value.
Tax Analysis Total.
Nominal Analysis Total.
Tax Value.
Exchange Rate.
Invoice Goods Value.
Discount.
Discount Days.
Tax Discount
Discounted Invoice Total
Require Authorisation
VAT Adjustment Document Expected?
For each of the nominal analysis lines:
Tax Value
Discount Value
Tax Code
Tax Short Code
Tax Rate
Tax Discount Amount

Entering Invoices and Credit Notes

Sales Invoices

You can enter sales invoices in the Standard templates supplied with Excelerator or design your own.

You can enter a single invoice or multiple invoices in a single worksheet.

You can enter a Credit Note by using the "Type" range and entering "CreditNote".

You may want to Validate Sage Data before you save.

Use the Save to Sage button to save the data.

The worksheet will be populated with calculated data after the save.

Default Data

As with all Excelerators, SL Invoice Excelerator will try to use default values where none are entered. For instance, you do not have to include a Due Date range on the sheet. Excelerator will work out a due date from the supplier's payment terms.

Credit Notes

To create a credit note:

Include the DocumentType range on the spreadsheet. See Designing Templates.
Enter "CreditNote" into that range. You can browse to pick CreditNote or Invoice.

Entering a Single Invoice

You can use the "Single" worksheet on the template or design a similar one with a single customer and invoice number cells in the header.

Entering Multiple Invoices

You can use the "Multiple" worksheet on the template or design a similar one with the customer and invoice number ranges as columns.

Validating and Saving In Batches

This feature functions in the same way as the Validating and Saving In Batches purchase invoice functionality.

Transaction Enquiry

The Transaction Enquiry menu button lets you download invoice transactions onto the Excelerator worksheet.

You will be prompted to enter a customer's account reference. You can use the dropdown button to pick a customer.

The selection will default to the entered customer if one is entered on the sheet. Note: Only an active customer can be entered. When you select a customer, all transactions for the customer will be listed in a browse window. (See Searching and Filtering In Browse).

Info

You can select transactions from one or multiple customers, depending on whether the sheet allows.

The following options are available:

Exclude Control Account Posting - this will exclude the control account and VAT postings when downloading transactions to the sheet.
Reverse Sign of Credit Note values - this will reverse the sign of credit notes. You should include the document type range if ticking this so that credit notes can be identified.

Printing

Sales invoice printing will print a Sage report that lists sales ledger transactions for the customers on the sheet.

The user can highlight customers on the sheet or print transactions for all of them. The report will not include transactions entered on the sheet but not saved to Sage.

See Printing.

Info

The Sage report used is Sales Ledger Transactions Report.report

Use Cases

See Entering Project Expense And Revenue

Entering VAT

Please see Entering VAT. This describes the different ways of entering VAT for purchase invoices, but the same principles apply to sales invoices.