Author: Sivaguru

  • How to Find Vendor No. with Vendor Name

    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

    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

    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…

  • How to Install LS Retail in Docker Container

    How to Install LS Retail in Docker Container

    Introduction Let’s first Create the docker Container using BCContainerHelper Module.If you would like to know how to install the moduleI got you covered.Check this Blog out https://sivagurumuralidharan.com/2023/10/20/how-to-install-bccontainerhelper/ Creating Docker Container with LS Setup Using the New-BcContainerWizard in Powershell, Get started with creating the container. I used to the Below Mentioned Code to create my container.…

  • How to Install BCcontainerHelper

    How to Install BCcontainerHelper

    Introduction This Topic Requires no introduction… and yet I describe what BCcontainerHelper does. BCcontainerHelper is the successor to the NavContainerHelper Powershell Module. They are both amazing Powershell modules which makes working Business Central and Navision in Docker Containers very easy. How to Install? Open Powershell using Admin Privileges and paste the following in the prompt…