The Automatic Payment Reconciliation – How does it work?

The automatic payment reconciliation of Dynamics NAV and Business Central is great feature – load a statement file and match the open invoices within the blink of an eye. It’s every accountants dream and a basic feature in today’s world. Let’s have a quick but informative look into how it works and fill the gap the official documentation leaves.

Visual representation of integration displayed by a puzzle.

Business Central & SQL Server: Send any query and store the result as XML with 4 lines of code

A couple of years ago, the idea was to have everything in one major ERP application. Nowadays, the trend shifts towards platforms and Business Central becomes a piece of software in a diverse environment. It will become a key skill for every consultant and developer to integrate other software into Business Central and vice versa. There are a couple of options how to integrate (flat file, webservices) and today I want to show you how to query a SQL server and store the result in XML format with only 4 lines of code.

Business Central: How to upload and download File Attachments in Extensions

Unfortunately, in Extensions it becomes fiddly when it is necessary to upload or download File Attachments. The build-in functions of Codeunit “File Mgt.” and Table “Attachment” are not allowed to be used in Extension development. Therefor it is necessary to create own functions. The code below works in every browser.

Dynamics NAV/365BC & built-in Machine Learning applications – Let’s have a look inside!

Machine Learning is everywhere. It does promise a bright future with auto-pilots and self-driving cars. And it brings nightmares with facial recognition and self-fulfilling prophecies. But because Dynamics NAV and Business Central are straight business, let’s keep things easy and have a look at Machine Learning applications, which Microsoft integrates into NAV 2017, NAV 2018 and Business Central.

Scroll to Top