Below is a chart showing the various options on how to setup the Accounting Link when your Seradex Database is on the SQL Server 2000/2005 Platforms. Please cross reference with your accounting package setup to select the correct option to use.
|
|
|
|
|
|
AccPac Windows
|
Pervasive/DB2
|
2000 and <6.2
|
X
|
|
|
Pervasive/DB2
|
2005 or 6.2+
|
|
|
X
|
SQL Server Same Server as Seradex
|
2000 and <6.1
|
X
|
|
|
SQL Server Same Server as Seradex
|
2000 and 6.1+
|
X
|
X2
|
|
SQL Server Same Server as Seradex
|
2005 or 6.2+
|
|
X2
|
X
|
SQL Server Different Server from Seradex
|
2000 and <6.2
|
X
|
|
|
SQL Server Different Server from Seradex
|
2000 and 6.2+
|
X
|
|
X2
|
SQL Server Different Server from Seradex
|
2005 or 6.2+
|
|
|
X
|
BusinessVision
|
2000 and <6.2
|
X
|
|
|
2005 or 6.2+
|
|
|
X
|
Great Plains
|
SQL Server Same Server as Seradex
|
2000/2005 and 6.1+
|
X
|
X2
|
|
SQL Server Different Server from Seradex
|
2000 and <6.2
|
X
|
|
|
SQL Server Different Server from Seradex
|
2005 or 6.2+
|
|
|
X
|
QuickBooks1
|
1 | For Quickbooks, no setup is required as the accounting link works by opening QuickBooks, so there is no need to link to Seradex |
2 This is the recommended option; however, the other option(s) will work
N.B. For Options A and C, you need to link/attach the Appropriate Accounting system tables directly to a new Microsoft database that we refer to as the SQLLink.mdb.
|