Hello!

Welcome to my blog! My name is Jen Kuntz, I am a CPA (CGA) and my blog is about Microsoft Dynamics GP, Excel, Power BI as well as other random topics from time to time.

Smiling thumbs up light bulb

  • SmartList Export Oddities

    I am in the early stages of a set of tips around the use of SmartList in Dynamics GP. Today I was writing one for this coming Tuesday and in doing the prep work to get screenshots etc. ready, I was doing some exports. One thing led to another, and I realized I should include… (continue >)

  • GP “Next” aka what’s in a name?

    ,

    The expression “GP Next” is a long-time moniker for the next “yet-to-be-named” release of Microsoft Dynamics GP. It’s a commonly used term to talk about the next version while product versioning and/or naming and/or branding details are still being sorted out, instead of referring to it by a semi-real name that changes at the last… (continue >)

  • 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 not utilized SmartLists at all in their day-to-day work yet, despite using Dynamics GP for a few years. It… (continue >)

  • Show Required Fields

    Today’s #TipTuesday is for new users, and 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. User Preferences In a post last summer, I covered some of the User Preferences window, but… (continue >)

  • Fixed Assets GL Posting Flow Part 1

    This is the first post in an 8-part series on Fixed Assets in Dynamics GP. This post is setting up the scenarios I plan to cover and the basic flow of asset acquisitions. (continue >)

  • GP Tech 2019 – Day 3

    I’m catching up and am now writing about “today”, day 3 at GP Tech 2019. My previous posts from the other days are here: Pre-Day Day 1 Day 2 The third day of the conference is always a short one – a half day of content and for some, various meetings or simply a chance… (continue >)

  • GP Tech 2019 – Day 2

    This is a continuation of the mini-series of posts about the GP Tech Conference in Fargo, ND. My previous posts are here: Pre-Day, including golf with Shawn, Taylor & Belinda Day 1 Meeting with Microsoft Day 2 started a lot more slowly for me. I decided to skip a couple of the first morning sessions… (continue >)

  • 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. Before 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… (continue >)

  • GP Tech 2019 – Day 1

    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 Monday and Tuesday followed by a “morning-only” set of content on Wednesday. As I write this, it’s Wednesday and I’m catching up on my blogs to get them written… (continue >)

  • GP Tech 2019 – Pre-Day

    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. Saturday – the trip in With limited flight choices on Sunday, I flew in a day early, on Saturday, and early enough that… (continue >)

  • Where’d my navigation pane go?

    A quick troubleshooting tip for #TipTuesday on how to get the Navigation Pane to re-appear if it ever seems to go missing! (continue >)

  • Celebrating 10 years!

    On Sept 1st., it was the 10th anniversary of my business – Kuntz Consulting Inc. It’s not 10 consecutive years of active business (since I took a brief detour to try full-time employment) but I’m celebrating it anyway! A brief history I have been working in various consulting firms since 2001, as a Dynamics GP… (continue >)

  • 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 for Excel users to get a set of data ready for an integration, which often is the world I’m living in. Sometimes I’ve… (continue >)

  • Excel’s hidden gem – IFERROR

    ,

    This #TipTuesday post explains the fantastic formula IFERROR and how it can help return meaningful data to users. (continue >)

  • Excel VLOOKUP – numbers as text & vice versa

    ,

    This #TipTuesday is about looking up numbers in text and text in numbers when the data types are not matching. (continue >)

  • Excel tip – “corner” copy

    ,

    This #TipTuesday post is about one of my favourite shortcuts in Excel: “Corner Copy”. (continue >)

  • MVP Renewal for 2019/2020

    I’m thrilled to announce that I’ve been renewed as a Microsoft MVP in Business Applications (Dynamics GP focussed) for the next year, through to July 1, 2020. Email notification for MVP renewal for 2019-2020. Renewal is never guaranteed and I don’t take it for granted that I will be renewed. What is a Microsoft MVP?… (continue >)

  • Dynamics GP & Office 365

    ,

    This #TipTuesday is a post about converting from Office 2016 to Office 365 and some of the issues one might experience with email functions in Dynamics GP. (continue >)

  • Outlook credentials issue

    This post is about credentials in Outlook for Office 365 and having difficulties with Outlook recognizing my email address. (continue >)

  • Are you using what you’ve purchased?

    Today’s #TipTuesday isn’t a technical tip, it’s more of a business tip. I’ve written this to be specific to Dynamics GP, although what I describe may apply to other applications and software licensing. I have not worked with licensing on any other ERP packages to know if this might be a general rule of thumb… (continue >)

  • Back to consulting!

    There’s an expression “You can take the girl out of consulting but you can’t take the consulting out of the girl”. OK, so that’s not really how that goes, but it fits the situation! As of June 1st (2019), I’m resuming my consulting business – Kuntz Consulting Inc. – and am back to being a… (continue >)

  • Excel Paste Special – Operations

    ,

    This #TipTuesday post is how to Paste Special with a multiply or divide operation to quickly change the sign on a set of data. (continue >)

  • SQL Alerts with HTML email body

    Today’s #TipTuesday is a bit different from my normal type of post. In the course of monitoring some integrations, I wanted to change the emails I get when there are issues. What I inherited was email alerts with attachments, without any data that I could use as an Outlook filter to tell me if something… (continue >)

  • In search of the perfect credit card

    This post is off-topic about a series of trials and errors in finding the right credit card for my needs. (continue >)

  • SmartList stuck on My Reports pane

    Today’s #TipTuesday post is about troubleshooting an issue with the My Reports home page area/pane and how to remove SmartList favourites from there. The specific scenario here related to favourites that were “stuck” in MyReports after an upgrade to GP 2013 a few years ago. I was reminded of this when I saw this post… (continue >)