Introduction: In this blog, I will be addressing some of the Table properties in Microsoft Business Central. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics NAV /  Business Central Properties: 1. CharAllowed It sets which characters are allowed in the field. This property can be applied to Table and Page fields. Charalowed takes parameters in a combination of two characters as shown below, where characters “1 to 4 “, “7 to 9” and “a to d” are allowed. An example of this property is given below. Definition Error 2. DataPerCompany It sets whether the table data applies to all companies in the database or only the current company. The default value for this property is true. This property can only be applied to Tables. The User table is an example where Datapercompany is false. 3. DataCaptionFields Sets fields defined on the Top Left Position of the Card page. It can be applied in Table. Syntax: DataCaptionfields= Field1,Field2,Field3; In below example, I have used No, Name and Type fields for Caption. Definition Result 4. Enabled Sets a value that indicates whether a field is enabled or disabled. It can be applied to Page fields, Table fields, and Actions. In the below example, I have set Enabled Property to True on Name field, therefore Name is field is visible to users but it is not editable and it is displayed Gray in color making it less highlighted than other fields. Enable = False   Hope this helps!

Problem Statement: I have a requirement where the user will select multiple attachments of choice from a list of Documents and Email them. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics Business Central Solution: Step 1: Create a drill-down on the field where the user will select attachments from a list of Documents. Here we have used Page Document Attachment Details as a drill-down page where I have attached some documents. Drill Down In the above code, I have created a drill-down of page Document Attachment Details. SetSelectionFilter() – To get selected attachments from the list of Documents. Step 2: Here I have created Instream and Outstream Objects for Attachments as shown below: In the below code Rec_Sample is a Record variable for sample table which contains the Media field “Document Reference” which stores the unique Document Reference ID of a single Document. After that, the same document is exported and Imported using Exportstream and Importstream. And AddAttachmentStream is called with the Instream object to add the attachment. This is done for the number of attachments selected and then the mail is sent. Conclusion: This way we can send Multiple attachments selected by the user and email them. Hope this helps!

Introduction: Microsoft Dynamics Business Central allows extending Pre-defined Tables, which is basically Customization and it is achieved using Extensions. Using Extensions developers can modify Pre-defined Tables according to requirements. But the extension of a Table can be done only if its “Extensible” property is set as True. This property is by default set as True for Tables. Now suppose a developer wants to extend a table that is created. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics Business Central Solution: Step 1: Set the Extensible property of the Table that is supposed to be extended as shown below: In this case, the table to be extended is “Properties”.   Extensible Property Step 2: Now go to Extension Management and get the AppID, Publisher, Name of App and Version as shown below:   App Details Put the above details of App in the dependencies section of the new extension where the table is to be extended as shown below and download symbols:   Dependencies Step 3: You can see that the “Properties” table is now available for extension. Here I have added a field “Extended Name” in the Properties Table. Also, that field can now be seen by accessing Properties Table by URL.   Extended Table   Thank you. Hope this helps!

Problem Statement:  We have a requirement where the client wants a part of String from Sales Order No. which is Code(Data type) and it is auto-generated from Number Series. The Sales Order No. value is “SO/123/789/456”. The required Sub-string was: 123<Space>789. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics NAV /  Business Central Solution: As per the requirement, we need to first retrieve Sub-strings “123” and “789” and this can be achieved using SELECTSTR( ) function. But SELECTSTR() only retrieves a Sub-string from a comma-separated String. And the Sales Order No. string is a slash-separated string. So firstly we need to convert this string to comma-separated string, which is achieved in the below-presented screen. CONVERTSTR(String, From Characters, To Characters)   In the above Screen, “SalesOrder No.” is initialized in a text variable “SoNumber” and then is converted to a comma-separated string. The code is: CONVERTSTR( String: Text, FromCharacters: Text, ToCharacters: Text ) Now comes the part where we retrieve Substring from this converted String using SELECTSTR( ) function as the string is now converted into a comma-separated string, below screen shows how it is done. SELECTSTR(Number/Position, Comma-Separated String)   As you can see in the above screen how SELECTSTR() function is used to retrieve substring on the 3rd and 4th position of the String and stored in text variables “No1” and “No2” respectively. And these variables are then initialized to another variable with space. The code is: SELECTSTR(Position, Commastring); In the above example the code is: SELECTSTR(3, Separatenumber); SELECTSTR(4, Separatenumber);     Conclusion:  We can retrieve a comma-separated string or any other character-separated string using CONVERTSTR() and SELECTSTR() functions. Hope this helps!  

Problem Statement: I have a requirement where I want to update the Subform(Part page) from the Main page, this Subpage(Subform) is linked to the Main page by SubpageLink Property. The Subpage is a List page and I want to filter this list by a field from Main Page. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics NAV /  Business Central Solution: To solve the above Problem statement we have to make use of the Currpage.Update() function which shall update the Subpage. As you can see in the below window a function is created Vendorfilter() on Subpage with the “vendor” parameter, in this function filter is added for the vendor on the part page and then CurrPage.Update() is used. This function will update the Subpage with the vendor. Now, call this function on “OnValidate” trigger of the Main page field, here we have “Vendor” field on Main Page.     The calling of Function is as follows: CurrPage.<SubpageName>.Page.<FunctionName>(Rec.<FieldName>); In this example we have CurrPage.POLines.page.Vendorfilter(Rec.Vendor); Conclusion: Thus we can achieve updating a Subform from a Main Page. Hope this helps!

Introduction: In this blog, I will be attempting to provide information about the new Application Lifecycle Management features of Business Central Wave 2. Pre-requisites: Microsoft Dynamics Business Central Wave 2. Demonstration: 1.Report Production Outages in Administration Center.   Suppose there occurs a case where the user is having issues on Production Environment, in order to get help on such issues, the user can report such cases to Microsoft, this is achieved by visiting Admin Centre >> Environments >> and then click “Report Production Outage” as shown below.   After that fill in the details as shown below, i.e. Outage type, Name, Email address, Contact Number and on the next page fill in the details of errors and the time and date of Outage occurrence as shown below. When the user reports the Outage, a message is displayed with the ticket Number. Then the reported outage is displayed on the Reported Outages Menu as shown below: And the user gets an Email regarding the outage. 2. Multiple production environments New Business Central Wave 2 brings a new feature where users can have multiple Production Environments for different localizations. After creating multiple Productions when the user visits “home.dynamics.com”, the user is asked for which Production Environment he wants to visit as shown below.   3. Detailed Notification for Update Events The following image shows a detailed notification mail for the update events of Tenant. Hope this helps!

Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business Central Wave 2. Pre-requisites: Microsoft Dynamics Business Central Wave 2. Demonstration: Overview of All Business Central Features in Single Click. With the new release of Business Central comes a new feature where users can see all the features of Business Central in a Single Click. On the Dashboard, user can locate a “hamburger” next to Actions on the top right of the screen, when the user clicks on it, a new window is displayed that shows all the features of Business Central according to Profiles (Roles). The screen displayed in the above picture shows All features for “Cronus General Manager” which is personalized for that Role. The screen displayed above shows All features for Role – “Accountant”.   2. Identify your Companies with Badges. When users are working with multiple companies, it is possible that confusion about companies may occur, to keep things clear users can make use of this feature which can be achieved with the following steps:- Step 1: Go to Company Information and change “Company Badge” to “Custom”. Step 2: Select “Company Badge Style” from a range of 10 different colors available as shown below and write a four-letter “Company Badge Text” as shown. Now the user can see the company’s badge as created on the top right corner of the Dashboard. 3. Modern clients only for Business Central Users can work with Business Central in the browser, Windows 10 desktop app, or mobile apps on Android and iOS. With this release, Dynamics NAV Windows Client is no longer available. Windows 10 Desktop App: Mobile App:   Hope this helps!

Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business Central Wave 2. Pre-requisites: Microsoft Dynamics Business Central Wave 2. Demonstration: Filter option fields by multiple values In the below picture, the user wants to apply a filter on an option field “Contact Type” on Customers, but the user can filter the data with either of the two options in Business Central. But with the new Business Central Wave 2 update, users can now filter option fields with multiple values as you can see below. 2. Multitasking across Multiple Pages: It is possible that users want to toggle between multiple pages, this feature was not available before, but it is possible in new Business Central Wave 2 update. Step 1: On the page, find the button highlighted below and click on the button that describes, “Open the page in a new window”. Step 2:  After Step 1 the page will open a new window as shown below. 3. Enter data with Speed and Agility Business Central wave 2 comes with more efficiency and agility,  data is entered with speed and agility, all the processing of fields in a record is done when the user adds a new record. 4. Longer timeout period for the server connection. In earlier versions of Business Central online, the session timeout period was set to 20 minutes. Microsoft has increased this value to two hours so that users are not asked to sign in to Business Central again and again. Note: This feature is only applicable to Business Central Online. For Business Central On-Premises, you can change the timeout in the Client Services tab in Business Central Server Administration. Hope this helps!

1. Saving and personalizing list views. Suppose we want to switch between pages and we want to add filters, so to achieve this we have to add filters every time we come back to that page, this feature was not available in the previous version of Business Central but now it has been added by the developers. We can save a combination of filters as our view and access it again and again.   2. Personalize actions and navigation on your Home page With the Business Central Wave 2 Release users can easily add their desired pages to their Role centers, making these pages easily accessible to the user. 3. Design for Extensibility. Users can adjust actions and action groups on their Role Center. Adjust the navigation menu items and grouping on a Role Center. Customize user profiles by designing page changes that will apply only to a specific profile in your extension.

1. Lock-free number series (Allow gaps in Number Series). Users can choose to mark number series to allow gaps in the series. These number series will be non-blocking, which will boost performance. Add notes and links to data Users can quickly add a note to the data they are currently viewing on the Business Central, these notes can be used if a user needs to add some note to the specific page. 3. Customize a user profile without writing code. (New fields have been added, Caption, Description, Use as Default Profile, Promoted). Users need not have to write code to change a user profile, instead, they can make changes to a user profile from Profile only.