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

  • Top 10 Blog Posts from 2021

    I didn’t do this for 2020, but I like to look back at what posts had the most views during the previous year to see what has staying power and what piqued other’s curiosity. Interestingly enough, not a single 2021 blog post made my top 10 list. That’s not too surprising to me since I… (continue >)

  • ROE issue in Canadian Payroll

    An ROE issue where Box 15B does not generate the correct value on the printed report. (continue >)

  • Pagination in Power Query (follow up)

    Part 5 of a series where I revisit one of my earlier steps, revise my code from post #2 to use the same approach used in post #4. (continue >)

  • Clear Recent Items list in Power BI Desktop

    How to clear the recently opened items list in Power BI Desktop. (continue >)

  • Pagination in Power Query (Part 2)

    The 4th post in the series around using APIs, specifically around iterating over an unknown number of pages of results, using the ClickUp API. (continue >)

  • Connecting to ClickUp in Power Query

    The 3rd post in the series, this one about the ClickUp API and how to connect to it. (continue >)

  • Power BI number formatting tips

    Two tips for formatting numbers in Power BI, replacing zeroes with dashes and displaying something other than blanks. (continue >)

  • Pagination in Power Query (Part 1)

    Part 2 in the series where I’m discussing Power Query with APIs. Today is about paginating over a known number of pages, using Harvest as the API example. (continue >)

  • Connecting to Harvest in Power Query

    The first post in a short series documenting how to work with some web application APIs in Power Query, using Harvest as my first example. (continue >)

  • Power BI matrix column width sizing

    A post with tips about managing the column width in matrix visuals in Power BI. (continue >)

  • GP Upgrades – series wrap-up

    Well, it’s finally the end of the series and this one is a short-ish one where I review some last-minute tips. Posts in the series Series intro Process overview Know your environment (part 1) Know your environment (part 2) Know your environment (part 3) Know your environment (part 4) Know your environment (part 5) Know… (continue >)

  • GP Upgrades – testing

    Much of the upgrade series so far has been about “knowing your environment”. As I get closer to the end of the overall series, there are a couple more topics to discuss. Today’s topic is testing and what to consider/plan for. Posts in the series Series intro Process overview Know your environment (part 1) Know… (continue >)

  • GP Upgrades – know your environment wrap-up

    This is the last post in the upgrade series that is specifically about “knowing your environment”. After this, I will branch out into other topics but for now, I am doing a catch-all of smaller things I may not have noted in prior posts. Posts in the series Series intro Process overview Know your environment… (continue >)

  • GP Upgrades – know your environment part 5

    My last post was about integrations and what to consider for that in terms of testing and planning. Today’s post is about reporting. The previous posts are linked below for what I’ve covered thus far in the series! Posts in the series Series intro Process overview Know your environment (part 1) Know your environment (part… (continue >)

  • GP Upgrades – know your environment part 4

    My last post was a few months ago and since then I’ve gotten a little distracted with other things (summer, nicer weather, etc.). I’m ready to try to catch up and finish this upgrade series, continuing for now with the “know your environment” topic. So far I have covered some product terminology, product types &… (continue >)

  • MVP Renewal for 2021/2022

    I was fortunate to be renewed today for the Microsoft MVP award, for the 5th time. When I got awarded the first time in October 2016, I never dreamed that I would be still here 5 cycles later. This year is bittersweet for me, as I’m only getting renewed due to the generosity of the… (continue >)

  • GP Upgrades – know your environment part 3

    In my last post, I continued on the “know your environment” topic. So far I have 2 parts to that with a background on the elements to be aware of with core Microsoft components of Dynamics GP plus ISV products, where they are modules and functionality within the Dynamics GP client. In this post, I… (continue >)

  • GP Upgrades – know your environment part 2

    In my last post in this Dynamics GP upgrade series, I talked about getting to know your environment. The importance of understanding some of the moving parts cannot be understated, for those who are “in charge” of the environment in any meaningful way. Reading this series isn’t intended for customers to bypass utilizing a partner… (continue >)

  • GP Upgrades – know your environment

    The 3rd post in the GP Upgrades series, and the first in a sub-series about knowing your environment. This post focuses on what is meant by “environment” before the next posts get into more details. (continue >)

  • SmartList Export – Excel Content Error

    Last year, I wrote a post about a relatively common SmartList Export error, the “Excel cannot open the file” error. Today, I was working on a client upgrade and cleaned up a ton of minor issues with some Canadian Payroll SmartLists they use. In writing this post, I have also developed a quick hatred for… (continue >)

  • GP Upgrades – process overview

    This post discusses what Dynamics GP upgrades look like, as an overview of the processes that typically occur. (continue >)

  • GP Upgrade Tips series intro

    I’m finally ready to get back into a regular blogging rhythm and will be starting a series around Dynamics GP upgrades. I’ve presented on this topic a few times and what I plan on covering is how I approach and manage upgrades. What this series will not be about is the technical “how to upgrade”… (continue >)

  • Remove all notes in PowerPoint

    This post contains a tip about how to remove all notes from PowerPoint slides instead of removing them one at a time. (continue >)

  • New Year’s Resolutions 2021

    ,

    It’s that time again, a new calendar year has begun. This year “Happy New Year” has an entirely different meaning to most of us, after what can only reasonably be described as a train wreck of a year. I’m a day late in writing this post this year (even though I’m posting this as Jan… (continue >)

  • Issues with Word Templates

    ,

    Recently, there have been issues with Dynamics GP and Word Templates, due to some changes to the most recent Microsoft Office build releases. Specifically, documents generated in Word Templates cannot be opened in Microsoft Word, for environments running a build of Microsoft Office from Sept 8/9th or newer. Today’s post is an attempt to clarify… (continue >)