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.
Canadian Payroll
Dynamics GP
Where can I find my registration keys on CustomerSource?
How to access CustomerSource to get registration keys for Dynamics GP.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & GP – SQL sources
A post in the series that covers connecting to 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, starting from scratch.
SmartList & SmartList Builder
Maximum columns in a SmartList
A short #TipTuesday about the maximum number of columns in a SmartList.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & Dynamics GP
Details about a planned series of posts on Power BI with Dynamics GP.
Canadian Payroll
ROE issue in Canadian Payroll
An ROE issue 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
How to clear the recently opened items list in Power BI Desktop.
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.
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, using Harvest as the API example.
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.
Power BI & Fabric
Power BI matrix column width sizing
A post with tips about managing the column width in matrix visuals in Power BI.
Dynamics GP
GP Upgrades – know your environment wrap-up
The last part of the know your environment part of my Dynamics GP upgrade series.