Tag Archives: Business Central
Extend a User-Created Table
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!
How to retrieve a Sub-string from a String
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!
Update Sub-form (Sub-Page) from Main Page to apply Filters.
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!
Business Central Wave 2 Features – Section 6
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!
Business Central Wave 2 Features – Section 4
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!
Business Central Wave 2 Features – Section 5
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!
Business Central Wave 2 Features – Section 3
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.
Business Central Wave 2 Features – Section 2
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.
Business Central Wave 2 Features – Section 1
1.Power-full filtering of Reports When running reports on Business Central, Users see a request page where they can add filters, this addition of filters was achieved by customization and coding. With the new Business Central Wave 2 Release users do not have to worry about customizing from the back end. Business Central Wave 2 comes up with hassle-free filtering of reports which is achieved before the report is run. Thus making it more efficient to use. The snapshot shown below is an example of previous report filters. This is how the business central wave has added filters. You just have to click the filters button and you can have multiple combinations of simple and complex filters. 2. Resize columns with fewer clicks. Columns play a major role in Business Central because the data to be displayed is dependent on how much visible that particular column is, In the earlier version of business central it was not possible to increase the width of a column to be displayed. With the new Business Central Wave 2 release, the developers have made it convenient for the users to increase the size of columns just with a single click and mouse drag. Below is the snapshot of the previous Business Central. This picture shows how the column “Contact” has been increased. Hope this helps!
How to fetch a custom table created in Business Central into PowerApps using CDS and Odata.
Introduction: In this blog, I have introduced how to fetch a custom table from Microsoft Dynamics 365 Business Central into Microsoft PowerApps using Common Data Service(CDS) and OData. The table that was created in Business Central was fetched into a custom entity(MatchingLists) in CDS that allows me to create a local database in PowerApps for storing the entity data and OData that helps to fetch and integrate the data. Pre-requisites: Microsoft Dynamics 365 Business Central Microsoft PowerApps Steps: 1. Create a custom entity within Common Data Service(CDS) whose data you want to retrieve from Business Central. 2. Add the fields with their required data types. 3. Get Data from Business Central using OData Integration. 4. Go to web services in Business Central, add the custom page in the web services and use its OData V4 URL. 5.Enter the OData URL and the Organization credentials. 6. You will be shown the list of tables in each and every company. 7. Go to the table whose data you want to get into PowerApps, and select that table. 8. Next is to select the entity to be mapped with this table and field by field mapping of the same. 9. Refresh can be set manual or automatically, if automatic then select the time. 10. Create a list structure to dsiplay the table.