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...
SQL Query on Matomo Database to Calculate the Number of Visits to Each Page
I’ve been using for just short of four years now and have been pretty happy with it. I generally consume the data it holds via the eweb portal, but I was wanting to extract some data to manipulate recently, in a way that the web portal didn’t allow, so I did a little poking around the database to work out the syntax needed to query the database directly in mySQL. The below query returns all… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use Virtual Tables to Expose More Business Central Data in Dataverse
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1. The 2nd of the new functionality in the Adapt faster with Power Platform section is use virtual tables to expose more Business Central data in Dataverse. Use virtual… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Work Orders in Field Service, Invoice Them in Business Central
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1. The 1st of the new functionality in the Adapt faster with Power Platform section is manage work orders in Field Service, invoice them in Business Central. This integration… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. This was a question which came up recently from a client for a new project. They have some larger… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Series Index
This post is part of a series on the new functionality available in Wave 1 of Microsoft Dynamics 365 Business Central 2024. There are two release waves for Business Central each year, with functionality being released over the six months of the wave. In this series of posts, I am going to take a look at what is new with Business Central in this release wave. My understanding is the announced… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Power Automate 2024 Wave 1: Ingest Process Data from Customers’ Data Lake
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 1st of the new functionality in the Process Mining section is ingest process data from customers’ data lake. You no longer have to transform or port your data in specific sources for Process… Continue Reading Ian Grieve’s...
Working with Power Automate: What Are Environment Variables and Why Should They be Used?
This article is part of the Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. As I’ve commented in other articles, solutions should be used when developing Power Automate flows, and in fact form part of… Continue Reading Ian...
New Functionality In Microsoft Power Automate 2024 Wave 1: Use Power Platform Connectors in Power Automate for Desktop Actions
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 3rd of the new functionality in the Desktop Flows section is use Power Platform connectors in Power Automate for desktop actions. Using Power Platform connectors directly in Power Automate for… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Power Automate 2024 Wave 1: Power Fx Integration with Power Automate for Desktop
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 2nd of the new functionality in the Desktop Flows section is Power Fx integration with Power Automate for desktop. You can now create automation flows through scripting using Power Fx. Power Fx… Continue Reading Ian Grieve’s...
Multiple Record Changes Volume Limitation for Power Automate in Microsoft Dynamics 365 Business Central
This isn’t something which I have an issue with at the moment, but, when researching for something else, I came across a blog post which mentioned it and thought it was worth noting for future reference. You can configure a trigger in Power Automate for the When a record is created action in Microsoft Dynamics 365 Business Central, which will, as the name suggests, run when a record is… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Power Automate 2024 Wave 1: Set Up Fallback UI Automation Mechanism
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 1st of the new functionality in the Desktop Flows section is set up fallback UI automation mechanism. This feature provides a reliable solution for UI and browser automation actions. With this… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Power Automate 2024 Wave 1: Get Quick Insights and Recommendations in Copilot for Process Mining
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 1st of the new functionality in the Copilot for Power Automate section is get quick insights and recommendations in Copilot for Process Mining. Copilot for Power Automate Process Mining can… Continue Reading Ian Grieve’s...
Working with Power Automate: Create a Visio Diagram of a Flow
This article is part of the Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. When I work on projects with clients in areas like approvals, I always use a tool like Visio or draw.io to define the workflow… Continue Reading Ian...
New Functionality In Microsoft Power Automate 2024 Wave 1: View a Power Automate Visual in a Power BI Report
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 3rd of the new functionality in the Cloud Flows section is view a Power Automate visual in a Power BI report. This feature helps you translate insights to action. With Power Automate visual, you… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Power Automate 2024 Wave 1: Be More Productive with Power Automate and Excel Desktop
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 2nd of the new functionality in the Cloud Flows section is be more productive with Power Automate and Excel desktop. The new Automate work button in Excel Online makes it easier than ever to… Continue Reading Ian Grieve’s...
Working with Power Automate Solutions: Change the Managed Properties of a Solution Component
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. As I noted in this article, the components in a managed… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Power Automate 2024 Wave 1: Receive Intelligent License Recommendations for Admins
This post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1. The 1st of the new functionality in the Cloud Flows section is receive intelligent license recommendations for admins. This feature simplifies the license assignment process for admins and enables a… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Power Automate 2024 Wave 1: Series Index
This post is part of a series on the new functionality announced for Wave 1 of Microsoft Power Automate 2024. There are two release waves for Power Automate each year, with functionality being released over the six months of the wave. In this series of posts, I am going to take a look at what is new with Power Automate in this release wave. My understanding is the announced new functionality… Continue Reading Ian Grieve’s...
Working with Power Automate Solutions: Importing A Managed Solution
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. If you want to import a managed solution into a non-development… Continue Reading Ian...
Microsoft Dynamics 365 Business Central Developer Associate Certification Now Available
The Microsoft Certified: Dynamics 365 Business Central Developer Associate which Microsoft announced in September 2023 is now available through the Microsoft Dynamics 365 Business Central Developer MB-820 exam which is currently in beta. This developer certification complements the Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate which is available through the… Continue Reading Ian...
Working with Power Automate Solutions: Exporting A Managed Solution
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. If you are developing a Power Automate solution and are ready… Continue Reading Ian Grieve’s...
Working with Power Automate Solutions: Importing An Unmanaged Solution
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. If you want to import an unmanaged solution into an environment… Continue Reading Ian...
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...
Working with Power Automate Solutions: Exporting An Unmanaged Solution
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. If you are developing a Power Automate solution and want to… Continue Reading Ian Grieve’s...
Working with Power Automate Solutions: Version Numbering for Solutions
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. I said in the last article on publishing solutions that I would… Continue Reading Ian...
Working with Power Automate Solutions: Publish a Solution
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. As mentioned in the article where I introduced solutions, when… Continue Reading Ian Grieve’s...
Working with Power Automate Solutions: Create a Solution
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. To create a soltuion, log into the Power Automate website and,… Continue Reading Ian Grieve’s...
Working with Power Automate Solutions: Create a Solution Publisher
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. As I mentioned in the article on what a solution publisher is,… Continue Reading Ian Grieve’s...
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...
Working with Power Automate Solutions: What is a Solution Publisher?
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. Every solution requires a publisher; if you don’t create one,… Continue Reading Ian...
Working with Power Automate Solutions: What Types of Solution Are There?
This article is part of the Working with Power Automate Solutions series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. As I briefly mentioned in the last post, where I introduced… Continue Reading Ian Grieve’s...
Working with Power Automate: What Are Solutions?
This article is part of the Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC. A solution is how you can implement ALM (Application Lifecycle Management) with Power Automate. A simple way of viewing a… Continue Reading Ian Grieve’s...