Today’s #TipTuesday is yet another non-Dynamics GP post… I’m on a bit of a roll of finding oddball new things that are worth sharing. I’ll get back to more GP content soon, I promise!
Today’s #TipTuesday is a feature that was introduced in GP 2013 R2: taking a company offline for maintenance or other periodic routines. Continue reading “Take company offline”
Today’s #TipTuesday is another non-product tip, but I’ll be knee-deep in sessions at GPUG Summit by the time many of you read this, so in the interest of a “simpler” topic, this is what I’ve come up with!
Today is the first “full” day of the 2018 GPUG (& other UGs) Summit. I get the sense that a lot of users tend to miss out on the news or updates because they aren’t on Twitter, or other social media sites where the news and information flow is often shared first. There are a lot of you out there reading this that may not know or care what a hashtag is, or know what you can do with it.
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.
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”!
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…).
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.
Today’s #TipTuesday post is for anyone who might be running more than one local instances of SQL Server. I often have at least a couple of instances on my laptop, as historically I would want to have the ability to mimic some client installs, as close as I can. While I am no longer a consultant, I will continue to do this so that I can have an instance the somewhat resembles what version of SQL and Dynamics GP we use at work + the latest version of GP with all the latest things installed. For blogging alone, I want to have the latest and greatest to play with and learn what’s new.