2021 – Page 34 – Pardaan.com

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

Dynamics NAV & BC Tips & tricks

New Dimension Correction tool in Dynamics 365 Business Central version 18

To be honest I’m thrilled to write about this topic. The thing is, that I started my NAV developer career by developing the Dimension Correction tool for NAV 3.7 and then supported and upgraded it till NAV2016. “Trust me” I know what I’m talking about. After…

15 March 2021