Sign Up for Training |
Jet Global Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Finding Dynamics GP (Great Plains) Configuration Information


Dynamics GP users need to know several pieces of information in order to configure their Jet Reports data source.  First, they must know the Server name. To find this, first open the Dynamics GP application.


On the login screen, there is a Server listed.  This is NOT the name of your GP server.

Copy this name down and then go to Start\Control Panel\Administrative Tools\Data Sources (ODBC). 

On the System DSN tab, you should see the same name that was listed in the Dynamics GP application.

Double-click on this data source to configure it. On the first screen, at the bottom, you should see a Server listed. This is the name of your actual GP server, which you need to enter into the Jet Reports options.


Next, you need to determine your login type and information.  GP can be configured in a number of different ways. In some cases, you can use the same username/password for Jet that you use to login to GP.  However, GP is not always configured like this; in some cases the application login may map to an entirely different database login or to a Windows login. If your GP application login doesn't work and if Windows authentication doesn't work, then you will probably have to ask your GP database administrator for the login information to the database. You need read access for both the company and dynamics databases.


Finally, you need the name of the GP company to use in Jet Reports.  In the GP application, the screen after the login screen shows you the list of companies available.  These are the same companies available in Jet Reports.

Was this article helpful?
0 out of 0 found this helpful