Category: D365 BC
Development of Trial Balance Report in BC D365: (1) In this blog, we will see how to develop a new Trial Balance Report in excel format. (2) First of all Take DataItem: “G/L Account”. (3) Write code in “OnAfterGetRecord” for calculating Opening, Debit, Credit and Running Balance. Header Part: Body Part: Footer Part: Excel Sheet Creation …
Solve Export to Excel Report Runtime Error in BC D365: (1) Error: “The report couldn’t be generated, because it was empty. Adjust your filters and try again” is coming when run “Export to Excel” report having no RDLC layout as shown: (2) Solution: Go to Export to Excel AL code and set the report property as …
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 …
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 & …