Working with Multiple Companies

It is possible to set up a Central Database Definitions of the Sage companies to be used by Excelerator. This can save the end-user having to enter the connection details when changing companies.

The central definition is held in a new table - the ExcelCompanies table. The connection set up for each Excelerator user then points at this table, and the user selects which company to use from a simple list showing a company name and description.

To set this up you will need access to the Sage database with permissions to create a table and grant rights on that table Codis provide a utility, CentralDBConfig, which will create the table and allow records to be entered. It also provides a back up and restore facility.

This Section Contains

  1. Install /Configure Central Multi Company database
  2. Configure Multi Company on each client