This page is for the Microsoft Dynamics GP using the Microsoft SQL Server Database Engine. The Server that SQL Server (and probably Dynamics GP) is installed on is required (along with the instance name if any).

Please follow steps below to configure your Dynamics company to the Open Accounting Connector application.
Click each step below for a pictorial view

Now that the application is installed please double click the Open Accounting Connector desktop shortcut. Some configuration details are required to connect to Dynamics. A few of these details can be found in Dynamics. Server Name:This is the Server Name the database is held on including the instance name in format "ServerName/InstanceName" Database: On the right this is the field in Blue, this Window can be found in Microsoft Dynamics GP > Maintenance > SQL. Please select seek the second database in the drop-down list and enter into Open Accounting Connector's configuration panel User / Password: These are the credentials used to log into Dynamics - you can create a user, please see Advanced below . Click 'Test Connection' when the form is complete. The connection would successful if all credentials are correct and will prompt which is incorrect. Now click Finish and Extract to submit your first data load!

Your Open Accounting Connector application may be setup to retrieve data automatically at a predefined schedule, this functionality relies to be logged on at the scheduled time. Due to the nature of Servers, it may rarely be logged into. So if the Open Accounting Connector application is installed on a Server, extractions may not always perform automatically. To enable this feature a task scheduler would have to be created.
To create a task scheduler please go to the installation path of Open Accounting Connector, usually held in C:\Open Accounting Connector_xxx\ Open the taskSchedule.bat file and follow the instructions.

To create a Dynamics user for the Open Accounting Connector application, please follow the steps below. This user is a Microsoft SQL Server user as well and has access rights to your Company Database. Please log into your Dynamics company and navigate to Microsoft Dynamics GP > Setup > System > User.
Now please create a user ensuring that Enforce Password Policy is un-ticked. Then save.

Your user has now been created for your Dynamics GP company, this can now be entered into the Configuration Panel.

If after clicking the Test Connection button an error message appears it is most likely that one (or more) of the credentials entered are incorrect. Below are a few examples of the typical errors and how to handle them:

• Incorrect username/password:
  
  If this error appears, the SQL Server username or password is incorrect ? remember the username and password required to connect Gemini. This can either be a read-only user set up in SQL Server or the username and password used to log into Dynamics GP.


• Incorrect Server/ Server not located
  
  

  If this error appears the Server isn't able to be located. This could be due to a number of reasons.

  • The server might be turned off
  • The server may not be on the same network as the same PC Open Accounting Connector is running from
  • The PC Open Accounting Connector is running from may not have access to that server
  • The server may have an instance that the database (that Dynamics GP is using) is located on.
  • The server may be using a different TCP/IP
  • There might be spelling error


• Database error:
  
  

  If this error appears the database name is incorrect. Please double check the name of the database Dynamics GP uses to store its data, please see Step 2 on how to locate the database name.