SQL – Search for special characters
Sometimes it may happen that by importing data from external sources (even with Web Services), some special characters are written and then uploaded to NAV \ Business Central. These characters (even if accepted) could then give problems to searches, XML exports, blocking the sending of documents. How to find them quickly? It is possible to execute an SQL query that checks all the ASCII… Continue Reading rs’s Article on...
Dynamics 365 Translation Service Visual Studio Code extension (Public Preview)
Very interesting Microsoft public extension, still in preview mode but already usable (i did some tests); the convenience is that it can be used within VSCode, calling the translations services directly. The Microsoft Dynamics 365 Translation Service (DTS) extension for Visual Studio Code (VS Code) lets users interact with DTS from the VS Code editor. This extension was created for… Continue Reading rs’s Article on their...
Worflkow in Business Central, in Power Automate and Instant Flows
Hi, a few days ago a demo was made on: Worflkow integrated in Business Central Workfow with Power Automate Some differences between the methodologies and how to best use them were explained, in addition there was talk of Instant Flows and Power Automate Desktop. In the case of the instant flow it was shown how to quickly implement them directly from Business Central…. Continue Reading rs’s Article on their blog Worflkow in...
Business Central 2022 Wave 2 preview is available
Microsoft Dynamics 365 Business Central 2022 Wave 2 preview (r.21) The preview of Business Central 2022 Wave 2 (release 21) was released and made available today; you can test it both Online and on Docker. It is only possible to create Sandbox preview and non-production environments; the preview environments are for demonstration purposes only and to have their functionality tested, they are… Continue Reading rs’s Article...
Upload Files to SFTP via Powershell
Hello everyone. I was asked how to upload files to SFTP from Business Central, there are several ways to do it and several posts published about it for Business Central. In this case, without going through other Azure services, PowerApps etc., it is possible to do it directly and simply via Powershell and, given that the previous post on Powershell was quite successful, I also report this… Continue Reading rs’s Article on...
C# Cortana Business Central Online APIs Commander
C# Cortana Business Central Online APIs Commander This simple C# application allows you to invoke Business Central administrative APIs directly from a Windows Form. It is possible to recall most of the existing functions from the APP, in particular it can be useful for Update all APPs quickly Create, Copy and restart environments Manage Sessions Avoid using powershell This Windows Form app… Continue Reading rs’s Article on...
Role Centers in Business Central
Business Central “Role Centers” The Role Center is the user’s entry point and home page for Dynamics 365 Business Central. You can develop several different Role Centers, where each Role Center is customized to the profile of the intended users. Role Centers are based on a “user-centric” design model. You should design a Role Center to give users: – Quick access to the information… Continue Reading rs’s Article...
Resolve Merge Conflicts using “Pull Request Merge Conflicts” Microsoft DevOps Extension
While there are different ways and tools to handle the issue, in this post we will use a Microsoft standard extensions for DevOps to resolve merge conflicts within Azure DevOps. The extension is called “Azure DevOps Pull Request Merge Conflicts” and is available in the marketplace (free). The problem of the conflicts in the merge can reveal itself during pull requests to merge branches, or… Continue Reading...
What’s new and planned for Dynamics 365 Business Central 2022 Wave2
This topic lists features that are planned to release from October 2022 through March 2023. Because this topic lists features that may not have released yet, delivery timelines may change and projected functionality may not be released, SOME NEWS Development This release continues investments in improving AL developer productivity in Visual Studio Code. FeatureEnabled… Continue Reading rs’s Article on their blog...
Business Central Online, quick comparison and detection of differences between table data structures using Powershell
Business Central Online, quick comparison and detection of differences between table data structures using Powershell Previously it was possible to export data structures to files (available in runtime1), the functionality was blocked from runtime 2 onwards. Interesting function that in my opinion should be reinserted and made usable at least for On-premise. <img loading=”lazy” width=”473″...
MVP Business Applications 2022-2023, seventh time in a row!
Thanks to Microsoft & MVP award team! Seventh year, given the numerous competitors, even more precious !! My thoughts for 2022-2023 Business Central Online “First”. Cloud, Cloud, Cloud.. APPs, APPs, APPs …automation, Integrations, Cloud Data Lake, New Ideas, more courses & video. Follow me Please follow me on Twitter @robstefane Linkedin… Continue Reading rs’s Article on their blog MVP Business...
Business Central working with dates
I want to report some information collected from several parts on the calculation of dates through dateformulaand calcdate, since they are very used. It could be useful, especially for those new to Business Central. AssumptionsC = CurrentD = DayW = WeekM = MonthQ = QuarterY = YearCD = Current DayCW = Current weekCM = Current month CM -> last date of the current month<-CM> ->… Continue Reading rs’s Article on...
Search for a string (or a TAG) in .al files with Powershell
Search for a string (or a TAG) in .al files with Powershell Migrating, upgrading, recoding & refactoring the older versions of Dynamics NAV to Business Central you will (or can find) find a lot of documentation tracked both in the Documentation and development notes \ TAG sections within the code. By loading these sources into Azure DevOps you can use the Microsoft built-in search function to… Continue Reading rs’s...
Business Central data exported in Azure Data Lake
Azure Data Lake? Azure Data Lake includes all the capabilities required to make it easy for developers, data scientists, and analysts to store data of any size, shape, and speed, and do all types of processing and analytics across platforms and languages. It removes the complexities of ingesting and storing all of your data while making it faster to get up and running with batch, streaming,… Continue Reading rs’s Article...
Business Central and Shopify Connector
Today I want to talk to you about the integration of Business Central with Shopify, I tested the tool and I must say that in a few minutes you are online with both platforms and with a good integration. Sure there are many ecommerce platforms (B2C) available with related integrations but this one is very simple and ready to use. Shopify Connector Features – Summary What can we do? Multiple… Continue Reading rs’s Article on...
Export SQL data to CSV or XML File via Powershell
Export SQL data to CSV or XML File via Powershell Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file…. Continue Reading rs’s Article...
Business Central from Directions NA, “Pictures are worth a thousand words..”
Although very late, I publish some pictures recovered from social networks and related to Directions NA held last week. The 2022Wave1 release of Business Central was presented at Directions NA (Orlando, Florida, 2-6 Apri), the official product lanch day will be on April 20th. There are many news and interesting ideas, I tried to collect some pictures of the most significant innovations… Continue Reading rs’s Article on...
Used and not used Objects in Business Central license
I publish a simple APP that allows you to see not Used objects compared to those assigned in customer license (useful on BC On-premise). For example, the customer can extract the list of all objects loaded in the APP as customizations. Even if the objects numbered 50000 are practically free to use for the Cloud, the Onpremise ones are licensed; with a specific report it is possible to identify… Continue Reading rs’s...
Business Central: Performance & Data management tools recap
Performance and data management tools available in Business Central In this post I want to summarize some of the features present in Business Central (up to preview version 2022Wave1) related to performance and data tools. Microsoft has been very attentive to performance for a long time and requires that those who develop the APPs be too, so it is making more and more tools available for… Continue Reading rs’s Article on...
Excel Layouts for reporting
Excel layout This new interesting new feature has already been released in the public preview of BC2022 Wave1 Info from Microsoft (toDate) Excel layouts in v20 are not translatable (Microsoft will add this later). Then, the headers will be just the AL field names, or you can choose to only support one user language. Either way, this should be enough to get started… Continue Reading rs’s Article on their blog Excel Layouts...
Dynamics 365 Business Central 2022 Wave1 (r.20) public preview is available
The preview of Business Central 2022 Wave1 (release 20) was released and made available today; you can test it both Online and on Docker. It is only possible to create Sandbox preview and non-production environments; the preview environments are for demonstration purposes only and to have their functionality tested, they are removed at most thirty days after the official release of the… Continue Reading rs’s Article on...
Universal Code Initiative Program: Cloud-optimized extensions
Universal Code Initiative Program: Cloud-optimized extensions Approach to the initiative Write ‘Cloud’ target code – Cloud Ready Software In general, Microsoft wants to reward those who develop cloud ready software and increasingly try to limit customizations of 1st party extensions (typically Base Applications). This is the main purpose, the driver, which guides the Universal Code… Continue Reading rs’s...
What’s planned for Business Central 2022 Wave1
What’s planned for Business Central 2022 Wave1 The features that will be released in Business Central 2022 Wave1 have been announced (released in April and in Preview from March as has been the case for some years now) Below are some that I think are very interesting, for the details and the complete list of features you can see the link to the page on Microsoft Docs. Application Allow the… Continue Reading rs’s...
Business Applications Cloud Week for Partners, February 28-March 4, 2022
Business Applications Cloud Week for Partners, February 28-March 4, 2022 Business Applications Cloud Week for Partners is a virtual skilling event designed to demonstrate the power of Dynamics 365 and Power Platform. This week-long training experience will result in deeper knowledge on sales and technical capabilities, allowing participants to not only deliver exceptional services to… Continue Reading rs’s Article on...
REST API integration in S2S (Service to Service)
REST API integration in S2S (Service to Service) The consumption of the Business Central REST APIs via OAuth2 authentication has as a prerequisite an AAD user who has been associated with a paid license of Business Central. With Business Central 2021 release wave 1, release 18.3 or later, Microsoft introduces S2S authentication:
Business Central: Send an appointment from Job Planning Line
Feature In addition to using Business Central in Outlook, a feature that I think is interesting is that of being able to send an appointment to the planned resource directly from the job planning lines. This is not comparable to the mail sending functions present in the service module (there are some limitations) but it is still interesting and useful; we are moving towards project management… Continue Reading rs’s Article...
Azure AI in Business Central – The Forecasting Model
Azure AI in Business Central – The Forecasting Model AI (Artificial Intelligence) can be used with Business Central; there are different possibilities of use and integration of Azure AI in Business Central. The technology integrated with Business Central is based on Azure Machine Learning, Azure AI Framework, Subscription and Web Services. Subscriptions for Business Central come with access… Continue Reading rs’s...
Business Central Online 19.1, 2D Barcodes Fonts are available
Business Central Online 19.1, 2D Barcodes Fonts are available Yes, 2D Barcode Fonts are real. Business Central Online includes the following one-dimensional (1D) and two-dimensional (2D) barcode fonts and symbologies from IDAutomation. The fonts have different specifications for characteristics like encode numbers, symbols, uppercase, and lowercase text. Knowing the specifications is useful… Continue Reading rs’s...
Business Central Online: “Restart Environment” feature is available
Hi, good news for today! The long-awaited feature has finally been released: the Restart of environments. Great! Restart is available for all environments, Sandboxes and Production. “How-to restart” and Environment The procedure is very simple. Select the Environment Ex: Production Open “Sessions” Click on “Restart environment” button “Confirm” and wait for completition. Have a… Continue Reading rs’s Article on...
Business Central Design Patterns & Best Practices
Business Central Design Patterns & Best Practices a New project… and a new site “This site is meant to house some of the community’s knowledge about Microsoft Dynamics 365 Business Central AL Development best practices, particularly around hosting Design Patterns” Site & GitHub Home :: AL Guidelines This site is meant to house some of the community’s knowledge about Microsoft Dynamics 365 Business Central AL Development...
Tech Academy Dynamics 365 Business Central 2022
Tech Academy Dynamics 365 Business Central 2022 Alterna sta organizzando una Tech Academy per formare i nuovi Sviluppatori Microsoft Dynamics 365 Business Central per la sede di Gravellona Toce (VB), Lainate (MI), Casalecchio di Reno (BO), Frascati (Roma) Cerchiamo candidati, sotto il link. link
Business Central Online: why should we choose an entirely cloud-based ERP system in 2022? PART I
I had already written an article in 2018 and one in 2019 on Business Central Cloud, now I am writing one to understand the status of the product at 2022 and why it is necessary to adopt it. The New Year is just around the corner! Business Central Releases Battle Cards, 2019 MSDYN365BC On-premise VS Cloud (SaaS) Battle Cards Microsoft Dynamics 365 Business Central ( MSDYN365BC) is a business management solution for small and...
DIRECTIONS EMEA 2021, SOME NEWS FROM MILAN
DIRECTIONS EMEA 2021, SOME NEWS FROM MILAN For various reasons, this year I am not present at Directions EMEA in Milan. However, in the evening I collected some images published today by the participants and some colleagues, I republish the most interesting ones I found, they could be useful for those who were not present at the event. By the weekend I will update the post with more images and… Continue Reading rs’s...
See what’s next for Dynamics 365 Business Central 2021 release wave 2: Register Now!
Be the first to get an in-depth look at the new features and capabilities for 2021 release wave 2. Join us for the Dynamics 365 Business Central Launch Event, where you will find 15 on-demand sessions. The Launch Event is a bit different this time, compared to the last launch events. Once you register, you’ll immediately get access to the 15 on-demand sessions that will be available… Continue Reading rs’s Article on...
Business Central: “The New Time Sheet experience”
The New Time Sheet Experience Many employees use time sheets, and as the time sheet administrator or manager, you want to make sure that Business Central has you covered when you create time sheets for the first time, or you add an employee or resource to record the time spent on tasks. The New Time Sheet Experience You can now use the “Set Up Time Sheets assisted setup” guide to… Continue Reading rs’s Article on their...
Business Central 2021 Release Wave 2 (rel. 19) is available!
Today October 1 2021, “Business Central 2021 Release Wave 2” is available Online (Cloud SaaS) and on Docker distributions, soon the On-premise installation DVD will be available. All what’s new for this October’s release can be found on the ms-docs page (below the link) New customers will automatically get the latest builds of Business Central 2021rw2 (version 19).
Security in Dynamics 365 and in Business Central Online
Security in Dynamics 365 and in Business Central Online Some customers ask for information on the security of systems in the cloud world and also on Business Central Online; Business Central being part of the Dynamics 365 suite, it uses the same security framework as the other products. The whole Dynamics 365 Online suite is secure, everything is controlled in multiple points and with multiple… Continue Reading rs’s...
Business Central OneDrive CloudStorage integration
Onedrive integration in Business Central With business central you can use OneDrive to save documents from Business Central; in practice it is possible to use your own personal Onedrive drive (if you already have one activated) or create it on the fly by passing through Sharepoint online. The use of Onedrive integrated in BC can be done in two ways: Classic (folder on disk) Modern (via .ASPX… Continue Reading rs’s Article...
Dynamics 365 Business Central 2021 Wave2 preview is available
Microsoft Dynamics 365 Business Central 2021 Wave 2 preview The preview of Business Central 2021 Wave 2 (release 19) was released and made available today; you can test it both Online and on Docker. It is only possible to create Sandbox preview and non-production environments; the preview environments are for demonstration purposes only and to have their functionality tested, they are removed… Continue Reading rs’s Article...
Business Central Insider Releases Artifacts
Business Central Insider Releases Artifacts Some have asked me about the Insider releases of Business Central; you can find some information on Microsoft Docs about specifics but in order to download these versions, you need to use the ready-made, published and available artifacts insider releases. Insider Release Artifacts These versions are made available to be able to test the new… Continue Reading rs’s Article on...
Dynamics 365 Business Central 2021 Wave 2 – Plan and prepare!
Dynamics 365 Business Central 2021 Wave 2 – Plan and prepare! Business Central 2021 Wave2 (release v.19) is expected to be launched in early October; I want to point out some features news of the product that I consider interesting (there are many …) For all the news and features, I refer you to the links below which contain everything that will be released between October 2021 and March… Continue Reading rs’s...
Word Layout Reports: repeat header lines on every page with Word 2019
Word Layout Reports: repeat header lines on every page with Word 2019 In Microsoft Word 2019 there is a property that allows you to determine if a row should be repeated for each page (Header Lines). This option saves us from inserting in the header, for example: “column names”, for example this tip eliminates the problem of aligning the column name row with the data (that after each… Continue Reading rs’s Article on their...
2021 Wave 2 Release plans for Dynamics 365 and Power Platform released
Dynamics 365 & Power Platform Plans Here are the links to the external release plans; the PDF copy is available when you access these links · https://aka.ms/Dynamics365Wave2ReleasePlan · https://aka.ms/PowerPlatformWave2ReleasePlan Dynamics 365 Business Central Plan for Release 2021 Wave2 (r.19) This topic lists features that are planned to release from October 2021… Continue Reading rs’s Article on their blog 2021...
Business Central rel. 18.3 – The “Data Administration” Page
Business Central rel. 18.3 – The “Data Administration” Page In Dynamics 365 Business Central, administrators have different options for handling table and database sizes; until now, these options have been available through several different pages and roles. With this new page, all processes are displayed in a single place. An in-product assistant can be used for guidance. These features… Continue Reading rstefanetti’s...
Update 18.3 for Microsoft Dynamics 365 Business Central online 2021 release wave 1
Below you’ll find an overview and relevant links to what has been done on hotfixes and regulatory features in this update. In addition, we have gathered some good to know information and links, you might find interesting. Feature changes Export any List to ExcelService-to-service authenticationDimension issues detection and repair toolIntegration of Word templatesData administration… Continue Reading rstefanetti’s...
Business Central OAuth 2.0 Get Token from AL Codeunit – massive apps update
Business Central OAuth2.0 Authentication – Access granted by Token OAuth2 authentication method, this type of connection can be used to connect to Business Central Admin APIs; the system to access the exposed APIs services uses a token issued by the access procedure, it is possible to use different ways to get the token released. How to retrieve tokens… In recent development courses… Continue Reading rstefanetti’s Article...
MVP 2021-2022, six times in a row!
Great! L’articolo MVP 2021-2022, six times in a row! proviene da Roberto Stefanetti Blog. Continue Reading rstefanetti’s Article on their blog MVP 2021-2022, six times in a row! – Roberto Stefanetti Blog Great! Blog Syndicated with rstefanetti’s...
Directions EMEA | Milan October 27-29 – registration is open!
Directions EMEA | Milan October 27-29 – registration is open! Reconnect with the Dynamics 365 community at Directions EMEA, October 27-29 in Milan. The Directions committee has opened up for registrations, make sure to explore their site and start your registration: Directions EMEA | Directions 4 Partners In the Directions committees own words: “After 18 months of working from home, a zillion… Continue Reading...
Word Templates and Word merge in Business Central
Word Templates and Word merge in Business Central Mail Merge in Business Central You can use the mail merge functionality in Word to use data from Business Central to add a personal touch to bulk communications. When you want to send a document to a lot of recipients (for example, to your customers and contacts as part of a sales campaign), you can use Word’s mail merge capability to… Continue Reading rstefanetti’s Article...
How to enhance Business Central Role centers with the power of Widget Containers and jQuery
How to enhance Business Central Role centers with the power of Widget Containers and jQuery Using the ControlAddins and power of jQuery it is possible to add container widgets to roles centers to extend their functionality, using the page parts in which to publish the widgets. Surely, this is interesting for demos as other products do the same thing, giving the idea that Business Central… Continue Reading rstefanetti’s...