MADIC dynamics Knowledge Hub Webinars: Jet Reports & Business Central
In our most recent webinar here at MADIC dynamics, we took a look at Jet Reports & Business Central. If you want to catch up on this webinar, you can do so here. Introduction Available Functions Fast Financials Jet Function (Jfx) Report Wizard Browser Table Builder Conclusion Introduction ^ In this webinar we took a look at Jet Reports & Business Central. Jet Reports is (probably) the… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
This article is part of the In Microsoft Dynamics 365 Business Central (Administration), 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. One thing I wasn’t initially aware of when you create a company in Business Central, is that the company actually has two… Continue Reading...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
This article is part of the In Microsoft Dynamics 365 Business Central (Administration), 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. A while ago, in this series, I covered how to use list pages in Business Central and also posted some links to advanced… Continue Reading Ian...
Splitting a Table on a Microsoft Dynamics 365 Business Central Word Template
This technically isn’t a Microsoft Dynamics 365 Business Central issue, but I encountered it when working on a Word template from Business Central. The same action will work for any table in Microsoft Word regardless of what data is in the table. I was doing some work for a client, adapting the layouts of the Word templates used to produce documents such as the sales invoice. The client asked… Continue Reading Ian...
Preview of Microsoft Dynamics 365 Business Central 2024 Wave 2 Investment Areas
Microsoft have released a preview of some of the functionality slated for Microsoft Dynamics 365 Business Central 2024 Wave 2. The functionality has been broken down into four areas: Core functionality AI and collaboration Ease and speed of implementation World class service The functionality slated for inclusion includes: AI powered business Finance Collections improvements Regulatory… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Access Worksheet Pages from Mobile Phones
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 4th of the new functionality in the User experiences section is Access worksheet pages from mobile phones. Expanding access to more Business Central areas from a… Continue Reading Ian Grieve’s...
Microsoft Excel Showing Formula Instead of Result
I was doing some work with a client a while ago and encountered a problem with Excel where it was showing me the formula in a call, rather than the result of the formula. I have no idea if the spreadsheet was sent to me with the formulas set this way (I’m not sure if this is possible) or if I inadvertently hit the keyboard combination to enable the setting at some point (Alt + M and then Alt +… Continue Reading Ian...
VAT Bus. Posting Group Error in Get Shipment Lines in Microsoft Dynamics 365 Business Central
While working with a client recently to implement Microsoft Dynamics 365 Business Central, they reported an error to me during UAT when trying to test the sales process. They’d raised and shipped a sales order and were now trying to use the Get Shipment Lines function on the Sales Invoice page, but when selecting the shipment lines they were receiving this error: VAT Bus. Posting Group must… Continue Reading Ian...
Error Calculating Depreciation in Microsoft Dynamics 365 Business Central: “No journal lines were created”
I helped a client implement the Fixed Asset Management module in Microsoft Dynamics 365 Business Central recently; during training I showed them how to configure and use the module and also created configuration packages for them to import both the fixed asset itself as well as the acquisition and depreciation to date. After importing the assets into Business Central with a net book value up… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Mass Insert Item Pictures
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. Business Central allows pictures to be attached to each item on the Item card page, but doing it… Continue Reading Ian...
Microsoft Dynamics 365 Business Central Configuration Package Import Error: “The package code in all sheets of the Excel file must match the selected package code…”
I’ve been doing some work with a client recently to implement Microsoft Dynamics 365 Business Central. We created a number of different configuration packages to import data into different areas of Business Central which were used without issue. However, when we came to import the fixed assets, we received an error during import: The package code in all sheets of the Excel file must match the… Continue Reading Ian...
Item No. Field Missing from the Item Card Page in Microsoft Dynamics 365 Business Central
While implementing Microsoft Dynamics 365 Business Central for a client, they reported an issue during UAT where they couldn’t set the No. for new items as the field was missing from the Item Card (30) page. My initial thought was that the user had inadvertently removed the field from the page using personalise, but they had asked other users to try and they had the same issue. The other… Continue Reading Ian...
New Functionality In Microsoft Power Automate 2024 Wave 1: View Attended Desktop Flow Runs Using Picture-in-Picture Execution Mode
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 9th of the new functionality in the Desktop Flows section is view attended desktop flow runs using picture-in-picture execution mode. The flow run does not interfere with the user’s work on the… Continue Reading Ian...
New Functionality In Microsoft Power Automate 2024 Wave 1: Connect Your Own Virtual Network with Hosted Machine Group
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 8th of the new functionality in the Desktop Flows section is connect your own virtual network with hosted machine group. Users can run desktop flows using a hosted machine group connected to their… Continue Reading Ian Grieve’s...
Error When Connecting Jet Reports to Microsoft Dynamics 365 Business Central for the First Time
While implementing Microsoft Dynamics 365 Business Central recently for a clinet, we also implemented Jet Reports. After installing the extension in Business Central, I created a data source and tried to log in, but received this error message: Jet reports Sorry, but we’re having trouble with signing you in. AADSTS90099: The application ‘~~~~~~~’ (Jet Reports) has not been authorised in the… Continue Reading...
New Functionality In Microsoft Power Automate 2024 Wave 1: Generate Flow Description Using AI
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 7th of the new functionality in the Desktop Flows section is generate flow description using AI. Users are able to generate a description of a flow without having to analyze the actions inside it.
New Functionality In Microsoft Power Automate 2024 Wave 1: Use Azure Key Vault Credentials in Flow Connections
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 6th of the new functionality in the Desktop Flows section is use Azure Key Vault credentials in flow connections. Users can leverage credentials from Azure Key Vault to connect to Windows sessions… Continue Reading Ian Grieve’s...
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 weeks with only a carry-on bag, so I’m glad to be home and wearing different clothes for a… 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 from the US Payroll module side of things in Dynamics GP. For Canadian Payroll users who use the HR… 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. 😄 ChallengeMicrosoft Learnpspier (Full URL:
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...