Tips – JenKuntz.ca

SmartList Tips – favorites

Today’s #TipTuesday topic is still related to SmartLists, the subject I’ve been writing a few of these about the past few Tuesdays! My topic is SmartList Favorites, which will be a bit shorter than the others as there is only so much one can write about it!

PS, unrelated side note: being Canadian, it’s killing me inside that I have to keep typing “favorites” instead of “favourites” but I know for SEO and all that stuff if users are searching for the proper term with respect to SmartLists they will be looking for the US spelling. You win some, you lose some, eh? 😉

SmartList Tips – working with columns

Today’s #TipTuesday post is the third in my series of tips on using SmartLists in Dynamics GP. The first two posts were around the “basics” as I call them and then printing and exporting. Today’s topic is working with columns.

SmartList Tips – printing & exporting

Today’s #TipTuesday is a continuation from last week, where I covered some of the basics around SmartLists: terminology, security, sorting & resizing columns, using the GoTo, and statuses.

In this post I plan to cover a few more things that I didn’t fit: more of the commands on the toolbar (Refresh, Stop, Print, Excel & Word) plus a bit more detail around exporting to Excel.

SmartList Tips – the basics

Today’s #TipTuesday is another one for the newer Dynamics GP users in the community. Recently a user asked me how they could prepare a SmartList for some receivables data they wanted. It turns out they had really not utilized SmartLists at all in their day to day work yet, despite using Dynamics GP for a few years. It occurred to me how little time we spend training users on being more effective with this valuable tool!

Over the next few weeks, I will post different tips about how to utilize SmartList more effectively!

Show Required Fields

Today’s #TipTuesday is simple but for new users, it could be a very helpful one. This post is all about options to make “required” fields in Dynamics GP more visible to users, a feature that is easily overlooked in training.

Hyphens in Dynamics GP Fixed Assets

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).

Where’d my navigation pane go?

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.

Excel Navigation tips

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.

Excel’s hidden gem: IFERROR

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!

Excel VLOOKUP – numbers as text & vice versa

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.

1 2 3 4 … 9 10 11

Tag: Tips