Monday, August 1, 2022

Validate User input data using Regular Expressions in Business Central using AL

 Hi Reader, 

Data is a crucial part of a Database and should be stored correctly and in the right format. But how do you make sure that users will not make any manual errors for the new customized fields? For example, if an E-mail is to be sent, the E-mail entered by the user should be in the right forward or valid so that emails are sent correctly. 

For scenarios like these, regular expression comes handly. 

Monday, April 25, 2022

Automated testing for Customizations in Business Central

Hi All, 

Long blogs are something I do not write that often; but stay with me, it is going to be worth it! ;)

Microsoft provides a Test Toolkit with Business Central that allows you to manage and run automated tests. You can find the toolkit on the DVD in the applications\TestFramework folder.

Note: Added as an extension by Microsoft for new versions. To be able to use this toolkit, add that as a dependency in app.json

Once the Test Tool is installed, you can run the standard tests (if they were installed). Search for AL Test Tool using Search/Tell Me.

Monday, April 18, 2022

Manage Multilanguage Development using Translation File in Business Central

Hi All, 

Microsoft Dynamics 365 Business Central is multilanguage-enabled, which means that you can display the user interface (UI) in a number of different languages. Although, every BC Application Package is installed as per Localization.  

Example: BC Localization Version for Germany will be in German (Local Language) but you can also run the Application in English (multilanguage)

To enable/add a Language for the developed extension, using a Translation File follow these steps:

Tuesday, April 12, 2022

Work with File Object in MS Business central SaaS

Hi All, 

File sharing is an integral part of Data sharing. You can import data from or export data to any external file through file variables.

The Business Central server (SaaS) can't access the user's local file system. To be able to work with files, you need to use streams.

Only the UploadIntoStream and DownloadFromStream functions are available for you to use as a developer in the SaaS version of Business Central. 

Monday, April 4, 2022

Difference between TABLE and TABLEDATA in NAV/Business Central

 Hi All, 

There are Basic/Major Objects: Table, Pages, Report, Query, MenuSuite, XMLPort, Codeunit, but while setting Permissions there is another Object Type that you see which is called TableData. 

Now, what exactly are they? How are they different from Table? A basic, but relevant discussion in my point of view. There is always confusion between the two while assigning Permissions. 

Let's understand it better. I will try to put it as simply as I can. 

Friday, April 1, 2022

Admin Privileges in Business Central/NAV, but not really!

Hello All, 

Permissions and User Licenses are one of the key things in ERP which defined proper Roles so that Business Processes run smoothly. 

But apart from that, it is also important to assign the right User group to access ERP. What about the external Users like Data Analysis who want to build reports or Auditors? These users do not really use the system for daily Business or processes, but need access to View All Modules and to check all tables and fields so that they can retrieve the right data.