March 2021 – Page 2 – Pardaan.com

An examples of how to use D365 Business Central interfaces

Interfaces are somehow like codeunits, excepting that an interface can only contain method signatures(name, parameters), not also the implementation of these methods. Interfaces are a way to achieve polymorphism. Polymorphism means “to have many forms”, so an interface can be used to call functions from different…

22 March 2021

Dynamics NAV & BC Tips & tricks

How to import Excel files using Excel Buffer

Last week, I saw a question about importing data from Excel file to Business Central using AL Language. A few years ago, the only solution was to use DotNet integration. However, with the Business Central, there is a much quicker and better approach. Source : Microsoft…

19 March 2021

Dynamics NAV & BC Tips & tricks

Use Enums as Text Constants

Earlier in January AJ Kauffmann tweeted a question about using Enum as Text Constants and a few weeks later I found a great use case for that. In this video, I show how to use Enum to store large constant strings. Source : Hougaard.com Read more...

18 March 2021

Dynamics NAV & BC Tips & tricks

How to detect anomalies in Business Central data using AL Http datatypes

Anomaly Detector is an Azure Cognitive Service that detects anomalies in time-series data. It consists of simple REST APIs that can be consumed by any application. This post explains how to setup Azure Anomaly Detector Service, and how to consume Anomaly Detector REST APIs in Business…

18 March 2021

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: introducing the reportextension object

One of the noisy limitations on Dynamics 365 Business Central until version 17.X was the impossibility to extend standard reports. If you want to add a simple new field to a standard report, you are forced to create an entire new report (new dataset), maybe from…

17 March 2021

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: Deleting Expired Sales Quotes

Today I would like to discuss how to delete expired sales quotes in Business Central. As you may know, in Business Central, you can create a sales quote to record your offer to a customer to sell certain products on certain delivery and payment terms. Source…

16 March 2021

Dynamics NAV & BC Tips & tricks

Extending standard APIs (1)

I’ve got this question so many times: how can we extend the standard APIs with extra fields? So I decided to write a blog post about it. Actually, it’s going to be two blog posts, because one would become too long. So here it goes… Source…

16 March 2021