Creating an Azure SQL Database backup via Powershell
Sep20

Creating an Azure SQL Database backup via Powershell

I have several Azure SQL databases (mainly Microsoft Dynamics NAV databases) on different Azure subscriptions and often I need to download a backup for some of them. Yesterday I’ve decided to automate this process by using Powershell and the Azure REST APIs (in particular the Database – Export API). I want to have a Powershell scripts that connect to an Azure SQL Database, creates a backup… Continue Reading...

Read More
MSDYN365BC – OnPrem Custom Font with Web Client.
Sep20

MSDYN365BC – OnPrem Custom Font with Web Client.

Hi Readers,Yesterday we stuck with an issue for a customer which we recently upgraded to Business Central 13.x on-prem. It took time to find the solution so I thought to share a solution with everyone.Issue Description – Report using custom Barcode Font does not work with Web client but works with the windows client.In this article, we will discuss the issue and resolution on same. Read… Continue Reading Saurav...

Read More
The “SystemId” in Microsoft Dynamics 365 Business Central 2019 release Wave 2
Sep20

The “SystemId” in Microsoft Dynamics 365 Business Central 2019 release Wave 2

I’m returning after a very interesting workshop on DevOps in Berlin .. . At this moment, I’m wasting my time in the very “attractive” TXL airport because of my delayed flight. And how can I better waste my time than to figure out some stuff regarding Business Central. Figuring out indeed, because I have barely internet, a crappy seat, nearly no access to food, … so for me this is a matter of…...

Read More
Banking Extensions Setup and Differences in Business Central
Sep19

Banking Extensions Setup and Differences in Business Central

One of the key functionality you are looking for in ERP is reconciling your bank transactions. There are two most popular extensions for banking in Business Central and we will explore the difference for choosing and setting up one of these two: Envestnet Yodlee and AMC Banking. Setup Envestnet Yodlee is the standard extension and it comes together with Business Central so you do not… Continue Reading Petras Butenas’s...

Read More
NAV 2018 / Business Central – Export Electronic Payment 2.
Sep19

NAV 2018 / Business Central – Export Electronic Payment 2.

Hi Readers,Thanks for all your feedback on the first article about Export Electronic Payment.Wow, I was amazed to see how many questions I received via email on Export Electronic Payment article.In this article, we will discuss all those questions.This article applies for any new implementation or if you upgrading a customer from a 2017 or lower to 2018 or higher.We will have copy certain… Continue Reading Saurav Dhyani’s...

Read More
YAML Multi-Stage Pipelines in Azure DevOps, Stage 1
Sep19

YAML Multi-Stage Pipelines in Azure DevOps, Stage 1

Let’s return to the subject of pipelines and this time let’s talk multi-stages. What is it and why might you want to implement it in your YAML file? Builds/Releases With the approach that Microsoft are now calling “classic” pipelines there was a definite division between a build pipeline and a release pipeline. A build starts with a given version of your source code (a particular… Continue Reading...

Read More
How Do I – Prevent an epic clusterfuck…
Sep17

How Do I – Prevent an epic clusterfuck…

Now that the NDA on Business Central Wave II has been lifted and the DVD preview is released partners got time to look at the code Microsoft has refactored. The reactions vary from being marketing correct to more realistic. I have a strong opinion about what Microsoft did, and especially how they did it. First of all, I agree that it’s a great idea to split NAV up into modules and I… Continue Reading Mark Brummel’s...

Read More
Dynamics 365 BC Wave 2 Release: What happens now?
Sep17

Dynamics 365 BC Wave 2 Release: What happens now?

Microsoft Dynamics 365 Business Central Wave 2 release date is just around the corner and there are many aspects of which you should be aware. I’ve written an article for my Simplanova‘s friends that summarizes some important technical aspects to take care. You can read it at the following link: Dynamics 365 BC Wave 2 Release: What Happens Now? – Simplanova Microsoft Dynamics 365 Business Central is the latest...

Read More
NAV 2018 / Business Central – Export Electronic Payment.
Sep17

NAV 2018 / Business Central – Export Electronic Payment.

Hi Readers,There were quite a few changes to EFT in NAV 2018 and unfortunately, it doesn't really work out of the box.In this article, we will discuss all these changes that are required to set up Electronic Payment in NAV 2018 or Business Central.Note – There is no more "Transmit", it is replaced with “Generate” .All Screenshot in this article is from NAV 2018 North America Database.**… Continue Reading...

Read More
Dynamics 365 Business Central Wave 2: on-premise and direct SQL integrations
Sep16

Dynamics 365 Business Central Wave 2: on-premise and direct SQL integrations

Do you remember this post? I wrote it long time ago to explain what happens on SQL Server when you create a new table or you customize an existing table with an AL extension: the new table is created by appending the extension’s ID to the table’s name and also the customization to a standard table creates a new table with the primary key of the original table plus the newly added fields and… Continue Reading...

Read More
Working with Azure Blob and NAV
Sep16

Working with Azure Blob and NAV

This is something that’s long overdue, I wanted to write this before my summer vacation. My reason for holding back is that I want to share all the code for this project and this needs cleaning up. This is still not done and if you want the code you’ll have to contact me. Why am I still writing this? I am actually writhing this from the “International” airport of Cork Ireland where I… Continue Reading...

Read More
Why Attend BCUG/NAVUG Summit 2019 in Orlando
Sep14

Why Attend BCUG/NAVUG Summit 2019 in Orlando

In a month, BCUG/NAVUG Summit in Orlando will start. There will be dozens of amazing lectures and if you are NAV or Business Central user, this event is probably something you must attend, especially if you want to continue with improving your knowledge. I like to come back to this event every year as this is probably only one opportunity where you can get directly feedback from thousands… Continue Reading atotovic’s...

Read More
NAVUG Summit North America.
Sep14

NAVUG Summit North America.

Hi All,In fact, at this very moment, I'm working on my final changes on my slides for NAVUG Summit. I will be attending Summit for the first time. I don't know at all what the experience is going to be like but I am looking forward to it!NAVUG Summit – Dates  – October 15-18,2019.Location – Gaylord Palms Resort, Kissimmee, FL.Pre-Confrence Activites – October 13-15. Read Complete Article…...

Read More
MSDYN365BC – Cumulative Update 04 released for Business Central on Prem (Spring 14.0).
Sep14

MSDYN365BC – Cumulative Update 04 released for Business Central on Prem (Spring 14.0).

Hi Readers,Microsoft has released, Cumulative Update 04 for Microsoft Dynamics 365 Business Central on-premises (14.0) and is available for download.Remember this Cumulative Update is for Version 14.0 Spring Release.Cumulative Update 04 – Application Build  – 14.5.35970Platform Build       – 14.5.35916 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog MSDYN365BC – Cumulative...

Read More
AL Build Helper for Dynamics 365 Business Central Builds
Sep12

AL Build Helper for Dynamics 365 Business Central Builds

If you’re interested in setting up a build pipeline to build apps for Business Central then you’re probably interested in running the automated tests as part of it. (I take it you are writing automated tests?) Turns out getting your test codeunits and methods populated into a test suite ready to run isn’t straightforward. We use a separate “Build Helper” app that exposes a couple of web… Continue...

Read More
Application Enhancements in April 19 – Primary Ship to Address
Sep12

Application Enhancements in April 19 – Primary Ship to Address

One customer can have multiple ship to addresses in Dynamics 365 BC, although, it was not possible to specify a primary ship to address on the customer card which will automatically populate on the sales transactions. Now with the new release it is easy to fill out multiple ship to addresses to one customer and mark one as “Primary”. There were several third party prodcut by partners to fill… Continue Reading Mahmoud...

Read More
Adding an External Accountant to Business Central: Steps and Error Messages
Sep11

Adding an External Accountant to Business Central: Steps and Error Messages

Over the time we have seen different issues and challenges you might have with adding an external accountant  to your solution so we‘ve decided to share them all in one place. Let‘s start with the steps you should take to add the external accountant user. The following steps should be taken: Contact your Partner of Record to add an external accountant  license type (free) to your… Continue Reading Petras Butenas’s...

Read More
Tip #61 | .gitignore for AL projects
Sep11

Tip #61 | .gitignore for AL projects

The Business Central Community loves Git, but GitHub does not seem to even know we exist. It recognises our projects as perl projects and there is no suggestion for a .gitignore file. Why .gitignore? It’s generally considered best practice to use Git for managing uncompiled code, but not to store the result of a project, nor it’s dependencies. Also, settings that may vary from… Continue Reading Mark Brummel’s...

Read More
Tip #60 | Suppress Warnings in Visual Studio Code
Sep11

Tip #60 | Suppress Warnings in Visual Studio Code

One of the most anoying things about writing AL code in Visual Studio Code is getting warnings that you cannot fix. Simply impossible. My “favorite” warning is this one For almost a decade it’s been possible to sort on flowfields from code and in reports and in most cases it works fine. On larger datasets it might require a covering index for performance. This warning is a joke… Continue Reading Mark...

Read More
Tip #59 | Multiple Start Configurations in Visual Studio Code
Sep11

Tip #59 | Multiple Start Configurations in Visual Studio Code

When developing extensions for Business Central you have a wide array of publishing options to choose from. My most used options when working on the ForNAV Customizable Report Pack are our Sandbox and Docker. Testing is best on the Sanxbox for two reasons. First because all the Azure Active Directory stuff actually returns something which is useful for licensing scenario’s. Second… Continue Reading Mark Brummel’s...

Read More
Dynamics 365 Business Central Availability in the Middle East – Arab Countries
Sep11

Dynamics 365 Business Central Availability in the Middle East – Arab Countries

Several years ago, we have submitted a suggesstin to Microsoft through the old MS Connect portal ( whic is currently retired ) asking about the possibility of providing a Arabic language module for Dynamics NAV. It was possible for us to use the W1 version and sell Dynamics NAV to clients. Now with the release of Business Central, subscription for this Small to Meduim ERP system has not been… Continue Reading Mahmoud M....

Read More
Microsoft Dynamics 365 Business Central 2019 release Wave 2: Full keyboard shortcut support
Sep11

Microsoft Dynamics 365 Business Central 2019 release Wave 2: Full keyboard shortcut support

Now Wave2 blogging is allowed, there are many topics that I want to share with you .. really, a lot. Time is not on my side – I’m in full preparation for Directions and NAVTechDays, so let’s see. Today, while working on my SaaS-deployment-pipeline in DevOps with ALOps, I DID find the time to say a few words on one of the topics I’m quite excited about: Shortcutkeys in the webclient, or in… Continue...

Read More
MSDYN365BC On-premise VS Cloud (SaaS) Battle Cards
Sep10

MSDYN365BC On-premise VS Cloud (SaaS) Battle Cards

MSDYN365BC On-premise VS Cloud (SaaS) Battle Cards Microsoft Dynamics 365 Business Central (MSDYN365BC) is a business management solution for small and medium-sized organizations Today Business Central is available in two versions: – On-Premise – Cloud (SaaS) LICENSING About “Team Member» License “BATTLE CARDS” – MSDYN365BC October 2019 Release2 (On-premise, Cloud SaaS) MSDYN365BC 2019… Continue Reading...

Read More
Dynamics 365 Business Central Wave 2: building apps on top of System Application
Sep09

Dynamics 365 Business Central Wave 2: building apps on top of System Application

As you already knows from this official Microsoft post, with Dynamics 365 Business Central Wave 2 release Microsoft has splitted the application into two main modules: Base Application (that contains all the ERP business logic) and System Application (that contains all the system layer). Separation between business and system layers is a first step for a future goal to have an application… Continue Reading demiliani’s...

Read More
Microsoft Dynamics Navision/Business Central Cumulative Update Summary For September 2019.
Sep08

Microsoft Dynamics Navision/Business Central Cumulative Update Summary For September 2019.

Hi All,Microsoft Have Released Cumulative Update for September 2019.Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2015, NAV 2016, NAV 2017, NAV 2018 & Business Central 13.Below are the Links to Download the Latest Cumulative Update. Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Microsoft Dynamics Navision/Business Central Cumulative Update Summary For...

Read More
Cumulative Update Summary September 2019
Sep08

Cumulative Update Summary September 2019

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 21 :- NAV2018CU21 Microsoft Dynamics NAV 2017 CU 34 :- NAV 2017 CU34 Microsoft Dynamics NAV 2016 CU 47 :- NAV 2016 CU 47 Microsoft Dynamics NAV 2015 CU 59 :-NAV 2015 CU 59 Warning Before you… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Page Extension Vs Page Customization in Business Central
Sep06

Page Extension Vs Page Customization in Business Central

Page Extension Vs Page Customization in Business Central I want to point out the differences between the Page Extension and Page Customization Objects, sometimes the Customization Object, although more limited in functionality, may be sufficient for some customizations. #1 – Page Customization Object The page customization object in Dynamics 365 Business Central allows you to add changes to the… Continue Reading...

Read More
Supply chain management in Dynamics 365 Business Central and Dynamics 365 for Finance and Operations
Sep06

Supply chain management in Dynamics 365 Business Central and Dynamics 365 for Finance and Operations

Supply Chain Management in Dynamics 365 ” Incremental Group How does Dynamics 365 Business Central compare to Dynamics 365 for Finance and Operations? And which one will fit my organisation best? This article focuses on comparing the supply chain management capability of both Dynamics 365 solutions. ( See our article on financial management) Download our guide comparing the features of Dynamics 365 for Finance and Operations and...

Read More
Business Central Modern Client: Remove the designer button
Sep06

Business Central Modern Client: Remove the designer button

You all know the designer, right? The tool for developers (aka the “in-client visual designer”) that “provides an easy and convenient way of making immediate adjustments to your design by simply dragging and dropping the components on the page”. Well .. then you probably know there are things to take into account…  Issues It actually all comes down to what I call “the worst button in NAV ever…...

Read More
Dynamics 365 Business Central on-premise: checking extension’s status via Powershell
Sep04

Dynamics 365 Business Central on-premise: checking extension’s status via Powershell

An interesting question pops out yesterday: with Dynamics 365 Business Central on-premise, how can I programmatically check if a particular extension is installed or not? The standard Powershell command (in the Microsoft.Dynamics.Nav.Apps.Management module) that gets informations about an extension in a specified Business Central Server instance is the Get-NAVAppInfo cmdlet (more info about… Continue Reading demiliani’s...

Read More
MSDYN365BC – Self Learning.
Sep03

MSDYN365BC – Self Learning.

Hi Readers,With all changes in product there are so many questions that you might be submitting in forums or reading in forums.Microsoft is continuously working for customer and partners with new features and changes in the product.Microsoft also understand that with all these changes everyone need some training for all changes that are happening in product.Microsoft have released a Free for… Continue Reading Saurav...

Read More
Application Enhancements in April 19 – Bulk Import Item Pictures
Sep02

Application Enhancements in April 19 – Bulk Import Item Pictures

In a previous NAV implementation with a client in the vehicle industry, inventory management in regards of SKUs definitions and characteristcs were a must as derived from the business needs. One of the most important requirements was to have item pictures attached to every SKU. The standard NAV functionality didn’t support bulk item pictures upload at that time, and we’ve had to develope a… Continue Reading Mahmoud...

Read More
Business Central – Importazione saldi contabili con pacchetti di configurazione
Sep02

Business Central – Importazione saldi contabili con pacchetti di configurazione

Business Central – Importazione saldi contabili con pacchetti di configurazione Pacchetti di configurazione Pacchetti di configurazione è una funzionalità disponibile da Dynamics NAV 2013 (RapidStart Services-Configuration Packages), ottimizzata ed arricchita nelle versioni successive, può essere utilizzato in vari modi ed è lo strumento principale che Microsoft indica per la “no code… Continue Reading rstefanetti’s...

Read More
MSDYN365BC – Cumulative Update 03 released for Business Central on Prem (Spring 14.0).
Aug30

MSDYN365BC – Cumulative Update 03 released for Business Central on Prem (Spring 14.0).

Hi Readers,Microsoft has released, Cumulative Update 03 for Microsoft Dynamics 365 Business Central on-premises (14.0) and is available for download.Remember this Cumulative Update is for Version 14.0 Spring Release.Cumulative Update 03 – Application Build  – 35602Platform Build       – 35570 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog MSDYN365BC – Cumulative Update 03...

Read More
App Dependency Tree – import your apps in the right order (with PowerShell)
Aug28

App Dependency Tree – import your apps in the right order (with PowerShell)

Recently, I got the question on how to get a dependency tree from a bunch of Microsoft Dynamics 365 Business Central apps. In other words – how do I know in which order I have to import my apps to respect the dependencies. Well, I didn’t have a ready-made script available. I only had a script my colleague provided me – so I took that as a starting point, and spent an evening in trying to put… Continue Reading...

Read More
Dynamics 365 Business Central: access modifiers
Aug26

Dynamics 365 Business Central: access modifiers

If someone of you know C# or other object oriented languages in general, you know also that those languages have access modifiers. Access modifiers are keywords used to specify the declared accessibility of a member or a type. With Dynamics 365 Business Central Wave 2 release, this feature will appear also on the AL language. A table object can have an Access level with the following… Continue Reading demiliani’s Article...

Read More
Episode 4 – BC Fall Release | Give Feedback
Aug26

Episode 4 – BC Fall Release | Give Feedback

Feedback is critical for Microsoft to improve Business Central and all of their other products. For this reason a preview is published of the upcomming release this fall. You can install this using Docker and I’ve been told a DVD will be made available soon. This release will be the biggest change since the introduction of the Three Tier model and Role Tailored Client and fits into the… Continue Reading Mark...

Read More
How to Show Only Vendor Items on Purchase Order !
Aug26

How to Show Only Vendor Items on Purchase Order !

It is a common business requirements that end user should only see the vendor items when creating a new purchase order, it is usually called a “Vendor Item Catalouge”. Consider an actual business scenario in which a company deals with 1000 vendors, and each vendor has a set of 100 items at least, it is quite challenging to pick only the vendor items on the purchase order. Even for small… Continue Reading Mahmoud M....

Read More
Episode 3 – BC Fall Release | Finding Stuff
Aug25

Episode 3 – BC Fall Release | Finding Stuff

UPDATE!! Microsoft is listening!! Big news, it seems that Microsoft is fixing the issues we’ve found in our App for AppSource. Both the functions on the TempBlob and the Language table will be added back! But also, let’s continue where we left off with the previous episodes because there are more challenges that won’t be fixed. Let’s see if we can fix some reference problems. Before… Continue Reading Mark...

Read More
“Mastering Dynamics 365 Business Central” book: please wait a bit more…
Aug23

“Mastering Dynamics 365 Business Central” book: please wait a bit more…

We have received in this last month lots of requests about our upcoming “Mastering Dynamics 365 Business Central” book, published by Packt: The book was planned to be released on the second half of August, but unfortunately due to a change in the management team inside Packt company (unpredictable), our book release date is delayed. I’ve explained this to all the people that contacted me… Continue Reading...

Read More
Testing Saved Views and Notes in MSDYN365BC 2019 Release 2 Preview
Aug23

Testing Saved Views and Notes in MSDYN365BC 2019 Release 2 Preview

Testing Saved Views and Notes in MSDYN365BC 2019 Release 2 Preview “Saved Views” and “Notes”, these new BC features (long time available in Windows Client and now in BC Release 2 Preview) are always requested and needed from my Customers. Knowing that these two features will soon be available is great for demos and allows you to eliminate the windows clients forever. Why am I talking… Continue Reading rstefanetti’s Article...

Read More
Use of Configuration Mode in NAV
Aug23

Use of Configuration Mode in NAV

Introduction: We all know about how to assign different Role Centers to Users based on their requirement. Any change made to the Role Center is applier to all Users who are assigned to them. Sometimes we do require to make minor changes to only a particular user like hiding certain home icons or adding certain pages to the Role Center. This becomes a bit tedious through the NAV Development… Continue Reading...

Read More
My Sessions during Fall 2019 Conference Season
Aug22

My Sessions during Fall 2019 Conference Season

This fall I’ll be active and attend to four conferences as lecturer. If you want to see some of my lectures or to meet me, register for some of these events: BCEE People, Prague – Business Central Roadmap in CEE countries Directions EMEA, Vienna – Demystifying Posting Groups in Business Central (for partners) BCUG Summit NA, Orlando – Demystifying Posting Groups in… Continue Reading atotovic’s...

Read More
Application Enhancements in April 19 – Merge Duplicate Customers, Vendors or Contacts
Aug22

Application Enhancements in April 19 – Merge Duplicate Customers, Vendors or Contacts

One of the most interesting features that was introduced recently is to merge duplicate records for; customers, vendors or contacts in Business Central. This feature was not available in Dynamics NAV, and it was widely reqeusted on Microsoft Ideas Merge Duplicates Permissions In order to be able to use the merge function, you need to have the “Merge Duplicates” permission set, which is… Continue Reading Mahmoud M....

Read More
Dynamics 365 Business Central: multiple production environments and web service endpoints
Aug22

Dynamics 365 Business Central: multiple production environments and web service endpoints

One of the most interesting features announced for the Wave 2 release of Dynamics 365 Business Central is the possibility to create multiple production environments for each tenant (this will include the option for environments to be on different country-specific or region-specific versions of Dynamics 365 Business Central). In order to support this upcoming feature, endpoints of all web… Continue Reading demiliani’s...

Read More
Application Enhancements in April 19 Release – Adding Multiple Items to a Sales or Purchase Document
Aug21

Application Enhancements in April 19 Release – Adding Multiple Items to a Sales or Purchase Document

With the new release of 365 Business Central, Microsoft introduced a new functionality which allows end user to add multiple items at once to the sales order. It is interesting how Microsoft products are sharing such creative ideas accross the different business solutions as this feature was presented initially in Dynamics AX, and now it is introducted in Business Central. Now on a sales or… Continue Reading Mahmoud M....

Read More
Dynamics 365 for Finance and Operations vs Dynamics 365 Business Central – Financial Management comparison
Aug21

Dynamics 365 for Finance and Operations vs Dynamics 365 Business Central – Financial Management comparison

D365 Finance and Operations vs Business Central – Financial Management comparison ” Incremental Group How does Dynamics 365 Business Central compare to Dynamics 365 for Finance and Operations? And which one will fit my organisation best? These are two questions we get asked on a daily basis, so we have created a guide and a series of article to help answer...

Read More
Step by Step guidance for Business Central… “ALL” power users?
Aug21

Step by Step guidance for Business Central… “ALL” power users?

Hi Guys, many news coming … Hot August!! Some step-by-step guides have also been added for Business Central, well done and video related. Will they be proceeding with Business Central certifications? I don’t know, but this type of guide is still very useful for the end user. “Learn new skills and discover the power of Microsoft products with step-by-step guidance. Start your journey today by… Continue Reading...

Read More
Self Learning – Dynamics 365 Business Central
Aug21

Self Learning – Dynamics 365 Business Central

Dynamics 365 Business Central has always been an easy to use platform, end users can drive through the various rich functionality in a very streamlined way. Microsoft is continuously supporting the growth of Business central not only by providing rich functionality, wide business functions coverage and easy to use system, but also by supporting the product with a very big and comprehensive… Continue Reading Mahmoud M....

Read More
Dynamics 365 Business Central: data encryption changements for Isolated Storage
Aug20

Dynamics 365 Business Central: data encryption changements for Isolated Storage

I suggested many times in the past to every partners I met and to all the attendees to my AL courses for Microsoft Italy that the way to store sensitive data in Dynamics 365 Business Central must be the Isolated Storage usage and not custom tricks on custom tables (see here) or using the old Service Password table (deprecated in Wave 2 release). In this days, during an extension’s code… Continue Reading demiliani’s...

Read More