Book Image

Microsoft Dynamics GP 2010 Implementation

By : Victoria Yudin
Book Image

Microsoft Dynamics GP 2010 Implementation

By: Victoria Yudin

Overview of this book

Microsoft Dynamics GP 2010 is a sophisticated Enterprise Resource Planning application with a multitude of features and options. The implementation of Dynamics GP is usually considered to be complex, and can be very confusing for users and consultants. This step-by-step guide will show you how to effectively implement Dynamics GP 2010 with ease.This focused, step-by-step tutorial covers the basics of Microsoft Dynamics GP, from licensing, to design, before moving on to more complex topics such as implementation and setup. You will learn how to install and configure Microsoft Dynamics GP 2010 from start to finish.This book will enable you to master the implementation of Microsoft Dynamics 2010 effectively. This book starts with how to plan and complete a successful Microsoft Dynamics GP 2010 implementation. You will then move on to learning who should be on the implementation team, what important questions should be asked and how to plan your infrastructure for Dynamics GP 2010. Detailed descriptions of all the setup options for the core Dynamics GP modules as well as practical advice on setup will help guide you through the myriad of options available in this powerful application. As you reach the end of the book you will learn how to import your initial data with illustrations and practical examples.
Table of Contents (18 chapters)
Microsoft Dynamics GP 2010 Implementation
About the Author
About the Reviewer
General Ledger Account Categories
Microsoft Professional Services: Additional Tools Available

Creating an ODBC data source

Every computer that needs to run the Dynamics GP application will need to have an ODBC (Open Database Connectivity) data source pointing to the SQL Server. This is true for all servers and workstations, including the server where SQL Server is installed.

Even though Dynamics GP is supported on 64-bit operating systems, it is a 32-bit application and requires a 32-bit ODBC data source. To create the ODBC data source on a 64-bit operating system, run the Odbcad32.exe file, found in the C:\Windows\SysWOW64\ directory instead of following Step 1 as shown in the following section, then follow the steps starting with Step 2.

Steps to create the ODBC data source

The following are steps to create the ODBC data source for Dynamics GP:

  1. Go to Start | Control Panel | Administrative Tools | Data Sources (ODBC).

  2. Click on the System DSN tab.

  3. Click Add and choose one of the following drivers:

    • SQL Native Client (for SQL Server 2005)

    • SQL Server Native Client 10.0 (for SQL Server...