Querying Dynamics GP Data Using SQL Server Part Two

05/23/2019 - 10:00 a.m.
Central time
Man sitting on working on laptop

Microsoft Dynamics GP is an SQL Server-based application. There are many times that using queries are useful. Organizing data for reports and updating data are two common uses of queries. This webinar will focus on selecting data for reporting. Following up on our April 2019 webinar, we'll walk through examples of SQL queries using SQL Server Management Studio and SQL Server Reporting Services Report Builder.

Learning Objectives

Upon completion of this program, participants will be able to:

  • Explain how to use the Select Statement to query GP tables and views
  • Describe how to use the Reporting Services Report Builder tool to query data
  • Identify which tables, views and functions to use for queries


I​f you have concerns or would like information regarding program cancellation policies or CPE credit, contact us at training@bkd.com or 800.472.2745.​ Click here to read the CPE FAQs.

CPE NASBA LogoBKD, LLP is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.


How can we help you?