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.
In early May 2016, we saw the introduction of Microsoft Dynamics GP 2016 and the general availability of the first two Canadian Azure data centres in Toronto and Quebec City. That combination gave me a chance to roll up my sleeves again and work with Azure a little more, as I want to ultimately host any of my own Azure machines in Canada, and of course, play with the last version of Dynamics GP!
One year ago now, I wrapped up a series of posts detailing my adventures with Microsoft Azure, learning about how it works, and what the cost looks like over the first few months of activity. The wrap-up post is here, which has the index of the series I wrote. Reading through those, most of what I wrote is useless now!
I hope to write some updated blog articles on what’s changed in Azure since I wrote about things last year. My experience recently has shown me that nearly everything I thought I knew last year, has changed! There is a new portal, which means deploying resources differently, with different terminology, different locations for finding some things etc.
A client asked me where they could find out some metric-type information from the last couple of years’ processing in Dynamics GP, such as the number of A/P invoices processed, number of cheques processed etc.; and the same for A/R if possible.
Simple question, not so simple answer. I admit it never occurred to me, this information isn’t particularly easy to get to in GP in aggregate form, or I’m drawing a complete blank on where to get it. There are many inquiry windows but most with this type of thing are at a customer level, not company level.
So, I wrote a couple of quick smartlists – one for A/P, one for A/R, and I thought I’d write it out as this client likely isn’t the first one to ask this question! I’ll call it a poor man’s dashboard… it’s simple, and for those who haven’t delved into dashboards yet or graphs or KPIs, this may suffice for some simple information about what you’re processing in Dynamics GP.
For some reason, out of the box, Dynamics GP Canadian Payroll T4 Forms don’t have the employer address. Why? I have no idea… but the information is there to be added easily, and here’s how to add it to your T4 reports for Employer and Employee versions.
Here’s another pet peeve of mine when it comes to Integration Manager: changing the default IM database on each installation. Like my previous post on how to register IM quickly, here’s another tip on using the .ini file settings to your advantage to roll out workstation installs quickly and painlessly.
I’m working on an upgrade at a client from GP 2010 to GP 2015. Part of this involves upgrading Integration Manager to the newest version. As I opened IM the first time on a new install, I am reminded of what a pain in the butt it is to manually put the reg keys in each workstation.
I started reading an old installation document to update it, a document that was written by someone else for their GP 2010 installs. It struck me that many people still don’t know there is a faster way to register Integration Manager on every machine, instead of having registration keys handy to cut and paste into each installed workstation. The instructions include the keys and the steps to put new keys in on each installation.
I actually am re-creating this post as it appears to have disappeared! Hmm…
An update on my Azure experiences… apparently I forgot to turn off my Azure VM one day last month. I say apparently because I don’t recall using Azure to turn it on, but perhaps I did, anticipating doing something, then forgot. It happens.
I lost an evening that I’ll never get back over something so stupid I wish I had just stopped to think about this issue a little more.
The situation was this: I just upgraded a client from GP 2010 to GP 2015. I didn’t upgrade the test companies, because it’s a waste of time right? So I finish the upgrade and proceed to create new test companies and take fresh backups of the new production companies and restore to the test companies. (more…)