Planes, Trains & Automobiles!
I'm home from a 3-week business trip, and I thought I'd share some of the travels as I legitimately had a "Planes, Trains, and Automobiles" experience, although not as chaotic as the movie! I didn't post too much about it while travelling, choosing to wait for my return home to share this. It was 3 weeks with only a carry-on bag, so I’m glad to be home and wearing different clothes for a… Continue...
Decimal Places for HR Benefits
I'm calling this a #TipTuesday post but it really should be called a "Jen is writing about it so she doesn't forget the next time she needs it" post. 😄 Fellow bloggers will be able to relate to that! By default, the Benefits and Deductions decimal places are set to 2 decimals, and it comes from the US Payroll module side of things in Dynamics GP. For Canadian Payroll users who use the HR… Continue...
New MS Learn AI Skills Challenge
A new Microsoft Learn challenge started today! It's very similar to the previous one I posted about, but this time once you complete it, you get a FREE exam voucher. The previous challenge resulted in a 50% off voucher which is good, but free is better. 😄 ChallengeMicrosoft Learnpspier (Full URL:
Restoring a copy of a GP company reminder
Several years ago, I wrote about a restore issue "that drove me nuts" as the post title says. That was written shortly after the "named system database" functionality was introduced in Dynamics GP and a new company table SY00100 to capture the company ID and system database name. What this post is about is a reminder that when creating a copy of another company, like a test company, or in my… Continue Reading...
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...
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...
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...
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...
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...
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:...
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...
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:...
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...