New Year’s Resolutions 2013

It’s that time of year again – time for a review of 2012 and noting what to resolve to do in 2013.

I say this every year – time flew by!  As my dad just told me, it seems to fly by faster the older you get.  It certainly does!  Today is December 31st and my sister & I are visiting my dad and his wife, and loving the few relaxing days away from home.  Along with relaxing with family, this is my favourite, if not humbling, part of the new year process: reviewing what I said I would do this year! (more…)

By | 2017-08-13T11:46:29+00:00 December 31st, 2012|Off Topic Articles|0 Comments

Fun with Windows 8

I’ve been using Windows 8 now on my new laptop for about a couple of weeks.  I *love* it!  What baffles me is the sheer volume of blogs and articles I run into that are crapping all over this new operating system… it’s hilarious really.  “How to make windows 8 look like windows 7”??  Are you serious?  Why bother upgrading if you’re going to do that?

Enough of that.  Part of the learning curve has fortunately been handled by reading other users’ experiences and searching out tips and tricks to understand how to get things to work for you.  None of what I’m putting in here is new or revolutionary, but hopefully it helps someone out!

Key note for all of these tips: I am not using a touch device so these tips are 100% for keyboard and mouse users… some might work for touch too, I have no idea! (more…)

By | 2017-08-13T11:46:29+00:00 December 24th, 2012|How To & Tips, Off Topic Articles|0 Comments

Windows 8 install tips and tricks

Time has flown by, as it does tend to do when you are not paying attention!  One minute I’m in Fargo at the Technical Airlift, dropping a perfectly functioning laptop on a hard tile floor (yes, boy, that was fun!), and the next, it’s nearly Christmas and I’m loading Windows 8 on a even more perfectly functioning new laptop. It’s wrapped in bubble wrap to protect it from myself, just so ya know… ; )

When the Windows 8 previews and betas came out, I fully intended to install them on a virtual image or something, and get to know the new features.  So much for that!  The, ahem, fortunate timing of dropping a laptop and having my other functional Dell brick fail to boot led me to a just-in-time-for-Christmas new shiny laptop.  While my American friends were eating Thanksgiving turkey, I was doing some timely Black Friday shopping.  It seems Canadian retailers have adopted the sale weekend much to our price advantage! (more…)

By | 2017-08-13T11:46:29+00:00 December 11th, 2012|How To & Tips, Installation, Off Topic Articles|0 Comments

Catching up after a web hosting issue

Those of you that follow my blog via RSS, you've just received 5 duplicate articles, re-posted today, with the original content and dates.

Earlier this week I was notified that my web hosting account had been hacked.  Of course I had a backup but it turns out it wasn't as recent as I thought.  I couldn't find my most recent one and only could find one from June.

So… thanks to syndication, I was able to view the last 5 articles I posted during the summer since my backup had been taken, and was able to re-create them and get back to where I am today.

Excuse the duplication, and hopefully I will get back to regular blogging soon!

Now if you excuse me, I'm off to do a backup ; )

By | 2017-08-13T11:46:29+00:00 October 25th, 2012|General Stuff, Off Topic Articles|0 Comments

A new season begins…

Yesterday I went golfing, and it was the first day that really had that “autumn turning to winter” feel about it.  It was about 8 degrees Celcius when I teed off, and yes, I froze my backside off in the process.  But the sun came out and gradually I only needed 3 layers to keep warm. ; )  (Such is life in Canada when you want to golf in October!)

October 1st also is a new season business-wise: the new Microsoft partner requirements officially begin.  For my firm, that means I officially do not meet the requirements to be a reseller anymore.  This isn't new, it hasn't “crept up” or caught me off-guard… no, partners have been well aware of the changes for many months now.

Am I disappointed?  Yes and no.  When I started, I was really proud to be a full Microsoft Dynamics GP reselling partner… I had customers who wanted to work with me, and only me, and they switched VARs to demonstrate their committment to my business as I had to theirs over the years.  Little did I know when I started, how difficult it is to be a small fish in a big pond.  Systems are heavily geared towards larger partners, particularly on the business transaction side of things.  I've grown to realize that doing business with firms where I'm such a blip on the radar is not fun, and it's not easy.  If you don't have a partner service plan or credit terms, it just takes a lot of back and forth to get business transactions done unfortunately.

Overall it's been interesting, from a business perspective, dealing with Microsoft and a few third party ISV vendors.  I don't regret my decision to become a reselling partner in the first place… it's had its share of hassles but I've learned a few things.

Focussing on the future…

I've been living and breathing Microsoft Dynamics GP, Great Plains, eEnterprise, whatever you call it, for over 12 years now and losing my “reseller” partner status is not going to affect that.  I've spent FAR too much time with this product to change careers.  For all of my venting at Microsoft or others in terms of doing business with them, their products are great, they are well positioned in the marketplace, and they have a tremedous team of people behind the product many of whom I've met over the years and I know they really care about making GP better.

I'll still be a “consulting” partner which gives me access to everything I've really needed.  Heck, software was 4.6% of my revenue last year – mostly enhancement revenue at that… hardly worth fighting over.  I'm working with a great small GP reseller who is small enough to be a good partner for my firm to work with on the software side of things and large enough that they don't have to constantly worry about meeting new partner requirements.  That will allow me to give my clients a quality combination of two solid firms with years of experience to support them in both software and services over the years.  I'll give up a little on the software revenue side of things but in the end, the winner will be my clients… and at the end of the day, that's the only thing that matters!

By | 2017-08-13T11:46:31+00:00 October 2nd, 2011|News, Off Topic Articles|0 Comments

Kudos to all the regular bloggers out there!

A very short off-topic article. When I first started blogging, I thought weekly posts was a good goal, and it seemed pretty easy to keep up with.  I had a long list of things I wanted to talk about at some point, no shortage of ideas!  I was set!

All was good until I went to the Tech Conference in Fargo in March… then I started writing a blog each day about my experiences.  So much information to talk about, so little time!  Upon returning home I had so many ideas I didn't know where to start, and didn't write much at all.  And then time has quietly slipped by…

I've managed a blog or two a month at most since March, I keep meaning to dig back into the regular articles but one thing or another distracts me!  Ahhh, such is life… my long list of topics is still nearby but lately I just can't seem to find the time to write.

I was already very impressed by the seemingly endless list of Dynamics GP blogs out there and how they all are likely super busy and still finding time to share thoughts and tips.  Now that I am one of those, I am even more impressed by the ones in particular who regularly post articles, seemingly without issue!

So, today I just wanted to say “wow”… I'm not sure how you do it, year 'round, month in, month out, but it's impressive to keep up with the flow of information and blog about it, not to mention keeping up with client needs!

By | 2017-08-13T11:46:31+00:00 August 4th, 2011|Off Topic Articles|0 Comments

Updating my blogs for new search feature

I've been doing some updates to my site recently and one of the most recent is implementing a new “search” feature.

In doing so, unfortunately I have had to update some blogs where I didn't include “excerpts” which may re-send through RSS feed/readers again after all this time.  So, sorry in advance if you follow my blog and your RSS reader starts showing you random old blog articles of mine!  It appears there are only 3 or 4 that I didn't do this on at the time, so it should be relatively painless!


By | 2017-08-13T11:46:31+00:00 July 10th, 2011|Off Topic Articles|0 Comments

Disenchanted with support? I understand your pain!

Is it me or is getting support sometimes like pulling teeth?  I've had a couple of experiences lately which remind me of why I am in this business and why my clients are so appreciative of the way I deal with them and respond to their issues.  The reminder for me is NEVER to let my clients experience this with my firm – no one deserves it and even more importantly no one deserves to pay for the privilege!

Yes, it's time for another small rant…

A client had a payroll issue two weeks ago – one that stumped me and I wanted to get some help with.  Fortunately for me, I don't have to go through this pain very often as experience does wonders in helping you resolve a great many things without needing to get help from partners.

I have a few pet peeves when it comes to support. 

  1. First and foremost, PLEASE communicate with me regularly… call me crazy but I like to know that someone out there is working on my issue, even if they haven't resolved it yet, just remind me occassionally that you are actually thinking about it and doing something about it.  And by regularly, I mean at a minimum every couple of days would be nice…
  2. When you do get around to answering me, or working towards that end goal, please don't insult me by giving me a poorly thought out answer that is clearly obvious and/or already discussed.  This is even more important if you decide to not respond for a week and then give me a non-answer.

The Issue

The client's issue was a simple-enough sounding message “Account Number does not exist”.  They can't post their payroll, Canadian Payroll would not create the poster file.  The error occurred on one person only, on a vacation “taken” paycode, and other people with the same paycode in that payroll all were fine (it found the account).

The Troubleshooting

There are a few moving parts at work with Canadian Payroll in how it posts but relative to other modules, there are really only a handful of things to look at really.  The account number is driving primarily from the paycodes themselves so we checked the Income Paycode and sure enough there was an account number there, and yes, it did exist in the GL.  We checked the GL Account to make sure it wasn't inactive or anything special that would prevent posting to it.  Hmm… the start of the head scratching!

Canadian Payroll also has a “masking” feature to distribute to departments – i.e. each department has a Salary Expense account and the company wants to post payroll to the dept the person worked in.  Fairly standard stuff, that setup is in the Canadian Payroll Control window and this company does not use it anyway.  Tick.  Crossing off things on the mental checklist.

Now I'm losing hair I'm scratching my head so much! (LOL).  The error seems so simple.  I used the Support Debugging Tool to generate some scripts and logging of the error.  It doesn't help but does lead me to look at a third party product, which was referenced with a “

[Not Found]” error of its own.

Asking for Help

This was a payroll issue, fortunately it had no effect on payroll itself nor on getting the employees paid on time.  However they run a weekly payroll and this payroll needs to be posted – Canadian Payroll needs the “Update Masters” procedure to be run or else the next week's pay run's Year To Dates may be incorrect.  THAT would be bad.

First I was going to simply open a support case through my Partnersource account, sending them the documentation I've done on the issue to date and the SDT logs etc. and be on my merry way… not so fast!  Here is the short timeline which 14 days later is yet to be resolved.

  • Two weeks ago I tried to submit a support case.  It's pretty easy really, pick your customer, pick the module, type in some information and submit.  In my case, being a small partner, I don't buy support incidents because I don't use them very often (read: 1 per year would be a lot).  So for me I have to input my credit card information to pay for the case up front.  No big deal, it's part of doing business.  PROBLEM: I get a “you're not authorized” page when I get past picking my customer and the module.  Fortunately for me there's a handy link to “submit this problem to our support team” button… glad they make this easy! (note the sarcasm…)
  • This issue was submitted at night after hours, the next morning there was the auto-reply with a case number etc. – FABULOUS.  I love it!
  • Later the same day, less than 24 hours after submitting, I get an answer: You don't have any support incidents left.  DUH… that is correct, which is why I was trying to create a case with a credit card – something I've done in the past without issue.  I reply re-iterating my issue and the credit card thing.
  • 2 days later (3 days since the original) I have heard nothing and respond again, inquiring about the status of the case.
  • 3 days later (6 days since the original) I get an email where I am copied on the shuffling of my case to some other department and there are several “departments” copied on the email.  Lovely.  Mental note, large companies don't tend to communicate well between departments… losing faith this will get resolved.
  • 1 day later (7 days since the original) Someone who thankfully subscribes to a “regular communication is good” mantra follows up with me to ask me if I have heard back from this new department yet.  I respond.
  • 2 days later (9 days since the original) Someone forwards me the response from this other department.  The message in a nutshell is: we don't have access to this area, we can't fix it, the website is down and someone else needs to deal with this.
  • 2 days later (11 days since the original) I get an email telling me the case is being closed since it is resolved. 

It is now 14 days since the original support case was submitted and I have heard nothing else, nor do I expect to.  I don't know what department is supposed to resolve this, don't know how to get in touch and at this point, figure that by the time I need to do another it may be resolved.

If this was the experience a client received, I would be appalled…

Asking for Help – attempt #2

Avenue #2 was to look at this third party reference in the debugging tool scripts and sql logs.  This particular tool has literally nothing to do with the GL accounts on payroll paycodes but since it was mentioned in the scripts and did only occur on this particular person's records, according to the script results.  Perhaps there is something that is blocking this that they can resolve. 

This particular third party firm I can't submit a support case online so I call them and speak to someone there who I explain the issue to.  She patiently listens and asks me one or two questions and gets my contact information, and the details on the case.  I get an email with a case link that I can now follow online – fabulous!  Love the tools!  I log in and dutifully update the case with the supporting documentation, screen shots, everything I can think of that would help them including the support files that show an error from their product.

After nearly 2 days I update the case with a request for an ETA on when I might be getting a response, not the answer, just a timeline on a possible answer.

7 days later, I get an update with – sorry – a really dumb answer, an “insult to my intelligence” answer that I hope to goodness I am not going to get charged for.  Their response? “The ____ product does not affect the Canadian payroll distributions. We suggest to create the gl account the detail posting report is looking for and post the batch.”  Yikes!  Are you kidding me?  It's beyond stunning to me how a firm that offers support can think that is acceptable.  “Create the account then post the batch”.  DUH… one of the first things we discussed was that the account does already exist.

C'mon man!  *smacking my head in disbelief*

If I get a bill in the mail for this one, whoever answers my call then won't like me very much!

Asking for Help – attempt #3

In the meantime, clearly I continue to have a payroll issue to resolve and I went to the Partner Online Technical Communities to get some “free” help.  It took 2-3 days for someone to respond to my post but when they did, they did help me sort through some other possible areas to check. 

At the end of this all, I resolved it before getting any support from the 3 sources I tried – meaning I created a workaround to be able to post but we still have never resolved why it happened in the first place.  My message to support teams out there: It's payroll people!  That can't wait!  The online tech communities helped me look at things to continue to find a solution but in the end, I was left unsupported by the businesses I am supposedly “partnered” with and that was very frustrating.

The Lesson Learned

Companies get away with providing bad to horrible support every day but in the long run they lose clients because of this.  The unfortunate reality is for larger firms – and they tend to be the ones that offer lower quality support, at least until something is escalated until you get to someone who knows what they are talking about – new customers keep on coming in the door attracted to your shiny sales pitches and promises of grandeur.  Look at our fancy support website!  You can get support at all hours of the day!  Yeah right… it seems more like “you'll have to wade through our junior support people who will give you bad information before you work your way up to someone who can really help”.

I'm a small firm, every lost customer I could potentially have is a major deal.  I treat the clients like that, and so do many other STELLAR small consulting firms out there.  Small isn't always better, you miss out on the cumulative experience of a larger group but what you lose there, you gain in respect, hard work, and dealing with people who actually care about your issue and resolving it.

I do like running into situations like this every once in a while, because it is a reminder of what I strive to do differently in my business and always have in my years of consulting.  Please don't misinterpret this to be anti-Microsoft, what I describe above you will find at EVERY other large firm out there doing ERP business or other things requiring software support.  Unfortunately no one has this market covered when it comes to sub-standard support and there are diamonds in the rough out there in the large firms that do care – it's just hard to find them!

Update 1 (April 4, 2011)

I originally posted this on March 22nd, and I wanted to post an update in the interest of fairness…

Today I received a call from Microsoft – from Crystal, a support team manager who manages the payroll team, after she read this blog post.  I discussed my concerns with her and she will be looking into where the VOICE/website issue is as well as why there hasn't been any communication to me yet on it being resolved (yes, it is still outstanding).  It was fabulous to get a personal call, and I hope that it gets resolved shortly.  I don't actually know if I am the only one affected but it's hard to tell.  As for my client's issue, I haven't yet submitted a support case and explained why to Crystal on the phone… the workaround got the payroll posted and the issue hasn't recurred yet.  The client will test further to reproduce the problem and then we will resume troubleshooting, this time with Microsoft's assistance.

Update 2 (April 19, 2011)

Two updates: .

  • The VOICE/website issue is resolved finally… thank you!
  • The Third Party vendor I tried to get support from in “Attempt #2” billed me… well, it gets worse, they billed MY CLIENT directly for the support case.  Nice!  I'm a pretty reasonable person, I'm not a yell-and-scream-til-I-get-what-I-want person.  BUT, this is ridiculous – answer a question 7 days later, with a lame answer – then bill my client for it?  Seriously, I can't make this sh*t up.  I've voiced my displeasure – and if they insist the charges need to be paid, I WILL pay it, begrudgingly, because that is how I run my business… I don't like how they are running theirs but I'm not going to ruin my reputation on stiffing them or taking a chance that it affects my client somehow down the road when they legitimately need support.

By | 2017-08-13T11:46:31+00:00 March 22nd, 2011|Canadian Payroll, Off Topic Articles|9 Comments