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.
Continue reading “How to follow a conference or event”
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.
Continue reading “Two Factor Authentication, part 2”
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).)
Continue reading “Two Factor Authentication, part 1”
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.
Continue reading “Advanced Lookups”
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”!
Continue reading “Excel tip: Copy & Paste Unique Values”
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…).
Continue reading “GP Utilities user permissions part 2”
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.
Continue reading “Flash Fill in Excel”
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.
Continue reading “Start/Stop SQL by Batch File”
Today’s #TipTuesday post is a simple one, and it’s about user notifications. In GP 2013 R2, the “Send Users Message” feature was introduced as an easy way to send a notification to users who are logged in or to add a task to users’ reminder list in Dynamics GP.
Continue reading “Send Message to Users”
Today’s #TipTuesday is a brief post about Budget Transactions. Introduced in GP 2010, Budget Transactions were a feature to add more control over budget changes in Dynamics GP. Here is a brief post on how it works.
Continue reading “Budget Transactions vs Budget Upload”