Business Central working with dates
Jun30

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...

Read More
Search for a string (or a TAG) in .al files with Powershell
Jun24

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...

Read More
Business Central data exported in Azure Data Lake
Jun10

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...

Read More
Business Central and Shopify Connector
May24

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...

Read More
Export SQL data to CSV or XML File via Powershell
Apr30

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...

Read More
Business Central from Directions NA, “Pictures are worth a thousand words..”
Apr15

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...

Read More
Used and not used Objects in Business Central license
Mar29

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...

Read More
Business Central: Performance & Data management tools recap
Mar25

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...

Read More
Excel Layouts for reporting
Mar06

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...

Read More
Dynamics 365 Business Central 2022 Wave1 (r.20) public preview is available
Mar04

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...

Read More
Universal Code Initiative Program: Cloud-optimized extensions
Feb22

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...

Read More
What’s planned for Business Central 2022 Wave1
Feb11

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...

Read More
Business Applications Cloud Week for Partners, February 28-March 4, 2022
Jan28

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...

Read More
REST API integration in S2S (Service to Service)
Jan23

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:

Read More
Business Central: Send an appointment from Job Planning Line
Jan07

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...

Read More
Azure AI in Business Central – The Forecasting Model
Dec19

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...

Read More
Business Central Online 19.1, 2D Barcodes Fonts are available
Nov30

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...

Read More
Business Central Online: “Restart Environment” feature is available
Nov21

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...

Read More
Business Central Design Patterns & Best Practices
Nov19

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...

Read More
Tech Academy Dynamics 365 Business Central 2022
Nov16

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

Read More
Business Central Online: why should we choose an entirely cloud-based ERP system in 2022? PART I
Nov13

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...

Read More
DIRECTIONS EMEA 2021, SOME NEWS FROM MILAN
Oct27

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...

Read More
See what’s next for Dynamics 365 Business Central 2021 release wave 2: Register Now!
Oct18

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...

Read More
Business Central: “The New Time Sheet experience”
Oct08

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...

Read More
Business Central 2021 Release Wave 2 (rel. 19) is available!
Oct01

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).

Read More
Security in Dynamics 365 and in Business Central Online
Sep25

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...

Read More
Business Central OneDrive CloudStorage integration
Sep10

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...

Read More
Dynamics 365 Business Central 2021 Wave2 preview is available
Sep06

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...

Read More
Business Central Insider Releases Artifacts
Aug30

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...

Read More
Dynamics 365 Business Central 2021 Wave 2 – Plan and prepare!
Aug25

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...

Read More
Word Layout Reports: repeat header lines on every page with Word 2019
Aug13

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...

Read More
2021 Wave 2 Release plans for Dynamics 365 and Power Platform released
Jul15

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...

Read More
Business Central rel. 18.3 – The “Data Administration” Page
Jul07

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...

Read More
Update 18.3 for Microsoft Dynamics 365 Business Central online 2021 release wave 1
Jul06

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...

Read More
Business Central OAuth 2.0 Get Token from AL Codeunit – massive apps update
Jul02

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...

Read More
MVP 2021-2022, six times in a row!
Jul01

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...

Read More
Directions EMEA | Milan October 27-29 – registration is open!
Jun16

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...

Read More
Word Templates and Word merge in Business Central
May29

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...

Read More
How to enhance Business Central Role centers with the power of Widget Containers and jQuery
May23

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...

Read More
Update apps installed from Appsource in Business Central Online with Powershell
May08

Update apps installed from Appsource in Business Central Online with Powershell

Update apps installed from Appsource in Business Central Online with Powershell This post will show you how you can update apps installed from the Marketplace in Business Central Cloud with Powershell. In the example below, powershell will be used which will invoke the APIs needed to update the APPs installed from the marketplace. For convenience I added a couple of functions to the… Continue Reading rstefanetti’s Article...

Read More
Publishing apps to a Business Central Online by Powershell
May01

Publishing apps to a Business Central Online by Powershell

Publishing apps to a Business Central Online by Powershell #1 Kinds of Apps There are 2 kinds of apps: AppSource Apps and Per Tenant Extensions (PTEs). These apps can be installed in two kinds of environments: Sandbox and Production. In Production, AppSource Apps are installed in the global scope (Global) and Per Tenant Extensions are installed in the Tenant Scope (PTE). In Sandbox… Continue Reading rstefanetti’s Article...

Read More
Delegated Admins for Business Central Online
Apr30

Delegated Admins for Business Central Online

Delegated Admins for Business Central Online LINKS Improvements for the delegated administrators – Dynamics 365 Release Plan Important Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What’s new and planned Enabled for Public preview General availability Admins, makers, marketers,...

Read More
MCT – Microsoft Certified Trainer, Finally!
Apr24

MCT – Microsoft Certified Trainer, Finally!

Hi, finally,I have been recognized as a Microsoft Certified Trainer in Business Applications; I had been following this certification for some time, I finally decided to activate it. The Microsoft Official Courses (MOC) will certainly help to improve the delivery of the courses, obviously I will participate in the improvement program of the courses themselves, as already done for Docs in… Continue Reading rstefanetti’s...

Read More
Corso online sviluppatori Microsoft Dynamics 365 Business Central
Apr23

Corso online sviluppatori Microsoft Dynamics 365 Business Central

Nuova edizione del corso aggiornato alle ultime novità di BC2021Wave1 Date Corso 19 mag 2021, 09:00 – 21 mag 2021 Dettaglio Corso e Link iscrizione Corso di Formazione Sviluppatori per Microsoft Dynamics 365 Business Central. PROSSIMO CORSO 19/20/21 MAGGIO Microsoft Dynamics 365 Business Centra l è progettato per le aziende che cercano una soluzione di gestione aziendale all-in-one facile da usare e adattare. Collega dati...

Read More
How to set Workdate to Today in Cronus Demo Environments
Apr21

How to set Workdate to Today in Cronus Demo Environments

How to set Workdate to Today in Cronus Demo Environments In demo environments (Cronus) not licensed Demo Company the workdate is set automatically by reading from the recorded ledger entries. This can be annoying if I want to use these environments for testing models or prototypes. Even in a non-activated PRODUCTION environments, it is the same thing. The workdate can always be changed… Continue Reading rstefanetti’s...

Read More
Barcode in Business Central Cloud!
Apr07

Barcode in Business Central Cloud!

BC2021W1 with a “Cloud Barcode” system Others have already posted about it, since it has always been a hot topic (since 2018!) I also set an example of use. Today Business Central 2021 Wave 1 natively provides the management of barcodes in reports (functionality announced long ago and released today). Barcode Ready-to Go Code39, Code128, EAN8, EAN13 … About Barcode in Business… Continue Reading rstefanetti’s...

Read More
Webinar Business Central 2021 Wave1 – Nuove Funzionalità, 15 Aprile 2021
Apr06

Webinar Business Central 2021 Wave1 – Nuove Funzionalità, 15 Aprile 2021

Webinar Business Central 2021 Wave1 – Nuove Funzionalità 15 Aprile 2021 -10-12 AM Evento di Sme.Up – Soluzioni EDP Evento dedicato ai rilasci e alle funzionalità dell’ultima release 2021 dell’ERP Dynamics 365 Business Central. AGENDA WEBINAR LIVE DALLE ORE 10 ALLE ORE 12 del 15 APRILE – Dynamics 365 BC: l’ERP evoluto, integrato, innovativo e in cloud di Microsoft a cura di Marco… Continue Reading...

Read More
Business Central 2021 Wave 1 released
Apr01

Business Central 2021 Wave 1 released

Business Central 2021 Wave 1 released “Nuntio vobis gaudium magnum”: Business Central 2021 Wave1 was released a few hours ago. You can already try it now: Cloud (Production and Sandboxes) Docker Artifacts DVD distribution Cloud Sandbox Have fun! L’articolo Business Central 2021 Wave 1 released proviene da Roberto Stefanetti Blog. Continue Reading rstefanetti’s Article on their blog Business Central 2021 Wave 1 released...

Read More
Business Central – Import Item Attributes from .CSV File
Mar27

Business Central – Import Item Attributes from .CSV File

Business Central – Import Item Attributes from .CSV File In this short post I point out a utility to import item attributes from a .csv file after modifying them in Excel. The system uses a page and an XMLport to import the .CSV file, it could be convenient to use it given the non-linear structure of the attributes management, or build a structure with RapidStart package.   Items Attribute… Continue Reading...

Read More
Business Central 2021 Wave1 Preview – testing some features – Part 2
Mar11

Business Central 2021 Wave1 Preview – testing some features – Part 2

Business Central 2021 Wave1 Preview – testing some features – Part 2 In this second part of the post, we talk about some features released and present in this Preview Release of Business Central 2021 Wave1 (the most interesting ones…), others are only mentioned. There are obviously many others too, which we will see immediately after the product launch (as I always do). “Availability… Continue Reading rstefanetti’s Article...

Read More