Multi Company

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, user will need access to the Sage database with permissions to create a table and grant rights on that table Codis provide a CentralDBConfig, utility which will create the table and allow records to be entered. It also provides a back up and restore facility.