Developing Microsoft Dynamics GP business applications : build dynamic mission-critical applications with this hands-on guide / Leslie Vail.

Format:

Book

Author/Creator:

Vail, Leslie.

Language:

English

Subjects (All):

Business--Computer programs.

Business.

Microsoft software.

Physical Description:

1 online resource (590 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, UK : Packt Pub., 2012.

Language Note:

English

Biography/History:

Vail Leslie: Leslie Vail is a CPA and has been working as a Microsoft Dynamics GP Consultant for nearly 20 years. She began with Version 1. 0 in 1993. During this period she completed numerous implementations, conversions, and custom-development projects. She has been a Session Leader at many partner and customer-technical conferences, and conducts training classes throughout Northern and Central America. Leslie has been a Microsoft Dynamics GP Microsoft Most Valuable Professional (MVP) since 2007. She is recognized throughout the industry for her product expertise and contributions to the Dynamics community. She is the Principal of ASCI, Inc. , a consulting firm located in Dallas, TX. As a Microsoft Certified Trainer (MCT), she serves as a Subject Matter Expert (SME) for the Microsoft Assessments and Certification Exams (ACE) team. She is a member of the US MCT Advisory Council, and has been listed as one of the Microsoft Dynamics Top 100 most influential people by DynamicsWorld. She is one of the top contributors to the Microsoft Dynamics GP Newsgroup and the Dynamics Community forum. Leslie maintains the popular Dynamics Confessor Blogspot blog (http: //dynamicsconfessions. blogspot. com/). Leslie has reviewed and developed Microsoft Courseware, coauthored the book Confessions of a Dynamics GP Consultant published by Accolade Publications, Inc. , and has been the Technical Editor of several books dedicated to Microsoft Dynamics GP. Leslie provides implementation and consulting services for companies ranging from a family office to a multinational manufacturing firm. She is a Microsoft Certified IT Professional in Microsoft Dynamics GP Applications and Microsoft Dynamics GP Installation & Configuration, as well as a Microsoft Certified Database Administrator (DBA). She holds a Microsoft Certified Technology Specialist certification in Dexterity, Modifier with VBA, Integration Manager, Report Writer, HR/Payroll, Financials, Inventory and Order Processing, FRx Report Designer, SQL Server 2000, SQL Server 2008, and Microsoft XP Professional. A skilled developer, Leslie uses Dexterity, Modifier with VBA, Integration Manager, and eConnect to provide custom solutions to her clients. She is a Certified Integration Developer (CID), a Dexterity CID, a Dynamics Tools CID, and a Dexterity Certified Systems Engineer. Her training proficiency spans the entire Microsoft Dynamics GP product line. She is an experienced trainer and gives classes for Dexterity, Financials, Inventory & Order Processing, HR/Payroll, Integration Manager, Modifier with VBA, FRx Report Designer, SQL Server Reporting Services, Report Writer, Crystal Reports, SmartList Builder, Excel Report Builder, Integrated Excel Reports, Extender, and System Manager. Prior to working with Microsoft Dynamics GP, Leslie was the Tax Director for a large financial institution; before that, she worked for one of the original "Big Eight" accounting firms as a Senior Tax Accountant.

Summary:

Written in a hands-on and friendly manner, Developing Microsoft Dynamics GP Business Applications takes a practical approach to teaching you how to develop and customize ERP applications. If you are a Microsoft Dynamics GP developer, consultant, or power user who wants to create and customize applications, then this book is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications, such as Microsoft Excel and SQL Reporting Services, is highly recommended.

Contents:

Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Microsoft Dynamics GP Architecture; The native user interface; Horizontal; Vertical; Dexterity overview; Resource Explorer; sanScript scripting language; Extensive function library; Structured exception handling; Integrated source code control; Built-in report writer; COM support; Graphical forms designer; Debugging tools; Dexterity design; Components of the Dynamics GP application; Start your engines!; The launch file (Dynamics.set)

The Preferences file (Dex.ini)SQLLogSQLStmt; SQLLogODBCMessages; SQLLogAllODBCMessages; Synchronize; Workstation=WINDOWS; Workstation2; OLEPath; RememberUser; ShowAdvancedMacroMenu; ExportOneLineBody; The Dexterity Runtime Engine (Dynamics.exe); SQL table and procedure names; Original table-naming convention; 00000 - Master tables; 40000 - Setup tables; 50000 - Temp tables; 60000 - Relation or Cross Reference tables; 70000 - Report Options tables; 80000 - Posting Journal Reprint tables; 90000 - Miscellaneous tables; 10000, 20000, and 30000 - Work, Open, and History Transaction tables

Stored proceduresCurrent table-naming convention; What you see - the User Interface (UI); Push buttons; Note button (record level); Printer icon; Zoom fields; Lookup button; Browse buttons; Sort-by List; Note button (window level); Additional window elements; E-mail Link; Map Link; Quantity alert button; Multicurrency button; Show Details; Information button; Expansion arrow; Help button; Summary; Chapter 2: Integrating Application Fundamentals; Defining the project; Changing a window's look or behavior; Changing current functionality; Creating new functionality

Exchanging data between systemsStoring additional data; Types of integrations; Overview of available tools; Dexterity; Capabilities of Dexterity; Limitations; Developer skills required; End-user prerequisites; Visual Studio Tools for Dynamics GP (VS Tools); Capabilities of VS Tools; Developer skills required; End-user prerequisites; Modifier with VBA (Visual Basic for Applications); Capabilities of Modifier with VBA; Developer skills required; End-user prerequisites; Continuum; Capabilities of Continuum; Developer skills required; End-user prerequisites; Extender / eXtender Enterprise

Capabilities of Extender and eXtender EnterpriseDeveloper skills required; End-user prerequisites; DDE \ ODBC \ ADO \ OLE Automation; DDE; ODBC; ADO; OLE Automation; Capabilities of DDE \ ODBC \ ADO \ OLE Automation; End-user prerequisites; Integration Manager; Capabilities of Integration Manager; Developer skills required; End-user prerequisites; Table Import; Capabilities of Table Import; Developer skills required; End-user prerequisites; eConnect; Capabilities of eConnect; Developer skills required; End-user prerequisites; Web services; Capabilities of web services

Developer skills required

Notes:

Includes index.

ISBN:

9781283937993

1283937999

9781849680271

1849680272

OCLC:

823719290