Lessons learned from not trusting my gut
Feb28

Lessons learned from not trusting my gut

It's been an expensive couple of weeks for me. I love/hate "life lessons". They hurt, but make me stronger if I learn from my mistakes. I've been wrapping up two different small projects and on both of these particular projects, I completely underestimated the amount of effort it would take me. I made several mistakes and it never hurts to share them. Hey, maybe I will actually learn from them… Continue...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 12
Feb20

MS Learn Fabric Analytics Engineer Challenge Part 12

This post is the last in the series specifically about the modules in this Cloud Skills challenge. Yay! The deadline to complete the challenge is February 22, 2024, so I got there with 2 days to spare! This topic is also not covered on the exam, hence it is not being included in the Learn Together series of video topics. In a few weeks, I will prepare and take the DP-600 exam, using the 50% off… Continue Reading Jen...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 11
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 11

This post is about module 9 of the Cloud Challenge series. Like the previous post in this series, it is a topic not covered in the DP-600 exam based on the study guide I read at least. After this, there will be one more post to complete the modules in the challenge, just before the deadline of February 22, 2024. Previous posts in this series: … Continue Reading Jen Kuntz’s Article on their blog MS Learn Fabric Analytics...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 10
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 10

This post is about module 8 of the Cloud Challenge series. It's the first of my series where there was no Learn Live video session for it. It is not a topic that is listed as covered by the DP-600 exam, although it is part of Microsoft Fabric and part of the skills challenge collection. I am completing the 3 modules not covered in the videos simply because those completing the challenge will… Continue Reading Jen...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 9
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 9

This post is the last of the 9 that had a "Learn Together" live video session. The posts after this will cover the modules I missed, numbers 8, 9, and 13 to round out the rest of the challenge. The deadline for the challenge is coming up quickly (ends Feb 22, 2024), and as of writing this post, I have not yet completed those 3 modules! Previous posts in this… Continue Reading Jen Kuntz’s Article on their blog MS...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 8
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 8

This post is about module 11 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses)Part 2 (Apache Spark)Part 3 (Delta Lake tables)Part 4 (Using Data Factory pipelines)Part 5 (Ingesting data with… Continue Reading Jen Kuntz’s Article on their blog MS Learn Fabric Analytics Engineer Challenge Part 8 Part 8 of the series covers the Microsoft Learn Cloud Skills challenge, module 11:...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 7
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 7

This post covers module 10 in the Cloud Skills challenge. This is where the video series and the challenge modules start to diverge a bit. Modules 8, 9 and 13 were not covered in the Learn Together video series, so I will be covering those last. Modules 10, 11 & 12 were covered in a different order in the Learn Together series, but for this blog, I am putting them in the order of how they… Continue Reading Jen Kuntz’s...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 6
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 6

This post is about module 7 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses)Part 2 (Apache Spark)Part 3 (Delta Lake tables)Part 4 (Using Data Factory pipelines)Part 5 (Ingesting data with… Continue Reading Jen Kuntz’s Article on their blog MS Learn Fabric Analytics Engineer Challenge Part 6 Part 6 of the series covers the Microsoft Learn Cloud Skills challenge, module 7:...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 5
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 5

This post is about module 6 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses)Part 2 (Apache Spark)Part 3 (Delta Lake tables)Part 4 (Using Data Factory pipelines) Microsoft Learn Module

Read More
MS Learn Fabric Analytics Engineer Challenge Part 4
Feb19

MS Learn Fabric Analytics Engineer Challenge Part 4

This post is about module 4 in the Cloud Skills challenge. Previous posts in the series: Part 1 (Introduction, Lakehouses)Part 2 (Apache Spark)Part 3 (Delta Lake tables) Microsoft Learn Module Use Data Factory Pipelines in Microsoft… Continue Reading Jen Kuntz’s Article on their blog MS Learn Fabric Analytics Engineer Challenge Part 4 Part 4 of the series covers the Microsoft Learn Cloud Skills challenge, module 5: Using...

Read More
Canadian Payroll 2023 T4s
Feb16

Canadian Payroll 2023 T4s

I received an email yesterday from someone I know via the Dynamics communities sites, asking me about the new Box 45 for Employer Offered Dental Benefits. The question was: is this new box supposed to be on the 2023 T4? In his case (or his client's case, I'm not sure if he's a partner or a customer), it was not appearing. Hmmm. I checked in with one of my clients who was right in the middle of… Continue Reading...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 3
Feb16

MS Learn Fabric Analytics Engineer Challenge Part 3

This post is about module 3 in the Cloud Skills challenge. Previous posts in the series Part 1 (Introduction, Lakehouses)Part 2 (Apache Spark) Microsoft Learn Module 3 Working with Delta Lake tables in Microsoft Fabric This module is… Continue Reading Jen Kuntz’s Article on their blog MS Learn Fabric Analytics Engineer Challenge Part 3 Part 3 of the series covers the Microsoft Learn Cloud Skills challenge, module 4: Delta...

Read More
Subscription options on this blog
Feb12

Subscription options on this blog

Since moving my blog onto the Ghost platform – which I absolutely love by the way! – I've been learning about some of the new features it has that I didn't have in my previous iterations of this blog. One big one is built-in functionality around newsletters, which in my case I'm using to "notify" subscribers about new posts. Ghost allows for free and paid tiers for content but having a...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 2
Feb11

MS Learn Fabric Analytics Engineer Challenge Part 2

In this post, I am covering module 3 of the Microsoft Learn challenge. Previous posts in the series Part 1 (Introduction, Lakehouses) Microsoft Learn Module 2 Use Apache Spark in Microsoft Fabric This module shows how to configure and… Continue Reading Jen Kuntz’s Article on their blog https://jenkuntz.ca/2024/02/ms-learn-fabric-analytics-engineer-challenge-part-2/ Blog Syndicated with Jen Kuntz’s...

Read More
MS Learn Fabric Analytics Engineer Challenge Part 1
Feb11

MS Learn Fabric Analytics Engineer Challenge Part 1

As I wrote in my introductory post a couple of days ago (which can be found here), this is the start of a short series following my journey through the Microsoft Learn cloud skills challenge "Fabric Analytics Engineer". I'm coming from a Power BI perspective, so the majority of Microsoft Fabric components I have not been hands-on with before this training. The first few posts in this series… Continue Reading Jen...

Read More
Microsoft Fabric Analytics Engineer challenge
Feb08

Microsoft Fabric Analytics Engineer challenge

If you happen to follow me on LinkedIn, you may have seen some of my posts recently about the "Learn Together" Microsoft Fabric live training series. As I watched each of the 9 sessions over the past 3 weeks, I would post a note about each with a link. Now I'm going to write a few short articles on my journey through the Learn Together series, the Microsoft Learn "Fabric Analytics Engineer"… Continue...

Read More
Add to Shortcuts & Startup folder
Feb06

Add to Shortcuts & Startup folder

This #TipTuesday post has a couple of things in it, one of which is not working for me in my test install of Dynamics GP though! DOH! Add to Shortcuts menu option In most Dynamics GP windows, under the File menu, there is an option "Add to Shortcuts". If it's not visible there on some windows, it will be either a third-party product or a former third-party product. Example: you will not find… Continue Reading Jen...

Read More
Stop Excel from opening "Book1"
Jan23

Stop Excel from opening "Book1"

Some things irritate me that really shouldn't, and this is one of them. I often use computers provided by my clients instead of my own if I remotely access their environment or at their office. That means things I have streamlined on my computer are not present, and typically, I have forgotten all about it by the time I get to a client and am using an out-of-the-box install of something. This… Continue Reading Jen...

Read More
Canadian Payroll Incomplete Paycodes message
Jan16

Canadian Payroll Incomplete Paycodes message

A client ran into this last week and I thought it would be a good topic for a #TipTuesday blog post. The scenario is specific to users with both the Canadian Payroll (CPY) module and the Human Resources (HR) module in Microsoft Dynamics GP. This only will apply if HR is installed, so for those with just Canadian Payroll, and no HR module, it won't be relevant! Incomplete paycodes warning… Continue Reading Jen Kuntz’s...

Read More
Canadian Payroll 2023 YE Hotfix
Jan12

Canadian Payroll 2023 YE Hotfix

This post is for Dynamics GP sites with Canadian Payroll and is a heads-up that a hotfix will be issued in January or February to address some issues. The hotfix will address more than just Canadian Payroll issues; these early-year hotfixes are typically when Microsoft cleans up all issues reported from the US Payroll Year End and Canadian Payroll Year End patch releases. I will update this… Continue Reading Jen Kuntz’s...

Read More
2023 year in review
Jan03

2023 year in review

This is my annual post look back at last year, 2023 in this case. It was an unusual year in a couple of respects. Most of 2023 was a blur as I had a very busy client project that consumed a lot of my time and the year seemed to fly by. 2023 started with a bang with a newly-released website and ended with yet another new website. I wrote a couple of blogs about the website changes so I won't… Continue Reading Jen...

Read More
Last Christmas…
Dec24

Last Christmas…

The title for this post is stolen from a post I read recently on LinkedIn, by Thomas LaRock, a fellow Microsoft MVP though one I’ve never met. The post gave me something to think about, or perhaps more precisely, helped focus some thoughts that have been bouncing around my head for the last while. I’m at the stage of life now where the generation before me is starting to pass away…. Continue Reading Jen...

Read More
Canadian Payroll & Employer-Offered Dental field
Dec19

Canadian Payroll & Employer-Offered Dental field

This post is specific to Microsoft Dynamics GP in case someone is reading this post after searching for more general information on this topic. After the Dynamics GP Year-End 2023 update is installed, some of the tables include new columns for the Employer-offered Dental Benefit tracking now required on T4 and T4A forms. The default value for all employees is a value of 1 in column… Continue Reading Jen Kuntz’s Article on...

Read More
Canadian Payroll Year-End Tax Update 2023
Dec19

Canadian Payroll Year-End Tax Update 2023

Greetings everyone! Great news for those using Canadian Payroll in Dynamics GP, the tax update was released earlier than expected. Let the installs begin! There are a lot of changes this year, so please make sure to follow the Microsoft Support pages for the latest information and updates. The best page to watch for updates is the one below. There are a few blogs and pages that contain similar… Continue Reading Jen Kuntz’s...

Read More
New website (again)!
Dec17

New website (again)!

I'm pleased to announce a new and improved website (for the second time this year)! Yes, it's a little embarrassing to admit that my earlier migration to Hugo & Azure was short-lived. I had so much fun working on that project. I learned many new things in the process and have no regrets. Some of what I learned I continue to use for this site and other GitHub things I learned through the… Continue Reading Jen...

Read More
MVP Renewal for 2023/2024
Jul06

MVP Renewal for 2023/2024

I am pleased to share that I was renewed for the Microsoft MVP awards, my 7th! As I was last year I am a bit in shock but grateful for the support of those who have kept me going. Last year, I didn't have many visible contributions but more behind-the-scenes things, but I wasn't sure it was enough to get renewed. Email from MVP Award Program with renewal confirmation July 2023 (Edit Dec 2023: I… Continue Reading Jen...

Read More
Moving website to Hugo & Azure
Jan29

Moving website to Hugo & Azure

Hello and welcome to my "new and improved" (I hope!) blog site, powered by Hugo and Azure Static Web Apps. My final post on WordPress has the same URL but different content. What is Hugo? Hugo is a framework for building static site websites. There are several "static site generators", but I happened to land on Hugo after reading and following some others in the community using it to convert… Continue Reading...

Read More

Moving website to Hugo

This post is for any WordPress followers and email subscribers… I am getting ready to move my website away from WordPress, which means whoever is subscribing to this via the WordPress subscribe or email subscription features will no longer get notifications of new posts. I do not yet have a plan or method for subscriptions to content with the new site other than an RSS feed. For those of you… Continue Reading Jen...

Read More
2022 Year in review
Jan01

2022 Year in review

I started writing this post on December 31st, 2022, as I re-read last year’s post to see where my head was at then. I re-read every “new year” post I’ve written here, all the way back to Jan 1, 2011. It’s fascinating to see the change(s) in mindset and priorities over the years. Ten years ago I was going through a divorce, and I didn’t know what the year would bring, other than I was...

Read More
Canadian Payroll 2022 Year End Update
Dec23

Canadian Payroll 2022 Year End Update

This is a few days late but the 2022 Canadian Payroll year end tax update for Dynamics GP was released earlier this week, on Wednesday. There were some unfortunate delays to getting this one released because of a late change for Quebec. Every year it seems like something causes a delay! Download details Like last year, there is only one download, which is a patch for “Microsoft Dynamics GP”… Continue Reading Jen...

Read More
Resource not found in dictionary error
Oct19

Resource not found in dictionary error

Greetings everyone! Yes, it’s been a while, my apologies. I’m struggling with motivation to write and hoping it comes back soon! Today I wanted to post a short blog on a support issue I had today. It is something that I can find a couple of references to online, but not many, so that tells me it’s worth it to share my experience and validate some of the other threads that confirmed the… Continue Reading Jen...

Read More
MVP Renewal for 2022/2023
Jul05

MVP Renewal for 2022/2023

I’m happy to share that I have been renewed today for the Microsoft MVP award, my 6th award. I am still a little shocked, as I truly did not believe I was consistent enough this past year with my contributions. I am grateful as always to the MVP Program team and Betsy Weber for believing in me. I do hope to get back to my “normal self” one of these days and be a more-frequent contributor and… Continue Reading...

Read More
Dynamics GP Email – Login Failed error
May11

Dynamics GP Email – Login Failed error

Today's #TipTuesday post is a pretty short one. A client of mine recently merged with another firm and part of that was everyone getting new email addresses for a new web domain. For most of the users that used email functionality in GP, it was a non-event: they simply logged into the "Exchange Log On" prompt with their new email and password and continued with their task. For one user,… Continue Reading Jen...

Read More
Dynamics GP Email – Login Failed error
May10

Dynamics GP Email – Login Failed error

Today’s #TipTuesday post is a pretty short one. A client of mine recently merged with another firm and part of that was everyone getting new email addresses for a new web domain. For most of the users that used email functionality in GP, it was a non-event: they simply logged into the “Exchange Log On” prompt with their new email and password and continued with their task. For one user,… Continue Reading Jen...

Read More
Enabling the Canadian Payroll module
Apr13

Enabling the Canadian Payroll module

Today’s post is short-ish and sweet. In my last post, I documented where to go to get registration keys. In the last part of the post, I had added a note that was specific to Canadian Payroll and today learned that it no longer applies, at least not for recent versions of Dynamics GP. I have edited that part of the post now… This post is a very brief overview of the 2 things that need to be… Continue Reading Jen...

Read More
Where can I find my registration keys on CustomerSource?
Mar29

Where can I find my registration keys on CustomerSource?

This is a short post. I went looking for a customer’s registration keys and could not remember how to get to them now that the old CustomerSource links are dead and buried. So… future “me”, this is your reminder! And for those who stumble across this, you’re welcome, I hope the info stays “correct” for the next few years so I don’t have to look for this again! NOTE: I am not covering...

Read More
Power BI, Excel & GP – SQL sources
Mar09

Power BI, Excel & GP – SQL sources

Today’s post combines the topics of the previous two posts and moves into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files. Previous posts in the series IntroductionStarting from… Continue Reading Jen Kuntz’s Article on their blog Power BI, Excel & GP – SQL sources The fourth post in the series, showing how to connect to SQL in Power Query (Excel or...

Read More
Power BI, Excel & GP – SQL sources
Mar08

Power BI, Excel & GP – SQL sources

Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files. The previous posts in the series are: Introduction Starting from scratch Data Access What this post covers In this post, here is what I am going to show, in the context of the Payables Transactions type of… Continue Reading Jen Kuntz’s...

Read More
Power BI, Excel & GP – Data Access
Feb25

Power BI, Excel & GP – Data Access

This is the third post in the series and I am going to dedicate this post to how to access GP data in terms of describing some of the options and factors to consider. Very little of this will have "how to" information about Power Query, but I will continue that in the next post. The previous posts in the series so far are: IntroductionStarting from scratch In my last post, “Starting from… Continue Reading Jen...

Read More
Power BI, Excel & GP – Data Access
Feb24

Power BI, Excel & GP – Data Access

This is the third post in the series and I am going to dedicate this post to how to access GP data in terms of describing some of the options and factors to consider. Very little of this will have “how to” information about Power Query, but I will continue that in the next post. The previous posts in the series so far are: Introduction Starting from scratch In my last post, “starting from… Continue Reading Jen...

Read More
Power BI, Excel & GP – Starting from scratch
Feb08

Power BI, Excel & GP – Starting from scratch

The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, starting from scratch. From my experience, an audience that is often overlooked is users who want to learn more or improve their skills but don't know where to start, and everything they find starts at a point they don't understand or can't get to. For… Continue Reading Jen...

Read More
Power BI, Excel & GP – Starting from scratch
Feb07

Power BI, Excel & GP – Starting from scratch

The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, literally starting from scratch. From my experience, an audience that is often overlooked are users who want to learn more or improve their skills but doesn’t know where to start, and everything they find starts at a point they don’t understand or can’t get… Continue...

Read More
Maximum columns in a SmartList
Feb02

Maximum columns in a SmartList

This is most likely the shortest #TipTuesday post I will ever create! I was playing with a SmartList to prep for my upcoming series on Power BI, Excel & Dynamics GP. I stumbled across something I have never seen before: I tried to add too many columns to a SmartList! Here’s the message I received. Apparently, 189 columns is the most you can display in a SmartList (if I’m reading the… Continue Reading Jen...

Read More
Power BI, Excel & Dynamics GP
Jan31

Power BI, Excel & Dynamics GP

Soon I will be starting a new series of posts around Dynamics GP and how to get data out of it with Power BI or Excel via Power Query. There is no shortage of reporting options available for Dynamics GP customers, with many ISV (3rd party) products out there to augment some out of the box options (Report Writer, SmartLists). However, as with accounting departments everywhere, there is a heavy… Continue Reading Jen Kuntz’s...

Read More
2021 year in review
Jan01

2021 year in review

It’s hard to believe it’s the start of another year. 2020 felt like it lasted forever while 2021 was a blur. I think 2021 was “2020 one” and 2022 is “2020 two”, which is what this pandemic feels like at the moment, that 2020 has never actually ended. Nearly two years into this pandemic and people still don’t know how to wear a mask properly, but I digress… Anyway, it’s always… Continue Reading Jen...

Read More
Top 10 Blog Posts from 2021
Jan01

Top 10 Blog Posts from 2021

I didn’t do this last year 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 was inactive for so long into the year, that the posts I had have not had a lot of time yet to gain… Continue Reading...

Read More
Canadian Payroll 2021 Year End Update
Dec14

Canadian Payroll 2021 Year End Update

In all the 2020 excitement, I realized I never posted about the 2020 Year End update. I think 2020 for me was all about getting through day to day things and I just forgot about this. Anyway, I’m back to blogging semi-regularly again and it’s that time of year again. This is a HEADS UP for now, primarily aimed at Dynamics GP Canadian Payroll users. I will update this post as more… Continue Reading Jen Kuntz’s...

Read More
ROE issue in Canadian Payroll
Nov30

ROE issue in Canadian Payroll

This post is about an issue that I found when testing the ROE (Record of Employment) functionality for a client in Dynamics GP. (Since “ROE” is a generic term, this post is specifically about a bug in the Dynamics GP Canadian Payroll module). I opened a case for it and it was quickly confirmed and written up as a quality issue (#91928 in case you need to add yourself or your customer to the… Continue Reading Jen...

Read More
Pagination in Power Query (follow up)
Nov25

Pagination in Power Query (follow up)

This post is an unintended follow up to my “mini-series” working through how I am connecting to Harvest and ClickUp APIs in Power Query. After writing up post #4 (iterating over an unknown number of pages), I decided to review the method I used there vs. the method in post #4 (List.Generate). So, today’s post is really just describing another example of how to use List.Generate, this time… Continue Reading Jen...

Read More
Clear Recent Items list in Power BI Desktop
Nov23

Clear Recent Items list in Power BI Desktop

Today’s tip I found completely by accident. In the Open Report window, I had a long list of previous Power BI reports in my “recently used” list, many of which I had long ago deleted or moved. I wanted to clear the list and could not find a way to do that in that screen. With Word or Excel, it’s easy to do in the equivalent screen so it was driving me a little nuts that I was not able to do it… Continue...

Read More