In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
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. If something catastrophic happens with your Business Central system, then it is possible to do a point in time restore of… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
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. When you delete an environment, it is first soft deleted for a fourteen day period in which you can restore it, after which… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
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. When you sign up for a Business Central trial, a production environment is created for you; if you sign up in other ways,… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete 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. Deleting companies in Business Central is quite easy to do and reinforces why security in Business Central should limit… Continue Reading Ian...
Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (May-Jul 2024) from MADIC dynamics
Every month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting some of the webinars, but other consultants will be getting involved as well, so there will be a variety of presenters through time. We aim to have the next three monthly Knowledge Hub Webinars scheduled and… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment
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. I am doing some work implementing Business Central for a company which will be changing their name before too long and… Continue Reading Ian...
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...
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...
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...