How to use the Query object as an API in Business Central
In the next post, I want to mention a way to expose data using Queries. Queries are a compelling object type within Business Central, as they allow us to retrieve …
How to Migrate Record Links from Business Central On-premises to Business Central Online
The weekend before this post, I was working on a migration from Navision 2015 to Business Central On Cloud (V20.4), and after finishing everything, the client asked about the Record …
Using partial records in Business Central (SetLoadFields)
Business Central allows us to set or select the fields that will be initially loaded when the record is retrieved from its data source, improving the performance of objects such …
How to read files via SFTP in Business Central
In this post, I am going to explain how to connect and read a file on an SFTP server and create a record in Business Central automatically through Azure Functions …
How to create a Windows Service and connect it with Business Central to manage Local files
Since the arrival of Business Central on Cloud, a big question arose, how to now connect Local Files, Printers, and other peripherals with the ERP? To achieve this there are …
How to create attachments on the Location page and other pages in Business Central
In this post, I want to show a simple way to create the functionality of being able to attach documents in Business Central tables, which originally do not have this …
How to attach from a zip file to a Sales Order in Business Central
Hello, I want to share a little code that allows you to import multiple files in a .zip and attach them to a “Sales Order“. This process could easily be …
How to Add Custom Filter Tokens in Business Central
Custom Filter Tokens is an interesting feature in Business Central, which allows us to add filter tokens in the form: TOMORROW YESTERDAY THISMONTH THISYEAR FISCALYEAR CHRISTMAS In other words, Tokens …
How to Create and use the Control Add-In in Business Central
The Controls Add-ins is a type of object in Business Central that allows us to add custom functionality. It’s a custom control, or visual element, for displaying and modifying data …
How to send Telemetry using Azure IoT and Azure Functions to Business Central
The objective of this Post is to create a small system, based on the Arduino platform capable of real-time telemetry, using MQTT through Azure IOT to send messages and Azure …