Blogs

 
Admittedly, the best job in the world is "caretaker of the Islands," "house-sit[ting]' the islands of the Great Barrier Reef for half a year" ( The Best Job in the World (advertising) ). The best job in your company, however, can be yours. And that's due to the power of automation. "It makes my job easier and more efficient," says an accountant at Stellar Solutions. What is it? Automated timesheets and expense reports. What does that have to do with your job? The first word, "automated," is the key here. Input your data. Output: Budgeting insights Freed up time & resources Happier employees Here's the catch--and this is true of anything ...
0 comments
Every year, thousands of conversations take place in the GPUG online communities, at chapter meetings, in virtual programming and at GPUG conferences and events. We are honored to recognize your GPUG community leaders who go above and beyond to share their knowledge and experiences to serve their Dynamics GP peers. The following annual volunteer recognition awards were announced and presented to deserving recipients at GPUG Summit Phoenix: GPUG All Star Awards The highest award given in your GPUG community, the All Star Award recognizes GPUG members who have a passion for Dynamics GP and have made significant contributions of their time and expertise ...
1 comment
Hello Everyone, During our last year end closing we had a issue come up in which we found out that some journal entries had not been rounded to the hundredths place before being uploaded in GP. We had a round time finding all of the little areas in which need to be have fractions of penny changed. Does anyone out there have a script that could possible help us fix this issue? We know this is probably going to happen again and would like to make it a little easier on ourselves this year. Thank you for any advice!
0 comments
When I was upgrading to GP 2018 R2 I received an error.  The error was: “The stored procedure SynchronizeTableData() of form duSQLAccountSynch : 27Pass Through SQL returned the following results: DBMS: 2601, Microsoft Dynamics GP: 0.” I searched online and did not find anything about it for GP 2018.  I did find this article which helped me find the errors one at a time. https://community.dynamics.com/gp/b/dynamicsgp/archive/2015/06/10/draft-known-upgrade-issues-when-upgrading-to-microsoft-dynamics-gp-2015-r2?pi62366=4 Thank you Sarah Purdy for the article! By creating a dexsql.log, you can see what table is causing your problem.  Here is the link on ...
1 comment
Whew, this week is flying by at User Group Summit in Phoenix, Arizona! We’re having a blast learning from peers and experts, sharing knowledge, and making lasting connections that will fuel the year ahead. Additionally, the energy and excitement during the keynote announcing the location for next year’s event was incredible and we want everyone to be a part of it. The much-anticipated location for 2019 is… Orlando, Florida! Don’t miss this premier event by adding User Group Summit, located in Orlando to your 2019 budget. You won’t want to miss it. Before User Group Summit in Phoenix is officially a wrap, we wanted to share some highlights from the ...
2 comments
​ There has been much to do around the Affordable Care Act : from passing the law under President Obama, to trying to repeal the law under President Trump. This has left many people confused as to where we are at now – what is the current status of the ACA? The short answer is: The ACA remained in full force for 2018, especially as it relates to US employers, and for now, remains in effect for 2019 and beyond. Even the individual mandate (requiring individuals to have ACA-compliant health coverage or else pay a penalty) remained in force for 2018 – a surprise to many. The Tax Cuts and Jobs Act (aka the new tax law) touted repealing the health law. However: ...
0 comments
If you missed our Q3 meeting last month, you missed a heck of a time! The get together was jam packed with some great content from our members and partners, followed by a game of Jeopardy with some generous prizes at stake. This was our first time meeting at the Ingleside Hotel in Pewaukee (this would be the old Country Springs Hotel that has been newly remodeled). I think I speak for all of the attendees in saying the venue is beautiful and lunch was quite tasty! After a bit of Chapter business, we jumped into the learning portion with a presentation by @Carol Kossoris about using the Mail Merge functionality of GP Macros. For those of you already utilizing ...
1 comment
The annual user group event, GPUG Summit , will be held in Phoenix, AZ this year! If you are coming to this event, AWESOME!! If not, please consider attending – it’s THE best conference for in person learning, networking and fun!  All things Dynamics GP (GPUG) plus other applications, such as Power BI, Microsoft Flow, and Power Apps! This year I will be presenting on many different topics!  Come join my sessions to learn a TON and have a great time as well! For session descriptions, visit the link below – OR add them to your schedule for the event!  If you see me, be sure to say hello! Shawn's Sessions List Thanks for reading! Shaw
0 comments
WOW where has the time gone?  For me August represented my boys going back to school and also kicked off the busy fundraising season for the elementary school PTA which I’m the Treasurer of.  I do apologize this recap is so overdue but I think you all will understand. I challenge those of you who will be at #GPUGSummit this year to make a new friend and post some fun pictures over lunch as well.  August was a very active month for all the challengers.  Below are some highlights.      Remember to use the hashtags #LunchTimePhoto and #GPUG and you just may be featured in next month’s recap.       GPUG members that have accepted the ...
2 comments
​Come and join the ladies from Explorer Pipeline at GPUG Summit and see how we are utilizing Power BI in our Accounting and Finance world.  Learn how to present your financials with pizazz  and see information and statistics on the spot with a click of a button.  No more boring Excel spreadsheets and pivot tables!!!  Not to mention, we are just a fun group of ladies!!  We hope to meet you and look forward to an amazing Summit in Phoenix!!
0 comments
Attending GPUG Summit Can Open Doors, Minds and Make a Life-Long Impact This week, I was looking through past GPUG Summit attendee surveys and a comment caught my attention: "GPUG is the Dynamics GP Manual...Summit is the real life version!"  If you've ever been to GPUG Summit - you are probably nodding your head and smiling. Think about how active our Open Forum is every day, every minute with questions posted, solutions shared, and strategies developed from a variety of colleagues. Now think of our live webinars and deep-dive Academy classes that you join virtually - and the amount of time-saving tips and practical Dynamics GP knowledge you ...
0 comments
GPUG Summit is Tailor-Made for YOU: Custom Developers If you’re a developer, you have to know the ins and outs of the Dynamics GP system. High level just doesn’t cut it, which is exactly why GPUG Summit has added a developer track to it’s amazing line-up.  You asked for it, and now we're delivering it! Here are just a few examples of how attending GPUG Summit , October 15-18, can help you master your Dynamics GP environment and improve your overall efficiency: o   Steve Mayhue, Senior Developer/DBA at My Florida Regional MLS , has a session that asks, ‘Where Did My Document Attachments Wander Off To?’  Hear directly from an experienced end user ...
0 comments
GPUG Summit is Tailor-Made for YOU: Human Resources and Payroll If you are on the Human Resources (HR) team at your office, check out these three (to start) GPUG Summit sessions available in Phoenix this October 15-18. If gaining a better understanding of HR and Payroll in Dynamics GP is what you seek, we have exactly what you’re looking for… o   Terry Heley, Fargo-based Escalation Engineer and GPUG All*Star , provided HR/P track leadership here via her umpteenth Planning Committee appearance and is presenting four times at GPUG Summit.  Enough said.  You will find no other Dynamics GP event in the world that covers Human Resources & Payroll ...
0 comments
GPUG Summit is Tailor-Made for YOU: Distribution If you’re a Distribution resource working sales, procurement, or directly with inventory at a small or mid-sized business that runs Microsoft Dynamics GP, you’re an end user of the most configurable and flexible ERP solution in the world.  You’re responsible for a lot of tasks and related information, so you need to leverage YOUR financial system and that’s not always easy.  Attending GPUG Summit in Phoenix this October 15-18 is easy, however, and here are just a few examples of how it can help you master your Dynamics GP environment and improve your overall efficiency: o   Jeffrey Porter, ...
0 comments
GPUG Summit is Tailor-Made for YOU: Dynamics GP Manufacturing There is bunch of excitement around this fresh NEW track for GPUG Summit . The array of manufacturing and distribution sessions planned covers everything from basics to setups, linking modules, reports, and more. If you’re a Manufacturing resource, check out these three (to start) GPUG Summit sessions available in Phoenix this October 15-18: o   Aleiha Hanson, IT Manager at Royal Basket Trucks and GPUG Chapter Leader (Milwaukee) , takes manufacturing one step further by linking it to sales faster…the whole idea, after all!  Leverage Aleiha’s Dynamics GP end user manufacturing experience ...
1 comment
GPUG Summit is Tailor-Made for YOU: Executives Did you know that GPUG Summit is tailor-made just for YOU ?  It’s true, regardless of your role.  So, who are YOU ? If you’re an Executive at a small or mid-sized business that runs Microsoft Dynamics GP, the most configurable and flexible ERP solution in the world, you need to make sure Dynamics GP is leveraged in the most efficient ways possible. One way to make that happen is to ensure your employees are trained by industry experts, immersed in the product you use for your financial longevity, and confident in seeking out answers to their everyday problems. The best way to do this is to ...
0 comments
GPUG Summit is Tailor-Made for YOU: New to Dynamics GP If you’re a recent hire at a small or mid-sized business that runs Microsoft Dynamics GP - the most configurable and flexible ERP solution in the world – but you’ve barely worked in the application, it can be an overwhelming and frustrating time. Turning to GPUG and attending GPUG Summit in Phoenix this October 15-18 is the answer to your problems.  Here are just a few examples of how it can specifically help you master your Dynamics GP environment and improve your overall efficiency: o   Barbara Gavron, CPA, Senior Consultant at S2 Technology , has an awesome session on simple SmartLists ...
1 comment
GPUG Summit is Tailor-Made for YOU: Accounting Professionals using Dynamics GP   If you’re on the accounting team at the office, check out these four (to start) GPUG Summit sessions available in Phoenix this October 15-18. If gaining a better understanding of Management Reporter, becoming self-sustaining in system maintenance, or improving productivity in General Ledger, Sales, and Purchasing is on your list of tasks, GPUG Summit has what you need! Read on… o   Amber Bell, Owner of Training Dynamo , will be here to turn you into a #GPSuperhero , just as she has before.  Her fast-paced trip around Dynamics GP is beyond excellent, and as she ...
0 comments
Jo is a peak-performing, action-oriented Microsoft/Advanced Certified GP Professional who sits on both the Dynamics Pro Credentialing Council and Exam Committee and is a Microsoft MVP Nominee .  Jo has taken all the GP Core exams and is excited to share with you her successful experiences. “Why taking the Credentialing Exams was important to me is fairly easy to answer.  Now that Microsoft no longer provides an exam in Dynamics GP it is important to have a standardized measurement of in-depth knowledge of the product to be able to provide to employers and future employers.  My current company does require that its consultants ...
0 comments
GPUG Summit is Tailor-Made for YOU: Dynamics GP Financial Analysts   With 12 session tracks to choose from at this year’s GPUG Summit , the education line-up is NOT one size fits all. There are ample options to choose from and with good planning, the learning experience can be tailor-made for YOU .  Not only do we have entire track dedicated to financials in Dynamics GP, GPUG Summit attendees can venture over to our inaugural Power Summit and attend sessions there at no additional charge .  The opportunity to learn more about the newest technology tools within Microsoft’s Power Platform has never been better. If you are a Microsoft ...
0 comments