|
This section will describe how to connect Seradex ot your Great Plains Customer, Vendor and GL Cards. Seradex utilizes the customer, vendor and chart of account cards in Great Plains for source information. Adding or modifying a customer, vendor or GL account is done in Great Plains. Other information obtained from Great Plains includes information contained on these cards like payment terms, currencies, exchange rates, sales taxes and territories.
If you are on the SQL Server version of OrderStream AND the Great Plains database is setup on the same server you can setup the link a much simpler way. In the sxRuntime.mdb that contains the connection information to SQL Server there is a field called LinkedServerName.
You can fill this value with the SQLServer and database information and update accounts links directly to Great Plains SQL Server. To find this value do the following:
| 1. | Launch Enterprise Manager |
| 2. | Click your Server then select databases and select your Seradex Database |
| 3. | Select Views then Create a new view. |
| 4. | Leave this window open and go to your Great Plains Database and expand the tables. |
| 5. | Pick any table you want and drag it onto the grey area in the view window. Now it will tell you the Server and owner name by looking at the view. For example: DYNAMIC S.dbo.W20000 1 |
The DYNAMICS.dbo is the value you put in the LinkedServerName in this case.
|
