Tips, Tricks & Thoughts on Microsoft Dynamics GP

Welcome to my website! My name is Jen Kuntz & I have created this blog to share some of what I've learned over the years! What you'll find are tips, tricks & various thoughts related to using or implementing Microsoft Dynamics GP & other related products.

Jul
28
2016

Year End Close & the Inactive Account Myth

This was a blog I was planning on writing earlier this year but the topic had slipped my mind. Earlier today I was browsing the forums at GPUG and one thread reminded me of this topic so I figured today’s a good time to get this post written while it’s fresh in my mind.

Jul
13
2016

Cool Excel Tip: Dates without holidays included

Have you ever wanted to put a schedule together in Excel with planned dates for something over a period of time, and then manually reviewed the formula, to change dates so they didn’t fall on a holiday?

A client of mine prepares a billing schedule a year in advance where they have to incorporate certain specific holding periods and factor in different holidays of both themselves and their service providers (mostly the same holidays but some different). For example, their data is read by a third party service and it takes so many business days after a scheduled read date to get the data back for billing; then they have a window of so many business days to finish and post the billing cycle etc. All these dates are based on a start date and a factor of so many days – business working days – but excluding holidays.

Jul
12
2016

CanPay ROE Issue with postal code

If you are a client using Dynamics GP Canadian Payroll, and use GP’s ROE functionality, this may be of use to you.

If you didn’t need the mid-year 2016 tax update, and only installed the year end 2015 tax update, there were a number of fixes in the ROE (Record of Employment) functions in a January hotfix that you may not have noticed or installed.

A client of mine showed me one issue and I’ve verified with Microsoft that is it one of the fixes in the January hotfix. The specific issue is when creating an ROE, the postal code isn’t being populated in the right box on the ROE window, and it’s a required field.

Jun
28
2016

Looking for special characters in SQL

Recently, a client was starting a SafePay & EFT implementation for Dynamics GP and one of the requirements of the bank was that the vendors cannot have any special characters outside of a handful of “regular” special characters. Their specifications and instructions had a list of acceptable characters and a longer list of unacceptable characters.

Jun
14
2016

Transaction vs. Batch Posting

I was working with a new Dynamics GP user recently, and one of the issues that they asked me about was an error they received when they tried to post a cash receipt transaction.

Jun
07
2016

Canadian Payroll 2016 Mid-Year Update

Guess what? It’s almost halfway through 2016! Wow, where did the time go?

For Microsoft Dynamics GP users with Canadian Payroll, that means it might be tax update time for you again as typically there are semi-annual tax changes. Most years, only a handful of provinces have tax changes so many customers can evaluate for themselves if this particular year would affect their employees or not.

Keep in mind, the tax updates are not “just” tax updates – they are full fledged service packs and often will also contain fixes for other modules. What does that mean?

  • Even if you are not a Canadian Payroll module user, you may want to install this service pack if it contains a fix for an issue that affects your environment.
  • If you are a Canadian Payroll module user, and you don’t have employees in the jurisdictions indicated in the updates, you can typically skip this update (assuming you don’t have a need for any of the other fixes). The updates are always cumulative so the next update will also contain these mid year changes if you skip this update.
Jun
05
2016

More Azure – Part 3

I made the rookie mistake of forgetting I left my VM on earlier this week and now I’m out of credits and have to wait another few days to use it again. Draaaaaag!

Prior to that I had taken some screen shots to demonstrate how to find and use some settings around IP addresses and DNS names. Some of these things have changed since I wrote about my Azure experiences around this time last year, so this is an update if you are using the new Resource Manager approach to managing VMs.

By |June 5th, 2016|Azure|0 Comments|
Jun
04
2016

More Azure – Part 2

Last year I wrote about what happens when you forget to turn your machine off. Well, I did it again. The good news is, this time the message is a lot less cryptic!

May
25
2016

GPUG Amplify 2016 – Day 3

Day 3 at Amplify was short and sweet, to enable the travellers to avoid the traffic that the Donald Trump rally might bring, which was scheduled to be at the Anaheim convention center next door! Originally we were supposed to start the day with a 9am breakout session followed by the closing keynote, ending the day at noon-ish. Everything got moved up by an hour, so we could get out of dodge without possible traffic delays.

May
24
2016

GPUG Amplify 2016 – Day 2

The second day at Amplify was a little more streamlined than day 1, with 5 breakout session timeslots and a wide-open evening. 🙂

Here are the sessions I attended and some more GP Live fun!