Book Image

Microsoft Dynamics GP 2013 Implementation

By : Victoria Yudin
Book Image

Microsoft Dynamics GP 2013 Implementation

By: Victoria Yudin

Overview of this book

Microsoft Dynamics GP 2013 is a sophisticated Enterprise Resource Planning system with a multitude of features and options. The implementation of Dynamics GP is usually considered to be complex, and can be very confusing for both end users and consultants. Microsoft Dynamics GP 2013 Implementation will show you how to effectively implement Dynamics GP 2013 with ease. "Microsoft Dynamics GP 2013 Implementation" is a focused, step-by-step tutorial covering the basics of Microsoft Dynamics GP, from licensing to design, before moving on to more complex topics such as implementation planning, installation, setup, and training. Learn how to plan and execute your Dynamics GP implementation from start to finish. You will start off by learning how to plan a successful Dynamics GP 2013 implementation. You will then move on to learn the important questions to ask, the key setup details that should be decided upfront, and how to plan the infrastructure. Detailed descriptions of all the setup options for the core Dynamics GP modules as well as practical advice on setup will guide you through the myriad of options available in this powerful application. This book will also cover how to import initial data and how to find out what additional resources and tools are available for Microsoft Dynamics GP. With many detailed and practical examples, "Microsoft Dynamics GP 2013" Implementation will help you plan and complete a successful Microsoft Dynamics GP 2013 implementation.
Table of Contents (18 chapters)
Microsoft Dynamics GP 2013 Implementation
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
General Ledger Account Categories
Index

Creating an ODBC data source


Every computer that will be running the Dynamics GP application will need to have an ODBC data source pointing to the SQL Server. This is true for all servers and workstations, including the server where SQL Server is installed if you are installing the Dynamics GP application there.

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 a 32-bit 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 Server Native Client 10.0 (for SQL Server 2008 or 2008...