Skip to content

Suppliers

Introduction

Suppliers Excelerator allows Sage 200 Suppliers to be added and amended.

Features include:

  • Suppliers' records can be created or amended individually or in bulk.
  • Existing supplier records can be downloaded and amended.
  • Existing supplier record can be deleted if it is not used in any of the transaction(s).
  • Browse Sage data and pick from browse to enter on the sheet.
  • Ability to print existing Purchase Ledger Aged Creditors report directly from Excel.

Please see our Quick Tutorial on importing suppliers into Sage from Excel.

To use this Excelerator, you must have permission to use the "Enter Supplier Account Details" to add suppliers and "Amend Supplier Account Details" to amend suppliers.

Info

To use Suppliers Excelerator, the user must have access to the following features in Sage:

  • Enter Supplier Account Details
  • Amend Supplier Account Details

See also: Sage 200 Configuration

Standard Templates

Codis provides the template S200SupplierTemplate.xlsx. You can, of course, amend this template or create your own. (See Designing Templates ).

The S200SupplierTemplate.xlsx includes sheets which allow:

  • Single - Entry of a single supplier.
  • Multiple - Entry of multiple suppliers.

Options

Save validated items immediately?

This option determines how Excelerator saves suppliers from the Save option.

If it is not ticked, Excelerator will validate the entire sheet and save it if all suppliers are valid.

If it is ticked, Excelerator will validate one supplier, save it if valid, and move on to the next supplier.

Do not ignore blank ranges?

This option controls how Excelerator treats blank cells in ranges.

If this is not ticked, then blank cells will be ignored. This means:

  • Existing values will not be overwritten when updating.
  • Blank is not validated as a valid value. (There are a few values like some address fields where blank is valid.)
  • A default value will be generated when saving a new record.

If this is ticked, then blank cells will not be ignored. This means:

  • Existing values will be overwritten when updating.
  • Blank is validated as a valid value.
  • A default value will not be generated when saving a new record.

Maintain contact order as on the sheet?

Allow duplicate codes on the sheet?

Excelerator will validate if the same supplier code is entered more than once on the sheet. If this option is ticked, duplicate codes will be allowed.

Transaction size

If this option is set to 0 (the default), Excelerator saves on an all-or-nothing basis. It attempts to save all the suppliers on the worksheet but saves 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 suppliers saved in one batch. All suppliers within this 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 suppliers have successfully been saved. If you don't include this range, you will be warned:

See Partial Validation and Saving of Data on a Sheet

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 Partial Validation and Saving of Data on a Sheet

Only process invalidated?

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 Partial Validation and Saving of Data on a Sheet

Continue save after error?

If this option is ticked, Excelerator will continue trying to save invoices after errors are found with other suppliers.

See Partial Validation and Saving of Data on a Sheet

Update existing external IDs?

This option applies when Using Excelerator To Import Data and tracking external IDs. If not ticked, if an external ID is found on the import that already exists, there will be a validation failure. Otherwise, the supplier data will be treated as an update to the existing supplier.

Printing

This feature prints the "Purchase Ledger Aged Creditors Report (Detailed)" report for the suppliers on the sheet.

See also: Printing

Download

This feature lets you download existing Sage suppliers onto the Excel sheet for amendment.

Validate

Validate will check that the data on the spreadsheet is compatible with Sage accounting rules. It validates all the data and displays any errors in a new panel. Sage is not updated.

Info

Save also validates the data, but Validate will validate faster than Save. Also, it will attempt to report all errors in the data in one run, whilst Save will stop on the first error it finds. It can be more efficient to use Validate before Save because of these reasons.

Sage 200 Excelerator CB Payments Validation

Validate lists any issues, the error description, and the line where the error occurred. By clicking next to the error, Excelerator takes you to the row in question.

To use, select Validate from the Ribbon for the relevant module. A panel is displayed listing all rows where Excelerator encountered problems.

Click next to the row to be directed to the row where Excelerator encountered the issue (see above).

A box like this one appears when Validate encounters no errors, and the data is ready to Save to Sage.

Any validation errors will be displayed in the Validation panel, as shown below. Red light lines are errors, yellow are warnings.

Info

Ticking "Fixed" does not correct an error but acts as a reminder that the error has been corrected.

Mirror Ranges

Mirror ranges are ranges that mirror the ranges used to update the suppliers. They are populated by the download, populate or browse features, and are read-only.

They can be used to provide a copy of supplier data before any updates are made and can by used by formula in the updatable ranges.

Delete

This feature allows all suppliers on the worksheet to be deleted.

Warning

All suppliers entered on the sheet that can be deleted, will be deleted.

Before any suppliers are deleted, you must confirm by entering "DELETE" into the input box.

Populate

When you have one or more Supplier code(s) already entered on the sheet, and you want to bring all related details, select the 'Populate 'menu option as shown below: