GPUG H1 2019

Page 1

MAGAZINE H1 2019

www.gpug.com

All the Best THINGS ABOUT GP Confessions OF A SQL GUY


When it comes to formula manufacturing... we need to be in the mix. At Vicinity, we help businesses operate with ease, produce superior products, and drive smart growth with a software system that accommodates the complexities of formula-based manufacturing. By implementing Vicinity software, you can eliminate outdated, basic, or multiple disjointed systems, and start maximizing your manufacturing capabilities.

First software product for formula based manufacturing in the Microsoft Dynamics reseller space. Integrates with Microsoft Dynamics GP, SL & NAV.

Powered by a team of software developers, technical experts, and business consultants with 30+ years of experience working with batch manufacturers.

Built to enhance manufacturer’s ERP investment by cutting cost while supporting growth through improvements in productivity.

VICINIT YSOF T WARE.COM 770.421.2467

info@vicinitysoftware.com

CHEM

FOOD

BREW


MAGAZINE www.gpug.com

All the Best THINGS ABOUT GP Confessions OF A SQL GUY

Business Computers (Time Matrix) Corporate Renaissance Group FASCOR

75 44 8, 45 4

GPUG Member Referral

10

GPUG Membership

54

ImageTag, Inc.

76

Integrity Data

39

Mekorma

13

MetaViewer from Metafile

6

MSX Group

29

Nodus Technologies

31

Summit North America

19

Vicinity

7

Events

9

Meet Your Peers

11

Name That Photo Contest

12

Chapter News

14

Find the Logo

20

Word Find

21

Trending Topics

38

What’s New on the GPUG Website

55

GPUG Academy

62

The GP List, from The Partner Channel

63

The Best Things About GP

16

Tips & Tricks What Can Microsoft Dynamics GP Do for YOU?

22

The Best Thing About Microsoft GP

26

Microsoft Dynamics GP: How Flexible Is It?

32

ISV Showcase In It Together!

36

Living on the Edge

40

Tips & Tricks Confessions of a SQL Guy

46

User Member Showcase Synthetic Genomics

48

Become a Dynamics Credentialed Professional

49

Members In Action Pennies for Taylor

50

Microsoft Dynamics GP Integration

56

Microsoft Showcase Terry Heley

60

2

wsTOOLS

25

Yooz, Inc.

35

Tweet It!

ADVERTISER INDEX

Absolute Value, a Lanham Company

From the General Manager

FEATURES

2019

H1 2019

H1

5

IN EVERY ISSUE

gpug.com

contents

From the Chairman

When you finish reading, share your favorite article on Twitter, #GPUG. H1 2019

3



FROM THE CHAIRPERSON RICHARD ZICH

The Best Things About GP

W

elcome to 2019! In December, we all looked back at the year, and now in early 2019, we are looking forward to what is to come. Something that has not changed is this: the amazing things that Microsoft Dynamics GP does for each of us. At the User Group Summit in Phoenix, we saw this firsthand. It is clear that each of you have made this flexible, configurable, and easy-to-use business application your own. I

love that our community can toot our own horns to show others the great things that we have done. While 2019 brings us new opportunities with the software, it also brings new vigor to perhaps go after that additional training on Microsoft Dynamics GP products. Keep in mind that those webinars and regional chapter meetings will get back into full swing. Never before have there been so many opportunities to continue to learn and apply knowledge to your daily routine. The GPUGÂŽ website has had a major facelift in its User interface, allowing you an even better experience. I would love to hear your feedback. As you dig into this issue, enjoy reading about your fellow GPUG Members and their experiences with Microsoft Dynamics GP. I envision you seeing what our great volunteers are doing and maybe thinking about joining us in our endeavors to be even greater this year. I personally invite you to join the army of people that make GPUG great. This is your User Group, and you can choose the direction we take it with your feedback and participation. I look forward to an amazing 2019. Sincerely,

Rick Zich Chairperson, GPUG

H1 2019

5


Paperless AP Processing? No sheets, Sherlock.

Are paper-based processes “eating” your profits? MetaViewer Paperless Automation for Microsoft Dynamics is designed with your budget in mind, robotically capturing information, eliminating paper-based processes, and automating workflow. With the entire end-to-end process developed by Metafile, MetaViewer reduces the per transaction costs as well as the long-term cost of ownership, while offering superior functionality and user experience in a tailored and affordable solution. MetaViewer — designed to keep your profits in your wallet.

Paperless Automation for Microsoft Dynamics AX | D365FO | GP | SL | NAV | CLOUD

#pitchthepaperclips | #touchlessinvoiceprocessing www.metaviewer.com


FROM THE GENERAL MANAGER BOB McADAM

All the Best Things

T

he new year is well underway, yet the excitement percolating in the GPUG® community thus far still feels as if we never left #PhabulousPhoenix late last year! The best things about Microsoft Dynamics GP—and there are many—were on display each and every day at the last #GPUGSummit, and that obvious momentum we all felt has continued nicely into 2019. To say that I’m optimistic about all this is a true understatement.

As I stated in my final BloGPipes post of 2018 (www.gpug.com/blogs/bob-mcadam/2018/12/03/newsworthy-items-

to-wrap-up-2018), we’ve reigned things in a little this year from an event standpoint with the shelving of GPUG Amplify in North America. This is our only major event change, by the way, and it allows us to focus on Central Florida this October as GPUG Summit returns to sunny Orlando the week of October 13th. The premier Microsoft Dynamics GP event on the planet will exceed your expectations this year, just as it has 12 times prior. GPUG Summit hasn’t been in Orlando since 2010, and we’re looking forward to being back! The best things about Microsoft Dynamics GP also include our extensive GPUG virtual content lineup (www.gpug.com/ participate/webinars). My colleague (and your GPUG program manager) @LisaLucas has already posted a bunch of topic areas on our webinar calendar, and I can tell you that we have no shortage of experts seeking to deliver more. If you have topic ideas you feel we’re missing, please ping Lisa directly at Lisa@gpug.com and let her know so she can continue to exceed Member expectations. Meticulous planning for yet another GPUG event in Johannesburg during early June as well as the annual pilgrimage to #FabulousFargo for Microsoft Dynamics GP Partners is already in the works, so if you’ve been to these events before or are perhaps considering them this time around, details are arriving very soon, I assure you. GPUG chapters continue to garner traction thanks to our dedicated chapter leaders, and our Open Forum is, of course, busier than a gopher on a golf course (do you know what gophers can do to a golf course?). The best things about Microsoft Dynamics GP are all right here inside this amazing GPUG community. If you’re active, thank you for your continued contributions. If not, what are you waiting for?! Sincerely,

Bob McAdam General Manager, GPUG

H1 2019

7


NEED TO COMBINE MULTIPLE COMPANY DATABASES IN DYNAMICS™ GP? CRG Company Combiner™ Get started today at crgroup.com/combiner Explore all CRGroup add-on solutions for Dynamics GP; including: Changer™, Re-Formatter™, AA Tools™, Merger Series™ and PA Cubes™ Learn more at crgroup.com/GP-addons Corporate Renaissance Group

Using Company Combiner, we were able to consolidate our FIFTY-FOUR GP DATABASES INTO ONE! The change increased daily productivity & reduced our GP maintenance and upgrade time. — Bobbi Powers-Hey, CoAdvantage

crg@crgroup.com 1.800.576.6215


events The weekly GPUG® Event Guide

Webinars

and www.gpug.com are your best

MARCH 11 New to GP: Navigation, Shortcuts, Routines, Checklists, Did You Know?

sources for the latest GPUG event information as this list is subject to change. Events are added

MARCH 12 GP Housecleaning MARCH 13 Partner Engagement MARCH 13 How to Find (and Keep!) the Right SEM Vendor MARCH 27 2019 Technology Marketing Benchmarks & Trends Report APRIL 9 GP 2013 – Why Upgrade?

weekly, so check back often

APRIL 10 Partner Engagement

and get registered for the next

MAY 7 GP Navigation 101

exciting GPUG event.

JUNE 12 Partner Engagement

MAY 8 Partner Engagement JULY 10 Partner Engagement AUGUST 14 Partner Engagement SEPTEMBER 11 Partner Engagement

“I want to thank you for

Chapter Meetings MARCH 15 Downers Grove, IL

a spectacular Dynamic

MARCH 19 Chesterfield, MO

Communities event

MARCH 20 Green Bay, WI

experience! This was my first

MARCH 21 Denver, CO MARCH 21 Jacksonville, FL

Summit, and I had the BEST

MAY 14 Indianapolis, IN

experience with every facet of

MAY 14 Boca Raton, FL

it. The workgroups, event hall

MAY 15 Montreal, QC MAY 15 Charlotte, NC

and professionalism of your

MAY 16 Mount Pleasant, SC

team were stellar and second

MAY 17 Orlando, FL

to none! I was overall wowed

JUNE 14 Chicago, IL JUNE 19 Green Bay, WI

by the whole event and the

JUNE 20 Denver, CO

networking opportunities

AUGUST 9 Lake Geneva, WI

not only with Users, but also with vendors. I will highly recommend this to all

AUGUST 15 Gaston, SC AUGUST 21 Charlotte, NC AUGUST 22 Iowa AUGUST 22 Denver, CO SEPTEMBER 11 Montreal, QC

Microsoft Users.” – Vice President, Visionet Systems, Inc.

Conferences JUNE 12-13 User Group World Tour AUGUST 21-23 User Group Summit Australia

Check out the event calendar on www.gpug.com and click on “Learn & Engage.” H1 2019

9



meet your peers Meet the All Stars The highest award given in the community is the All Star Award, recognizing GPUG® Members who have a passion for Microsoft Dynamics GP. These leaders have made significant contributions of their time and expertise to the GPUG community. All Stars are nominated and voted on by the community and receive a lifetime All Star designation! CONGRATULATIONS TO THE NEWEST GPUG ALL STARS:

JEN KUNTZ Energy+ Inc. | Microsoft MVP

BRYAN ROBERTSON SBA Communications

MARIANO GOMEZ Mekorma, Inc. | Microsoft MVP

Meet the Chapter of the Year

Meet the Richard Whaley Academy Award Winner

The Chapter of the Year award recognizes a successful local GPUG chapter and is based on the size of the chapter, meeting attendance, and the involvement of the chapter leaders to drive content, promotion, and engagement.

Richard Whaley was an author and publisher, longtime GPUG Member, GPUG All Star, and well-respected Academy instructor who selflessly contributed countless hours of his time and talents to his GPUG Academy students. Richard passed away July 1, 2014, and this award was created to honor Richard by carrying on his legacy. An award in Richard’s honor is a way for GPUG and the community to recognize others who have been influenced by his example.

CONGRATULATIONS TO THE 2018 GPUG CHAPTER OF THE YEAR:

CONGRATULATIONS TO THE 2018 RICHARD WHALEY ACADEMY AWARD RECIPIENT:

FLORIDA (JACKSONVILLE) Leaders: Tasha Orange, Laureen Mobley, and Barbara Gavron

ALEIHA HANSON Royal Basket Trucks, Inc. GPUG Professional Certificates include: PCAP – Accounts Payable, PCAR – Accounts Receivable, and PCBI - Business Intelligence

H1 2019

11


Congratulations to Denise McCaughan of Cedar Hammock Fire Control District for her caption submission below… “Raise your hand if you like GP. Raise two hands if you LOVE GP!” What were these GPUG® Summit attendees discussing while browsing the Expo halls at User Group Summit in Phoenix this past October? Submit your caption by emailing Captioncontest@ gpug.com. The winning submission will be printed in the magazine’s next issue.

12

GPUG MAGAZINE

NAME THAT PHOTO CONTEST


Microsoft Dynamics

®

Microsoft Dynamics GP

GP


news SAPPHIRE

RUBY

EMERALD

GRANITE

Congratulations to the 2018 GPUG Gemstone Award recipients: SAPPHIRE Beat Bucher Brian Miller Cecile Dinh Danny Clemenson Darin Vialpando Jeff Roe Jessica Gorski

14

Kathy Kim Kevin Carnahan Margo Call Sean Reynolds Sven Vosse Sylvia VanHees Tiffany Ziegler

RUBY Anne Provost Bert Green Brian Lambertz Bryan Robertson Christine Lowe Frank Heslin

Jason Zonts Jen Kuntz Kelly Hobart Rick Zich Steve Burney

EMERALD Aleiha Hanson Jackie Yip

Steve Erbach

GRANITE Abra Gilman Amber Bell David Musgrave Derek Krebs Jeannette Coty Bachellor Jo deRuiter

Kim Peterson Nick Sercer Nicole Albertson Noah Moseley Rod O’Connor Shawn Dorward

GPUG MAGAZINE

GPUG

Volunteer News Every year, thousands of conversations take place in the GPUG® online communities, at chapter meetings, in virtual programming, and at conferences and events. We are honored to recognize community leaders who go above and beyond to share their knowledge and experiences to serve their Microsoft Dynamics GP peers. GEMSTONE AWARDS Volunteers play a vital role in building a strong and valuable GPUG community. At User Group Summit Phoenix, we were honored to recognize outstanding community Members for their contributions to the User Group through the Gemstone Awards. GPUG User Members are recognized at three award levels: Sapphire, Ruby, and Emerald; GPUG Partner Members are recognized at one award level: Granite. A sincere thank you to all GPUG volunteer leaders who dedicate countless hours around the world to help drive a strong GPUG community powered by Users, for Users. You are at the heart of what the User Group is all about, and you are greatly appreciated! Congratulations to this year’s recognition award recipients! To get involved in the GPUG community and learn more about the Gemstone Awards, visit www.gpug.com/engage/volunteer.


LEADER HIGHLIGHTS FLORIDA CHAPTER LEADERS

Come Together The Jacksonville Chapter started up three years ago, and Barbara Gavron gave the boost this young group needed to build it up. “Barbara was instrumental in getting our chapter started and going strong. I came on board the leadership team this past year, and it’s pretty awesome. Laureen, Barbara, and I are so close, we’re like family,” Tasha Orange explains. In addition to being awarded the 2018 GPUG® Chapter of the Year, Jacksonville is pretty well-known for its Q4 zoo meetings. Laureen Mobley works at the Jacksonville Zoo and Gardens and opens it up just for chapter attendees. “The zoo meetings are the best and so fun to look forward to. Laureen gives us our own personal tour, and it’s always catered so nicely. It is such an excellent experience for our Members,” Tasha says. Florida chapters have an “all are welcome” attitude, and that is resulting in some amazing comradery and collaboration. The past two years the four Florida chapters have worked together to host a regional chapter meeting in Orlando because of its central location. With 58 attendees at the last meeting in August 2018, it felt like “our own mini Summit,” Tasha described. “Jason Zonts does so much to make the regional chapter meetings a success; he makes it pretty spectacular.” Jason is on the leadership team for the Orlando chapter and has been since its inception in 2015. “The first time I attended GPUG Summit was after Microsoft decided not to do Convergence, and there I met Anne Provost,” Jason explains. “We decided an Orlando chapter was needed, and ever since, we’ve been building it up and constantly recruiting new Members.” At its start, Orlando had about 18 regular attendees. Today, they host more than 30 Microsoft Dynamics GP Users and Partners each quarter. “Through the years, we’ve gotten a lot better and more efficient in running our meetings,” Jason explains. “We include feedback questions during the icebreakers and hand out questionnaires as much as we can.” In addition to trying to attend other Florida chapter meetings, the four chapters coordinate their schedules so that Members and sponsors don’t have to choose one over the other. Two chapters meet one month and then the other two meet the following month. “We like to schedule them close enough so that Bob McAdam is able to attend all our meetings. He brings the Dynamic Communities side, and if any of us don’t feel like emceeing, we know Bob will step up to the plate,” Jason jokes. The preparations have begun! At GPUG Summit in Phoenix, Jason and Anne suggested to Bob that the Orlando and Jacksonville chapters work as a team to host User Group Summit North America in Orlando. “We have some big and bright personalities across all our Florida chapter leadership teams and wish to showcase them all,” Jason shares. “We are ‘Florida Strong’!”

Jacksonville (2018 Chapter of the Year) Leadership Team: » Tasha Orange, Senior Financial Analyst at US Assure » Laureen Mobley, Account Manager at Jacksonville Zoo and Gardens » Barbara Gavron, Dynamics GP Consultant at S2 Technology Orlando Leadership Team: » Jason Zonts, Business Applications Manager at OneBlood, Inc. » Anne Provost, Chief Financial Officer at TNR Technical, Inc. » Kelly Silva, Controller at etech (Event Technology, LLC) » Kyana Brooks, Operations Manager at EIZO Inc.

Jason is very excited to have User Group Summit in his home city and hopes not only will it be the greatest GPUG Summit ever, but also that it will be the largest. “The conference space is second to none. I’m sure there will be Disney characters (rumors of Beauty and the Beast played by Molly Fuschel and Bob McAdam have already begun), and we have chapter Members becoming presenters, ready to show their stuff,” Jason shares. “That’s such a fun transition to see in a User; moving over to the other side of the wall.” To Jason, GPUG chapters and GPUG as a whole have become more than just a resource. “These people have become my friends, and I’m looking forward to having Summit in my own backyard, so to speak,” Jason concludes. H1 2019

15


16

GPUG MAGAZINE H1 2019


story by Kim Peterson

best things The

A

About GP

t User Group Summit Phoenix, the passion for Microsoft Dynamics GP was hard to ignore, and the people behind the product are doing amazing things. Let’s represent how Members are loving the product, people, and processes that go into the most flexible, configurable, and easy-to-use business application around. »» Microsoft Dynamics GP is so flexible: “How flexible is it?!” »» Microsoft Dynamics GP is so configurable: “How configurable is it?!” »» Microsoft Dynamics GP is easy to integrate with: “How easy is it?!” »» The people: “How great are they?!” Here’s what we got:

Microsoft Dynamics GP is LOVED – Major League Style! With spring baseball training camps going on, you feel the excitement in the air for America’s sport, and spring is around the corner. Many fans take their vacations to watch the pros

H1 2019

17


practice and prepare for the season. Many Microsoft Dynamics GP Users feel the same way when coming to GPUG® Summit. You are surrounded by major league players who have put their heart and soul in learning and helping the community. Microsoft Dynamics GP Users’ passion is strong about what this product is CAPABLE of, how it continues to extend its capability, and how HAPPY we are as a community. I know I’d rather work with a seasoned player than a rookie. It’s evident that practice, long-term strategies, hours of hard work, and concentration in using this product to its fullest POTENTIAL make the solution what it is. Microsoft Dynamics GP is just darn DEPENDABLE. Microsoft Dynamics GP is the MVP (most valuable player) of ERPs. It’s a WINNER, COMPLETE, and meets more needs than any other OUT-OF-THE-BOX solution in the market! It also has RELIABLE heavy hitters on the bench with hundreds of add-on products. What a STRONG EXTENDABLE lineup! Besides relying on a SOLID product, it’s backed by the most committed community in the midmarket. I simply get excited about the COMMUNITY. I actually LOVE the community. Why? Because everyone is very HELPFUL, HAPPY, and wants peers to SUCCEED. I witnessed countless hours of volunteerism while at GPUG, and it continues to grow each month. How many work in this kind of environment? LOVEABLE is an adjective we can all relate to if we have been in the Microsoft Dynamics GP community for a while. How many can explain when they get back home from GPUG Summit all the hugs they have received, late nights of sharing, and the appreciation expressed to folks like those quoted on why they love Microsoft Dynamics GP? How lucky are we that the most EXPERIENCED ERP software designers and coders work with Microsoft Dynamics GP? With years of listening and fixing, the product is SET. People ask why Microsoft doesn’t put many resources into it anymore. I say, WHY SHOULD THEY? Let’s face it: It’s SOLID and WORKS. Newer solutions are just trying to catch up to our solution; they have even borrowed Microsoft Dynamics GP talent to get it done. The moral of the story is: Keep on trucking with what works. While Microsoft is trying to launch another ERP solution into the marketplace, those of us in GP-LAND are more than COMFORTABLE with our solution and how it meets our UNIQUE company needs. We have a solution that has been WORKING for decades, and we APPRECIATE that TRACK RECORD. No matter what kind of organization we are in, you can find fellow peers using Microsoft Dynamics GP with a SMILE. Kim Peterson is the founder of Dynamics Connections, an organization with a mission to help the Microsoft Dynamics GP Partner community in companion product education. She is also the “longest working FAN” of the Microsoft Dynamics GP family, starting in January of 1983. She can be reached at Kimkpeterson@outlook.com. To learn more about the word art used in this article, visit https://wordart.com/edit/08vr93ofnl5e.

Microsoft Dynamics GP is… (words from your peers)

»» GREAT because how easy it is in reporting. Most amount of reporting options in the Dynamics ERP space. Reporting Expert: Derek Krebs, MSX Group

»» FLEXIBLE because you can “CUSTOMIZE” custom links to track shipments, view item images, or make Skype phone calls, right from within the product…FOR FREE!

»» SEARCHABLE because you can use wild cards in your search options for SmartLists! »» AWESOME because you can tag transactions to track subledger activity, like projects, vehicle expenses, grants, and more! Most Creative Player: Shawn Dorward, Microsoft MVP

»» STRONG and DEPENDABLE because it is an application truly strengthened by the ISV community and all the development

one can do around it as a core application. The levels of strength are up to you! 2018 GPUG All Star: Bryan Robertson, SBA Communications Corporation

»» CONFIGURABLE because Microsoft Dynamics GP is one of the most POWERFUL and FLEXIBLE ERP systems available. The tools and languages available for customization of the UI and INTEGRATION of the data are amazing. The fact that you can CUSTOMIZE the product so easily with so many different tools is what my business is built upon. I have spent the last 25 years of my career customizing and ENHANCING Microsoft Dynamics GP to meet Customers’ requirements, and code written 25 years ago still works on today’s versions. Smart Guy: David Musgrave, Winthrop Development Consultants, Microsoft MVP (Business Applications), GPUG All Star, Advanced Dynamics Credentialed Professional, plus more initials!

18

GPUG MAGAZINE H1 2019


Paperless ERP for Microsoft Dynamics


o o Lg

the best return on my investment while being hat others FINDhave invested in me. THE

Congratulations to

PAMELA LASITER from EXPLORER PIPELINE for

finding the logo on page 42

of the H2 2018 issue of

ctivity in the GPUGCONTEST community

GPUG® Magazine.

Let’s play again! Hidden

somewhere between the covers of this magazine is our GPUG logo. Can you find it?

unity, so I haven’t had the pleasure of getting available to me, but at the moment being our favorite volunteer activity. I love the interaction ding ways to grow our chapter community. I ut the various GPUG meetings, opportunities, iastically involved, together. While our logo shows up

L VO

UN

Tasha Orange | Senior Financial Analyst | US Assure

TE

ER

ER RN CO

needs some stress relief or to keep them occupied if I am researching something while they wait), and 4) of course there’s paperwork, lots and lots of paperwork (my organized chaos of work, hence my “dreamed my desk was clean” desk plaque).

Are you going to Summit Phoenix? Why? I am absolutely going to Summit Phoenix. I’m so excited that I’ll be making it back to Summit this year because last year was my first Summit, and it opened a whole new Microsoft Dynamics GP world for me. I really don’t want to miss out on the knowledge and networking available to me.

MEMBER SINCE 2016

Who do you follow on social media right now and why? I currently follow Will Smith because I think he’s just adorable and his posts usually make me smile (insert school-girl heart-eyed emoji here, lol).

LU VO

NT

EE

R NE OR C R

What is on your desk? Right now, EVERYTHING is on my desk, but to point out the particulars: 1) VariDesk attachment (because I can’t always just sit here) 2) hand sanitizer (an extra-large 67.6 fluid ounce container because that way I don’t have to say how I feel about germs) 3) handheld games, an assortment of mini games and buttons, Simon, Bop Its, fidget spinners, and more (just in case someone

42 | GPUG Magazine

20

GPUG MAGAZINE H1 2019

What do you do when you’re not at work? It feels as if I am always working, and honestly, I love it that way. When I’m not at work, I am mostly a homebody taking care of everything that keeps my household running smoothly. But I must admit that at those perfect times that the sun/stars/ moon/work/home have aligned perfectly, I love to sit down and just read something that has caught my interest and takes me away somehow. I recently finished “The Heart Forger” and “The Wicked Deep”, and I am currently reading “Children of Blood and Bone”. My reading interests are more on the dark fantasy side at this moment, but I definitely mix that up here and there.

What is the best advice you’ve ever received? The best advice I’ve ever received is “you get what you pay for” because I don’t take that strictly in the monetary sense. I take that advice metaphorically and apply it in many ways. Primarily though, I think about everything that I put into anything that I’m involved in, and I strive to get the best return on my investment while being and/or providing the best return on what others have invested in me. What is your favorite volunteer activity in the GPUG community and why? I am relatively new to the GPUG community, so I haven’t had the pleasure of getting to know all the volunteer opportunities available to me, but at the moment being our North Florida chapter’s co-leader is my favorite volunteer activity. I love the interaction with my peers, and I am devoted to finding ways to grow our chapter community. I strive to get our Members excited about the various GPUG meetings, opportunities, and initiatives so that we are all enthusiastically involved, together.

throughout the magazine in

conventional spots, it’s hidden in only one place.

When you’ve found it, send an

email to Logocontest@gpug.com

with an explanation of where and

on what page it’s at. We’ll choose a winner at random and will

highlight him/her in the next issue

of the magazine.


o w rd

Below are 20 words and phrases that relate to the topics and theme in this issue of GPUG® Magazine. These words can be found in the grid horizontally, vertically, diagonally, backward, and forward. Submit your completed Word Find for a chance to win a gift certificate; simply scan and email your entry to Wordfind@gpug.com.

FIND

S

F

S

K

I

G

S

E

V

O

L

U

T

I

O N

A

H

F

S

U

K

N

B

J

Y

F

J

K

I

E

R

Y

B

D

S

W

M

V

X

Q

T

I

V

J

G

F

E

A

N

H

N

G

Y

M

K

N

V

D

W

T

A

G

H O K

M

G

N

F

C

T

R

C

T

I

H

N

Y

S

B

P

L

M

K

Y

T

C

X

E

P

G

F

A

V

H

I

B

K

H

D

C

U

S

T

O

M

I

Z

A

B

L

E

V

L

X

A

L

L

S

T

A

R

S

E

J

K

Y

T

O

D

W

E

B

H

G

T

U

I

N

I

G

V

F

D

S

X

C

O

T

T

G

W

N

N

I

M

H

G

T

D

F

F

P

L

M

N

P

A

S

S

I

O

N

I

G

P

D

W

E

T

G

I

N

B

V

I

S

X

I

Z

A

Q

W

E

R

T

Y

V

C

O

U

L

K

A

H

P

F

D

S

E

B

N

F

S

J

H

I

R

C

Y

C

C

I

G

D

G

J

U

W

T

U

E

C

D

B

N

K

U

V

H

J

N

M

L

Y

O

C

L

E

E

W

G

H

A

L

G

G

F

C

X

D

E

S

C

Z

W

T

J

O

H

N

U

L

N

N

E

L

O

R

D

C

T

R

S

A

Z

W

Q H

N

U

E

H

U

I

F

N

E

O

P

B

F

C

D

E

T

G

N

H

Y

I

N

J

A

G

F

G

C

D

B

I

M

Z

M

Y

S

S

A

S

Q

L

S

C

R

I

P

T

I

N

G

G

R

J

L

Q

G

E

O

I

G

I

I

K

P

M

H

V

F

X

A

Z

D

C N

G

N

A

M

L

P

U

U

O

C

F

T

S

Q

J

K

L

K

J

H

G

T

Y

U

E

O

P

T

S

D

F

R

H

Y

S

R

E

W

Q

Z

Q

X

W

C

E

V

R

B

T

L

Y

M

I

L

E

P

A

U

B

T

C

R

X

Z

A

J

G

J

H

A

F

H

L

H

Y

U

H

O

G

L

C

T

D

E

F

L

O

R

I

D

A

C

H

A

P

T

E

R

S

B

T

G

N

U

B

T

I

D

I

X

Z

B

N

C

D

E

E

J

K

L

O

U

H

G

T

F

R

E

D

I

B

O

N

L

L

G

H

U

N

V

C

D

E

X

H

Y

G

T

K

I

N

Y

G

P

X

F

N

S

O

H

P

E

N

N

I

E

S

F

O

R

T

A

Y

L

O

R

S

Z

A

E

W

E

R

V

Y

I

N

B

G

F

J

L

K

M

N

H

I

Y

B

V

F

H

J

K

L

P

I

N

E

G

T

F

C

F

E

S

D

T

H

V

G

F

U

N G

I

H

N

M

F

G

F

S

G

W

O

R

K

I

N

G

T

O

G

E

T

H

E

R

L

K

J

H

A

Q

X

F

P

A

P

FLEXIBLE

GPUG WEBSITE

PENNIES FOR TAYLOR

INTEGRATION

EVOLUTION

SQL SCRIPTING

GPUG

WORKING TOGETHER

CUSTOMIZABLE

ALL STARS

SIMPLIFIED

PASSION

ILOVEGP

GEMSTONE AWARDS

ISV CHANNEL

CLOUD

FLORIDA CHAPTERS

JACKSONVILLE ZOO

CONFIGURABLE

SYNTHETIC GENOMICS H1 2019

21


&

tips tricks What Can

by Aleiha Hanson, Royal Basket Trucks, GPUGÂŽ User Member

Microsoft Dynamics GP Do For YOU?

M

icrosoft Dynamics GP continues to improve and grow with each release. Many of these improvement suggestions come directly from US! As Users we are in Microsoft Dynamics GP every day and give honest feedback on what improvements would be most helpful and what works for US in the meantime! By having hands-on experience, it becomes more and more valuable to share with each other the tweaks and customizations we do to make Microsoft Dynamics GP ours. Customizations, configurations, and User settings can be simple or complex. Some of these examples may require assistance from your IT team or Microsoft Dynamics GP Partner, but others are just a click away! Our sales/customer service team uses customizations to

22

GPUG MAGAZINE H1 2019


reduce errors and save TONS of time with processing hundreds of orders each day. As an example, we put all our orders shipping for the day into a single batch. Based on that batch, we’re able to print labels, shipping documents, AND a call-in sheet to schedule trucks for any number of orders with just a few clicks! The details are derived from custom, User-defined fields we complete when entering a sales order. Documents, reports, and labels can come from Microsoft Dynamics GP navigation lists, SmartLists, SSRS reports, or Report Writer modified forms. All of these made it easier to ship orders out the door. But what about getting orders in the system? Use integration! Whether you are a made-to-order manufacturer or just billing for services, integrations can reduce keystroke errors and the amount of time data entry consumes each day. While there are many options for integration, such as IM, macros, replicator, and many EDI providers, we chose to use a third-party service that works well for our customers’ data and how we generate our sales orders. By having integrations, both for entering orders and sending documents back to our customers (acknowledgments, invoices, ship notices, etc.), we can import and export large batches of documents instead of one at a time. It also eliminates doublekeying of line items, addresses, tracking information, etc. as it reads directly from Microsoft Dynamics GP back to our EDI interface!

We continue to use simple tweaks across other modules such as inventory, purchasing, and manufacturing. In any system, you will always be scrubbing and updating to ensure you have data integrity. In doing so, it can be helpful to know what was proofed/updated and when. Why not use Userdefined fields for that? We added a date field, proofed by, and verified by as we continue to review our inventory items and their BOMs/routes. It’s easy to know when a task was completed as well as which ones still need to be done.

H1 2019

23


When scrubbing some data, it can be difficult to analyze from within the native Microsoft Dynamics GP window or even more difficult to get it into Microsoft Excel. We invested in a couple intricate SSRS reports to make this easier! One of my favorite parts of Microsoft Dynamics is how easy it can be to make updates to your data. There are many tools, but our go-to has been running a mail-merge macro. They can be effective for inventory, customers, vendors, GL, etc. Like any other business, we’re constantly making changes and improvements or need to add information. No matter how quickly you can type, it can be time-consuming and leave room for errors by doing anything manually. Be sure to always create a back-up before running any scripts or macros!

When scrubbing some data, it can be difficult to analyze from within the native Microsoft Dynamics GP window or even more difficult to get it into Microsoft Excel. We invested in a couple intricate SSRS reports to make this easier! An indented BOM and a “where did I miss a component” makes proofing and analyzing inventory and BOMs much more efficient! On every purchase order, we strive to hold ourselves and our vendors accountable. By using the date fields on a PO, we can state when we want the PO delivered, when our vendor acknowledges, and when they promise to deliver. With this information, we can create dashboards, scorecards, and more to analyze issues with our vendor performance.

By making the most out of every window, in every active module, and utilizing reports that work for YOU, Microsoft Dynamics GP has the structure and ability to be one of the most reliable and effective systems available. From simple to complex, you can create any customization to improve efficiencies across your company. Microsoft Dynamics GP is here for the long haul to provide a customizable, buildable ERP system to suit your needs! Aleiha Hanson is GPUG Milwaukee, WI chapter leader, the 2018 Richard Whaley Academy Award Recipient, and a 2018 Emerald Award Recipient. She serves as IT manager at Royal Basket Trucks and can be reached at Ahanson@royal-basket.com.

24

GPUG MAGAZINE H1 2019


YOU ASKED FOR IT. WE SOLVED IT.

wsTOOLS

Automate Processes I Empower Users Simplify Tasks I Improve Accuracy

Work smarter with wsTOOLS for Dynamics GP. With our Microsoft Dynamics GP enhancements, eliminate common multi-step processes, keep data accurate and more. + Conveniently move historical payables transactions back to open with PM Unapply + Eliminate the hassles of payroll voids, no need to manually correct ACH files, tired of rekeying payroll transactions when you simply need to reprocess, try Payroll Rewind + Switch the vendor on a PO or unposted payable voucher without starting over with Vendor Change + Secure your document attachments with folders that are great for organizing and securing access. Our Drawer tool works with vendors, employees, customers and items Learn more about the 50+ enhancements we offer at

www.iscorp.biz/solutions/wstools

Harness the power of Dynamics LEARN MORE AT www.iscorp.biz

218.486.5095


26

GPUG MAGAZINE


story by Melissa Dobkins and Pam Misialek, Njevity, Inc., Partner Member

Being in the Cloud

M

icrosoft Dynamics GP works totally awesome in the cloud, but unlike other cloud solutions, you get to choose what kind of cloud you want. It’s really the best way to go to the cloud and get all the cloud benefits while keeping your business processes and historical data. How does the cloud work? Private cloud is a dedicated environment for one business. You get direct database access and can add any ISV, and things are easy to customize. Public cloud doesn’t offer these benefits, but since you are sharing hardware, it’s much cheaper. Keep in mind, private cloud is a private dedicated environment, so you also might spend time on maintaining this environment, where public cloud is mostly maintenance-free.

Microsoft Dynamics GP in the Cloud: Totally Awesome For IT pros, it frees up time to focus on strategic IT investments instead of creating and testing backups. The cloud takes care of time-consuming server maintenance and backups, and it ensures security. Plus, you never have to do a Microsoft Dynamics GP install again. For power Users, the cloud gives more flexibility to work from where you want; all you need is an internet connection. Plus, you won’t have to argue with the IT team about getting an upgrade anymore. For business leaders, the cloud gives peace of mind with an extra team working for you. You get to focus on achieving your

H1 2019

27


company vision rather than the systems that support it. Plus, it can give you a predictable cashflow without unexpected expenses. Microsoft Dynamics GP in the cloud gives you the ability to upgrade easier, lets you take advantage of tech-heavy features, reduces overall IT costs, and gives you the flexibility to work from wherever you need to.

Things to Research Not all clouds are the same; they offer different benefits. When doing research, be careful; they will all sound fantastic, but you need to get into the details. Should you go to the cloud yourself? You can, but should you? It really depends on three factors: »» Skills of your team. Going to Azure or any other cloud takes a little skill. It’s not impossible, just something much different than an on-premises deployment. »» Money you want to invest. Paying someone to help you can save you a lot of time, but the cost might be more than you want. »» The time to deploy the solution and the time to maintain it. Maintaining a cloud solution yourself takes up a lot of time and gives you less value. Just because you have the skills and time doesn’t mean you should be using it for this. Of course, it’s totally possible to go to cloud on your own. I’ve talked to successful Users doing it that are very happy. Just make sure that you know what you are getting in to. Should you use a cloud service provider or hosting provider? Here are things to ask your potential hosting provider: »» What kind of service level agreement (SLA) do they offer? Most providers offer a pretty good SLA. Make sure you understand the terms and what you should expect. »» How do upgrades work? Asking about who does the upgrade and the cost are important questions. Some cloud solutions do upgrades on their terms. Others give you control over the upgrade.

Microsoft Dynamics GP in the cloud gives you the ability to upgrade easier, lets you take advantage of tech-heavy features, reduces overall IT costs, and gives you the flexibility to work from wherever you need to. 28

GPUG MAGAZINE


»» Do they have Microsoft Dynamics

GP experts? Some providers just provide the hardware, and they don’t understand Microsoft Dynamics GP and how it’s different. There’s a reason many IT teams don’t want to mess with Microsoft Dynamics GP. »» Who owns the data? If you want to move from their cloud, how does it work? I’ve heard of providers keeping data hostage. »» What security protocols do they have? Where your data is located and where backups are located is important. Most providers do this well, but it’s always good to do your due diligence. »» Do the people fit with your people? This is probably the most important question. When something happens, it’s the people who you can trust and rely on that will make all the difference. Make sure their values match yours.

Specific Microsoft Dynamics GP Considerations Going to the cloud is your chance to look at your deployment and see how you can get more out of your investment. You can take your local deployment and have exactly the same solution in the cloud, most likely, and in the meantime save money, be more productive, and be happier overall. As newer versions of Microsoft Dynamics GP are released, there is additional technical knowledge needed. This also means potentially additional costs for hardware. Being in the cloud allows you to take advantage of these features. Moving to the cloud gives some additional benefits. Web Client has been out for a few versions now, and

Another Month End. Another Set of Financials. Another Bud et. Another Forecast.

PROSPERO

®

An All-in-One Solu on for Financial Repor n , Bud e n & Analysis

Your cost-effec ve replacement for Mana ement Reporter®, FRx® and Forecaster® brou ht to you by former Microso�® Team Members, with 20 years experience on these products info@msxgroup.com

®

877-456-7623 www.msxgroup.com H1 2019

29


this is the time to embrace it. While you could certainly deploy this on your own while on-premises, taking advantage of cloud experts that know how to deploy and maintain it will be much easier and cheaper. We all hear a lot about Power BI, PowerApps, and more. Being in the cloud allows you to integrate your data into these new applications and really advance your business. Power BI can allow all your data consumers to have immediate access to the data they need, and they can see it the way they want to see it. You don’t need to have team members ask for text reports that you then spend an enormous amount of time formatting. Putting the power in your Users’ hands allows for quicker visibility and decision-making abilities. At the end of the day, going to or not going to the cloud is a personal decision. But it isn’t one you need to make on your own. Talk to your Partner and find out what your options are. If your Partner is hesitant, then reach out to the community. There are great cloud providers in the Microsoft Dynamics GP community that are experts at supporting the solution.

30

GPUG MAGAZINE


Improve Your Your Accounts Accounts Receivable Improve Receivable for Microsoft Microsoft Dynamics for DynamicsGP GP Automate every every step step of of your Automate your AR AR process process Reducecosts costs of of paper paper invoicing Reduce invoicing and andmanual manualcollections collections Lowerpayment payment processing processing transaction Lower transactionfees fees FulďŹ llPCI PCI compliance compliance requirements requirements FulďŹ ll

Payment Processing Payment Processing

Customer Payment Portal Customer Payment Portal

B2B and B2C eCommerce B2B and B2C eCommerce

SCHEDULE A DEMO: SCHEDULE A DEMO: (909) 482-4701, OPT 1 | sales@nodus.com (909) 482-4701, OPT 1 | sales@nodus.com

Payment Hyperlinks Payment Hyperlinks

Gateway and Merchant Services Gateway and Merchant Services

Secure Cloud Payments Secure Cloud Payments


32

GPUG MAGAZINE


story by Brandon Mayer, Implementation Specialists, Inc., Partner Member

How Flexible Is It?

I

f you’re reading this, you are likely familiar with Microsoft Dynamics GP and the seemingly endless ways it can flex and adapt to meet company and industry needs. As in most cases, when you initially started using the solution, you made decisions on what modules you would utilize and how to configure them based on practicality and company goals. This practical approach to tailor your experience empowers companies to accurately track and manage essential information and improve processes. I’ve heard time and time again, “No two companies are the same”; I don’t disagree. I do challenge you, though, to consider this: Is your company at this present moment the same company it was when you initially started using Microsoft Dynamics GP? Because of the industry specific addons, its immediate functionality, and its customization options, more and more businesses reinvest in Microsoft Dynamics GP. This ERP solution best answers to their needs. While there are endless reasons why companies and industries have, and continue to choose, Microsoft Dynamics GP over other products, its adaptability remains a crucial benefit that is rivaled by few.

Microsoft Dynamics GP = Flexible “The measure of intelligence is the ability to change.” – Albert Einstein While I’ve yet to produce an alternative theory to debunk Einstein’s theory of relativity, I have been able to conclude that Einstein was referring to Microsoft Dynamics GP in his quote above.

H1 2019

33


In GPhysics, my theory states that Microsoft Dynamics GP is still the most flexible and best ERP solution available to date. No two businesses are the same, just like no two businesses use Microsoft Dynamics GP the same, but you can be sure the solution is the versatile tool that meets both their needs. Flexibility can mean many things, but when it is used to describe a whole business software application, it refers to the ability for a solution to adapt to potential or future changes in its functionality. In my pursuit to prove how flexible Microsoft Dynamics GP is, I was inspired by Einstein’s other work and came up with a formula that states flexibility (F) is found when great (g) is multiplied by plains (p) squared: F=gp². With that definition, a solution like Microsoft Dynamics GP that has been a proactive instrument of change for decades to meet the demands of thousands of businesses certainly equates to being labeled as flexible. Here are some of the many ways on how you can take advantage of Microsoft Dynamics GP’s flexibility.

Meets You Where You Are Growth brings great complexity. However, where there is complexity, there is opportunity. A business is always growing, from adding employees and offerings to entering new markets and partnerships. Businesses with ever-changing needs can easily accommodate that new business line and cut down tasks or processes distracting and taking away from company time and resources, thanks to a vast catalog of industry and taskspecific add-ons that work seamlessly with Microsoft Dynamics GP. Let’s also not forget that as needs change, where Microsoft Dynamics GP is deployed can adjust to where it makes the most sense, whether onpremises, in Azure, or a combination of both. Microsoft Dynamics GP is flexible, configurable, and designed to grow as the business grows. Its configuration can be adjusted to accommodate your needs and help you make the most out of new opportunities.

No two businesses are the same, just like no two businesses use Microsoft

Dynamics GP the same, but you can be sure the solution is the versatile tool that meets both their needs.

Embraces Modern Technologies All of Microsoft Dynamics GP’s flexibility can produce a significant amount of data, which is why it’s time to put it to work with some of Microsoft’s new tools, like Power BI and PowerApps. Microsoft Dynamics GP Users turn data into knowledge through Power BI by visualizing key information to gain insights across the business and help them become proactive and predictive. PowerApps lets YOU, not a developer, build your own business apps to be shared internally and externally with customers. By connecting your app to Microsoft Dynamics GP data with other sources, you can publish your app to the web, iOS, Android, and Windows.

34

GPUG MAGAZINE


It’s time to get creative with your Microsoft Dynamics GP data, and it is so easy with Power BI and PowerApps. You just have to get started. Power BI and PowerApps can breathe new life into your data, offering fresh visuals, unique presentation methods, and more ability to be created by you for you.

challenges, there are always more to come, and customization can transform the way you do business. I agree that custom software development is more expensive; however, it does allow you to tailor it according to your needs. You know what’s best for your company. You understand its strengths and weaknesses and know where the areas for improvement are needed. But by taking the core strengths that are already provided in Microsoft Dynamics GP and customizing it to your business’s strengths, you can ensure that your company is equipped with the right tools for the job.

Give Customization Another Chance There is a major misconception when it comes to customizations and that is that they cause unnecessary headaches and make future changes problematic. I want to set the record straight that when a customization is done correctly, it will be a positive impact on your business and provide a massive ROI. For some, hearing the word customization can send them into a frenzy, and they are immediately turned off by it because of cost, waiting long periods of time for a customization to be delivered, having difficulty maintaining the customization, or having it not provide the intended results. If you have a workaround for another workaround to get by, then it’s time to consider a customization to overcome those inefficiencies. The key to your successful customization in Microsoft Dynamics GP is partnering with the right custom development team, so here are a few tips in finding the correct team for you: »» They dedicate time to understanding your business thoroughly and can state the challenge you want to overcome along with the desired outcome. »» They are reputable, specialize in your industry, and will provide references for you to speak with on their previous custom projects. »» They lay out a roadmap for your project and have details on how they will maintain and support you afterward. Even though you and your company have already overcome many

Cloud P2P Automation. Easy. Powerful. Smart.

Your file cabinet called. It’s lonely! Join thousands of companies already leveraging the most efficient, end-to-end invoice and payment processing solution on the market.

Don’t wait. Just Yooz it!

We’ve saved nearly $35,000 a year with the Yooz paperless workflow, and our GMs can approve payments on-the-go.

Patsy Price

Director of Operations Peterson Auto Group

Just a few innovators who’ve made the switch

Ready to Yooz It?

Call us at 832-384-YOOZ (9669) GetYooz.com

Island-Branded-GPUG.indd 1

TOP 10

ACCOUNTING

SOLUTION PROVIDERS - 2019

1/24/19 11:59 AM

H1 2019

35


isv showcase

MARTIN OLSEN

Owner, eOne www.eonesolutions.com “We can now be independent of Microsoft’s release cycle and update based on Customer demand versus what Microsoft does.”

In It Together!

C

reative thinkers, Martin Olsen (eOne), Jay Manley (Mekorma), Lak Chahal, and Brian Morris (Binary Stream) are taking advantage of Microsoft’s yearly update schedule for Microsoft Dynamics GP. Instead of waiting for Microsoft’s cue, these ISVs are working together to proactively solve solution gaps. Now that these ISVs are enjoying a bit more freedom from keeping up with Microsoft, improvements to their add-on solutions are being made proactively and in large-scale ways:

GPUG®: How has this Microsoft shift changed your Microsoft Dynamics GP business? Martin Olsen (MO): It’s actually been great! Our Customers

LAK CHAHAL, President and CEO, and Brian Morris, Partner Account Manager Binary Stream www.binarystream.com

are getting new features and functionality without waiting for Microsoft. It has given us more freedom to not just sit back and wonder what they’re going to put out that may overlap with our product. We can and are making Microsoft Dynamics GP better than it was before.

“Upgrades are inherently disruptive. Once a year is much better for us and our Customers. We can focus on making our solution better instead of training on new features and functionality from Microsoft.”

Lak Chahal (LC): It has also simplified our business. With every release, we need to educate all our Customers on those new features and functionality. It was a challenge for us to keep up and make sure our Customers kept up along with us. This new cadence helps us focus on our product and what we do best. Jay Manley (JM): Agreed! We were so busy keeping up that we couldn’t focus on larger, net-new features. Now we can and are focusing on larger features we didn’t have time for before.

JAY MANLEY

President, Mekorma www.mekorma.com “The constant upgrade threat isn’t there. We are freer to try new things. We were resource-constrained in the past, but now the sky is the limit to what we can do!”

36

GPUG MAGAZINE

GPUG: How do you identify which issues to focus your time and effort on today? JM: I used to answer the question, “why can’t you do this”, a lot more than I do today. Now the question is, “what can we do?”. We’ve gone from a reactive approach to a proactive one that allows us to think bigger. MO: A lot of that is driven by our Partner channel and the broad appeal of making major changes to our horizontal solution. We focus on how it can make a bigger impact across our Customer base. LC: ISV collaboration has allowed us to focus our efforts in the right place to really streamline the value we can provide. We work with 30 different ISVs that integrate with our products and collaborate together to build integrations so there is less dependency. Just a few years ago, new functionality could break functionality. What has come as a result of those challenges is a proactive ISV community. There are so many of us excited


about working together to make sure products work together. As we mature, there are less and less issues occurring. It’s been a steady evolution for Microsoft Dynamics GP ISVs, and I think that makes our community unique in that sense.

GPUG: That is very exciting! How do you identify which ISVs to work with? LC: Usually it’s a phone call to see how we can work together. We’re a tight-knit group. Sometimes it depends on the specific industries or verticals we play in. We focus on how the partnership could help win more deals together and ultimately be less hassle for end Users and VARs. JM: I sat down with Binary Stream while at User Group Summit and pointed out all our mutual Customers to see what else we could do together. From there, we changed the ways we handled screens so we could provide something deeper than we had prior. Those are the sort of updates that are key to Customer success. When you start treading on other ISV toes, we start to ask, “how can we not tread so heavily on your toes?”.

GPUG: What are some ways you “play well together” in the Microsoft Dynamics GP ISV channel? LC: I think the mindset that we’re in it together—here together— focused on the end User experience is crucial. We collaborate and look to the interest of our end Users, asking how we can bring it together and show the importance of integration. JM: When Binary Stream and Mekorma teamed up, we didn’t fully understand some of their models. They came in to train us how to properly test our functionality with theirs, and that gave us enough of a highlight to build out testing demo images to show the integration between the two. Showing the combined solution and complete story sells so much better than demoing one-off solutions. This is really something we need to think more about how to streamline in the future. Brian Morris (BM): When we’re working with new Customers for an upgrade, we really dive into what other third-party products they are involved in. I’m amazed at all the new third parties we’re encountering. When we identify those new ones, we pick up the phone to call them. We also make our table list available online so that other ISVs can easily access it and their developers can build a hook in. LC: We’ve learned to write code in a new way to prevent running into issues with others.

MO: Yeah, we don’t write in Dexterity like we used to. We do it separately and outside of the Microsoft Dynamics GP solutions to guarantee more flexibility. If our Customers are on Microsoft Dynamics GP and plan to stay there, we got them covered. If they plan to move to Microsoft Dynamics 365 Business Central, we also have them covered. We’re essentially future-proofing our ISV products so the functionality Customers need will be there, no matter what their upgrade path looks like.

GPUG: What do you see happening in the channel for Microsoft Dynamics GP? MO: In short, I don’t see massive changes to the Microsoft Dynamics GP Customer base. If the last 10 years have showed anything, it’s proved that Microsoft Dynamics GP Customers don’t like to move software, and for good reason! ERP is complex, and mid-market companies simply don’t move from one ERP to another. It might get tougher to attract net-new Customers, but small companies growing out of QuickBooks, for example, could greatly benefit from Microsoft Dynamics GP. JM: Both our net-new adds and renewals were much higher than we thought they would be in 2018. Fewer Customers dropped Microsoft Dynamics GP than we thought. It’s exciting to see the number of net-new Customers exceed our expectations as well. LC: We also had a very strong year in 2018. We surveyed our Customers recently, and not many are planning to upgrade from Microsoft Dynamics GP anytime soon. Customers see for themselves the value they get from their platform, and that value is still very much there with Microsoft Dynamics GP. JM: Business Central still has a lot to prove, and the functionality is pretty limited. There is still no mid-market ERP that can scale the way Microsoft Dynamics GP can. I’m not aware of any others that can keep up with the raw transaction throughput that Microsoft Dynamics GP has. It holds the record and already has so much time and effort invested into it. LC: I agree! All the competition—Intacct, Acumatica, and NetSuite—are going through growing pains and major changes. Microsoft Dynamics GP is so great as it is, and the cost of ownership is lower. We recently won a Microsoft Dynamics GP opportunity in healthcare that is 1,400 percent bigger than any other deal. They have more than 330 healthcare offices with 1,300 Users. That in itself is a great testament to the power of Microsoft Dynamics GP.

H1 2019

37


TOPICS

TRENDING

The GPUGÂŽ Open Forum is a place where connections are made and questions are answered. With more than 46,000 discussion posts, the GPUG

Cannot Reset Passwords in GP; User Locked Out

Visit www.gpug.com/trend1 to view the full thread and read all comments.

SOP - Same Master Number Getting Assigned to Multiple Orders

online community allows fellow Microsoft Dynamics GP Users to share best practices, tips and tricks, and general knowledge with their peers. Highlighted here are two popular discussion posts from the Open Forum. Check them out and then take some time to share your thoughts, answer a question, and/ or create your own post.

It’s easy to post a question or a response. Simply visit www.gpug. com, log in, and click on Participate > Discussions. 38

GPUG MAGAZINE

Visit www.gpug.com/trend2 to view the full thread and read all comments.


Microsoft Dynamics users, please help us help you... Microsoft Dynamics users, please help us help you... www.integrity-data.com/payroll-afraid www.integrity-data.com/payroll-afraid


40

GPUG MAGAZINE


story by Laurent Charpentier, COO and chief innovation officer, Yooz Inc.

Five Technologies Shaping the Modern Finance Office

R

emember the early days of personal digital assistants and cell phones? Before they were “smart�? We were wowed by the first handheld computers (now long forgotten) like the PalmPilot and BlackBerry, but few among us knew then that in a few short years we would become dependent upon smart technology in all aspects of our personal and business lives. Technology and time march swiftly on, and business moves fast. Today’s emerging innovations are already impacting business operations, profits, and productivity, and companies must learn how to adapt or consequently fall behind. If you are a modern finance leader focused on strategic priorities, workflow automation will become even more critical for handling routine accounts payable (AP) tasks such as invoice processing, approval, payments, and vendor audits. Living on the edge, in this case, of computing, is a good thing. Embrace the following five emerging technologies to scale gracefully and remain competitive.

One: Data and Analytics Finance leaders are looking at the best strategies for organizing and standardizing their data, which is a top pain point

H1 2019

41


for many organizations according to industry research. But, while getting a better view of internal data is critical, advances in machine learning and unstructured data processing will assist CFOs in becoming more accurate in estimating revenue and profitability…and making smarter business decisions. And that is only the first step. Looking ahead, prescriptive data analysis will identify new markets, Customers, services, and channels—all leading to profitable growth.

Two: Risk Management Yooz chief innovation officer and COO, Laurent Charpentier, expresses a frustration shared by many CFOs and risk managers, “Up until now, we had to have a human that could actually decipher the information from risk evaluation, which was a nearly impossible task.” Fortunately, that is changing. Now, artificial intelligence (AI) and more robust data analytics will enable finance teams, including AP departments, to make more informed decisions about cash management, investments, and lending, thus reducing the risk of being caught short of capital to fund missioncritical projects. Further, Charpentier says, “Future AI tools will have the ability to analyze a lot more data than is currently possible to detect fraud before it gets too far.” And that will allow you to sleep at night!

Three: Robotic Process Automation (RPA) While today’s “robot” may not wander around your finance offices flailing its arms and shouting, “Danger, Will Robinson!” (for those of you who admit being old enough to remember the 1960s TV series “Lost in Space”), it might be your new favorite co-worker. Adoption of cloud-based AP

42

GPUG MAGAZINE


automation platforms that leverage a form of RPA powered by AI and machine learning is expected to become more widespread, streamlining and improving efficiencies across the entire financial planning and analysis process.

Four: Blockchain Cryptocurrencies continue to be a darling or a devil in the finance industry, depending on what day you’re listening to the news. But blockchain is emerging as a potential solution to supply chain payments and other financial transactions. One of the key pain points for accounting leaders is a lack of visibility into the payment process, from both the supplier and vendor side. Blockchain holds the promise of creating a payment ecosystem with valuable Partners that provides a fast and secure way to process transactions. It can help finance leaders in a number of other ways as well, including: »» Saving time by streamlining everyday business transactions and eliminating inefficient processes »» Identifying and limiting risk »» Eliminating overhead and multiple intermediaries »» Creating a strong audit trail

Five: Cloud Applications This day and age of being connected 24/7 and needing real-time information anywhere, anytime has sparked an increase of cloud applications, otherwise known as “edge” computing. Business leaders are pushing for faster and more agile applications, and cloud applications perform data

H1 2019

43


processing at the edge of the network, near the source of the data, to provide Users with the fast, real-time analysis needed for smart decision-making. The cloud will become the dominant platform for ERP and CRM applications, providing better visibility into spend. And AI, RPA, and machine learning will be the leading catalysts to drive greater cloud computing adoption in the next two years. Some of today’s cloud P2P (purchase-to-pay) automation platforms are already leveraging all five of these key technologies, providing finance and accounting teams of the future the tools to escape mundane processing tasks, up-skill, scale gracefully, and remain competitive. The most sophisticated solutions offer an end-to-end workflow that supports the entire invoice process in six steps: »» Purchase: Create a PR/PO »» Capture: AI-based data extraction via scan, import, email, and EDI »» Verify: With automated GL coding and PO matching »» Approve: Or reject via desktop or mobile device »» Pay: Prepare and release payment »» Export: Seamlessly integrate with Microsoft Dynamics GP Today’s tools allow firms of tomorrow to build P2P automation ecosystems that are easy to manage and increase collaboration between co-workers, vendors, Partners, and Customers. See you in the future! And that may be as soon as tomorrow.

Time Keeping for Dynamics GP

Interfaces with:

Payroll Human Resources Project Accounting GP Manufacturing KEY2ACT Job Cost KEY2ACT Service Mgmt. ADP / Ceridian / Paychex

www.Business-Computers.com

44

GPUG MAGAZINE

info@Business-Computers.com

303-499-2039

screen image simulated


Ongoing Employee Performance Management STARTS HERE Easy, Affordable & 100% Configurable Employee Performance Management Software HOSTED OR ON-PREMISE DEPLOYMENT PLUS INTEGRATION WITH DYNAMICS™ Trusted by organizations around the world since 2004, CRG emPerform delivers award-winning software to save time, automate & streamline vital performance management efforts, and engage your company’s talent in easy, effective, and ongoing feedback & development. ONLINE REVIEWS & SELF ASSESSMENTS � 360º REVIEWS � FEEDBACK � JOURNALING & CHECK-INS NINE-BOX TALENT MATRIX � COMPENSATION PLANNING � SURVEYS � REPORTING NEW! ON-DEMAND FORMS FOR AGILE TALENT MANAGEMENT

Corporate Renaissance Group

employee-performance.com


&

tips tricks

by Brent Olsen, ZAAG Inc., User Member

Confessions of a SQL Guy

Part Two, SQL Scripting Basics SQL for Other Microsoft Dynamics GP Guys There are lots of great Microsoft Dynamics GP solutions on the web; I love this community! Once you find a solution that works for you, embed the URL link in your saved SQL script so that you will not only have the original reference for the solution, but also when you hold CTRL and click the link on line 7 of the code below, it opens the page as a new tab inside SSMS (SQL Server Management Studio). Now you have everything you need to use this code in the future; how cool is that? I used the following script recently from Microsoft Dynamics GP Community Forum and include it here as an example:

How to Update Tables Safely Most data manipulation scripts used to fix corrupt Microsoft Dynamics GP data include INSERT, UPDATE, or DELETE commands, which are at the heart of SQL’s power. But how do we wield that power for good and not evil? In the above example, the select command on line 11 is benign; no data will be changed when the entire code is executed. The update on line 12 has the power to update every row in the table sy01402. The WHERE statement on line 13 limits which rows will be updated, in this case only those rows with syDefaultType of 96, and the userid JosephBlow will be updated but only if both rows 12 and 13 are highlighted and run together. This syntax allows you to write one query for both the select and update, ensuring that the results for the update will be what you are expecting from the select statement.

SQL Comments Let’s talk about SQL scripting readability and annotation. I like to use lots of notes so I don’t have to read through code to remember what it does. The double dashes used throughout the script create a comment on one line causing the SQL code to the right of the dashes not to be executed if the dashes are included or highlighted when the code is executed. I like to create reminders or even a checklist of steps to take since many fixes in Microsoft Dynamics GP require you to run reconcile or checklinks routines after adjusting data in the tables. You can also use the characters /* and */, as I did on lines 19 through 24, to encapsulate an entire section of code, which is great for secondary scripts which might be used to ferret out the errors or to test a view or stored procedure created. Bottom line, none of the code in green will execute unless highlighted directly. If the above code is executed in its entirety by clicking the Execute or F5, only the USE DYNAMICS and the select statement on line

46

GPUG MAGAZINE


11 would run using the where statement on line 13. Also, I like to start a new script by writing the steps I want the code to take as a checklist and then fleshing out the code to do the actual work beneath the notes. Referred to as pseudocode, this leaves your SQL code very readable to you or anyone who may need to execute the script in the future. Back to the script: The code on line 12 is what does the actual work here. For added safety, it can be a good practice to comment on the UPDATE on line 12 to avoid the possible headache of accidentally running an entire script. For even more safety, embed the UPDATE within a transaction so that you can roll back the results if you don’t like them. If you highlight the code from the “Begin” to the end of line 13, then the records included in the select statement will be updated, and you should receive a row count which should match the count from the original select statement which was just one row in this example.

This can be confirmed by running the entire script, and you will receive results with the new value updated. If the row count is different, you would execute the rollback tran on line 17 to reverse the update. Once you have confirmed the accuracy of the results by executing the original select on line 12, be sure to run the commit statement on line 15 to finalize the update. If you do not rollback or commit the transaction it will wait indefinitely for your response and cause all other transactions to queue up behind it, and Users can’t make their own updates. If a User is posting after your update but before your commit, Microsoft Dynamics GP will basically stop responding as it waits for the open update transaction to finish. This code provides additional control over your updates. If you are updating just one row but miss the where statement, the record count would reflect the multiple rows updated. You would see this as you run the select statement to confirm the update, and to fix this, you just select the rollback tran statement on line 17 to start over. This is a lot nicer than a database restore. The primary role of the transaction with commit code discussed here is to automatically abort changes to the database if errors are encountered. This error handling is crucial for production systems but is beyond the scope of this article. We use it here to give the User a second chance before data is committed with no recourse.

SSMS Text Editor Tricks Here is another helpful tip when scripting in SSMS for Microsoft Dynamics GP updates: using the Shift/Alt keys to modify columns of data. The SSMS is not a bad text editor; in the following screenshot I paste the four SOP numbers sent to me in an email which I would like to use in a where statement to update User-defined data in the SOP10106 table: ORD1000001 ORD1000005 ORD1000100 ORD1000105 If I copy that column of data into a query, I can highlight columns to add the single quotes and commas required for the where statement. If I left-click to the right of the value ORD1000001 as the beginning location, then hold the Shift and Alt keys as I leftclick at the end of the value ORD1000105 as the ending location, then a thin blue line will show the vertical “highlighted” area:

I then enter the single quote and comma, and presto: All rows are updated. I do the same for the leading single quote, and I have all the data ready for the statement (after deleting the extra comma on the last SOP number):

This may not seem like much, but if you need to update thousands of rows with a column of data, it’s a quick fix. Make sure to try these tips in a test database. In the next article in the next issue, I will discuss audit considerations in the administration of your Microsoft Dynamics GP databases. H1 2019

47


user member showcase

M

INTERVIEWEE

COMPANY

Mary Kay Merkel, Senior Accountant Synthetic Genomics

WEBSITE www.syntheticgenomics.com

PRODUCT VERSION

Microsoft Dynamics GP 2016

NUMBER OF EMPLOYEES 250

48

GPUG MAGAZINE

ary Kay Merkel is a senior accountant at Synthetic Genomics and the company’s Microsoft Dynamics GP advocate. Everyone filters their Microsoft Dynamics GP questions and comments through Mary Kay, and she takes it from there to resolve any issues. Her first source of information, education, and support is GPUG®. “Nine out of 10 times, there is already something available to answer my questions right on the GPUG Discussion Forum. If that can’t lead me to the right answer, I reach out to our Partner,” Mary Kay explains. Once such Discussion Forum response opened Mary Kay’s eyes to the community available to her online: “I was asked to update a field in the Inventory module and to create a SmartConnect map to do this. I questioned myself in being able to do this alone, so I thought why not take a chance and post a question on GPUG? The response was amazing. I received a wealth of information and support as well as someone offering me to work through the creation of a SmartConnect map without charge. I couldn’t believe this type of support was out there. In the end, I was able to learn how to do this on my own through perseverance, but without the support and suggestions that everyone provided me on a daily basis, I wouldn’t have had the confidence to tackle this. I knew I believed in the GPUG Discussion Forum, but now I’ll be a contributor and a regular User of this incredible community. In addition, I’m going to encourage our team to utilize this as a source of support.” Since then, she has encouraged her entire accounting team to get more engaged online by sending them links to relevant discussions, suggesting recorded webinars for new employees to watch, and, if encountered with an error message, encouraging them to search www.gpug.com for the answer. Mary Kay tries to be as independent as she can be, and GPUG allows her and her colleagues to do just that. In doing so, she also plans to get certified as an administrator through the GPUG Academy to expand what she already knows within the software she loves to use. “I’m pretty passionate about Microsoft Dynamics GP. When people who don’t know the solution say it’s broken or not good enough, I stop that thinking right away,” Mary Kay concludes. “It comes down to how much you know about Microsoft Dynamics GP and making sure you’re educated. All that education is readily available in GPUG, and every Microsoft Dynamics GP User should realize that.”


BECOME A DYNAMICS CREDENTIALED PROFESSIONAL

ONLINE! In an effort to maintain the professional standards of Microsoft Dynamics GP administration and deployment practices, Dynamics Credentialed Professionals, powered by GPUG®, has developed a series of credentialing exams. Upon passing an exam, you will join an elite group of Dynamics Credentialed Professionals who demonstrate the highest knowledge of and expertise regarding Microsoft Dynamics GP. As a Dynamics Credentialed Professional, you will: • Be granted the right to use the official Dynamics Credentialed Professional (DCP) mark for e-mail signatures, social media, blogs, etc. • Receive a certificate acknowledging your DCP achievement • See your name and picture published on the GPUG Credentialed Professional website www.gpug.com/credentialing/credentialed • Have your credential maintained for two full years Become a Dynamics Credentialed Professional for: • Microsoft Dynamics GP Core Installation and Configuration • Microsoft Dynamics GP Core Financials Setup and Functionality • Microsoft Dynamics GP Core Distribution

Schedule your Microsoft Dynamics GP exam today and become a Dynamics Credentialed Professional: www.gpug.com/credentialing

H1 2019

49


members in action

50

GPUG MAGAZINE


r o f s e i n n e P

TAYLOR Y

ou know the sound a penny makes when you drop it into an empty jar? For Shawn Dorward and his family, that first “Penny for Taylor” marked the beginning of their miraculous story. Although a lonely sound, it was to celebrate Shawn’s son, Taylor’s, first movement after he nearly drowned in a friend’s pool on July 4, 2018. Taylor was 18-years-old at the time and went without oxygen for 13 minutes. It took 19 minutes of CPR to bring him back. After that trauma, the outcome looked bleak. As you can imagine, the Dorward family was lost in despair, terrified of losing Taylor, and relied heavily on the medical staff (who were not giving them the best news those first few days). Shawn recalls the “bad day” where doctors recommended they consider organ donorship five days into Taylor’s coma. “Our other option was to keep trying, and that is what we did and have been doing now for more than 26 weeks, always shooting for making tomorrow better than today,” Shawn shares. Twenty of Taylor’s friends came to the hospital the day after the accident. They and the Dorward family were starving for any and all hope they could find. On that same day, Taylor clutched Shawn’s hand, so Shawn decided to drop a penny in a jar to celebrate. They’ve since celebrated all the brand-new things Taylor has done after the accident.

These amazing companies and community Members contributed to the fundraising efforts for Taylor: »» David Musgrave auctioned off a TV at his booth and donated those proceeds to Pennies for Taylor. »» Kristen Hosman and Brianne Van Reenen raised more than $600 with penny jars placed around the conference. »» GP Power Tools, Ethotech, Encore Business Solutions, Historical Excel Reporting - 10% Campaign »» Training Dynamo »» mpolino.com/gp/ »» Encore Business Solutions »» Njevity »» Rockton Software »» BTP Technologies (Easy E Bank Rec) »» Greenshades »» Nodus »» Integrity Data »» Jet Reports »» Power GP Online »» EthoTech »» Electric Guard Dog »» InterDyn Artis »» Dynamic Communities »» Hundreds of individuals, companies and organizations!! H1 2019

51


GP stands for “Great People”… “I have been in the Microsoft Dynamics GP community since 1994. Back in 1997, I even attended the CIS Conference in Fargo while I was pregnant with my son. I loved the people in Fargo, North Dakota, and the entire community so much that I named my son Gregory Dakota Conklin! Fast forward a few years, and my son was diagnosed with cancer. He fought the disease for more than six and a half years, and we held fundraisers. Besides contributing to the fundraisers and flying to southern California to participate in them, after my son passed away, and I took time off to grieve. MANY community Members helped me get my feet going straight again by being alongside me while I navigated my next conference. The Dorwards’ story brings back memories for me of a loving community that will do everything for its Members!” – Abra Gilman, Collins Computing, Inc.

52

GPUG MAGAZINE

Today, they have more than 33 pounds of pennies in jars all over their house AND a 19-year-old who has made almost a complete recovery. Taylor went on a jog recently and has returned to taking college classes. “He has gone through so much and hasn’t complained once. He’s such an upbeat person with a good attitude,” Shawn says. “He does and will have vision problems but has reached above average cognitive ability and is nearing 100 percent physical ability. He is a miracle.”

Kindred Spirits Shawn has been a part of the GPUG® community for six years. Kim Peterson was a big advocate in rallying him to volunteer, and before long, he was presenting at webinars and conferences, becoming an MVP as well as a GPUG All Star. “I used to be asked if I could help; now I’m the one beating down the door to ask when I can present again. When you have that desire to help someone, you really have no choice but to learn something new. It’s self-challenging as well as rewarding,” Shawn explains. A kindred spirit soon came into Shawn’s life, and at one event, he was convinced to tell her how much he enjoyed her sessions. Shawn and Belinda Allen have known each other for about two years now, catching up at conferences and forming a great friendship.


“There is something special about Belinda. Her dedication to helping someone individually is amazing,” Shawn shares. When Belinda came to visit Shawn in the hospital, it deepened their bond as friends even further. “Belinda came to visit a few times in the hospital and was such a strong shoulder to lean on. We are very like-minded, and that alone helped keep me in check while my life was falling apart around me,” Shawn recalls, “She gave up her own time to help us. Her generosity to be our advocate is far more than I can ever thank her for.” The GPUG community support soon followed, after Belinda informed the channel of what Shawn and his family were going through. By the time GP Tech Conference came around in August, Taylor was doing better. His recovery was promising, yet he still had a long way to go. Shawn’s GPUG peers were there and ready to help. David Musgrave and Mark Polino both approached Shawn about fundraising efforts for Taylor. Every day since, Shawn has felt the support of the GPUG community through social media, at conferences, and via friends reaching out with an email or phone call. “It wasn’t a story about how we lost him,” Shawn says. “It was a story about how we got him back, and not everyone gets that chance.”

H1 2019

53


Counting on Each Other Shawn and his wife, Jennifer, celebrate their anniversary in early October, and both enjoy traveling to User Group Summit. “It’s nothing but an uplifting week,” Shawn shares. As you can imagine, they were reluctant to leave Taylor on his own this past year, so the leaders of GPUG invited Taylor to attend the conference in Phoenix. “So much transpired that week,” Shawn recalls. “Taylor got to hear me speak, and that was a treasured moment for me. Usually I attend and present. People tell me they learned something, and those are all awesome things. But when someone comes up to your son and says, ‘I’m so inspired by you.’ Now that is a different level of awesomeness!” The community pulled together to support the Dorward family in GPUG Summit fashion! A collection of GPUG ISVs, spearheaded by Njevity and Rockton Software, pulled together a “Pennies for Taylor” challenge party that included serious karaoke, pies to faces, and an amazing donation to the Dorward family of more than $3,200. “Fundraising efforts from that event alone paid for three weeks of Taylor’s therapy. You don’t realize how expensive things are until…they are. If he took a break from therapy, it could have been bad news,” Shawn explains. Shawn finds it impossible to convey his appreciation for all the support he has received. “GPUG has turned into something we call community, and it’s easy to say ‘the community’. That’s my neighbor, that’s my friend, but when you have actual evidence where people in large quantities come together for one thing that is so selfless of them simply because we are a community, it is pretty incredible,” Shawn adds. “It’s a whole new level of community. You’re not just saying it, you’re living it. I would never want others to go through something like this, but having this feeling is very powerful. It’s not just a community for your accounting software, it’s the way we count on each other.”

54

GPUG MAGAZINE


WHAT’S NEW ON THE GPUG

New Discussion Forum Features: Reply Email Notifications, Inline Replies, Save Posts as Drafts

R

ecently, we announced three new community features on the User Group website, all designed to enhance your Discussion Forum experience: reply email notifications, inline replies, and save posts as drafts.

New Reply Email Notifications Participants will now receive a real-time email notification when there is a new reply on a discussion thread that you started or when there is a new post to which you’ve replied. You will see a star icon next to the title of the post that will be automatically filled in when you create or participate in a discussion. When the star is filled in, that means you will receive email notifications.

Interested in getting a notification on a thread that you didn’t create nor have a reason to reply yet? Simply click on the star icon to “favorite” that thread to get real-time post updates on that discussion, and you can deselect it to stop getting notifications on new posts on that thread. Not interested in getting ANY real-time notifications when a post is updated? Simply go to your profile page and navigate to My Settings > Email Preferences and toggle “Participation Emails” to NO.

Inline Replies To make it easier for Users to reply to threads online, you now can make a reply within the discussion thread page to allow you to reference all the replies made when creating your post. This new default is a quick reply option with streamlined formatting options; however, you can click on the “Reply with Advanced Editor” link if you want to use more formatting options (add an image, etc.) in your post. You will still be able to use the ”Reply to Discussion” option to reply to discussion posts online, which has all the usual reply formatting features. This will take you to the standard reply to discussion page with all the formatting options that you are used to having on our forums.

You can now press “Save as Draft” if you need more time to finish before you post your new thread or reply to the community. When you save a post as a draft, you will see a notification confirmation on the discussion page of where to find your draft. In addition, when you start typing a new thread or reply, your post will

now be auto-saved at a frequent interval so you can continue your post in case of the occasional computer or internet issues. To find your drafts so you can continue your post, go to your Profile page and click on My Contributions > List of Contributions. There is a filter that will allow you to sort by your draft posts. Simply click on the option to continue your post, or click delete to remove it.

Save Posts as Drafts Ever found yourself writing a post and got pulled away?

We hope you enjoy these new features!

H1 2019

55


56

GPUG MAGAZINE


story by Kyle Malone, CGB Enterprises, Inc., User Member

integration Microsoft Dynamics GP

How Easy Is It?!

W

hat really separates an ERP system from the herd? The ability to integrate, of course! Without having the ability to integrate, we’d be back to processing everything manually like the days of the cavemen. Microsoft Dynamics GP is especially EASY to integrate with, and this short article will walk you through the whys and the hows, with a few tips and tricks along the way.

The Whys SQL Server Microsoft Dynamics GP is built on SQL Server, which is one of the most widely used database management systems in existence. It’s easy to work with, easy to connect to, you don’t come across many issues/bugs, and there are a million resources out there on the database platform and language itself.

H1 2019

57


Table and Database Structure Microsoft Dynamics GP at its core is logically sound, very well thought-out, and tables/fields are organized. A thought-out and organized database structure makes integrating to (and reporting from) SIGNIFICANTLY easier. Anyone who has ever spent any time looking or working with the Microsoft Dynamics GP tables will be able to quickly tell you what a prefix of “PM” stands for (Payables Management) and what “10000” in a table name signifies (hello, unposted transactions). The whole database model is standard, consistent, and just makes sense. eConnect The out-of-the-box “Integration Roads” that Microsoft Dynamics GP provides (eConnect) give peace of mind when integrating data. If you’ve heard stories of corrupt data and nightmare ERP system implementations, it’s likely because of faulty/incorrect data integrations. This happens when “someone” who thinks they know everything just starts inserting data into tables based on their own thought process…this never ends well. With Microsoft Dynamics GP and the assistance of the out-of-the-box eConnect nodes, your worries of bad/incorrect data are no more. eConnect nodes are what can be used to integrate directly into the CORRECT places in Microsoft Dynamics GP and will prevent you from ending up with bad data. There are dozens of these eConnect nodes available right out of the box that you can hook up to and integrate data. Need to integrate a payables transaction? Well instead of your team having to know that you must hit the PM10000 and PM10100 tables, you just run your data through the eConnect nodes which will properly import the data AND will stop/notify you if there are potential issues with your data (say an inactive vendor). eConnect nodes are hands down an integration job’s best friend.

The Hows Integration Tools The technical back-end is great, but what good is it if you’re not interested in talking SQL, tables, or data in general, and you just want to integrate and be done? Microsoft Dynamics GP has several integration tools available to its Users which is really what takes integrating with Microsoft Dynamics GP to the next level. Some of these tools are Microsoft provided and come right out of the box with Microsoft Dynamics GP, but there are also several other integration tools available from companies that focus their business solely on data integrations into Microsoft Dynamics GP. Almost all the tools provide pre-defined integration templates for those that just want to quickly push data through from say Microsoft Excel to Microsoft Dynamics GP. However, the bread and butter of these tools and real value come from the integrations that you can fit exactly to your business. Want to integrate credit card transactions directly from the bank into Microsoft Dynamics GP as payables transactions on a monthly basis? You can take the out-of-the-box payables integration, modify it to exactly fit the file (or even setup a direct connection) that’s come from your bank, and push “Go” to integrate those transactions. Also, these tools have the ability to handle your more complex integration scenarios and become fully automated!

58

GPUG MAGAZINE


Want to integrate customer orders from your website into Microsoft Dynamics GP on a realtime basis? You can set up a connection to your website and integrate these transactions over IMMEDIATELY with some of the tools available in the Microsoft Dynamics GP world. Pre-Defined Integrations Within Microsoft Dynamics GP Integration tools aside, there are also several pre-defined integrations that are built right into Microsoft Dynamics GP. Need to integrate cleared checks from your bank into your bank reconciliation module of Microsoft Dynamics GP? There are a few integrations/processes like this already available right within Microsoft Dynamics GP that can be set up with little to no effort.

The Resources It’s been mentioned a few times to this point, but the Microsoft Dynamics GP community and resources available are plentiful when it comes to integrations. Here are a few general resources that that I’d recommend utilizing:

»» GPUG® forums, webinars, and blogs (obviously ) »» Microsoft community »» Partner/ISV blogs »» Scalar-valued functions in SQL (Ever wanted to know what the doctype value of “1” stands for in the payables table? The DYN_FUNC functions will tell you.)

Getting Data Out for Integrations to Other Systems This article has been primarily focused on getting data into Microsoft Dynamics GP, but the points discussed above also apply to getting data out and integrating with other systems. We could go on for another four pages talking solely about reporting, but the main points are that getting data out is just as easy as getting data in (well, easier, really). Taking that data and importing into another system can be done with some of the tools that integrate data INTO Microsoft Dynamics GP or the data can easily be handed off to another tool for another system.

Recap

»» The proper application set up on the back-end simplifies getting data in/out. »» The integrations tools and out-of-the-box integrations are very well developed and can handle

the most basic through most convoluted integrations to Microsoft Dynamics GP that you can dream up. »» The resources and community available in the Microsoft Dynamics GP world are vast and experienced, and likely any integration scenario that presents itself to your business has already been done with others willing to share their insight. That’s it. Hope you enjoyed, learned a thing or two, and are now ready to go move those current manual processes into some good-looking integrations!

H1 2019

59


microsoft showcase

TERRY HELEY

Escalation Engineer at Microsoft

T

erry Heley is part of a rare breed. While the IT sector has seen such rapid and far-reaching transformation, so many have come and gone to follow new paths, opportunities, and projects. But Terry has confidently chosen Microsoft as her home for the past 18 years. For this Microsoft escalation engineer, it’s been a fascinating labor of love, ever-challenging, and incredibly satisfying as she has intimately learned the Microsoft Dynamics GP product while guiding many, many Users through extremely challenging times. When you speak to Terry, one thing shines through: It’s not about the future of technology. It’s about the future of the Users she serves and how she can make today better than yesterday—and even better tomorrow.

GPUG®: What exactly is an escalation engineer? Terry Heley (TH): We have vendor support pulled inside on the Microsoft Dynamics GP side. We have level one and level two engineers, and then we have escalation engineers. We take on any case for Microsoft Dynamics GP. Sometimes the level one and level two engineers have some unhappy people, and it may prove tough to fix an issue and communicate workarounds. It can lead to escalation, and that’s where we come in. We’ve become trusted advisors to people over the years. Now that we have questions about lifecycle and future changes, we really need to have people trust us with the changes.

GPUG: You’ve been with Microsoft 18 years, almost your full career time since college. People don’t tend to stay in one place for as long anymore. What has kept you at Microsoft all this time?

60

GPUG MAGAZINE


TH: I have stayed in support because I enjoy the role. Things are always changing, and we’re always coming up with different ways of doing things to support the Customer. I enjoy working with Customers. I remember when I was hired, they said, “we are like koala bears,” meaning we are always amiable, likable, and empathetic to the Customer. We are always excited when we can solve a Customer’s situation—especially around year-end. If we feel we can help them get the job done, that’s extremely rewarding. Over the years the role has evolved, and we do a lot more proactive work than we ever did before. We used to handle 50 cases a day! Now, we handle about eight to 10 because of all the proactive efforts. Look at the User Group website; that wasn’t here 20 years ago. There’s so much more community involvement. That’s great because our support team participates in the User Group, and we leverage that. It’s so nice to see our Users become more self-sufficient. We’re a lot more interactive than years ago, and I think that’s great! What people might not know is that the Microsoft Dynamics GP team is only a very small piece of Microsoft. We have perhaps about 30 engineers. We have a very collaborative team and a very open cubicle structure. If you see something you haven’t seen before, someone else probably has seen it, giving us the opportunity to work together to solve problems quickly. It’s great because I don’t want to troubleshoot something I know nothing about, and most likely a fellow team member has the knowledge. GPUG: Which advances in your work do you think have been the most beneficial?

TH: Over the past 18 years, the Microsoft Dynamics GP product has become a more mature product, so the challenges are different. The product team has changed a lot and gotten smaller. As such, we’ve been creative in finding ways of doing things differently while providing the same level of service we always have, all while focusing on new solutions in a collaborative manner. I still learn things about the product all the time. I’m more of an applications person versus an upgrades and systems person. There are a lot of modules, so we’re always dabbling with upgrades integrated with Office products and learning all that goes with that. There continues to be different development work, and we continue to drive things within the product. We now do a lot of documentation.

GPUG: What comes next for you and Microsoft Dynamics TH: We’ll continue to watch the lifecycle of Microsoft Dynamics GP. We are going to do a new 2018 R3 version release with new features for Customers, so we still have a lifecycle to support which goes into 2028. We will support our Customers through that, see what ERP is doing, and see how the changes with Microsoft Dynamics 365 are taking hold. We’re doing a little cross-training because we are so knowledgeable in ERP, so we’ll see where that takes us. We will evolve and change with what happens over the next 10 years. I think we have one of the larger User Groups, so there are a lot of Customers to continue to support. As for me, I like the fact that with my job, I’m always learning and challenging myself with different issues every day.

Over the past 18 years, the Microsoft Dynamics GP product has become a more mature product, so the challenges are different. The product team has changed a lot and gotten smaller. As such, we’ve been creative in finding ways of doing things differently while providing the same level of service we always have, all while focusing on new solutions in a collaborative manner.

H1 2019

61


EXPERT KNOWLEDGE. QUESTIONS ANSWERED. BEST PRACTICES. TRAINING AND EDUCATION. Get the boost you need to achieve professional success! “Well worth the time!”

VIEW OUR

A

CADEMY CLASS OFFERINGS

A

T

WWW.GPUG.COM/PARTICIPATE/ACADEMY CHECK OUT POWER BI ON-DEMAND TRAINING: WWW.PBIUSERGROUP.COM/POWERBIUG /

62

PARTICIPATE/ACADEMY/ON-DEMAND

GPUG MAGAZINE

“The classes were very well thought out and the instructor's knowledge was valuable”


The List MOBILE

Solutions at your fingertips

thelistmobile.com Search for the products and services you need with the Mobile version of The List!

Powered by Dynamic Communities

Table of Contents Industry........................Page 64 Horizontal......................Page 67 Services.........................Page 73

The List from Dynamic Communities is your tool for finding the solutions available from Microsoft Dynamics® Partners. Review the various industry, horizontal, and service offerings available and you may just find exactly what you’ve been looking for! The List is unique in that it shares only those solutions and services that work with the Microsoft Dynamics product line. We want you to spend time using the solution, not looking for it. If you have a product or service that you would like included on The List, please contact Jane.Olson@dynamiccommunities.com. NOTE: Dynamic Communities offers no expressed or implied warranty or guarantee for any of the products included in this directory. Support and quality assurance of these software products and services are solely the responsibility of each Microsoft Dynamics Partner. *Due to the nature of the “classified” format used for The List, Microsoft Dynamics brand guidelines may not have been followed. We encourage Partners NOT to follow the example we are setting!


Industry

INDUSTRY

Associations

Evironmental

DATABASICS, Inc.

TrueCommerce

www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation!

www.truecommerce.com • 888-430-4489 TrueCommerce Scalable & affordable EDI solutions for Microsoft Dynamics. A managed service approach, from one trusted source, helps lower your fulfillment & procurement costs & connects you to an expansive global trading network.

Automotive

Cross Industry Solution

Slimstock

DATABASICS, Inc.

ACOM Solutions, Inc.

www.slimstock.com • 970-420-1777 Slim4 Inventory Optimization for Dynamics Forecasting, supply planning, and inventory optimization for distributors, manufacturers, 3PLs, and retailers.

Chemicals Horizons International www.qualityessentialssuite.com 866-949-9504 ext. 811 Quality Essentials Suite Quality Management System integrates to all Dynamics products. Used in chemicals, food and other regulated industries. Control layouts for certificates of analysis, comply with ISO standards, manage lot holds.

Vicinity www.vicinitychem.com 770-421-2467 Vicinity Vicinity’s ERP software manages formulation, quality control, compliance, production and planning for process manufacturers in the Food/Beverage, Chemical, Cosmetic, Paint, Personal Care and Pharmaceutical industries.

Consumer Packaged Goods

Data Masons Software www.datamasons.com/thelist • 866-575-1631 Vantage Point EDI for Dynamics EDI compliance without ERP customization. That’s EDI made simple.

acom.com/electronic-payments/ 866-730-9248 Paperless AP Payment Automation for Microsoft Dynamics ACOM streamlines how companies process their supplier payments of any type via one intelligent platform gaining better control over cash, higher efficiencies and the ability to earn cash rebate revenue.

DiCentral www.dicentral.com • 281-480-1121 EDI Integration with Microsoft Dynamics DiCentral is the industry leader in providing managed EDI solutions for Dynamics 365 Business Central and Finance and Operations, NAV, and GP.

Nodus Technologies, Inc. www.nodus.com/solutions/e-commerce/ 909-482-4701 eStore Solution Stack with PayFabric Go beyond a shopping cart with a feature-rich, automated and fully integrated ecommerce solution. Securely take orders from our PCI certified B2B, B2C, and sales portal web site with attractive responsive web design. Nodus Technologies, Inc. www.nodus.com/solutions/payment-processing/ 909-482-4701 Credit Card Advantage and CRM Charge with PayFabric Securely process credit cards and ACH within Dynamics GP or CRM and store credit card info in a PCI-certified cloud using PayFabric. Includes batch processing & reporting tools. Optional AutoPay and customer portal.

www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation!

Finance Banking ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikPayables KwikPayables automates the accounts payable process with centralized invoice workflows for GL coding, approval routing and transaction creation in GP or SL, with complete digital audit trail.

Food and Beverage

Nodus Technologies, Inc. www.nodus.com/solutions/online-bill-pay/ 909-482-4701 ePay Advantage with PayFabric A web-based customer payment portal that automates A/R, improves cash flow, and provides security and convenience to you and your customers. Optional recurring/subscription billing, AutoPay, and payment plan modules.

ASC Software www.vicinityfood.com • 937-429-1428 ASCTracŽ Top Award winning, enterprise supply chain software designed for Distribution, Manufacturing & 3PL operations of any type or size. 29+ years of experience in the Food/Beverage industry. (WMS, MES, MRP, & more).

Paramount WorkPlace Horizons International

DocStar www.docstar.com • 888-DOC-STAR DocStar ECM AP Automation Integrated content and process automation for Dynamics AX, GP, SL & NAV. Specializing in AP, AR, Sales Order & Contract workflow processes. Integrated Software, Inc. www.isiusa.com • 321-984-1986 Request For Quote Create RFQs for multiple vendors from a single RFQ Entry window. Compare Vendor responses. Auto-create PO's and/ or Sales Quotes. Seamlessly integrated with Inventory, Purchase Order and/or Sales Order Processing. JAT Computer Consulting, Inc. www.jatnet.com/JBC.htm 888-525-8874 ext. 462 JAT Benefits Connect (JBC) JBC communicates enrollment data to carriers and insurance providers.

www.ParamountWorkPlace.com 800-725-4408 Paramount WorkPlace 365 Business Central, AX, GP, NAV, SL Mobile Apps Expense, Requisition, and Procurement with Mobile Apps, Mobile Entry & Approvals. Robust Capabilities, Intuitive Features, Seamless Out-Of-The-Box Integration with your ERP.

WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 Dynamics GP PowerPack Over 80 Enhancements to GP, based upon customer requests. Enhances virtually every part of the GP System. Make GP more intuitive, easier to use!

www.qualityessentialssuite.com 866-949-9504 ext. 811 Quality Essentials Suite Quality Management System integrates to all Dynamics products. Used in chemicals, food and other regulated industries. Control layouts for certificates of analysis, comply with ISO standards, manage lot holds.

Slimstock www.slimstock.com • 970-420-1777 Slim4 Inventory Optimization for Dynamics Forecasting, supply planning, and inventory optimization for distributors, manufacturers, 3PLs, and retailers.

JAT Computer Consulting, Inc. www.jatnet.com/JPI.htm 888-525-8874 ext. 462 JAT Payroll Interface (JPI) JPI is a bi-directional integration linking GP HRM and ADP payroll. KEY:

64

D365 Customer Engagement/CRM

GPUG MAGAZINE

Dynamics AX

Dynamics GP

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Online Trial Available

Mobile Enabled


TrueCommerce

Life Sciences

Government Contracting

DATABASICS, Inc. www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation!

Horizons International www.hzs.com • 800 287 8014 ext. 811 Horizons Manufacturing Suite Our Dexterity products deliver mixed mode manufacturing capabilities with BOM/formulas, co products, costing, MRP and PO editing, serial/lot, material holds, scheduling, jobs and quality in the Dynamics GP UI.

Manufacturing

DATABASICS, Inc. www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation!

Healthcare

Business Computers Software, Inc. www.business-computers.com • 303-494-9390 Time Matrix Time Clock that integrates with Dynamics GP PR, HR, PA, & Manufacturing. ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikExpense KwikExpense automates expense reporting with digital receipt capture, instant expense report creation and automatic approval routing, with corporate credit card reconciliation included! ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikPayables KwikPayables automates the accounts payable process with centralized invoice workflows for GL coding, approval routing and transaction creation in GP or SL, with complete digital audit trail.

Sierra Workforce Solutions www.sierraws.com • 800-822-0973 Sierra Workforce Solutions Dynamics ERP time & attendance solutions optimizing productivity and data integration for payroll, job costing & HR. Advanced scheduling and ACA reporting options. Biometric, badge, WEB, PC or mobile time clocks.

KEY:

D365 Customer Engagement/CRM

ASC Software www.ASCsoftware.com • 937-429-1428 ASCTracŽ Top Award winning, enterprise manufacturing software designed for all types of Manufacturing, Distribution, & 3PL operations of any size. (MES, MRP, WMS, WCS, IIoT, Shop Floor & more.) 29+ years of successes.

Business Computers Software, Inc. www.business-computers.com • 303-494-9390 Time Matrix Time Clock that integrates with Dynamics GP PR, HR, PA, & Manufacturing.

Data Masons Software www.datamasons.com/thelist • 866-575-1631 Vantage Point EDI for Dynamics EDI compliance without ERP customization. That’s EDI made simple.

DocStar www.docstar.com • 888-DOC-STAR DocStar ECM AP Automation Integrated content and process automation for Dynamics AX, GP, SL & NAV. Specializing in AP, AR, Sales Order & Contract workflow processes.

FASCOR www.fascor.com • 888-8FASCOR (888-832-7267) ext. 103 FASCOR WMS Scalable WMS Tier1 functionality for SMB market. Adv order mgmt., user configurable dashboards, integrated TMS, voice picking & more, deliver rapid ROI for Dist, Warehouse & Mfg operations. Serving MS Dyn for 17 yrs.

Dynamics AX

Dynamics GP

ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikTag KwikTag is the ONE SYSTEM you need for document management with extensive Dynamics integration - go live in less than 1 week. ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikPayables KwikPayables automates the accounts payable process with centralized invoice workflows for GL coding, approval routing and transaction creation in GP or SL, with complete digital audit trail.

Manufacturing Resource Partners www.mrpconsulting.com • 562-547-6156 Dynamics GP Manufacturing Consulting The Dynamics GP implementation team at Manufacturing Resource Partners is one of the most experienced available. Each of our consultants has 12 to 24 years of manufacturing and operations management experience.

Vicinity www.vicinitysoftware.com 770-421-2467 Vicinity Vicinity’s ERP software manages formulation, quality control, compliance, production and planning for process manufacturers in the Food/Beverage, Chemical, Cosmetic, Paint, Personal Care and Pharmaceutical industries.

WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 Manufacturing PowerPack A suite of enhancements for GP Manufacturing. Tighter integration and added functionality between GP Core Modules and Manufacturing. WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 MO Generator MO Gen integrates external Mfg systems into GP Mfg. Creates, schedules, and releases MO's. Builds pick lists and receives and posts MO receipts.

Non-Profit Organizations

DATABASICS, Inc.

Sierra Workforce Solutions www.sierraws.com • 800-822-0973 Sierra Workforce Solutions Dynamics ERP time & attendance solutions optimizing productivity and data integration for payroll, job costing & HR. Advanced scheduling and ACA reporting options. Biometric, badge, WEB, PC or mobile time clocks. StockIQ Technologies www.stockiqtech.com • 720-420-7946 Intelligent Supply Chain Planning Inventory planning & analytics, forecasting, promotion planning & multi-site replenishment designed for Distribution, and Manufacturing.

Dynamics NAV

D365 Unified Operations/AX

www.truecommerce.com • 888-430-4489 TrueCommerce Scalable & affordable EDI solutions for Microsoft Dynamics. A managed service approach, from one trusted source, helps lower your fulfillment & procurement costs & connects you to an expansive global trading network.

Dynamics SL D365 Business Central/NAV

Dynamics CRM

www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation! ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikExpense KwikExpense automates expense reporting with digital receipt capture, instant expense report creation and automatic approval routing, with corporate credit card reconciliation included!

Online Trial Available

Mobile Enabled

H1 2019

65

INDUSTRY

Vicinity www.vicinityfood.com • 770-421-2467 Vicinity Vicinity’s ERP software manages formulation, quality control, compliance, production and planning for process manufacturers in the Food/Beverage, Chemical, Cosmetic, Paint, Personal Care and Pharmaceutical industries.


Oil and Gas

INDUSTRY

DATABASICS, Inc. www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation!

ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikPayables KwikPayables automates the accounts payable process with centralized invoice workflows for GL coding, approval routing and transaction creation in GP or SL, with complete digital audit trail.

Retail

Pharmaceuticals ASC Software www.ASCsoftware.com • 937-429-1428 ASCTracŽ Top Award winning, FDA approved software designed for GMP-FDA Manufacturing, Distribution & 3PLs of any type or size. 29+ years of success in the Pharmaceutical industry. (MES/MRP, WMS/QC/QA, IIoT, clean room & more)

DiCentral www.dicentral.com • 281-480-1121 EDI Integration with Microsoft Dynamics DiCentral is the industry leader in providing managed EDI solutions for Dynamics 365 Business Central and Finance and Operations, NAV, and GP.

Software Manufacturers

Horizons International www.qualityessentialssuite.com 866-949-9504 ext. 811 Quality Essentials Suite Quality Management System integrates to all Dynamics products. Used in chemicals, food and other regulated industries. Control layouts for certificates of analysis, comply with ISO standards, manage lot holds.

Next Generation Logistics, Inc. www.DynamicsTMS.com 847-963-0007 ext. 136 DynamicsTMSÂŽ Transportation Management System LTL, FTL, Multi-stop Routing. Rate Shop, Tariff Mgmt, Load Tendering, Posting, and Bidding. Track and Trace, Freight Audit, and Reporting.

Selective Software Inc www.selectivesoftware.com • 421-369-0480 In Transit Software Integrated solutions for Trucking: Loads, Driver/Carrier Pay, Freight Billing, EDI, Dispatch, Imaging, Maintenance & Repair, Fuel Integration, Road Taxes. Reporting & more. Asset-Based & Brokerage.

Warehouse Management

FASCOR www.fascor.com • 888-8FASCOR (888-832-7267) ext. 103 FASCOR WMS Scalable WMS Tier1 functionality for SMB market. Adv order mgmt., user configurable dashboards, integrated TMS, voice picking & more, deliver rapid ROI for Dist, Warehouse & Mfg operations. Serving MS Dyn for 17 yrs. Panatrack, Inc. www.panatrack.com • 262-361-4950 PanatrackerGP for Inventory Management Add an integrated bar code solution and turn GP into your WMS for inventory management. An easy to install solution with robust features.

Wholesale Trade: Durable Goods TrueCommerce

Yooz, Inc.

Professional Services

www.GetYooz.com 832-384-YOOZ (9669) NEW: Cloud based P2P Automation with award winning Yooz, Inc. Secure cloud-based invoice and payment processing solution. Easy. Powerful. Smart

DATABASICS, Inc.

Transportation / TMS

www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation!

FASCOR www.fascor.com • 888-8FASCOR; (888-832-7267) ext. 103 FASCOR TMS 3.X PARCEL/LTL/TL. Int'l & Domestic. Carrier Cert. UPS, FedEx, USPS & more. HazMat, ASN/EDI, RateShopping, Cartonization, Tariff mgmt, Adv Analytics

ASC Software www.ASCsoftware.com • 937-429-1428 ASCTracŽ Top Award winning, enterprise supply chain software for Distribution, Manufacturing & 3PL operations of any type or size. 29+ years of advanced WMS innovations. (WMS, MES, MRP, WCS, IIoT, Shop Floor & more).

www.truecommerce.com • 888-430-4489 TrueCommerce Scalable & affordable EDI solutions for Microsoft Dynamics. A managed service approach, from one trusted source, helps lower your fulfillment & procurement costs & connects you to an expansive global trading network.

Learn why Je rey with StockIQ Technologies likes The List: The Partner featured for the ISV Partner Profile is randomly selected from those Partners participating in The List. To learn more about The Listresource contact for Jane@thepartnerchannel.com. “The List is a very valuable both Partners and customers. It is a one stop shop for finding ISVs with deep vertical expertise and solutions, who are committed to helping the Dynamics channel.â€?

Jerey Porter, StockIQ Technologies

KEY:

66

D365 Customer Engagement/CRM

GPUG MAGAZINE

Dynamics AX

Dynamics GP

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Online Trial Available

Mobile Enabled


Horizontal Accounting

Affordable Care Act Reporting

ACOM Solutions, Inc. acom.com/electronic-payments/ 866-730-9248 Paperless AP Payment Automation for Microsoft Dynamics ACOM streamlines how companies process their supplier payments of any type via one intelligent platform gaining better control over cash, higher efficiencies and the ability to earn cash rebate revenue.

Aatrix Software, Inc. partner.aatrix.com/msdynamicsgp 800-426-0854 ext. 175 Aatrix COMPLETE ACA eFile Service Aatrix, the nation's leading single-point eFile center makes complying with ACA reporting requirements simple. The COMPLETE ACA eFile Service will Print & mail employee copies and eFile the IRS as low as 99¢/employee.

Century Business Solutions www.ebizcharge.com/ • 888-500-7798 EBizCharge Payments for Microsoft Dynamics Process credit, debit, and ACH payments in D365, CRM, NAV, GP & AX using the secure payment integration EBizCharge. Unlimited batch history and reports. Online customer bill pay portal, recurring billing, and email pay.

Encore Business Solutions www.encorebusiness.com • 888-898-4330 ePayStub for Canadian Payroll ePaystub for Canadian Payroll is a seamless extension to Microsoft Dynamics GP Canadian Payroll that allows users to email out employee Payslips with an email that is password protected. ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikTag KwikTag is the ONE SYSTEM you need for document management with extensive Dynamics integration - go live in less than 1 week.

Yooz, Inc.

AIM Technologies www.aim-technologies.com/ acadashboard.html • 888-234-0428 The ACA Dashboard Complete solution for proactive management and reporting for compliance with the Affordable Care Act. Integrity Data www.integrity-data.com • 217-732-3737 Comprehensive HR & Payroll Solutions for Dynamics GP Creating great DynamicsŽ GP HR & Payroll experiences by offering solid solutions: reliable software, top-notch support and expert services - making your payroll system work exactly the way you want and need it to! Integrity Data www.integrity-data.com/software/ aca-compliance/ • 888-786-6162 Integrity Data ACA Compliance Solution Making IRS compliance around ACA reporting a non-issue by tracking eligibility year-round and automatically generating, printing and e-filing Form 1095-C/ 1094-C.

Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Project Tracking with Advanced Analytics Creates a seamless connection between a company’s financial transactions & project revenue & expenses. Easily assign project info. from within GP at the time of transaction entry.

Century Business Solutions www.ebizcharge.com/ • 888-500-7798 EBizCharge Payments for Microsoft Dynamics Process credit, debit, and ACH payments in D365, CRM, NAV, GP & AX using the secure payment integration EBizCharge. Unlimited batch history and reports. Online customer bill pay portal, recurring billing, and email pay.

Budgeting Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Advanced SmartList Enhanced analysis of SmartList data. Ad-hoc reports & queries on the fly. Sort, filter & re-order columns easily. Sum groups of info fast.

Automation ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikPayables KwikPayables automates the accounts payable process with centralized invoice workflows for GL coding, approval routing and transaction creation in GP or SL, with complete digital audit trail.

Yooz, Inc. www.GetYooz.com 832-384-YOOZ (9669) NEW: Cloud based P2P Automation with award winning Yooz, Inc. Secure cloud-based invoice and payment processing solution. Easy. Powerful. Smart

Corporate Renaissance Group crgroup.com/better-budgeting/ 800-576-6215 ext. 286 Budgeting, Planning & Forecasting Solutions from CRGroup Leading budgeting, planning & forecasting solutions for companies of any size: BOARD, Adaptive Insights, and NEW! Rapidstart budgeting for SMBs and Dynamics users. Contact us to learn more + explore partner benefits.

Jet Global www.jetglobal.com • 503-608-3602 Jet Budgets Controlled budgeting built for small and midsized businesses to accelerate and simplify the fiscal planning process without over-inflated or complex tools that take months to implement or require technical resources.

Business Intelligence

Barcode Data Collection Sierra Workforce Solutions www.sierraws.com • 800-822-0973 Sierra Workforce Solutions Dynamics ERP time & attendance solutions optimizing productivity and data integration for payroll, job costing & HR. Advanced scheduling and ACA reporting options. Biometric, badge, WEB, PC or mobile time clocks.

Panatrack, Inc. www.panatrack.com • 262-361-4950 PanatrackerGP for Inventory Management Add an integrated bar code solution and turn GP into your WMS for inventory management. An easy to install solution with robust features.

Flexible Solutions www.GPReportsViewer.com 212-254-4112 ext. 1 GP Reports Viewer Easily & quickly print/email Crystal/SRS/ Excel reports directly from Dynamics GP. Replace existing GP reports, link reports directly to GP and 3rd party windows, pass parameters to reports directly from fields in GP.

www.GetYooz.com • 832-384-YOOZ (9669) NEW: Cloud based P2P Automation with award winning Yooz, Inc. Secure cloud-based invoice and payment processing solution. Easy. Powerful. Smart

KEY:

D365 Customer Engagement/CRM

Dynamics AX

Dynamics GP

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Online Trial Available

Mobile Enabled

H1 2019

67

HORIZONTAL

Corporate Renaissance Group crgroup.com/aa-tools/ • 800-576-6215 ext. 286 CRG AA Tools | Analytical Accounting Simplify the management of GP Analytical Accounting: AA Backfiller, AA Changer, AA Segment Converter & AA Cubes. Backfill data in AA, change AA codes, convert GL segments to AA dimensions & complete analytics.

Billing

Analytics


Integrated Software, Inc. www.isiusa.com • 321-984-1986 Credit Card Authorization A Token-based system to handle all your credit card processing needs. Seamlessly integrated with Sales Order Processing and Cash Receipts. Choose to integrate with Cybersource or Verifone.

Compliance

Halo BI www.halobi.com • 888-300-0219 Halo BI Analytics and BI platform for self-service supply chain planning and data discovery. Enterprise scaled, rapidly implemented, data secured. Analyze, decide and plan faster than ever before. See demo live on halobi.com

Jet Global www.jetglobal.com • 503-608-3602 Jet Analytics Corporate analytics and reporting that brings all of your data together in one place to enable everyone in the organization to easily perform sophisticated business analysis in Excel, Power BI, and on the web.

HORIZONTAL

Business Process Management DocStar www.docstar.com • 888-DOC-STAR DocStar ECM AP Automation Integrated content and process automation for Dynamics AX, GP, SL & NAV. Specializing in AP, AR, Sales Order & Contract workflow processes. JAT Computer Consulting, Inc. www.jatnet.com/JBC.htm 888-525-8874 ext. 462 JAT Benefits Connect (JBC) JBC communicates enrollment data to carriers and insurance providers.

Check Printing

ACOM Solutions, Inc. www.acom.com • 866-730-9248 Paperless AP Payment Automation for Microsoft Dynamics ACOM streamlines how companies process their supplier payments of any type via one intelligent platform gaining better control over cash and higher efficiencies with bank-level security to meet compliance. Integrity Data www.integrity-data.com/software/ aca-compliance/ • 888-786-6162 Integrity Data ACA Compliance Solution Making IRS compliance around ACA reporting a non-issue by tracking eligibility year-round and automatically generating, printing and e-filing Form 1095-C/ 1094-C.

Cost Accounting Corporate Renaissance Group crgroup.com/Cost-Allocator/ • 800-576-6215 CRG Cost Allocator | Multi-Level Step-Down Cost Allocations Perform multi-level account allocations using 1 of 4 methods: percentage values, fixed amounts, cost drivers/measures, or account balance. Integrates with Dynamics, other ERP solutions or as a stand-alone system.

Credit Card/Check Processing

ACOM Solutions, Inc. Trans-Micro, Inc. www.checkfactory.com • 800-749-2335 Check Factory Visual Series v5 for Dynamics GP and SL MICR check and forms printing software solution with automatic signatures on checks. Designed to replace the need to purchase pre-printed checks and forms. Check Factory works inside Dynamics GP and SL.

acom.com/electronic-payments/ 866-730-9248 Paperless AP Payment Automation for Microsoft Dynamics ACOM streamlines how you process supplier payments of any type via one intelligent platform- Cards, checks, ACH, EFT and more - gaining better control, higher efficiency & you earn rebate revenue too!

Century Business Solutions www.ebizcharge.com/ • 888-500-7798 EBizCharge Payments for Microsoft Dynamics Process credit, debit, and ACH payments in D365, CRM, NAV, GP & AX using the secure payment integration EBizCharge. Unlimited batch history and reports. Online customer bill pay portal, recurring billing, and email pay.

KEY:

68

D365 Customer Engagement/CRM

GPUG MAGAZINE

Dynamics AX

Dynamics GP

Nodus Technologies, Inc. www.nodus.com/solutions/payment-processing/ 909-482-4701 Credit Card Advantage and CRM Charge with PayFabric Securely process credit cards and ACH within Dynamics GP or CRM and store credit card info in a PCI-certified cloud using PayFabric. Includes batch processing & reporting tools. Optional AutoPay and customer portal.

Data Integration Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Project Tracking with Advanced Analytics Creates a seamless connection between a company’s financial transactions & project revenue & expenses. Easily assign project info. from within GP at the time of transaction entry.

Winthrop Development Consultants www.winthropdc.com/products_BPST.htm +61893329446 Batch Posting Service Toolkit Post batches into Dynamics GP from external applications, in real-time, with a single web service call ... without using Dexterity.

Data Management Corporate Renaissance Group crgroup.com/changer/ • 800-576-6215 ext. 286 CRG Changer | Change, Merge & Combine Codes & Data in GP Quickly & easily change, merge & combine your codes & data in GP. Changer is trusted by thousands of organizations, supports 3rd party tables & is completely flexible - ensuring GP operates at optimum efficiency.

Jet Global www.jetglobal.com • 503-608-3602 Jet Global Jet Global delivers complete data access and control from Microsoft Dynamics so users can make decisions at the speed of business without the need for bottlenecked technical resources or data expertise.

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Distribution

Absolute Value www.absolutevalue-us.com • 678-905-1204 POS Data Analytics Improve key retail customer sales & relationships using EDI 852 data in the cloud. Understand stores positions, analyze sales, receive actionable alerts. Use with/without Lanham EDI or Demand Planning.

ASC Software www.ASCsoftware.com • 937-429-1428 ASCTracŽ Top Award winning, enterprise supply chain software for Distribution, Manufacturing & 3PL operations of any type or size. 29+ years of advanced innovations. (WMS, MES, MRP, WCS, IIoT, Shop Floor & more). FASCOR www.fascor.com • 888-8FASCOR (888-832-7267) ext. 103 FASCOR WMS Scalable WMS Tier1 functionality for SMB market. Adv order mgmt., user configurable dashboards, integrated TMS, voice picking & more, deliver rapid ROI for Dist, Warehouse & Mfg operations. Serving MS Dyn for 17 yrs.

Slimstock www.slimstock.com • 970-420-1777 Slim4 Inventory Optimization for Dynamics Forecasting, supply planning, and inventory optimization for distributors, manufacturers, 3PLs, and retailers.

StockIQ Technologies www.stockiqtech.com • 720-420-7946 Intelligent Supply Chain Planning Inventory planning & analytics, forecasting, promotion planning & multi-site replenishment designed for Distribution, and Manufacturing. WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 Dynamics GP PowerPack Over 80 Enhancements to GP, based upon customer requests. Enhances virtually every part of the GP System. Make GP more intuitive, easier to use!

Online Trial Available

Mobile Enabled


Field Service Management

Document Management TrueCommerce DocStar www.docstar.com • 888-DOC-STAR DocStar ECM AP Automation Integrated content and process automation for Dynamics AX, GP, SL & NAV. Specializing in AP, AR, Sales Order & Contract workflow processes.

ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikTag KwikTag is the ONE SYSTEM you need for document management with extensive Dynamics integration - go live in less than 1 week.

Nodus Technologies, Inc. www.nodus.com/solutions/e-commerce/ 909-482-4701 eStore Solution Stack with PayFabric Go beyond a shopping cart with a feature-rich, automated and fully integrated ecommerce solution. Securely take orders from our PCI certified B2B, B2C, and sales portal web site with attractive responsive web design.

www.truecommerce.com • 888-430-4489 TrueCommerce Scalable & affordable EDI solutions for Microsoft Dynamics. A managed service approach, from one trusted source, helps lower your fulfillment & procurement costs & connects you to an expansive global trading network.

Expense Solutions

DATABASICS, Inc.

www.sana-commerce.com • 646-362-0432 Sana Commerce Through 100% seamless integration, our e-commerce solution leverages existing ERP business logic and data in powerful, user-friendly web stores.

www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation!

Winthrop Development Consultants www.winthropdc.com/products_BPST.htm +61893329446 Batch Posting Service Toolkit Post batches into Dynamics GP from external applications, in real-time, with a single web service call ... without using Dexterity.

ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikExpense KwikExpense automates expense reporting with digital receipt capture, instant expense report creation and automatic approval routing, with corporate credit card reconciliation included!

Avalara, Inc.

Century Business Solutions www.ebizcharge.com/ • 888-500-7798 EBizCharge Payments for Microsoft Dynamics Process credit, debit, and ACH payments in D365, CRM, NAV, GP & AX using the secure payment integration EBizCharge. Unlimited batch history and reports. Online customer bill pay portal, recurring billing, and email pay.

KEY:

D365 Customer Engagement/CRM

Data Masons Software www.datamasons.com/thelist • 866-575-1631 Vantage Point EDI for Dynamics EDI compliance without ERP customization. That’s EDI made simple.

DiCentral www.dicentral.com • 281-480-1121 EDI Integration with Microsoft Dynamics DiCentral is the industry leader in providing managed EDI solutions for Dynamics 365 Business Central and Finance and Operations, NAV, and GP.

Dynamics AX

Dynamics GP

Joesoftware Inc. www.joesoftware.com • 780-990-0220 Spencer Easy, configurable, web-based expense tracking system. Seamlessly drive Payables or Project Accounting. Credit card integration, workflow, multi-currency, VAT support, electronic receipts and more.

Paramount WorkPlace ParamountWorkPlace.com/solutions/ travel-and-expense/ • 800-725-4408 Paramount WorkPlace Expense Mobile App & Entry & Approvals, OCR, Google Maps, Receipt Attachment, Rule Engine, Credit Card & Banking Integration, Real-Time Cash Advances, On-Account Balance, Expense Split, GL Distribution, Open Payment Sunshine

Dynamics NAV

D365 Unified Operations/AX

wsTOOLS www.iscorp.biz/solutions/wstools/ 218-486-5095 wsTOOLS for KEY2ACT Enhancements for GP, KEY2ACT Jobcost, Service Management and MobileTech.

Fixed Assets

EDI

www.info.avalara.com/TheList • 877-780-4848 Avalara | Tax Compliance Automation Software Avalara helps businesses of all sizes get tax compliance right. Avalara delivers cloud-based compliance solutions for various transaction taxes, including sales and use, VAT, excise, communications, and more.

Shining Brow Software Shiningbrow.com • 414-258-3400 The Service Manager Solution for field service organizations that install, service, and maintain equipment. Track customers, equipment, contract data and service history. Schedule work & integrate your field staff with our Mobile client.

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Panatrack, Inc. www.panatrack.com • 262-361-4950 PanatrackerGP for Fixed Assets Bar Code data capture extending GP Fixed Asset module to manage assets.

General Ledger

Corporate Renaissance Group crgroup.com/re-formatter/ 800-576-6215 ext. 286 CRG Re-Formatter | Modify Your GP Account Framework CRG Re-Formatter is the only tool currently available to help companies quickly & easily modify the account framework of Microsoft Dynamics GP after the initial installation. Corporate Renaissance Group crgroup.com/company-combiner/ 613-232-4295 ext. 286 Company Combiner | Combine Multiple GP Company Databases Trying to manage multiple companies in Dynamics GP? Easily combine company databases into one single entity for easier maintenance, reduced risk, greater efficiencies, and improved reporting with CRG Company Combiner

Online Trial Available

Mobile Enabled

H1 2019

69

HORIZONTAL

E-commerce

www.fieldconnect.com • 949-428-1540 FieldConnect Mobile Workforce Solutions FieldConnect is an end-to-end solution for workforce mobilization. Electronic work orders & timesheets, dispatch software, and customer portals are directly integrated with Microsoft Dynamics for maximum efficiency.

Sana Commerce

Metafile Information Systems, Inc. www.metaviewer.com • 507-286-9232 MetaViewer Paperless Automation for Microsoft Dynamics AP Automation for Dynamics AX, GP, SL & NAV, & expanded functionality including expense reports, journal entry, purchase requisition and more.

FieldConnect, Inc.


Corporate Renaissance Group crgroup.com/aa-tools/ • 800-576-6215 ext. 286 CRG AA Tools | Analytical Accounting Simplify the management of GP Analytical Accounting: AA Backfiller, AA Changer, AA Segment Converter & AA Cubes. Backfill data in AA, change AA codes, convert GL segments to AA dimensions & complete analytics.

HR Management

Aatrix Software, Inc. partner.aatrix.com/msdynamicsgp 800-426-0854 ext. 175 Aatrix COMPLETE ACA eFile Service Aatrix, the nation's leading single-point eFile center makes complying with ACA reporting requirements simple. The COMPLETE ACA eFile Service will Print & mail employee copies and eFile the IRS as low as 99¢/employee.

Payables Enhancement

FASCOR www.fascor.com • 888-8FASCOR (888-832-7267) ext. 103 FASCOR WMS Scalable WMS Tier1 functionality for SMB market. Adv order mgmt., user configurable dashboards, integrated TMS, voice picking & more, deliver rapid ROI for Dist, Warehouse & Mfg operations. Serving MS Dyn for 17 yrs. Panatrack, Inc. www.panatrack.com • 262-361-4950 PanatrackerGP for Inventory Management Add an integrated bar code solution and turn GP into your WMS for inventory management. An easy to install solution with robust features.

Invoicing Enhancement

Century Business Solutions

HORIZONTAL

Corporate Renaissance Group employee-performance.com/ • 877-711-0367 CRG emPerform | Online Employee Performance Management Award-winning employee performance management for Microsoft Dynamics users. Online performance reviews, 360° assessments, goal management, succession planning, pay-for-performance, reporting & year-round feedback. Integrity Data www.integrity-data.com • 217-732-3737 Comprehensive HR & Payroll Solutions for Dynamics GP Creating great DynamicsÂŽ GP HR & Payroll experiences by offering solid solutions: reliable software, top-notch support and expert services - making your payroll system work exactly the way you want and need it to! JAT Computer Consulting, Inc. www.jatnet.com/JBC.htm 888-525-8874 ext. 462 JAT Benefits Connect (JBC) JBC communicates enrollment data to carriers and insurance providers. JAT Computer Consulting, Inc. www.jatnet.com/JPI.htm 888-525-8874 ext. 462 JAT Payroll Interface (JPI) JPI is a bi-directional integration linking GP HRM and ADP payroll.

Inventory Management ASC Software www.ASCsoftware.com • 937-429-1428 ASCTracŽ Top Award winning, enterprise supply chain software for Distribution, Manufacturing & 3PL operations of any type or size. 29+ years of advanced innovations. (WMS, MES, MRP, WCS, IIoT, Shop Floor & more).

KEY:

70

D365 Customer Engagement/CRM

GPUG MAGAZINE

www.ebizcharge.com/ • 888-500-7798 EBizCharge Payments for Microsoft Dynamics Process credit, debit, and ACH payments in D365, CRM, NAV, GP & AX using the secure payment integration EBizCharge. Unlimited batch history and reports. Online customer bill pay portal, recurring billing, and email pay.

Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Subscription Billing (formerly called Recurring Contract Billing) Automates & manages cyclical & subscription based billings by generating invoices, quotes or orders in GP SOP based on the billing date & billing frequency assigned to the customer contract line item.

Nodus Technologies, Inc.

Yooz, Inc. www.GetYooz.com • 832-384-YOOZ (9669) NEW: Cloud based P2P Automation with award winning Yooz, Inc. Secure cloud-based invoice and payment processing solution. Easy. Powerful. Smart

Job Costing

Sierra Workforce Solutions www.sierraws.com • 800-822-0973 Sierra Workforce Solutions Dynamics ERP time & attendance solutions optimizing productivity and data integration for payroll, job costing & HR. Advanced scheduling and ACA reporting options. Biometric, badge, WEB, PC or mobile time clocks.

Manufacturing Enhancement

WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 Manufacturing PowerPack A suite of enhancements for GP Manufacturing. Tighter integration and added functionality between GP Core Modules and Manufacturing. WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 MO Generator MO Gen integrates external Mfg systems into GP Mfg. Creates, schedules, and releases MO's. Builds pick lists and receives and posts MO receipts.

Multi-Entity Management Corporate Renaissance Group crgroup.com/company-combiner/ 613-232-4295 ext. 286 Company Combiner | Combine Multiple GP Company Databases Trying to manage multiple companies in Dynamics GP? Easily combine company databases into one single entity for easier maintenance, reduced risk, greater efficiencies, and improved reporting with CRG Company Combiner

www.nodus.com/solutions/online-bill-pay/ 909-482-4701 ePay Advantage with PayFabric A web-based customer payment portal that automates A/R, improves cash flow, and provides security and convenience to you and your customers. Optional recurring/subscription billing, AutoPay, and payment plan modules

Dynamics AX

Dynamics GP

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

ACOM Solutions, Inc. acom.com/electronic-payments/ 866-730-9248 Paperless AP Payment Automation for Microsoft Dynamics ACOM streamlines how companies process their supplier payments of any type via one intelligent platform gaining better control over cash, higher efficiencies and the ability to earn cash rebate revenue.

ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikPayables KwikPayables automates the accounts payable process with centralized invoice workflows for GL coding, approval routing and transaction creation in GP or SL, with complete digital audit trail.

Trans-Micro, Inc. www.checkfactory.com • 800-749-2335 Check Factory Visual Series v5 for Dynamics GP and SL MICR check and forms printing software solution with automatic signatures on checks. Designed to replace the need to purchase pre-printed checks and forms. Check Factory works inside Dynamics GP and SL.

Payroll Enhancement

Aatrix Software, Inc. www.aatrix.com/dynamics 800-426-0854 ext. 175 Aatrix State and Federal Payroll Reports Complete eFiling and plain paper printing W-2 & 1099 solution. Unemployment, withholding, & new hire reports for all 50 states are completed automatically from your Microsoft Dynamics GP payroll data ready to eFile. Integrity Data www.integrity-data.com • 217-732-3737 Comprehensive HR & Payroll Solutions for Dynamics GP Creating great DynamicsŽ GP HR & Payroll experiences by offering solid solutions: reliable software, top-notch support and expert services - making your payroll system work exactly the way you want and need it to!

Online Trial Available

Mobile Enabled


Integrity Data www.integrity-data.com/software/ aca-compliance/ • 888-786-6162 Integrity Data ACA Compliance Solution Making IRS compliance around ACA reporting a non-issue by tracking eligibility year-round and automatically generating, printing and e-filing Form 1095-C/ 1094-C. JAT Computer Consulting, Inc. www.jatnet.com/JPI.htm 888-525-8874 ext. 462 JAT Payroll Interface (JPI) JPI is a bi-directional integration linking GP HRM and ADP payroll. Joesoftware Inc. www.joesoftware.com • 780-990-0220 Payroll Toolbox Over 50 add-ons to enhance CDN and US Payroll; multi-batch processing, vacation audit and more.

Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Project Tracking with Advanced Analytics Creates a seamless connection between a company’s financial transactions & project revenue & expenses. Easily assign project info. from within GP at the time of transaction entry.

Purchase Order Processing Enhancement

Metafile Information Systems, Inc.

Procurement Management

WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 Blanket PO Create a Blanket with multiple control lines. Apply spending limits, allowable items, and user security to each Blanket, all with Blanket PO.

Nodus Technologies, Inc. www.nodus.com/solutions/online-bill-pay/ 909-482-4701 ePay Advantage with PayFabric A web-based customer payment portal that automates A/R, improves cash flow, and provides security and convenience to you and your customers. Optional recurring/subscription billing, AutoPay, and payment plan modules.

Reconciliation

Flexible Solutions www.GPReportsViewer.com 212-254-4112 ext. 1 GP Reports Viewer Easily & quickly print/email Crystal/SRS/ Excel reports directly from Dynamics GP. Replace existing GP reports, link reports directly to GP and 3rd party windows, pass parameters to reports directly from fields in GP.

Jet Global www.jetglobal.com • 502-608-3602 Jet Reports Advanced financial and business reporting solution inside of Excel and on the web. Get all the financial and operational reports you need, in the format that works for you, from anywhere.

Sales Order Processing Enhancement Century Business Solutions www.ebizcharge.com/ • 888-500-7798 EBizCharge Payments for Microsoft Dynamics Process credit, debit, and ACH payments in D365, CRM, NAV, GP & AX using the secure payment integration EBizCharge. Unlimited batch history and reports. Online customer bill pay portal, recurring billing, and email pay.

Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Subscription Billing (formerly called Recurring Contract Billing) Automates & manages cyclical & subscription based billings by generating invoices, quotes or orders in GP SOP based on the billing date & billing frequency assigned to the customer contract line item.

Quality Control Paramount WorkPlace www.ParamountWorkPlace.com 800-725-4408 Paramount WorkPlace Requisition & Procurement Mobile App & Entry, PunchOut, Catalog, Check Request, Budget Compliance, RFQ, PO Generation, Receiving, OCR Invoice Matching & Vendor Contract Compliance, Robust Approvals Engine.

Project Accounting

Horizons International www.qualityessentialssuite.com 866-949-9504 ext. 811 Quality Essentials Suite Quality Management System integrates to all Dynamics products. Used in chemicals, food and other regulated industries. Control layouts for certificates of analysis, comply with ISO standards, manage lot holds.

KEY:

D365 Customer Engagement/CRM

Century Business Solutions www.ebizcharge.com/ • 888-500-7798 EBizCharge Payments for Microsoft Dynamics Process credit, debit, and ACH payments in D365, CRM, NAV, GP & AX using the secure payment integration EBizCharge. Unlimited batch history and reports. Online customer bill pay portal, recurring billing, and email pay.

Dynamics AX

Reporting

Flexible Solutions www.GPReportsViewer.com 212-254-4112 ext. 1 GP Reports Viewer Replace SOP and POP documents with Crystal or SSRS reports. Email SOP and POP documents in PDF using all native Dynamics GP setup.

Sales Tax

Avalara, Inc.

Receivables Enhancement

Business Computers Software, Inc. www.business-computers.com • 303-494-9390 Time Matrix Time Clock that integrates with Dynamics GP PR, HR, PA, & Manufacturing.

GPC Systems, Inc. www.easybankrec.com • 208-290-3040 Easy e-Bank Rec Easy e-Bank Rec is a bank reconciliation product for Microsoft Dynamics GP. Eliminate tedious work, save time with automation, have clarity -- and make month-end less stressful.

Dynamics GP

AIM Technologies www.aim-technologies.com • 888-234-0428 Cash Basis Reporting A fully integrated cash basis reporting module that allows real-time reporting on both cash and accrual accounting basis with no additional keystrokes. Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Advanced SmartList Enhanced analysis of SmartList data. Ad-hoc reports & queries on the fly. Sort, filter & re-order columns easily. Sum groups of info fast.

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

www.info.avalara.com/TheList • 877-780-4848 Avalara | Tax Compliance Automation Software Avalara helps businesses of all sizes get tax compliance right. Avalara delivers cloud-based compliance solutions for various transaction taxes, including sales and use, VAT, excise, communications, and more.

Online Trial Available

Mobile Enabled

H1 2019

71

HORIZONTAL

wsTOOLS www.iscorp.biz/solutions/wstools/ 218-486-5095 wsTOOLS for Dynamics GP PayrollRewind, W2SafetyNet, 1095Importer, WebTimeEntry, PayrollHandoff & other tools have been developed to protect data and make tasks easier.

www.metaviewer.com • 507-286-9232 MetaViewer Paperless Automation for Microsoft Dynamics AP Automation for Dynamics AX, GP, SL & NAV, & expanded functionality including expense reports, journal entry, purchase requisition and more.

Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Subscription Billing (formerly called Recurring Contract Billing) Automates & manages cyclical & subscription based billings by generating invoices, quotes or orders in GP SOP based on the billing date & billing frequency assigned to the customer contract line item.


Sierra Workforce Solutions

Security

Halo BI Winthrop Development Consultants www.winthropdc.com/products_GPPT.htm +61893329446 GP Power Tools The premier tool for Dynamics GP administrators. A must have collection of powerful utilities for administering, supporting & developing for GP.

www.halobi.com • 888-300-0219 Halo BI Analytics and BI platform for self-service supply chain planning and data discovery. Enterprise scaled, rapidly implemented, data secured. Analyze, decide and plan faster than ever before. See demo live on halobi.com

Shipping/Manifesting Slimstock

FASCOR www.fascor.com • 888-8FASCOR; (888-832-7267) ext. 103 FASCOR TMS 3.X PARCEL/LTL/TL. Int'l & Domestic. Carrier Cert. UPS, FedEx, USPS & more. HazMat, ASN/EDI, RateShopping, Cartonization, Tariff mgmt, Adv Analytics

HORIZONTAL

Supply Chain Management

www.slimstock.com • 970-420-1777 Slim4 Inventory Optimization for Dynamics Forecasting, supply planning, and inventory optimization for distributors, manufacturers, 3PLs, and retailers.

www.stockiqtech.com • 720-420-7946 Intelligent Supply Chain Planning Inventory planning & analytics, forecasting, promotion planning & multi-site replenishment designed for Distribution, and Manufacturing.

ASC Software www.ASCsoftware.com • 937-429-1428 ASCTracŽ Top Award winning, enterprise supply chain software for Distribution, Manufacturing & 3PL operations of any type or size. 29+ years of advanced innovations. (WMS, MES, MRP, WCS, IIoT, Shop Floor & more).

www.truecommerce.com • 888-430-4489 TrueCommerce Scalable & affordable EDI solutions for Microsoft Dynamics. A managed service approach, from one trusted source, helps lower your fulfillment & procurement costs & connects you to an expansive global trading network.

Winthrop Development Consultants www.winthropdc.com/products_GPPT.htm +61893329446 GP Power Tools The premier tool for Dynamics GP administrators. A must have collection of powerful utilities for administering, supporting & developing for GP.

Avalara, Inc. www.info.avalara.com/TheList • 877-780-4848 Avalara | Tax Compliance Automation Software Avalara helps businesses of all sizes get tax compliance right. Avalara delivers cloud-based compliance solutions for various transaction taxes, including sales and use, VAT, excise, communications, and more.

KEY:

72

D365 Customer Engagement/CRM

GPUG MAGAZINE

DATABASICS, Inc. www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation! ImageTag, Inc. www.kwiktag.com • 888-KWIK-TAG KwikExpense KwikExpense automates expense reporting with digital receipt capture, instant expense report creation and automatic approval routing, with corporate credit card reconciliation included!

Workflow / Notifications

Time and Attendance

Business Computers Software, Inc. www.business-computers.com • 303-494-9390 Time Matrix Time Clock that integrates with Dynamics GP PR, HR, PA, & Manufacturing.

Metafile Information Systems, Inc.

System Enhancement Encore Business Solutions www.encorebusiness.com 888-898-4330 ext. 2336 Advanced SmartList Enhanced analysis of SmartList data. Ad-hoc reports & queries on the fly. Sort, filter & re-order columns easily. Sum groups of info fast.

Data Masons Software

FASCOR www.fascor.com • 888-8FASCOR (888-832-7267) ext. 103 FASCOR WMS Scalable WMS Tier1 functionality for SMB market. Adv order mgmt., user configurable dashboards, integrated TMS, voice picking & more, deliver rapid ROI for Dist, Warehouse & Mfg operations. Serving MS Dyn for 17 yrs.

Travel Expense Management

DocStar www.docstar.com • 888-DOC-STAR DocStar ECM AP Automation Integrated content and process automation for Dynamics AX, GP, SL & NAV. Specializing in AP, AR, Sales Order & Contract workflow processes.

DATABASICS, Inc.

www.datamasons.com/thelist • 866-575-1631 Vantage Point EDI for Dynamics EDI compliance without ERP customization. That’s EDI made simple.

www.sierraws.com • 800-822-0973 Sierra Workforce Solutions Dynamics ERP time & attendance solutions optimizing productivity and data integration for payroll, job costing & HR. Advanced scheduling and ACA reporting options. Biometric, badge, WEB, PC or mobile time clocks.

System and Network Management

Tax

StockIQ Technologies

TrueCommerce Absolute Value www.absolutevalue-us.com • 678-905-1204 POS Data Analytics Improve key retail customer sales & relationships using EDI 852 data in the cloud. Understand stores positions, analyze sales, receive actionable alerts. Use with/without Lanham EDI or Demand Planning.

Winthrop Development Consultants www.winthropdc.com/products_GPPT.htm +61893329446 GP Power Tools The premier tool for Dynamics GP administrators. A must have collection of powerful utilities for administering, supporting & developing for GP.

WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 1 Dynamics GP PowerPack Over 80 Enhancements to GP, based upon customer requests. Enhances virtually every part of the GP System. Make GP more intuitive, easier to use!

www.metaviewer.com • 507-286-9232 MetaViewer Paperless Automation for Microsoft Dynamics AP Automation for Dynamics AX, GP, SL & NAV, & expanded functionality including expense reports, journal entry, purchase requisition and more.

www.data-basics.com • 800-599-0434 DATABASICS Timesheets and Expense Reports DATABASICS makes Time Collection and Expense Reporting Easy and Mobile. Let us solve your toughest challenges related to projects, billing, leave, compliance and automation! Joesoftware Inc. www.joesoftware.com • 780-990-0220 Penny Web-based timesheets, employee/ manager self-service for CDN payroll.

Dynamics AX

Dynamics GP

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Online Trial Available

Mobile Enabled


Services Marketing Planning & Services

Njevity, Inc. www.njevitytogo.com • 720-870-9700 Your Customers, Your Brand, Our Cloud Expertise NjevityToGo, the most trusted Cloud Partner of the Dynamics Community, provides our Partners Exceptional Cloud Experiences. Also, check out our amazing new SaaS offering powered by Azure at www.PowerGPOnline.com.

Cloud Computing

Njevity, Inc. www.njevitytogo.com • 720-870-9700 Your Customers, Your Brand, Our Cloud Expertise NjevityToGo, the most trusted Cloud Partner of the Dynamics Community, provides our Partners Exceptional Cloud Experiences. Also, check out our amazing new SaaS offering powered by Azure at www.PowerGPOnline.com.

Custom Development Implementation Specialists www.iscorp.biz • 218-486-5095 Custom Development 20+ year experience, Dexterity, .NET, SQL, VB, MS Source Code Provider. WilloWare, Inc. www.willoware.com • 888-339-4556 ext. 2 WilloWare Custom Development Fixed bid customization developed to the same high standards as our popular ISV products, including on-line help and detailed documentation.

Dexterity Development DexPros www.dexpros.com • 623-535-9216 Microsoft Dynamics GP Development Experienced Dexterity development of GP enhancements/integrations/ upgrades.

D365 Customer Engagement/CRM

Educational Services Dynamics Connections www.DynamicsConnections.com 218-862-5002 Dynamics Connections Dynamics ISV Education Partners can expand product and service awareness with Dynamics Connections quarterly educational sessions; covering 10 ISVs in 1 hour.

HR & Payroll Implementation & Consulting Integrity Data www.integrity-data.com • 217-732-3737 Comprehensive HR & Payroll Solutions for Microsoft Dynamics GP Creating great DynamicsŽ GP HR & Payroll experiences by offering expert consulting, customizations, implementations and training - making your payroll system work exactly the way you want and need it to.

Manufacturing Implementation & Consulting

Marketing Monarchs

The Partner Marketing Group www.thepartnermarketinggroup.com 734-425-7414 Microsoft Approved Vendor for Dynamics Marketing Consulting From strategic marketing plan development to the critical daily execution, this Microsoft experienced team can help fill your sales pipeline.

www.tornado-marketing.com • 608-520-0772 Marketing Consulting Boost your sales with high-impact marketing & persuasive messaging. Work with industry veteran Adrianne Machina on website, content, & strategy.

Member Organizations ERP Software Blog www.groupbloggers.com • 888-800-0999 ERP Software Blog/ CRM Software Blog Group blog sites for VAR/ISV partners to increase SEO, web traffic, leads

Referral Marketing

www.dabpartners.com • 813-965-1069 DAB Partners Dynamics ISVs rely heavily on referral relationships. DAB Partners offers outsourced services to help you grow and strengthen your referral partner network.

Sales Tax Management Service

Avalara, Inc. www.info.avalara.com/TheList • 877-780-4848 Avalara | Tax Compliance Automation Software Avalara helps businesses of all sizes get tax compliance right. Avalara delivers cloud-based compliance solutions for various transaction taxes, including sales and use, VAT, excise, communications, and more.

Dynamics AX

Dynamics GP

Dynamics NAV

D365 Unified Operations/AX

Training

Tornado Marketing, Inc.

DAB Partners

Manufacturing Resource Partners www.mrpconsulting.com • 562-547-6156 Dynamics GP Manufacturing Consulting The Dynamics GP implementation team at Manufacturing Resource Partners is one of the most experienced available. Each of our consultants has 12 to 24 years of manufacturing and operations management experience.

www.marketingmonarchs.com/ • 617-256-6178 Social Media Services Social Media Marketing bureau that works with partners to: overcome their digital marketing challenges, leverage the power of social platforms, maximize their social footprint, and ultimately drive more leads.

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Training Dynamo, LLC www.trainingdynamo.com • 203-308-5144 Microsoft Dynamics GP: YearEnd Workbook and Workshop Training Dynamo provides workbooks & customized webinar materials to help you and your clients become GP Superheroes! Superpowers will include: X-Ray Vision into GP Data & Super-Speed for Month-End Tasks!

Upgrades Merit Solutions, Inc. www.meritsolutions.com/upgrade-me/ 630-614-7133 Upgrade365 Evaluating a move from Dynamics AX to Dynamics 365 for Finance and Operations? Talk to Merit Solutions, the 2018 Microsoft US Partner Award Winner for D365F&O.

Writing/Documentation Services The Partner Marketing Group www.thepartnermarketinggroup.com 734-425-7414 Blogs, Case Studies, Infographics, Websites Use 'content marketing' to build your brand and drive prospects into your sales pipeline.

SERVICES

KEY:

Implementation Specialists www.iscorp.biz • 218-486-5095 Dynamics GP Customizations & Enhancements with Dexterity 20+ years, Dexterity customizations, enhancements, and new apps for GP.

Social Media

Online Trial Available

Mobile Enabled

H1 2019

73


Tired of wandering the expo floor trying to find the solutions you or your customers need? The List now includes Microsoft-focused events so you can easily find the solutions you’re looking for on the expo floor!

2. Identify the Industry/Horizontal/Service need you have (or better yet, use the keyword search)

If you are looking for a specific solution, The List can help you find it!

4. Click on the event icon to see which solutions are at that event’s expo

KEY:

74

1. Bookmark www.thelistmobile.com on your mobile device

D365 Customer Engagement/CRM

GPUG MAGAZINE

Dynamics AX

Dynamics GP

3. Click on the Filter Options (+ button) to see the events

Dynamics NAV

D365 Unified Operations/AX

Dynamics SL D365 Business Central/NAV

Dynamics CRM

Online Trial Available

Mobile Enabled


THE EDGE FOR COMPANIES THAT SELL TO RETAILERS:

POS DATA ANALYTICS

Improve Your Sales and Relationships with Key Retail Customers •

Spot under or overstocked stores weekly at a glance.

Analyze data in the format you prefer (units, dollars, items, category, geography).

Discern new product performance quickly and easily.

Identify sales trends as they are happening.

Anticipate inventory needed, by warehouse, for each retail distribution center.

Select instant notifications of data that is important to you.

Gain access to all of this information without any disruption to your EDI or ERP system. Contact us today! • 678-905-1204 • www.lanhamassoc.com/pos-data-analytics.htm


ONE SYSTEM

AUTOMATE ANY BUSINESS PROCESS

Why Choose KwikTag?

Integrated with MS Dynamics

Access documents from anywhere

Complete audit trail

KwikTag Products KwikTag accelerates your organization’s digital transformation with ONE SYSTEM. Manage any document, in any department, in any process.

KwikPayables for GP

KwikExpense for GP

KwikTag for GP

AP automation helps companies go paperless with automated invoice routing, approval and audit trail

Eliminate paper receipts and expense reports with automated creation, approval and corporate card reconciliation

Capture, find and share any document in a secure, centralized document management system

Payables transactions created in GP

Expense lines mapped to GL codes in GP

Tag, view and search on 75+ GP screens

888.KWIKTAG | kwiktag.com/gpug


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.