Error Message “The request was blocked by the runtime to prevent accidental use of production services” in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business CentralI was doing some work with a client recently to implement Microsoft Dynamics 365 Business Central. While testing in a sandbox environment we encountered an issue when trying to email using the Continia Document Output module.

This error is no just with that module, but with any module or functionality which tries to make outward requests; as a security measure the ability to make outward requests is switched off when the sandbox environment is created.

Error message trying to email using Continia Document Output

The request was blocked by the runtime to prevent accidental use of production services

Continue reading “Error Message “The request was blocked by the runtime to prevent accidental use of production services” in Microsoft Dynamics 365 Business Central”

Error Creating a Sales Quote in Microsoft 365 Business Central: “The field Location Code of table Sales Header contains a value (NEWCASTLE) that cannot be found in the related table (Location)”

Microsoft Dynamics 365 Business CentralOn a recent project I helped a client implement Microsoft Dynamics 365 Business Central. When they started doing UAT, they received an error on sales quotes (and we then verified other sales documents):

Error entering sales quote

The field Location Code of table Sales Header contains a value (NEWCASTLE) that cannot be found in the related table (Location)

Continue reading “Error Creating a Sales Quote in Microsoft 365 Business Central: “The field Location Code of table Sales Header contains a value (NEWCASTLE) that cannot be found in the related table (Location)””

In Microsoft Dynamics 365 Business Central (Administration), how do I… Edit Data in Excel

Microsoft Dynamics 365 Business CentralThis 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.

Business Central allows users to export data to Excel from list and worksheet pages by either using the open or edit option. If you choose the open option, then the data is simply exported into a static Excel workbook, which you can then manipulate or share with someone else.

If, however, you take the edit option, you can edit the exported action and import back into Business Central.

To edit data in Excel, open a list page and apply whatever filters you need; the export will only be data loaded on the page, so you can pre-filter before exporting to Excel, such as limiting the page to only current period data.

Click the share button in the top right and select Edit in Excel:

Chart of Accounts list page with share menu open

Continue reading “In Microsoft Dynamics 365 Business Central (Administration), how do I… Edit Data in Excel”

Why Migrate from Microsoft Dynamics GP to Microsoft Dynamics 365 Business Central?

Microsoft Dynamics GPI spent 19 years working with Dynamics GP before I made the decision to switch to working with Business Central. My main reason for moving away from Dynamics GP is the same as many of the clients and prospects I have spoken to over the last few years; it was the expected future of Dynamics GP, or actually now the confirmed lack thereof, with the end of life announced in September last year.

Even with the only announcement of the end of licence sales to new customers starting with perpetual licences in 2025 and then subscription licences in 2026, conversation around projects to replace it with a new system were starting to intensify, something which only increased pace with the end of life announcement.

While the end of life is a few years in the future, and if you have perpetual licences, you will be able to continue using Dynamics GP after this date, my best advice is to start looking at a replacement system now, while you can do so with some leisure, giving time for full consideration of options.

There are many alternative ERP systems in the marketplace, aimed at a variety of sectors and business sizes and it is difficult to say that one solution fits all. Some of the smaller clients with only a handful of users are considering Xero, while larger organisations are looking at systems like NetSuite and, especially, Business Central.

It is the last of these, Business Central which I selected as the product to switch to when I moved away from working with Dynamics GP. I did look at a few of the alternatives, both in terms of the software, but also the companies who implemented and provided consultancy services, and ultimately decided that remaining within the Microsoft ecosystem was the natural choice for me with my experience and skill set.

Staying within the Microsoft ecosystem gave me a choice; Business Central or Finance & Operations (or whatever Microsoft are now calling it). I ultimately decided on Business Central as it serves a similar market as Dynamics GP, both in terms of the type, but also the size of organisations.

It is an ERP system which scales very well from a handful of users up to several hundred; Microsoft typically target it at organisations with a turnover of up to £500m, showing how scalable it is considered. Licencing is based on the number of users, which means it scales quite well price-wise as well as in terms of functionality.

It has almost all of the same modules as Dynamics GP, US and Canadian payroll excepted, but these aren’t modules which are a concern for the clients with whom I work as they are typically UK and/or Ireland based.

So for a company using Dynamics GP, what makes Business Central the best replacement for Dynamics GP?

First, it is a Microsoft product and part of an ecosystem which is very familiar to users of Dynamics GP. There is full integration with Microsoft products such as Office, Azure and the Power Platform. Business Central’s integration with these products is much tighter than that of Dynamics GP, which would require additional products like OData Service or custom development to be done to integrate with some of these other Microsoft products; Business Central has this integration as standard.

Second, starting from Dynamics GP 10, both Dynamics GP and Dynamics NAV started to look more and more alike, with changes to the UI in both systems bringing them together. Business Central is a descendant of NAV and still shares a very similar look and feel to Dynamics GP, and especially of the Dynamics GP web client. This means that users are able to adapt quite quickly to Business Central, in a way that they potentially won’t with other non-Microsoft systems.

Third, in addition to the training provided by Business Central partners, like MADIC dynamics where I work, there is also a lot of material available directly from the Microsoft Learn platform and bloggers like myself.

My articles on Business Central are largely contained within these series:

Fourth, Business Central is provided by Microsoft using the Software-as-a-Service (SaaS) model which means it is both scalable and stable, with Microsoft guaranteeing a 99.9% uptime. The platform is designed to be scalable so that a busy system is allocated more resources, so that performance doesn’t decrease in the way that an on-premises system will when it gets overloaded with users. Stefano Demiliani, a Microsoft MVP, did a good article late 2023 on how Business Central scales when there is a lot of processing happening.

As a SaaS system, it is also available to users via the web browser, or app, on any device size wherever the user happens to be; all they need is an Internet connection and they can access Business Central.

Fifth, Business Central has, through it’s integration with Power Automate, much better workflows available to it that Dynamics GP. These workflows are not just limited to workflow approvals, but allow all different automated processes to be created, including data extracts and updates as well as approvals. There are hundreds of actions available which allow you to interact with Business Central, as well as Microsoft favourites like One Drive for Business and SharePoint, but also many third party web services, including DocuSign.

Sixth, Business Central is automatically updated with new releases as they become available. You can delay the upgrade of a live system for a period of time while you do testing on a sandbox environment with a copy of the production system. These upgrades are included within the licencing for Business Central so there is no cost for the upgrade and little, if any, consultant or support time is required for a standard system. This substantially reduces the cost of ownership of the product as you don’t need to pay a consultant to upgrade your system.

Seventh, Business Central is being heavily invested in by Microsoft, with dozens upon dozens of enhancements being released twice a year in the release waves, available in April and October. This includes both new and improved functionality and also rapid deployment of AI Copilot technologies into Business Central for improved performance.

As I said near the start of the article, I did look at alternatives to Dynamics GP by looking into some of the other ERP available before I made my decision to switch to Business Central; I opted for Business Central as it seemed to be the best of the alternatives for the types of clients with whom I am used to working for the reasons outlined above.

Vivaldi Crashes Immediately When Launching

Microsoft Dynamics 365 Business CentralI started testing Vivaldi when it was (I’m pretty sure) still in appha and mainly using it when it was a beta version. They’ve refined and improved the browser regularly since. One of the features they added was workspaces, which allows you to have a multiple sets of tabs in the browser without needing a separate profile.

I’ve started using both profiles and workspaces on my work laptop, allowing me to keep different work streams separate.

Unfortunately, I have recently started having problems with one of the profiles once I hit a certain number of workspaces. I’ve reduced the workspaces, but the problem persists.

The problem is that when I try to start that browser profile, all Vivaldi windows close. A first I was stuck with not being able to open the browser profile, until a did some exploring and found mention of the sessions folder which, if cleared, allowed the browser to be opened again.

The default sessions folder is %localappdata%\Vivaldi\User Data\Default\Sessions.

My issue was not with the default profile, but a secondary one, so I had to identify the Person n folder and deleted the sessions in there. After I launched Vivaldi I was able to use history to reopen all of the tabs which had been lost when the session was deleted.

I also found that if I left the files prefixed TABS_, they I could, once the browser was open restore the closed tabs through the Show closed tabs button.

The problem continues to recur, so the above only seems to be a temporary workaround; I think I will need to export the bookmarks and then delete the profile and create a new one to get rid of the problem permanently (or at least until it goes wrong again).

Error Entering Sales Invoice in Microsoft Dynamics 365 Business Central: “There is no Currency Exchange Rate within the filter…”

Microsoft Dynamics 365 Business CentralA client I’ve been working with recently has been implementing Microsoft Dynamics 365 Business Central. We did basic system configuration and then training to the users so they could go through and set up all of the companies (there was more than a dozen spread across several countries.

After they had done the company setup for the various countries, they were doing some UAT when they encountered an error when trying to raise a sales invoice:

There is no Currency Exchange Rate within the filter…

There is no Currency Exchange Rate within the filter…

Continue reading “Error Entering Sales Invoice in Microsoft Dynamics 365 Business Central: “There is no Currency Exchange Rate within the filter…””

2024, A Year in Numbers

Microsoft Dynamics 365 Business CentralI’m always interested in the breakdown of areas I write about and regard some areas as my main ones; I am a Microsoft Dynamics 365 Business Central functional consultant, so that is naturally my main area of writing; I have started working with Power Automate, mainly in relation to Business Central, and am regarding it as one of my new main areas and have published an increased umber of articles on it this year; I develop plugins for ClassicPress to support what I do on this site, so do often write a fair bit about doing that, although I seem to have got through 2024 without writing a single one; I was, before starting to work with Business Central, a Microsoft Dynamics GP specialist, but have only five articles on GP this year and likely not many to come as I no longer work with it and its end of life has been announced.

The articles I published in 2024 break down into my main four areas like this:

Continue reading “2024, A Year in Numbers”

Stop Autoplay of Gifs in Microsoft Teams

Microsoft Dynamics 365 Business CentralMost companies using Microsoft products in anything other than a minor way will also be using Microsoft Teams, which allows for communication and collaboration. The last few companies I’ve worked at have all used it, so I’m fairly used to it now.

Usually the chat feature is good, allowing you to communicate with others, but we have a developer who makes use of gifs in response to messages. All well and good I suppose as they do carry their own message, but I hate gifs (or other animations) which are moving on the page when I’m trying to read.

I looked for and failed to find a setting to allow me to switch off autoplay of gifs without success and did an online search for it. I did find references to a setting, Turn off animations (I’d missed it as I was looking for something referring to autoplay and/or gif), but it was not where the search results were saying.

A bit of exploration and I found it in the settings under Appearence and accessibility:

Appearence and accessibility » Turn off animations

Toggle the setting and gifs will no longer play (and other animations won’t play either, so a double win).

The New Subscription Billing Module is Installed by Default Upgrading to Business Central 2024 Wave 2

Microsoft Dynamics 365 Business CentralIn Business Central 2024 Wave 2, Microsoft has introduced a new Subscription Billing module which allows for the management of subscription contracts in Business Central for recurring revenue streams.

All good so far. However, the module is installed by default and introduces a number of new pieces of data, including number series, source codes, job queues and more (including even a dimension!).

It seems odd that Microsoft is splitting some functionality into separate apps that need to be installed, while at the same time installing a brand new app by default.

The issue here is that beyond the module and data being introduced, it is introduced into every single company. Even when the app is uninstalled, the data remains behind, meaning the data needs to be removed from every company.

Eric Wauters has a full write-up and steps to remove all of the different pieces of data which the module introduces.

One point he makes is that while Microsoft say they are working on a fix, it does seem impossible for them to fully tidy up what has been installed by the module, as there is a risk that some of the data they introduce is already present for another purpose (the introduced dimension is called CUSTOMERCONTRACT for example, or at least it is in English language environments; in others it will be translated into the relevant language).

Following Eric’s steps will allow you to tidy up the system now to ensure none of it is inadvertently used, but need to do so in every company in the upgraded environment.