Author: ERP Consultors

Call “No.” field “OnValidate” trigger via EventSubscriber: (1) In this blog we have seen that how to call the “No.” field OnValidate trigger of the Sales & Purchase Line table. (2) For that call Event of “No.” field “OnAfterValidateEvent”. (3) Example 01 (In case of Sales Line Table): In this, we have to auto-update Sales line …

Create Database via query in SQL Server: (1) “CREATE DATABASE” command is used to create a new database in SQL Server. (2) Syntax: Create Database NameOfDataBase; (3) Let’s create a database via query. Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor open …

Attach Report in Page in D365 BC: For attaching any report on the Page, follow the below AL code. In the below image I have attached the report on the Sales Order page, for that, I have developed one new extension and added the “Actions” format and added the report. For Attaching Report, we use Runmodal …

Create and Assign Dimensions in Sales Document: (1) In this blog, we will do auto-creation and assignment of Dimensions in Sales Document creation (or OnInsert Trigger) as shown below. (2) In the above function, we have called EventSubscriber of Sales Header table OnAfterInsertEvent for auto assigning the value to Sales Document. Source Code: codeunit 50001 “Custom …

Convert Amount into Words in D365 BC: (1) For converting “Amount in Words” in Dynamics 365 BC, use system predefined function. (2) In previous versions, we used “Check Report—>Function” for converting Value in Text. But in the latest version, I have found that, if we use “ Check Report—>Function” then the system will show “AmountInWords in …

Develop Multiline property in AL code in BC D365: (1) Multiline property is available in Page field and Page Label. But if you break or separate lines in AL then you should follow the below steps. Let’s take an example, In the Purchase Order report, the comment is shown in a single line but the requirement …

Assign Role Center to Users in BC D365: (1) In the previous version, “Role Center” assign in the “User Personalized” page but in BC D365, the name of the page is changed to “User Settings” as shown. Role Center is basically to control the user home page interface and controlling the display of pages, reports & …

Assign Permission and Company to Users in BC D365: (1) As we already know that BC D365 is a standard ERP, it has the capability to control users access like Companies, Pages, Tables, Reports etc. (2) For doing this, go to the “Users” list and assign Permissions as shown. (3) After selecting “Users”, the list will …

Purchase Order Short Closed Feature in BC D365: (1) In Business Central D365 “Purchase Order Short Closed” feature is not available. But in industries the demand for this feature is mandatory. (2) For adding the PO Short Closed feature, we will develop a small function to achieve this requirement, as shown. (3) Create PurchaseHeader extension to …

Sales Order Short Closed Feature in BC D365: (1) In Business Central D365 “Sales Order Short Closed” feature is not available. But in industries the demand for this feature is mandatory. (2) For adding the SO Short Closed feature, we will develop a small function to achieve this requirement, as shown. (3) Create a SalesHeader extension …