Today’s #TipTuesday is a continuation of last week’s first post on Two Factor Authentication, 2FA for short. Today I am not getting into examples, as I found an interesting article last week after posting my first blog, that illustrates some of why 2FA and password managers are important. Instead of trying to document what already exists, I focused on some other things in this post and end this with where to get setup information for some common sites.
Last week, Dynamics GP 2018 R2 was released and the first thing I did was check out and set up the replication with the Intelligent Cloud. I’ve tried a few more things, with somewhat minimal success, which means I need to do some more learning around how to navigate Business Central.
In the meantime, here are a few tips around replication that I have figured out, and where I’m at with some other stuff. I’m not finding a lot yet in the way of documentation so at this point I am trying things and trying to figure it out on my own.
Great news! GP 2018 R2 was released today, October 2, 2018. There are tons of posts on the official Dynamics GP blog about the features through their feature of the day series.
I downloaded and installed it on my Surface Go, so I could try it on this device as well as check out the new features. After I was done, I went through the Intelligent Cloud setup to see how it looked.
Today’s #TipTuesday is a topic that likely needs multiple posts to handle it properly. In fact, as I write this, it’s already long before I even get into examples and “how to” on common sites so this will be a mini-series in my #TipTuesday series (a series within a series?!). Long story short: with all of the data breaches and hacks out there, the best thing you can do to protect your logins is to turn on Two Factor Authentication (2FA). There are multiple names for this and multiple acronyms most of which generally have the same or similar meanings. (The other most common term you might hear is MFA (multi-factor authentication).)
Today’s #TipTuesday is an oldie but a goodie: Advanced Lookups. These have been around as long as I can remember, but they are one of those hidden things in Dynamics GP that many users don’t realize exists.
Here’s a cool little Excel tip for #TipTuesday. Have you ever had a column of information in Excel and wanted to get a distinct / unique list of values from one of your columns of data? I learned a new thing last week doing just this, and, surprise, it wasn’t “create a pivot table with that column”!
TL;DR summary: I like it!
I have had the Surface Go for just over 1 week now. I had been interested in it since it came out and did a lot of research on my recent trip to Fargo comparing US prices vs. CAD prices and comparing the “unique” build configuration that Costco was selling vs. what everyone else had.
Yes, I’m one of those…
Today’s #TipTuesday is short, but also related to a post from a couple of weeks ago where I posted what the minimum permissions required were for using GP Utilities. Coincidentally (or perhaps not?), last week a consultant posted a “tip” on this on the GPUG Open Forum, where there was a dangerous suggestion made, that I’m not sure they fully realized the implication of (at least I hope they didn’t think that one through and posted in haste…).
This post really doesn’t have anything to do with Dynamics GP specifically, but more about business process, internal controls or lack thereof and a fun “Twitter Moment” earlier today.
Late last week, Steve Endow, fellow Microsoft MVP, independent technical consultant, and ISV (distributor of some ISV products at least!) posted a tweet, and it’s not the first time I’ve seen something like this from him. If the Twitter link dies, it says “Another Dynamics GP partner paid me by credit card, and then sent me a check 2 weeks later. Methinks this is a common AP control / process / communication issue. Unfortunately, I don’t think software can easily fix this.”
Today’s #TipTuesday post is a Microsoft Excel tip, instead of the usual Dynamics GP tips! I do have a tie-in to Dynamics GP on where you could use this in a pinch in GP from an exported Smartlist, at the end of this post!
Have you ever used Flash Fill? It came out in Office 2013 (as far as I can confirm) and I must say, there are a number of different instances where I’ve found this extremely useful in a pinch to pull data out of some cell that contains more than what you need.