-
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 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…
-
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…
-
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! Update after publishing this: the Startup folder functionality is working on my Fabrikam Ltd. 18.5 GP install now. It appears to me that it does not work when…
-
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…
-
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…
-
Canadian Payroll 2023 YE Hotfix
This post is for Dynamics GP sites with Canadian Payroll about a Year-End hotfix just released to address some issues. The hotfix addresses 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. January…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Resource not found in dictionary error
Greetings everyone! Yes, it’s been a while, my apologies. I’m struggling with the motivation to write and hope it comes back soon! Today I wanted to post a short blog on a support issue I had. It is something I can find a couple of references to online, but not many, which tells me it’s…
-
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…
-
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”…
-
Enabling the Canadian Payroll module
In my last post, I documented where to go to get registration keys. In the last part of the post, I 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…
-
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 previous CustomerSource links are dead and buried. For future “me”, this is a reminder! This post is not covering what to do with login issues for this site, that is…
-
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 Introduction Starting from scratch Data Access What this post covers In this post, I am using the same context of…
-
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.…
-
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…
-
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.…
-
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…
-
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 people…
