Loading Events

« All Events

  • This event has passed.


October 12, 2021 - October 15, 2021


Join John Kirsch at Community Summit!

JohnMicrosoft GP Product Lead, is known for his leadership, which facilitates strong teamwork and positive working relationships.

John holds more than two decades of work in Microsoft Dynamics GP as a consultant, user, IT support, and controller. His breadth of experience includes working with hundreds of GP implementations. He has extensive experience with SQL and performance tuning and report writing using Excel, SSRS, and other tools. On the functional side, John has expertise in the distribution modules, including inventory, sales order processing, and purchase order processing.

John has a vast knowledge of and experience with SmartConnect integrations with GP and other ERP systems, including Business Central. John is also experienced with other technologies, including Windows Servers, Azure, and Power BI.

Register Now



Tue Oct 12

Integrating Data with GP

3:00 PM – 3:50 PM CDT / 1:00 PM – 1:50 PM Your local time   (50 Min)

GRBC – Third Floor, 342C

BROADCAST Starts 2 min before the session time

One of the most common questions with any ERP – how can I integrate data?  This session will cover different integration tools as well as common integration usages.  There are some included tools and some that require additional licenses.  We will point out some of the differences as well and the strengths and weaknesses of the various tools.  If you are looking to add integrations or alternative options, come to this session!


Locked Away – Ransomware, Avoidance and Recovery

3:00 PM – 3:50 PM CDT / 1:00 PM – 1:50 PM Your local time   (50 Min)

GRBC – Third Floor, 360DE

BROADCAST Starts 2 min before the session time

Attend this session where experts share their advice regarding the security and ransomware risks facing both on-premise and cloud-based applications.

  •    Our experts discuss how to mitigate ransomware risk
  •    Advice on recovering quickly and safely from ransomware
  •    Disaster Response plans and best practices
  •    War stories and real-world experiences



Wed Oct 13

GP – My Favorite Time Saving Tips

9:30 AM – 10:20 AM CDT / 7:30 AM – 8:20 AM Your local time   (50 Min)

GRBC – Third Floor, 351D

Whether you are new to GP or have been using it for a while, there always seems to be “new to you” ways to utilize the software.  In this session, I will share some of my favorite tips and tricks to use GP more efficiently.  From screen navigation, to printing, to data entry, there are many tips that I have seen and accumulated over the years.  This session will feature how to use GP without add-ins so it can apply to everyone who is using GP.  Come join this session to pick up some new ways to complete you work!



Thu Oct 14

Intermediate SQL for GP

9:00 AM – 9:50 AM CDT / 7:00 AM – 7:50 AM Your local time   (50 Min)

GRBC – Third Floor, 342E

So you’ve been using SQL but want to understand more or enhance the usage of GP even more.  This session will dive deeper into some ways to get more out of your investment via SQL tools.  This session will cover maintenance plans to make sure SQL and GP are running efficiently.  A deeper dive into using views for reporting and optimizing the queries.  We will also review custom triggers and tables and have some Q&A time to answer questions.


 SQL 101 for GP

1:10 PM – 2:00 PM CDT / 11:10 AM – 12:00 PM Your local time   (50 Min)

GRBC – Third Floor, 342E

This is a beginner session for GP system admins.  In this session, we will cover basic tasks including backups, security and tables.  We will also discuss views used for reporting solutions inside and outside GP.  This session will also share resources for accessing GP data for troubleshooting and enhancing the use of GP.  If you administer GP and would like to be able to do more by feeling more comfortable with accessing SQL directly, this is the session for you.



Fri Oct 15

Reporting Live Design – Excel and SSRS

10:00 AM – 11:30 AM CDT / 8:00 AM – 9:30 AM Your local time   (1 Hour, 30 Min)

GRBC – Third Floor, 342E

This is an interactive session to customize existing reports or build new reports – all done live during the session.  We will use Excel Refreshable and SSRS reporting tools to develop these new reports.

This is a fun and interactive session – great to participate in being back in person.

Submit report ideas ahead of time to work on during this session or bring them up during the discussion.  We will save our SQL and reporting objects to be shared after the session is over!


October 12, 2021
October 15, 2021


Community Summit
View Organizer Website


George R Brown Convention Center
1001 Avenida De Las Americas
Houston, TX 77010
+ Google Map