Dynamics GP & Office 365

Today’s #TipTuesday is a post about Office 365 and Dynamics GP and is specific to email functionality such as emailing Purchase Orders, EFT Remittances and Sales Documents. Rest assured that most other functionality other than email seems straight-forward and works no matter what (like exporting from Smartlist). (At least that’s my experience although there may be exceptions I am unware of!)

Continue reading “Dynamics GP & Office 365”

No Canadian Payroll 2019 Mid-Year Tax Update!

There’s no #TipTuesday today since I had website issues over the weekend and was unable to access it to prepare something. So, this will be a form of a tip in lieu of another topic!

There will be no mid-year tax update for Canadian Payroll for Dynamics GP this year, zippo, nada, zilch! Imagine that, not a single jurisdiction has a tax change this mid-year. That’s got to be a first!

So, enjoy your July 1st without a tax change!

Back to consulting!

There’s an expression “you can take the girl out of consulting but you can’t take the consulting out of the girl”. OK, so that’s not really how that goes, but it fits the situation!

As of June 1st (2019), I’m resuming my consulting business – Kuntz Consulting Inc. – and am back to being a Microsoft partner and independent consultant. This is so new that I haven’t even had a chance to update my website; so, depending on how quickly you read this post and click on that link, you may see the old message “no longer taking on clients”! Rest assured, I’m working on the updates as you read this.

Continue reading “Back to consulting!”

Are you using what you’ve purchased?

Today’s #TipTuesday isn’t a technical tip, it’s more of a business tip. I’ve written this to be specific to Dynamics GP, although what I describe may apply to other applications and software licensing. I have not worked with licensing on any other ERP packages to know if this might be a general rule of thumb or not.

If you’ve been using Dynamics GP for any length of time, it might be worth revisiting what you’re registered for and have paid for, module/functionality-wise. It’s probably worth taking a look at this every couple of years post-implementation, particularly if you paid for things up-front with the intention of phased implementations later. Every year is probably too frequent, but every couple of years allows you time to evaluate if your master plans have changed, if you still plan to implement what you thought you would at the time of purchase.

The math works out that, on average, every 5 years you are re-purchasing your Dynamics GP software (based on a rough average of 20% annual enhancement from ISVs). This doesn’t apply to subscription-based licensing, which is paid by the month, but the vast majority of users of Dynamics GP are not on subscription licensing (or that would be my guess).

Continue reading “Are you using what you’ve purchased?”

Excel Paste Special – Operations

Today’s #TipTuesday is an Excel tip. Did you know there are some funky Paste Special options beyond the basics like Paste Values, Paste Formats etc.? I find if you were to ask most Excel users what Paste Special is, the majority will answer “pasting values instead of formulas”. While that’s definitely true, there are also Paste Operations.

There are random circumstances where I’ve found this to be useful in a pinch and today was one of them. I was working on some Fixed Assets stuff, and my data had asset cost and accumulated amortization both as positive values. I wanted to do some Pivot Table analysis with it, to validate some Net Book Value info, without fussing with formulas. Paste Special Operations to the rescue!

Continue reading “Excel Paste Special – Operations”

SQL Alerts with HTML email body

Today’s #TipTuesday is a bit different from my normal type of post. In the course of monitoring some integrations, I had wanted to change the emails I get when there were issues. What I inherited was email alerts with attachments, without any data that I could use as an Outlook filter to tell me if something was ok or not. I had to open the attachment to see if there were errors. I wanted to find something better.

What I’m writing about today is what I’ve pieced together from various searches and unfortunately, while I got the pieces from various other blogs, I’ve changed so many things and re-worked this so many times, I no longer even have the references of those that helped me get to the point of what I’m sharing today. I wish I could link to them to thank them.

Continue reading “SQL Alerts with HTML email body”

In search of the perfect credit card

A few months ago, I started re-evaluating the credit cards I was using, and checking into the benefits they offer. I was planning a big trip and have never really paid attention too much to the benefits other than the basic rewards they offer (cash back or travel points in various programs etc.). I knew friends who had used some of the warranty extension kinds of benefits, but that’s about it. It seemed like most cards advertise the same stuff – extending the warranty on certain purchases, concierge services, car rental insurance coverage, some insurances on trip cancellations and things like that. It all sounded the same to me.

I decided to make some changes, cancelling a basic card I had and looking for something with better rewards. Who knew that months later I would have gone through 3 different “new” credit cards to find the “right” one for me? I realize now how many things I never took into consideration that can make or break your experience with a credit card. Here is my story and some lessons learned that may help you too.

Continue reading “In search of the perfect credit card”

Posts navigation

1 2 3 4 5 6 32 33 34
Scroll to top