Today’s #TipTuesday is about the Dynamics GP Fixed Assets module. I am going to discuss the restriction around the use of hyphens (dashes) in Fixed Asset IDs. Prior to GP 2013, there was no issue with hyphens and many customers who utilized Fixed Assets had created Asset IDs with them as separators. Of the numerous clients I have been to over the years, every single one of them used hyphens as it was easy to read, both on reports and in the screens (where things like underscores often get partially hidden by the UI). There was a consistency in viewing the Asset ID + suffix on reports too, since the “Full” Asset ID with the suffix displays with a hyphen. Using some other character as a separator combined with the use of a hyphen between ID and suffix just plain looks weird (to me).Continue reading “Hyphens in Dynamics GP Fixed Assets”
Day 1 of this year’s GP Tech conference was Monday, September 9th. As in previous years, this is a 2.5 day event, with very full days on the Monday and Tuesday followed by a “morning-only” set of content on the Wednesday. As I write this, it’s Wednesday and I’m catching up on my blogs to get them written and posted before I fly out this afternoon for home.
If you missed my “Pre-Day” post, you can find it here.Continue reading “GP Tech 2019 – Day 1”
Today’s post is about the trip and pre-day for GP Tech 2019. It’s my annual trek to Fargo, ND, to the home of Dynamics GP! I always look forward to this trip.Continue reading “GP Tech 2019 – Pre-Day”
Today’s #TipTuesday is a quick one!
Last week, a client brought me over to her desk to ask me how to get her Navigation Pane back. It had gone missing for some reason, despite the option “checkmark” still showing as having the pane enabled.Continue reading “Where’d my navigation pane go?”
This is not my typical #TipTuesday blog. I’ve missed the last 2 Tuesdays, and I promise to get back to a regular schedule by end of this summer!
In its place is my take on what I look for when considering who to vote for in the GPUG All*Star awards voting process plus a little bit about the difference between a Microsoft MVP and GPUG All*Star.
So, let’s get to it! It’s that time of year again – GPUG All*Star voting time! First, here is some background information for those of you who may not yet be familiar with these programs and awards.Continue reading “GPUG All*Star 2019 Voting”
Today’s #TipTuesday is yet another Excel tip. This one is about navigation, and some tips around things I use every day when I’m working in Excel. Some of these are particularly useful if you are using Excel to get a set of data ready for an integration, which often is the world I’m living in. Sometimes I’ve integrating right from Excel and sometimes I’m working with something where I need to “save as” and I need to make sure I don’t inadvertently have blank rows or columns in my data. That, in a nutshell, is the background for this post and set of tips.Continue reading “Excel Navigation tips”
Today’s #TipTuesday is yet another Excel tip. Can you tell I’ve been working with spreadsheets a lot lately? My blogs tend to follow my work and these last 3 weeks have been no exception. As I run into things or use something I haven’t touched in a while, I tend to blog about it!
This tip is about what I believe to be a hidden gem in Excel and that is the IFERROR formula. Over the years, I have seen many people do many funky workarounds to “pre-check” if they will get an error when there is a formula that will help you out much more easily!Continue reading “Excel’s hidden gem: IFERROR”
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”