Options by Accounting System


Previous Page  Next Page

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.

 

Accounting Package

Accounting Data Setup

SQL / Seradex Version

Option A

Option B

Option C

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

 

1For 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.