2022 Year in review
Reflecting on 2022 including a look back at how my reviews have trended over the years, as well what I hope 2023 will bring.
Personal
Dynamics GP
Resource not found in dictionary error
Troubleshooting the “Resource not found in dictionary” error in Dynamics GP, including some tips around how to troubleshoot it.
News
MVP Renewal for 2022/2023
Celebrating my Microsoft MVP Award renewal for 2022-2023 in Business Applications, a surprising one since I didn’t feel I had the contributions.
Dynamics GP Microsoft Office
Dynamics GP Email – Login Failed error
Troubleshooting the error “Login Failed: check your login information and try again”, for the Exchange Log On prompt in Dynamics GP.
Canadian Payroll
Enabling the Canadian Payroll module
In this post I’m documenting some of the basic steps for enabling the Canadian Payroll module in Dynamics GP.
Dynamics GP
Where can I find my registration keys on CustomerSource?
Learn how and where to access CustomerSource to get registration keys for Dynamics GP. It seems to be harder to find these days!
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & GP – SQL sources
A post in the series that covers connecting to Dynamics GP databases in SQL directly in Power Query.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & GP – Data Access
The third post in the series, discussing data access considerations and options to securely handle your data in a report.
Microsoft Excel Power BI & Fabric Power Query
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.
SmartList & SmartList Builder
Maximum columns in a SmartList
Learn what happens when you attempt to add too many columns in a Dynamics GP SmartList! Hint: 299 is the maximum!
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & Dynamics GP
Learn about using Power BI to report on Dynamics GP data, starting with some basic approaches to getting started.
Personal
2021 year in review
Changing up the format from “resolutions” to “review”. Reflecting on 2021 achievements and plans for 2022.
Canadian Payroll
ROE issue in Canadian Payroll
An ROE issue in Dynamics GP Canadian Payroll where Box 15B does not generate the correct value on the printed report.
Power Query
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.
Power BI & Fabric
Clear Recent Items list in Power BI Desktop
Learn how to clear the recently opened items list in Power BI Desktop, which doesn’t behave the same as other Office apps.
Power Query
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.
Power Query
Connecting to ClickUp in Power Query
The 3rd post in the series, this one about the ClickUp API and how to connect to it with Power Query.
Power BI & Fabric
Power BI number formatting tips
Two tips for formatting numbers in Power BI, replacing zeroes with dashes and displaying something other than blanks.
Power Query
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.
Power Query
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.