Search Results: open source (1982)

Ever wonder what the folks in IT are doing when you ask them to pull data for you from Dynamics GP? Did you ever wish you could do it yourself? Well join us for this fun hands-on class and soon you’ll be speaking and using SQL like a pro!

We’ll start from the very beginning and teach you the elements of a SQL query with a focus on the Dynamics GP data structure. SQL allows users to ask a question of the database, and have it answered in a very specific way. Although it may look like gibberish to you today, SQL is one of the most logical languages there is and we intend to make it easy for you to read and write it, but beyond that, SQL actually allows you to ask a series of leading questions, coupled with specific commands, grouped together to get to the answer you really want. It’s like truth serum for your data!

Through interactive lectures and hands on examples, attendees of this class will learn:

•Understand how to employ SQL to get data out of Dynamics GP
•What is SQL and how can it be used in relation to Dynamics GP
•The components of an SQL Select query
•Different ways to connect data sources (JOINS and UNIONS)
•How to find data within Dynamics GP
•SQL Functions that can make queries better
•What to do with your query after it is written
•What are UPDATE, INSERT, and DELETE commands?
•How do we build a query, stored procedure, or function? For that matter, what are queries, stored procedures, and functions?
•More SQL functions, and how they help us navigate our Dynamics GP data.
The class will start out assuming attendees know nothing about SQL or programming and will quickly progress them to a point where they can effectively ask a complex question of their Dynamics GP database, as opposed to waiting for someone else to ask it for them.

After the basics, attendees will quickly advance to a point where simple reporting, data manipulation, or support needs needn’t wait on an IT resource to be available.

Audience: Anyone who wants to understand SQL

Level: Beginner

Prerequisites: An open mind and a positive attitude.

Preparation: 

•Students should bring an internet capable Windows laptop computer to the course.
•The detailed instructions for connecting and attending the class will be sent a week prior to class. 
•There will be short installation that will need to be completed, in order for you to have access to the training environment needed for labs and exercises.
•Your instructor will use a hands-on training environment.

The COVID-19 outbreak has forced businesses to change the way they operate overnight, having to do more with fewer resources and shifting priorities. The need for automation has become clearer than ever to increase efficiency and free up teams from mundane tasks, such as sales tax compliance. 

Managing sales tax can be complex and time-consuming, yet failure to comply can leave a business open to audits and significant fines. Automating tax compliance can reduce that risk and free up teams to focus on higher value projects. Want to learn more? Join our session to discover the benefits of sales tax automation, and how to choose the right technology for your business. 

You’ll learn: 

•    The challenges of tax compliance 

•    Which industries typically have the most compliance risk

•    How to know when your business should pursue tax automation to maximize ROI

•    Tips to identify and implement the right automation software

In these uncertain times, the last thing you need to worry about is tax compliance. Don’t miss this session to make sure your obligations are being managed properly and efficiently.

Attend this session to be entered to win the new Xbox series X – exclusively for Avalara session attendees! Winners will be selected at random, based on session attendance.

Dynamics products Avalara works with:

•    Microsoft Dynamics 365 Business Central

•    Microsoft Dynamics 365 Finance & Operations

•    Microsoft Dynamics GP

•    Dynamics NAV

•    Microsoft Dynamics SL Microsoft Dynamics AX

If you’re a Microsoft Dynamics user, a whole new world of cost savings and customer satisfaction has just opened up to you. Available through Microsoft AppSource, BluJay Gateway for D365 is a Microsoft Certified Dynamics 365 Finance and Operations Module that provides secure, real time and easy to manage integrations between BluJay’s transportation and global trade solutions and Microsoft Dynamics.

Learning Objectives: 

•Designed for D365FO users 
•Fully integrated with Microsoft Dynamics 365 Finance and Operations
•Superior cost management & automated workflows
•Frictionless Trade Compliance and enhanced customer service
•Enhanced Parcel and TMS Solutions