Have you ever tried a VLOOKUP formula in Excel where you’re looking up something that is numeric but stored as text, or vice versa? So annoying, when you seem to have one set of data one way and the lookup in another, right? Today’s #TipTuesday is all about helping you with a couple of formula tweaks to make this a bit easier.Continue reading “Excel VLOOKUP – numbers as text & vice versa”
Today’s #TipTuesday post is a little Excel tip. It’s one of those things that I assume most people know it, and then I work wth someone and watch them use Excel and end up teaching it to someone. I call it corner copy but I’m sure there’s some official name!
There are 2 parts to this tip really: one is the copy via double clicking on the lower right corner and the bigger tip is the little pop-up window that gives you options on how that command is executed. That little pop-up window is the *gem* of this tip in my opinion as it appears in numerous instances of doing things in Excel.Continue reading “Excel tip – “corner” copy”
I’m thrilled to announce that I’ve been renewed as a Microsoft MVP in Business Applications (Dynamics GP focussed) for the next year, through to July 1, 2020.Continue reading “MVP Renewal for 2019/2020”
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”
A little while ago, I was trying to add one of my Office 365 email accounts back to Outlook and it wasn’t working. I forgot that I needed an app password because I have MFA (Multi-factor authentication) enabled on my domain/tenant. I initially put in my “regular” password and was expecting it to kick back and let me try again; however, it didn’t do that.Continue reading “Outlook credentials issue”
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!
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!”
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?”
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”
This is a belated #TipTuesday, posted a day later than usual! Recently, support for longer passwords in Office 365 was announced but oddly enough, in some places the password change dialog boxes still limit you to 16 characters. Here’s how I worked around this.
Standard “password reset” feature – 16 char limit
Here’s a screenshot of a password reset window in my Office 365 tenant, and it clearly states my password must be between 8 and 16 characters. Hmm. My assumption is this will be noticed and rectified fairly quickly as it’s inconsistent with the next part I’m going to show you.
Workaround: “Forgot my password”
The current workaround is use the Forgot My Password link when you log into Office 365. If you use MFA/2FA like I do, simply cancel out of the dialog box that prompts to send a notification code and then click on Forgot my password.
Next, there may be one or two steps requiring you to verify with either an authenticator app code or text message or both depending on your organization’s MFA/2FA setup. I had to do both. Once I was past that part, the standard “choose a new password” section came up. Now I can select a password up to 256 characters.
That’s it! As I mention above, it’s very likely this will be corrected soon… but until then, this may help if you want to secure your account with a longer-than-16-character password.