Author: ERP Consultors
Item Charge Assignment detail against Sales Invoice: (1) In this blog we will see how to develop or fetch information of Item Charge Assignment detail against Sales Invoice. (2) For fetching information of Item Charge against Sales Invoice, use Dataitems: Value Entry as IC_Value_Entry, Value Entry as SI_Value_Entry and Sales Invoice Line as shown below. (3) …
Item Charge Assignment detail against Purchase Invoice: (1) In this blog we will see how to develop or fetch information of Item Charge Assignment detail against Purchase Invoice. (2) For fetching information of Item Charge against Purchase Invoice, use Dataitems: Value Entry as IC_Value_Entry, Value Entry as PI_Value_Entry and Purch. Inv. Line as shown below. (3) …
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 …
