Category: business central
-
How to Find Vendor No. with Vendor Name
Who this is for: AL developers building custom tables in Business Central who want users to search by vendor name instead of memorizing vendor codes. Most tables in Business Central use “Vendor No.” as a foreign key because it is the primary key of the Vendor table — stable, unique, and fast to look up.…
-
How to Create Excel File in Business Central
Introduction Let’s assume that we have a situation where I need to export Customer data from Business Central in an Excel Sheet. The simplest way would be to use the Export Functionality in Business Central But this would require Human interaction with the system. Let’s Automate this using the Excel Buffer Table in Business Central.…
-
How to Create Server Instance in Business Central
Introduction Business Central comes with a default Server Instance which can be configured to our requirements during the Business Central installation process. What if we need more server instances and with Business Central Administration Tool deprecated, we have to use the Command Line Interface. The following Script Example Uses Business central 22 Version, but it…
Sivaguru Muralidharan 