GP Tech Conference 2019: Full Schedule

7:00am CDT

Registration/Breakfast/Expo

Get your registration pass for the event, grab some breakfast and visit with the sponsors in the expo area!

Monday September 9, 2019 7:00am - 8:00am CDT
TBA

Registration

8:00am CDT

Opening General Session

Monday September 9, 2019 8:00am - 9:15am CDT
TBA

General Session, addnew

9:15am CDT

Networking Break/Expo

Monday September 9, 2019 9:15am - 9:30am CDT
TBA

Break

9:30am CDT

Geek Speak: Developer Roundtable

A free format AMA (Ask Me Anything) session where you can have open discussion about Microsoft Dynamics GP customisation development with experienced developers David Musgrave, Mariano Gomez, Steve Endow and Kerry Hataley as well as fellow audience members. Developers love to chat with one another, so let's begin this event by meeting up and discussing what's on everyone's mind.

Speakers

David Musgrave

Managing Director, Winthrop Development Consultants

David Musgrave is Managing Director of his own development and consulting business. Based in the suburb of Winthrop in Perth, Western Australia, Winthrop Development Consultants offers a range of Microsoft Dynamics GP add-on products as well as development, consulting and training... Read More →

Mariano Gomez

Director of Technology, Mekorma

Mariano Gomez is the Director of Technology at Mekorma and a Microsoft Business Applications MVP specializing in Power Platform, Microsoft Dynamics GP, and Azure. He's an international speaker and a long time community influencer. Visit his channels and follow or subscribe at:YouTube... Read More →

Steve Endow

Owner, Precipio Services

Steve is a Microsoft MVP specializing in Business Applications. He works with Dynamics GP, Business Central, .NET, SQL Server, PowerApps, Flow, and Microsoft Azure.

Kerry Hataley

Owner, Nanook Software

Kerry has been involved with and worked with PowerApps, Microsoft Flow and Common Data Service since they were first introduced in 2016. Since that time, Kerry has presented sessions and provided training at user group sessions around the world for PowerApps, Flow and the Common... Read More →

Geek Speak Developer Roundtable pptx

Monday September 9, 2019 9:30am - 10:45am CDT
Morton West

Development

9:30am CDT

Not Your Daddy's Financials: Operational Financials in Power BI

Attend this session to see Belinda use GP Data to make Financial Statements in Microsoft Power BI. She'll review how to model the data, DAX formulas that could/should be used and other tips. Come, see how you can:

Help your customers save time
Help your customers make better decisions
Reduce your customers workload
Increase your consulting revenue

* CPE Eligible

Speakers

Belinda Allen

Microsoft MVP/Author/Trainer, Smith & Allen Consulting

I am passionate about hobbies! I crochet, knit, sail, kayak, love movies, I make jewelry, clay pottery, play the Ukulele, and ______ (you get the idea).OK, I'm a geek and a nerd, I LOVE Excel and BI! Microsoft Data Platform (Power BI) MVP.

Monday September 9, 2019 9:30am - 10:45am CDT
Morton Central

Seasoned Consulting

10:45am CDT

Networking Break/Expo

Monday September 9, 2019 10:45am - 11:00am CDT
TBA

Break

11:00am CDT

Solution Showcase: From Good to GREAT - Simplify your business processes and drive value! Presented by Binary Stream

Learn how Binary Stream’s enterprise-grade ERP software that extends the capabilities of Microsoft Dynamics platforms. From subscription billing automation, facilitating intercompany transactions, or property lease management, we help businesses simplify their company processes. Our products integrate seamlessly with your Microsoft Dynamics ecosystems across a wide range of industries, including healthcare, real estate, professional services, manufacturing, distribution, financial services, telecommunications, and more. Discover how you can improve your productivity and enhance your business intelligence with the tools and expertise from Binary Stream.

Speakers

Lisa Hills

Senior Software Services Consultant, Binary Stream

Lisa is a consultant working on implementations of Binary Stream products and has worked in the Microsoft Dynamics world for close to ten years. She is also a CPA a number of years experience working for Finance Departments as an accountant and analyst.

Monday September 9, 2019 11:00am - 11:45am CDT
Morton Central

Partner Solutions Showcase

11:00am CDT

Solution Showcase: Streamlining Bank and Credit Card Reconciliation with Nolan Business Solutions Presented by Nolan Business Solutions

Nolan’s ABR has been helping Dynamics GP clients streamline their bank and credit card reconciliation process for many years. Derek Beaupre will be discussing Nolan’s Advanced Bank Reconciliation solution for Dynamics GP and will walk you through a sample reconcile within Dynamics GP and conclude by taking questions regarding the features and functionality of the solution.

Speakers

Derek Beaupre

Channel Development Manager, Nolan Business Solutions

Monday September 9, 2019 11:00am - 11:45am CDT
Morton West

Partner Solutions Showcase

11:00am CDT

Solution Showcase: The RIGHT Path to the Cloud – Now with Remote Desktop! Presented by PowerGP Online

The future is in the cloud – and PowerGP Online now has everything you need to help your clients make the shift: Desktop Client, SQL DB access, remote desktop, customizations, access to ALL of the ISVs, and more cool new features designed with users in mind. Come see for yourself why PowerGP Online is the RIGHT solution for both your existing and NEW Dynamics GP customers. Let’s win with GP!

Speakers

Chris Dobkins

President, Njevity - PowerGP Online

Ask me about hosting Dynamics GP Web Client with Zero Remote Desktop and how you can leverage our White Label Cloud Partner Program to start selling GP Web Client today!

Pam Misialek

Director of Cloud Applications, Njevity

Pam is a well-known figure in the ERP industry with over 20 years of experience at Microsoft where she most recently led the Dynamics GP product line and was a vital part of the Dynamics GP community. In addition, Pam has a proven record of facilitating long term business relationships... Read More →

Monday September 9, 2019 11:00am - 11:45am CDT
Morton East

Partner Solutions Showcase

11:45am CDT

Networking Break/Expo

Monday September 9, 2019 11:45am - 12:00pm CDT
TBA

Break

12:00pm CDT

Leveraging GP Power Tools as a Developer

GP Power Tools has scripting capabilities which can be used for troubleshooting and fixing issues as well as prototyping and creating customizations. This session will demonstrate how you can use Dexterity, Transact-SQL, C# and/or VB.Net code to find issues, create fixes and customize the user interface. GP Power Tools can be used to create custom report writer functions to return difficult to access data. You can also create custom Service procedures which can be called as web services. Join us to see all this and also what’s new in GP Power Tools.

* CPE Eligible

Speakers

David Musgrave

Managing Director, Winthrop Development Consultants

Leveraging GP Power Tools as a Developer pptx

Monday September 9, 2019 12:00pm - 1:30pm CDT
Morton East

Development

12:00pm CDT

Practical GP Security

How do you protect your clients and make money doing it?

In this session, we'll dig into practical, simple, BILLABLE ways to improve client security. We'll look at techniques that work for companies of all sizes and you'll learn how to apply those techniques using skills you already have.

Cybersecurity issues dominate the headlines, but internal fraud accounts for 80% of corporate losses. The focus on cybersecurity from news organizations means that more companies are aware that they need improved security. It's also a huge opportunity for additional partner revenue.

This is not a session focused on external tools. There are some great security tools available for GP, but those tools enhance these techniques. Come hang out and learn how to make your clients more secure tomorrow than they are today.

* CPE Eligible

Speakers

Mark Polino

Director of Client Services, Fastpath

Mark Polino is an experienced CPA with additional certifications in financial forensics (CFF) and information technology (CITP). He is the author or coauthor of 9 books on Dynamics GP and he runs the popular DynamicAccounting.net website. Mark was a Microsoft MVP for 10 years. He... Read More →

Practical GP Security Polino GP Tech 2019 pptx

Monday September 9, 2019 12:00pm - 1:30pm CDT
Morton West

Newer Consulting

12:00pm CDT

Hands On: Creating a View and Utilizing It

Have you ever been asked to create a report and users want it three different ways??? One of the under utilized features are Views! Create a view that can be accessed by Excel, SSRS or SmartList Designer. If you already know how to create them learn a few tips and tricks on how to get the most out of SQL views.
* CPE Eligible

Speakers

Tanya Henderson

Owner, S2 Technology

Monday September 9, 2019 12:00pm - 1:30pm CDT
Morton Central

Seasoned Consulting

12:00pm CDT

Dynamics Credentialed Professional Exam Lab ($150 - pre-registration required)

Become a Dynamic Credentialed Professional (DCP) while you’re at GP Tech Conference. You can earn any of the three Dynamic GP Core Credentials while in Fargo at the event. GPUG will be hosting 2 exam labs where candidates that have pre-registered can sit for their scheduled exam and demonstrate their knowledge of and expertise with Microsoft Dynamics GP.

Exam candidates can pre-register for a specific exam at either or both of the lab sessions. Simply add one or more of the GP Dynamics Credentialed Professional Exams to your GP Tech Conference registration while going through the registration process. If you have already registered for GP Tech Conference, you can Edit your existing registration and add the exams from the Sessions tab in your existing registration form.

Registration fees do apply: $150.00 for Members and $187.50 for non-Members

Pre-register for any of these 3 exams:

GP Core Installation & Configuration Certification Exam
GP Core Financials Setup & Functionality Exam
GP Core Distribution Setup and Functionality Exam

All exam candidates must pre-register for exams. Walkups, unfortunately, will not be able to be accommodated.

Monday September 9, 2019 12:00pm - 2:00pm CDT

Credentialed Professional Exam (separate registration required)

1:30pm CDT

Lunch/Networking/Expo

Grab your lunch, network with fellow attendees and visit with the sponsors in the expo area!

Monday September 9, 2019 1:30pm - 2:45pm CDT
TBA

Lunch

2:45pm CDT

Even More Dexterity Development Tricks & Hacks in 50 Minutes

Continuing on from last year’s successful session, experienced Developer Evangelists, David Musgrave and Mariano Gomez, discuss yet more of the Dexterity tricks and hacks they use when developing to make coding faster and easier or just building better code.

* CPE Eligible

Speakers

David Musgrave

Managing Director, Winthrop Development Consultants

Mariano Gomez

Director of Technology, Mekorma

Even More Dexterity Development Tricks & Hacks in 50 Minutes pptx

Monday September 9, 2019 2:45pm - 3:45pm CDT
Morton East

Development, addnew

2:45pm CDT

Data Import Options

This is an intro level session to discuss options for getting data into GP.
* CPE Eligible

Speakers

Windi Epperson

Customer Service Manager, Njevity, Inc.

Long-time GP partner - I've been on the GPUG Tech Conference planning committee for three years now and I'm truly excited about the content!

GP Tech 2019 Data Import Options pptx

Monday September 9, 2019 2:45pm - 3:45pm CDT
Morton West

Newer Consulting

2:45pm CDT

Report Writer User Defined Functions

* CPE Eligible
This is an Advanced Report Writer session. This sessions uncovers 50 of the gems of Report Writer's user-defined functions. Once you get the data to show up in Report Writer, you can include it in your Word Templates. Learn how to use them to your advantage and exactly how they should be formatted. These functions are the golden nuggets of Report Writer, but not well documented. After attending this session, be sure to attend Advanced Word Templates on Wednesday at 10:15 where you'll see me using some of these functions in Word Templates.
While you're here, don't forget to sign my memory book to commemorate my 26 years with Dynamics GP!

We will review each to the functions listed below:
RW_AccountDescription
RW_AccountNumber
RW_Get_Segment_Description
rw_GetTotalInventoryValue
rw_GetTotalInventoryValueByLocation
RW_GetSiteDesc
rw_IVItemDefaultSite
RW_Pad
RW_PadZero
RW_Round
RW_Truncate
RW_Value
RW_Left
rw_right
rw_length
rw_lower
rw_upper
rw_parsestring
rw_proper
rw_replace
RW_Strip
RW_GetMsg
RW_Substitute
RW_Trim
RW_AddMonth
RW_DateDiff
RW_DateToString
RW_MakeDate
RW_EndOfMonth
RW_GetItemDefaultSite
RW_ivGetFuncListPrice
RW_GetInternetPrompt
RW_GetInternetInfo
RW_GetInternetText
RW_GetPOTypeString
RW_GetPOPTypeString
RW_GetSOPTypeString
RW_GetRMDistTypeString
RW_GetNoteText
RW_GetCommentText
RW_POPHDRCommentText
RW_POPLINECommentText
RW_SOPHDRCommentText
RW_SOPLINECommentText
RW_DateToString
RW_CoAddrIDInfo
RW_SelectAddrLine
RW_ConvertToWordsAndNumbers
RW_ConvertToWordsAndNumbersParse
RW_Format

Speakers

Leslie Vail

User Defined Functions 2019 pptx

Extra Info on User Defined Functions zip

Monday September 9, 2019 2:45pm - 3:45pm CDT
Morton Central

Seasoned Consulting

3:45pm CDT

Networking Break/Expo

Monday September 9, 2019 3:45pm - 4:00pm CDT
TBA

Break

4:00pm CDT

Solution Showcase: Come for the Payroll, Stay for the Xbox Presented by Greenshades Software

Spoiler Alert: WE’RE GIVING AWAY AN XBOX ONE BUNDLE. Join us to hear all the new and exciting things we’re doing at Greenshades Software. Learn more about the Greenshades rodmap, product enhancements, parnter training, marketing and more...

Speakers

Molly Van Kampen

Chief Evangelist, Greeshades Software

Monday September 9, 2019 4:00pm - 4:45pm CDT
Morton East

Partner Solutions Showcase

4:00pm CDT

Solution Showcase: If your customers aren’t asking for these, lets show them how with wsTOOLS Presented by Implementation Specialists

In this session, we will explore the most impactful wsTOOLS: PMUnapply, PayrollRewind, SummaryRecalc and more. Come gain valuable insight on how each tool enhances Microsoft GP, as well as, target audience, talking points to generate interest, and how customers and partners will benefit. Walk away with a greater knowledge of the tools we offer and how to solve customer’s needs. WsTOOLS, your industry leader in Dynamics and Key2Act.

Speakers

Deb Sletmoen

Owner/President, Implementation Specialists

If you haven't seen any of our amazing products PMUnapply, SpeedSwitch, Drawer, Payroll Rewind, GLBank Bridge just too name a few. Come and find me I am happy to show you what your customers will want.

Monday September 9, 2019 4:00pm - 4:45pm CDT
Morton Central

Partner Solutions Showcase

4:00pm CDT

Solution Showcase: Sales Tax Solution, What you need to know! Presented by Vertex

Join us to learn everything you need to know about Sales Tax and what you need to consider when selecting a Sales Tax Automation Solution. A brief demo will illustrate how GP customers can utilize an easy integration to Vertex.

Speakers

Gina Chen

Sales Engineer, Vertex

Monday September 9, 2019 4:00pm - 4:45pm CDT
Morton West

Partner Solutions Showcase

4:45pm CDT

Networking Break/Expo

Monday September 9, 2019 4:45pm - 5:00pm CDT
TBA

Break

5:00pm CDT

Should You Use Git for Source Code Control?

All the cool coders are talking about Git. Should you use it? Is it a good fit for your organization and your developers? In this session, Steve Endow will share his thoughts and experiences with Git and offer a few reasons you might want to use Git--as well as a few reasons why it may not be the best choice for your organization.

* CPE Eligible

Speakers

Steve Endow

Owner, Precipio Services

Steve is a Microsoft MVP specializing in Business Applications. He works with Dynamics GP, Business Central, .NET, SQL Server, PowerApps, Flow, and Microsoft Azure.

GP Tech 2019 Should You Use Git Rev 1 pptx

Monday September 9, 2019 5:00pm - 6:00pm CDT
Morton East

Development

5:00pm CDT

Installation/Upgrade Tips

* CPE Eligible
Have you ever wondered what all of the GP options are during an installation? Have you deployed the SQL Reporting Services Reports, Excel Reports, and Power BI Reports? This session will walk through a complete client installation with tips and tricks from many years of experience.
We will also look at upgrading GP and looking at the common pitfalls that can make an upgrade go awry.

Speakers

David Feenstra

Director, Maner Costerisan

I have been a GP Technical Consultant and Developer for over 20 years. My passion has always been to help clients get the most out of their systems.

GP Installation and Upgrades pptx

Monday September 9, 2019 5:00pm - 6:00pm CDT
Morton West

Newer Consulting

5:00pm CDT

SQL Server Life Hacks

This session is designed for the functional consultant who uses SQL but does not 'know' SQL. I've compiled a list of cool SQL 'stuff' that I have learned over the years and combined that with some super helpful scripts/tips/techniques, and rolled it all up into this presentation of over 30+ items to share!!
We will demo some, talk about some and have a great time too!

Are you a SQL junky? Come participate and add to the conversation! We will use a presentation style but will include tips/tricks from the attendees!

* CPE Eligible

Speakers

Shawn Dorward

Practice Manager, Dynamic Consulting

Shawn Dorward is a business and technology professional focusing on efficiencies and maximizing the return on technology investments. After using Dynamics GP for nearly 15 years as an end user, Shawn found himself better serving the Dynamics Community as a consultant. Shawn focuses... Read More →

SQL Server Life Hacks pptx

Monday September 9, 2019 5:00pm - 6:00pm CDT
Morton Central

Seasoned Consulting, addnew

6:00pm CDT

Welcome Reception/Expo (Cafe)

Unwind from a busy day of learning with some snacks & beverages and network with fellow attendees and sponsors!

Monday September 9, 2019 6:00pm - 7:30pm CDT
TBA

Welcome Reception

7:30am CDT

Registration/Breakfast/Expo

If you have not already registered, get your registration pass for the event, grab some breakfast and visit with the sponsors in the expo area!

Tuesday September 10, 2019 7:30am - 8:30am CDT
TBA

Breakfast

8:30am CDT

COA: Segments vs AA/Dimensions

This session will discuss chart of account options with a focus on segments vs. dimensions.
* CPE Eligible

Speakers

Windi Epperson

Customer Service Manager, Njevity, Inc.

Long-time GP partner - I've been on the GPUG Tech Conference planning committee for three years now and I'm truly excited about the content!

GP Tech 2019 COA Discussion pptx

Tuesday September 10, 2019 8:30am - 9:30am CDT
Morton West

Newer Consulting

8:30am CDT

Self-Healing SQL Servers

Can your SQL Servers heal themselves with they have a problem? Can they notify you or someone else that there is something wrong with the data itself, without you doing anything at all?

This session will show you how to setup a system that will automatically heal your SQL Servers for you, and keep an eye the data to let whoever needs to know that there is some potentially incorrect data before it becomes a real problem.

* CPE Eligible

Speakers

Cory Severson

GP Team Manager, Stoneridge Software

Functional Team Manager at Stoneridge Software. He helps lead the functional consultants and assists clients with implementations, upgrades, and technical support. Cory is the GP team’s go-to expert for all reporting in Dynamics GP, including Management Reporter. Prior to joining... Read More →

John Lowther

Director of Cloud Operations and Development, Njevity, Inc.

Director of Cloud Operations and Development for Njevity, Inc. Past Chairman of the Board of Advisors for the Dynamics GP User Group (GPUG) Leader of several of the GPUG Special Interests Groups (SIGs) (DBA, & Sys Admin) Published author in the User Group Magazines. One of the first... Read More →

Self Healing SQL Servers pdf

Code Examples txt

Get the code for this session txt

Tuesday September 10, 2019 8:30am - 9:30am CDT
Morton Central

Seasoned Consulting

9:30am CDT

Networking Break/Expo

Tuesday September 10, 2019 9:30am - 9:45am CDT
TBA

Break

9:45am CDT

Solution Showcase: Blue Moon – The Best Kept Secret in the Channel Presented by Blue Moon

Blue Moon has been developing Dynamics GP add ons for over 15 years, but what else do we offer? Custom Development! We have worked with many partners extending Dynamics GP functionality in all different ways for customers in all kinds of industries. Do you have any requests from your customers that you would like to review with us? Stop by our session and find out how we can assist you and your customers!

Speakers

Janice Phelps

Senior Solutions Consultant, Blue Moon

Tuesday September 10, 2019 9:45am - 10:30am CDT
Morton East

Partner Solutions Showcase

9:45am CDT

Solution Showcase: PrismView: Better than Excel and/or SmartList? Presented by Centerprism

PrismView™ is a high performance, scalable data navigation tool that allows the user to rapidly display, group, filter, and edit virtually any card or transaction table in GP. Directly connected to the GP database, PrismView™ requires no configuration nor additional database to run. Users can easily customize the out-of-the box views with the Field Chooser™ , and pre-loaded calculation and summaries are available for financial views.

Speakers

Michael Hollingsworth

President, Centerprism

Michael is President of Centerprism which is an all-in-one, full spectrum software solution built for GP. Centerprism gives the GP user the best option to keep GP while improving functionality and reducing ownership costs. This modern overlay to GP offers new features and functionality... Read More →

Tuesday September 10, 2019 9:45am - 10:30am CDT
Morton West

Partner Solutions Showcase

9:45am CDT

Solution Showcase: Sales Tax Compliance in the Post South Dakota v. Wayfair Era. What you need to know in 2019 about Economic Nexus Presented by Avalara

Sales Tax Compliance just got more complicated in 2019 as more states, 30+ now including California in April, 2019, have established economic nexus laws. Is your company at risk? Sales Tax Compliance has always been a challenge for businesses. Determining what to tax, how to tax it, what is and isn’t taxable, physical nexus, and exempt sales are just some of the challenges. Each state handles these issues differently, and now new legislation established in the South Dakota vs. Wayfair case, that the Supreme Court change the long standing ruling of physical nexus and grant South Dakota the state authority to impose sales tax obligations on out-of-state transactions creating economic nexus. There are unique and specific challenges with sales tax compliance that makes managing this process difficult while putting your business at risk. Sellers will have a new set of obligations and challenges ahead of them, while states could potentially gain billions in revenue. Session Hosted by Avalara.

Speakers

Rick Blue

Strategic Alliance Manager, Avalara

Alayne Kohlman

Strategic Alliance Manager, Avalara

Tuesday September 10, 2019 9:45am - 10:30am CDT
Morton Central

Partner Solutions Showcase

10:30am CDT

Networking Break/Expo

Tuesday September 10, 2019 10:30am - 10:45am CDT
TBA

Break

10:45am CDT

Best Options for Replacing Current VBA Code

* CPE Eligible

Speakers

Rod O'Connor

Product Specialist, eOne Integrated Business Solutions

David Musgrave

Managing Director, Winthrop Development Consultants

Steve Endow

Owner, Precipio Services

Steve is a Microsoft MVP specializing in Business Applications. He works with Dynamics GP, Business Central, .NET, SQL Server, PowerApps, Flow, and Microsoft Azure.

Best Options for Replacing Current VBA Code pptx

Tuesday September 10, 2019 10:45am - 11:45am CDT
Morton East

Development, addnew

10:45am CDT

Setting Up System, Company, and Core Right the First Time

* CPE Eligible
This session is good for beginning and experienced user's alike. In setting up your modules there are so many choices. Should I check that box? Should I uncheck it? What does it mean?? This session will cover the 'best practices' for setting up Posting, Company, GL, Bank Rec, Payables and Receivables. You'll be surprised at how many things you'll want to tweak!

While you're here, don't forget to sign my memory book to commemorate my 26 years with Dynamics GP!

Speakers

Leslie Vail

Set it up right the first time 2019 pptx

Tuesday September 10, 2019 10:45am - 11:45am CDT
Morton West

Newer Consulting

10:45am CDT

The Power Platform and Dynamics GP

Description coming soon...

* CPE Eligible

Speakers

Belinda Allen

Microsoft MVP/Author/Trainer, Smith & Allen Consulting

Tuesday September 10, 2019 10:45am - 11:45am CDT
Morton Central

Seasoned Consulting

11:45am CDT

Networking Break/Expo

Tuesday September 10, 2019 11:45am - 12:00pm CDT
TBA

Break

12:00pm CDT

SmartConnect Deep Dive: Nodes & APIs

* CPE Eligible

Speakers

Chris Hanson

Tuesday September 10, 2019 12:00pm - 1:30pm CDT
Morton East

Development

12:00pm CDT

Hands On: Creating Common Documents using SSRS

* CPE Eligible
SQL Server Reporting Services (SSRS) is a powerful reporting tool that has been around for many years now. Come to this session to learn how to build basic reports in SSRS and how and where to leverage them in Dynamics GP.

This will be a hands-on session. To get the most out of this session, please have access to SQL Server and preferably an install of SSRS. We will be using Report Builder 3.0 and SQL Server Server Data Tools for report creation so please try and have these installed as well if you would like to follow along.

Speakers

David Feenstra

Director, Maner Costerisan

I have been a GP Technical Consultant and Developer for over 20 years. My passion has always been to help clients get the most out of their systems.

GP Tech SSRS Reports pptx

Tuesday September 10, 2019 12:00pm - 1:30pm CDT
Morton West

Newer Consulting

12:00pm CDT

Hands On: Creating a Power BI Dashboard

It's easy to pin a visualization to a dashboard.. boom! You now have a dashboard... but what is the value of a dashboard? Where does the data come from? How do I strategize an approach for dashboards?
This session is designed to start at the beginning... but from the end. Confused? That's ok, you are not alone. Many organizations want dashboards, but how do you design them? How do you make them effective, and honestly, what makes a dashboard... a dashboard?
Come join me for a detailed discussion on:

Power BI
PBI Components
Types of Visualizations
Types of Dashboards
Techniques for consumable dashboards
... and much more!

We naturally will be building a dashboard, but through each step, we will unpack the steps and help bring value to the consumer!

* CPE Eligible

Speakers

Shawn Dorward

Practice Manager, Dynamic Consulting

Power BI Dashboards Publish pptx

Tuesday September 10, 2019 12:00pm - 1:30pm CDT
Morton Central

Seasoned Consulting

12:00pm CDT

Dynamics Credentialed Professional Exam Lab ($150 - pre-registration required)

GP Core Installation & Configuration Certification Exam
GP Core Financials Setup & Functionality Exam
GP Core Distribution Setup and Functionality Exam

All exam candidates must pre-register for exams. Walkups, unfortunately, will not be able to be accommodated.

Tuesday September 10, 2019 12:00pm - 2:00pm CDT
Microsoft Executive Briefing Center - West

Credentialed Professional Exam (separate registration required)

1:30pm CDT

Lunch/Networking/Expo

Grab your lunch, network with fellow attendees and visit with the sponsors in the expo area!

Tuesday September 10, 2019 1:30pm - 2:45pm CDT
TBA

Lunch

2:45pm CDT

Hands On: SmartList Designer

SmartList Designer, Why? It is FREE and allows you access to all of the fields in SQL! Join us to learn how to use this out of the box feature that can give your users access to the much needed fields that are not in the standard Smartlist.
* CPE Eligible

Speakers

Tanya Henderson

Owner, S2 Technology

Tuesday September 10, 2019 2:45pm - 4:15pm CDT
Morton West

Newer Consulting

2:45pm CDT

Hands On: Creating a Flow

Want to build some Microsoft Flows while learning Flow? Then attend this session with Belinda! Think of it as a “mini 75-minute class”. Bring your notebook, arrive early and join the fun! Goals of the class:

Learn Flow, by building a few flows
Obtain ideas on how to make money with customers

* CPE Eligible

Speakers

Belinda Allen

Microsoft MVP/Author/Trainer, Smith & Allen Consulting

Tuesday September 10, 2019 2:45pm - 4:15pm CDT
Morton Central

Seasoned Consulting

4:15pm CDT

Networking Break/Expo

Tuesday September 10, 2019 4:15pm - 4:30pm CDT
TBA

Break

4:30pm CDT

Introductory SQL Server

* CPE Eligible

Welcome to the world of SQL SERVER!!!
The best day of your life is the day you begin learning how to do things in SQL Server!

This session is an open Q&A discussion for everyone just starting out with SQL Server.
While there is a presentation, we will cover anything about SQL and SQL Server you would like to ask, so bring on the Questions!

Learn the two groups of people that need to work with SQL Server.
Figure out what is a SQL Server
Learn how to translate the Cryptic web information into English

To get you started here are some example questions:
What are the similarities between SQL Server and Excel?
What if I have a question next week, or next month, what do I do?

Speakers

John Lowther

Director of Cloud Operations and Development, Njevity, Inc.

Introductory SQL Server pdf

Tuesday September 10, 2019 4:30pm - 5:30pm CDT
Morton West

Newer Consulting

4:30pm CDT

SQL Profiler for Consultants

* CPE Eligible

Speakers

Kerry Hataley

Owner, Nanook Software

Tuesday September 10, 2019 4:30pm - 5:30pm CDT
Morton Central

Seasoned Consulting

8:00am CDT

Registration/Breakfast/Expo

If you have not already registered, get your registration pass for the event, grab some breakfast and visit with the sponsors in the expo area!

Wednesday September 11, 2019 8:00am - 9:00am CDT
TBA

Breakfast

9:00am CDT

GP Navigation & Shortcuts

This is a "Train the Trainer" session! We will discuss why I insist on covering these topics with all my new clients (especially for anyone who is "self taught")! Come to this session to learn my proven methodology for teaching GP Navigation & Shortcuts that has literally turned my clients into GP "Raving Fans"!

We will discuss features you need to show your clients including:

Setting Up the Home Page
Navigation Lists - Perfect for recovering Quickbooks users!
Cool Tricks Using the GP Toolbar
Navigation Pane Tips including the "Start Up Folder"
Why you need to show the User Preference window

* CPE Eligible

Speakers

Amber Bell

Owner, Training Dynamo LLC

I have worked with hundreds of GP clients across the United States for over 20 years. Come to my 'Train the Trainer' Navigation and Shortcuts session on Wednesday. My company helps GP users and consultants get more out of GP! I wrote a GP Year-End manual and I am writing a 2nd book... Read More →

GP Tech 2019 GP Navigation and Shortcuts pdf

Wednesday September 11, 2019 9:00am - 10:00am CDT
Morton West

Newer Consulting, addnew

9:00am CDT

Use Your On-Premises Data With the Microsoft Power Platform

Come see me put together end-to-end solutions using Power BI, Microsoft Flow, and PowerApps to leverage your Microsoft Dynamics GP data for powerful insights. In this session we will work through PowerApps applications, Flow workflows, and Power BI, showing in the process how the entire Power Platform stack integrates to implement complementary solutions to your Microsoft Dynamics GP application setting you on a path to capitalize on your investment.

Session Level: intermediate

Topics Covered:

Power Platform integration
Power BI data visualizations
Microsoft Flow workflows
PowerApps integration with Power BI
On-premises Data Gateway

* CPE Eligible

Speakers

Mariano Gomez

Director of Technology, Mekorma

Use Your On premises Data with Microsoft Power Platform pptx

Samples zip

Wednesday September 11, 2019 9:00am - 10:00am CDT
Morton Central

Seasoned Consulting

10:00am CDT

Networking Break/Expo

Wednesday September 11, 2019 10:00am - 10:15am CDT
TBA

Break

10:15am CDT

Understanding CDS better

* CPE Eligible

Speakers

Kerry Hataley

Owner, Nanook Software

Wednesday September 11, 2019 10:15am - 11:15am CDT
Morton East

Development

10:15am CDT

MR Troubleshooting

* CPE Eligible

Speakers

Cory Severson

GP Team Manager, Stoneridge Software

Wednesday September 11, 2019 10:15am - 11:15am CDT
Morton West

Newer Consulting

10:15am CDT

Using Advanced Technologies to Modify Word Templates

* CPE Eligible
Learn how to take control of your Word Templates. This session will use the SOP invoice and POP document to show you how to add more comments, display the entire item description, put fields like the customer e-mail address and tracking number onto the invoice, add terms and conditions pages and more. You'll learn the best way to set up for modifying templates, how to use Report Writer user-defined functions and how to control cell margins and nested tables so that you can turn a single line item into two lines. Learn how to better line up the various line-intem sections (description, comments, serial/lot) and how to draw a line between each item number. This is a class for advanced users and includes several instructional documents and samples to download that explains everything discussed in the class. Come ready to listen - we cover a lot of ground in 50 minutes!
While you're here, don't forget to sign my memory book to commemorate my 26 years with Dynamics GP!

Speakers

Leslie Vail

Adv Word Templates 2019 Tech pptx

AdditionalFilesWordTemplateInfo zip

Wednesday September 11, 2019 10:15am - 11:15am CDT
Morton Central

Seasoned Consulting

11:15am CDT

Networking Break/Expo

Wednesday September 11, 2019 11:15am - 11:30am CDT
TBA

Break

11:30am CDT

Geek Speak: Developer Roundtable v2.0

Speakers

David Musgrave

Managing Director, Winthrop Development Consultants

Mariano Gomez

Director of Technology, Mekorma

Steve Endow

Owner, Precipio Services

Steve is a Microsoft MVP specializing in Business Applications. He works with Dynamics GP, Business Central, .NET, SQL Server, PowerApps, Flow, and Microsoft Azure.

Kerry Hataley

Owner, Nanook Software

Geek Speak Developer Roundtable pptx

Wednesday September 11, 2019 11:30am - 12:30pm CDT
Morton East

Development

11:30am CDT

PSTL Rundown

Join this session to look at all the options with in the PSTL suite.
* CPE Eligible

Speakers

Windi Epperson

Customer Service Manager, Njevity, Inc.

Long-time GP partner - I've been on the GPUG Tech Conference planning committee for three years now and I'm truly excited about the content!

GP Tech 2019 PSTL pptx

Wednesday September 11, 2019 11:30am - 12:30pm CDT
Morton West

Newer Consulting

11:30am CDT

Cloud Migration to Dynamics 365 Business Central from Microsoft Dynamics GP

Are you looking to move your business to the Cloud? Microsoft’s Dynamics 365 Business Central application is our hosted product that allows you to move your data to the cloud. Within Business Central we have a migration tool that helps you move your data to Business Central.
Learning Objectives:
1. How do I use and configure the Migration tool
2. What data does the migration tool move
3. What is next from the cloud migration tool

* CPE Eligible

Speakers

Jennifer Ranz

Sr Program Manager, Microsoft

Wednesday September 11, 2019 11:30am - 12:30pm CDT
Morton Central

Seasoned Consulting

12:30pm CDT

Closing

Wednesday September 11, 2019 12:30pm - 12:30pm CDT
TBA