Microsoft Dynamics GP 2010 Implementation电子书

Microsoft Dynamics GP 2010 Implementation

Table of Contents

Microsoft Dynamics GP 2010 Implementation

Credits

About the Author

About the Reviewer

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

1. Application Structure and Licensing

Structure of Dynamics GP—modules and series

Dynamics GP licensing

Core modules explained

Dynamics GP and Microsoft SQL Server

What you may not expect from a SQL Server application

Application security and SQL Server authentication

SQL Server databases created by Dynamics GP

SQL Server collation options

Where is the application server?

Dexterity and product dictionaries

Dexterity components

Dynamics GP products

Report Writer and Modifier

Financial reporting: AFA, FRx, and Management Reporter

Summary

2. Planning: Business Requirements

Implementation team

Who should be on the implementation team

Project manager

The team and practical considerations

To plan or not to plan

How to start planning

Not Just Widgets—a sample company

Identifying reporting needs

Financial statements

Multiple control accounts on Balance Sheets

Variations of Profit and Loss Statements

Management reports

Business forms

Running two systems concurrently

Pros

Cons

Recommendation

Populating data

Master data

Historical data

Open transactions

General Ledger

Payables Management

Receivables Management

Inventory

Purchase Order Processing

Sales Order Processing

Bank Reconciliation

How to import

Training

Implementation timeline

Summary

3. Planning: Dynamics GP System

Companies in Dynamics GP

Benefits of having one company in Dynamics GP

Benefits of having multiple companies in Dynamics GP

Integration with other systems

General Ledger Chart of Accounts

Account framework

Account format

Master record IDs and names

Fiscal periods and years

Users and security

Sales and purchase taxes

Additional setup considerations

Shipping Methods

Payment Terms

Credit Cards

Credit cards accepted from customers

Credit cards used to pay vendors

Posting setup

Post Through General Ledger Files

Create a Journal Entry Per

Posting Date From

Require Batch Approval

Multicurrency

Currencies

Exchange Rate Tables

Summary

4. Planning: Infrastructure

Scope of vision

Dynamics GP system requirements

Client requirements

Server requirements and recommendations

Terminal Server requirements

Additional notes and considerations

Virtual environments

64-bit or 32-bit

Printers

Officially supported—what it means to you

Network requirements

The Terminal Server only approach

Pros of a Terminal Server only implementation

Cons of a Terminal Server only implementation

Test/development environment

Add-on products

Shared files

Modified dictionary files

Shared network location

Locally on each Dynamics GP client

OLE notes

FRx files

Integration Manager files

Data backups

Additions to the implementation timeline

Summary

5. Installation of SQL Server, Dynamics GP, and Integration Manager

Pre-installation checklist

Check your server

Dynamics GP requirements

SQL Server requirements

Additional recommendations

Make sure you have all media and license keys

Installing as the local administrator

Installing Microsoft SQL Server for Dynamics GP

Installation steps

Installing the Dynamics GP 2010 application

Creating an ODBC data source

Steps to create the ODBC data source

Dynamics GP Utilities

Completing the Dynamics GP installation

Loading sample company data

Creating a new Dynamics GP company

Additional steps

Removing the SOP and Invoicing message

Changing paths for report dictionaries and forms

Changing path for OLE Notes

Installing additional products

Logging into Dynamics GP for the first time

Checking versions

Installing Integration Manager

Installation steps

Additional steps

Entering registration keys

Checking the version and applying service packs

Changing the Integration Manager database path

SQL Server and database settings

SQL Server settings

Maximum memory

Cursor Threshold

Processor

Database settings

General

Files

Options

Recovery model

Other options

SQL Server maintenance jobs

Backing up data

Summary

6. System and Company Setup

Logging into Dynamics GP

System setup

Show required fields

System password

System preferences

Dynamics GP registration

Creating Dynamics GP users

User security

Access to companies

User security

Multicurrency setup

Currency setup

Exchange rate tables

Multicurrency access

Additional system-wide setup

Home Page metrics

Default tasks

Company setup

Account format

Account setup

Multicurrency

Taxes

Tax details

Tax schedules

Company setup

Company Setup window

Internet User Defined

Company options

Fiscal Periods

Shipping Methods

Payment Terms

Credit Cards

Posting setup

Posting Setup

Posting Accounts

E-mail setup

Company e-mail setup

Summary

7. Module Setup: General Ledger, Bank Reconciliation, Payables, and Receivables

General Ledger

General Ledger setup

Categories

Segments

Account currencies

Bank Reconciliation

Checkbooks

Bank Reconciliation Setup

Payables Management

Payables Management Setup

Payables Setup Options

Vendor classes

Accounts for vendor classes

1099 setup

Purchasing E-mail setup

Vendors

Setting up vendor e-mail options

Receivables Management

Receivables Management Setup

Receivables Setup Options

Sales Territories

Salespeople

Price levels

Customer classes

Accounts for customer classes

Sales e-mail settings

Customers

Customer setup

Customer accounts

Customer options

Customer e-mail settings

Summary

8. Module Setup: Inventory, SOP, and POP

Inventory

Inventory Control Setup

Inventory sites

Unit of Measure Schedules

Item class setup

Item class currency setup

Item class accounts setup

Inventory Item Setup

Item Maintenance

Item Internet Information

Item Maintenance Options

Item Account Maintenance

Item Currency

Price List

Price List Options

Purchasing Options

Item vendors

Assigning items to sites

Kits

Copying items

Sales Order Processing

Sales Order Processing Setup

Sales Document Setup

Quote

Order

Back Order

Fulfillment Order/Invoice

Return

User-Defined Fields

SOP Document Numbers

Sales Order Processing Setup Options

E-mail Settings

Customer Items

Purchase Order Processing

Purchase Order Processing Setup

Purchase Order Processing Options

Receivings User-Defined

E-mail Settings

Summary

9. Populating Initial Data

Basics of Integration Manager

Components of an integration

Properties

Source(s)

Destination

Destination Mapping

Running an import

Open transactions

General Ledger account import

General Ledger transactions

Vendors

Open payables transactions

Customers

Open receivables transactions

Inventory items

Inventory transactions

Summary

10. Training, Tools, and Next Steps

Training

How to train and who should be training?

How much training and for whom?

When to train?

Notes for the trainer

Available training resources

Tools for Dynamics GP

Professional Services Tools Library

Free tools

Other useful tools

Installing the Professional Services Tools Library

Tools from Microsoft's Professional Services Team

Support Debugging Tool

Troubleshooting tips

Tests

Important information

Additional resources

Knowledge Base

Forums

Blogs

Summary

A. General Ledger Account Categories

B. Microsoft Professional Services: Additional Tools Available

Index