Tag: GP

Being a Consultant at KTL and Our Annual User Conference.

In this blog, I wanted to provide a little insight into what it is like to be a Consultant at KTL Solutions and shed a little light on what our user conference is all about from a consulting perspective. I have been working at KTL Solutions as a Senior Business Consultant for a little over three years. In this capacity I have been implementing and supporting Microsoft Dynamics GP, Microsoft Dynamics CRM, and PaperSave along with many third party add-ons. Prior to working at KTL Solutions, I was also implementing and supporting ERP systems for about 20 years.

June 2, 2015

Non for Profit .. What options are there out there for you using Dynamics GP

Fund accounting by definition is an accounting system emphasizing accountability rather than profitability. This is used by non-profit organizations and governments. Most ERP systems are designed to emphasize on profitability not accountability. Dynamics GP has options for this that will assist you in spending less time managing funding and accounting processes and more time on your mission. The modules available in Dynamics GP are interfund accounting, control account management, encumbrance management, commitments, and grant management. Below we will give you the details of each module and how it can help.

May 26, 2015

Why the User Conference?

For the last few months we at KTL Solutions (me in particular) have been promoting our upcoming “Empower the User Conference” a free one-day educational event for Microsoft Dynamics GP, SL, and CRM users. And while it is a great educational event that you have learned about through a number of emails, landing pages, and tweets from KTL there are other benefits to attending this event:

May 11, 2015

Automatically Tracking Use Tax in Dynamics-GP

This topic may have been posted on the internet by someone else but my clients have asked about this many times so I thought I would write a short blog on how to configure USE tax in Dynamics-GP.

April 30, 2015

How To: Modify Dynamics GP with Modifier and Dot Net

For years I have been creating customizations for Microsoft Dynamics GP using a combination of Modifier and VBA. This has always worked well for me in the past with a few quirks and hiccups in VBA from time to time. I have created simple additional fields on screens, complex logic to enhance our customers business and many other types of projects. All of this has worked well, been easy to upgrade to the next GP version and been basically stable code for many years.

March 26, 2015

Microsoft Business Intelligence (BI) Tools Can Jumpstart your BI Initiative

I often get asked about Business Intelligence and related tools, as dashboards and data integration have become so common today, and everyone wants “instant information”. After all, aren’t we all information workers today?

Since my company is a Microsoft Partner, doing Dynamics (GP, SL and CRM) business applications, my first recommendation is to “look close to home”. You may be surprised how much existing BI you already own and are not utilizing if you use Microsoft products. (Dynamics, SQL, SharePoint, Office) The Microsoft BI toolkit is not a lightweight player in the BI market, as you can see from the 2013 Gartner’s Magic Quadrant graphic below.

March 19, 2015

Demystifying The Modification Of Word Templates For GP

Prerequisites:

Once GP has been installed – Install the Microsoft Word Add-In from the GP Installation Disk. This will install the Default Word Templates and will add Template Maintenance and Template Configuration to the Administration >> Reports Window.

March 13, 2015

Project Budgeting and the Questions You Should Ask

Budgets are one of the 3 pillars that hold-up a project and they ensure that there is enough of “it” to support the other 2, viz. scope and time. All three are just as important but for a successful project implementation a smart budget is at its core.

The PMBOK talks about several methods we can use for budgeting but the one that is my favorite and is most accurate is “bottom-up estimating”. When using this method we break down each task into a smaller component and such a component can be assigned anywhere from 8-16 hours to complete. We then work our way up into estimates of higher-level deliverables.

March 11, 2015

4 Ways to Maximize excel based budgeting in GP

Do you report actual to budget variance and always have a difficult time getting your budget into GP? Below are some suggestions on how to best use excel based budgeting within GP. There are options for users who have budget workbooks outside of GP and just need to load the data as well as users that are just starting the budgeting process and how to build templates and get historical data out of GP for budgeting.

March 5, 2015

Why are my GL Cash Account Balance & Checkbook Balance Different?

In this blog, I wanted to address the variety of factors that may lead to your Checkbook balance and General Ledger Balance differing. Some vital information that should be collected to evaluate why the balances are different are:

What is the difference between the General Ledger Cash Account and the Checkbook balance?
When did the balances between the General Ledger and the Checkbook last match?
Are there any un-posted General Ledger batches?
Are there any Cash Receipts not deposited?
What are the results from the Reconcile to GL function in GP: Microsoft Dynamics GP – Tools – Routines – Financial – Reconcile to GL

February 27, 2015