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

  • Time budgets

    A post about setting annual targets or budgets for hours worked, how I broke down the targets and analyze the data in PowerBI throughout the year. (continue >)

  • Power of Attorney: lessons learned

    Lessons learned being a power of attorney for a US relative (as a Canadian citizen). Fun with banks, investment firms and Apostilles! (continue >)

  • End of my MVP journey

    My time in the MVP Award program has come to an end as of July 2025. (continue >)

  • CRA T619 change for 2025

    A post about the Canada Revenue Agency T619 XML schema changes, examples of the T619 XML format for 3 scenarios, and some guidance for #MSDYNGP clients using Canadian Payroll. (continue >)

  • 2024 year in review

    Another year has flown by and I’ve been thinking about how last year went. In my 2023 year-in-review post, I wrote that I was ending the year on a high note, getting back into blogging after not writing a lot in recent years. I wrote 27 posts in 2024, but only 2 of those since… (continue >)

  • Dynamics GP End of Life announcement

    This is a post about the end of life announcement for Dynamics GP on Sept 25, 2024, and what it means for customers, timelines and recommendations for next steps. (continue >)

  • MVP Renewal for 2024/2025

    A long overdue post about my MVP renewal for 2024-2025 and a catch-up on why my blog has been so quiet since March. (continue >)

  • 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… (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… (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. 😄 Challenge Microsoft Learnpspier (Full URL: https://learn.microsoft.com/learn/challenges?id=b696c18d-7201-4aff-9c7d-d33014d93b25&WT.mc_id=DX-MVP-5002186) If you… (continue >)

  • Restoring a copy of a GP company reminder

    This post is a reminder to Microsoft Dynamics GP admins who may be creating a test company or copy of a company for other reasons, that the SY00100 table may need updating before logging into GP. (continue >)

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

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

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

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

  • 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 Dataflows Gen2) Part 6 (Getting started with data warehouses) Part 7 (Administration of Microsoft Fabric)… (continue >)

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

  • 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 Dataflows Gen2) Microsoft Learn Module Get started with data warehouses in Microsoft Fabric This module… (continue >)

  • 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 Ingest Data with Dataflows Gen2 in Microsoft Fabric This module is about Dataflows Gen2, a cloud-based ETL… (continue >)

  • 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 Fabric This module is about Data pipelines, which will be familiar to anyone who uses Azure Data… (continue >)

  • Canadian Payroll 2023 T4s

    This post is about 2023 T4s in Dynamics GP Canadian Payroll. Watch for previously modified T4 reports which may not show the new Box 45! (continue >)

  • 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 about the Delta Lake storage format in lakehouses, creating and working with delta tables in Spark.… (continue >)

  • Subscription options on this blog

    [UPDATED February 15, 2024 – it won’t quite work how I initially described it.] 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… (continue >)

  • 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 use Apache Spark for data processing and analytics in Microsoft Fabric. Spark is frequently used in… (continue >)