Sales Invoice Report Format and Development: (1) Development of New report already explained in the previous blog. In this blog, we will develop a new “Sales Invoice Report”. Follow the below screenshot and develop a report for the client. The report includes- No. of Copies and Document No. filter. (2) RDLC Format for designing. (3) After …
Rename or Change the value of Primary Key in BC D365: (1) Introduction: When you want to change the value of a primary key, then RENAME method is used. (2) Syntax: Record.Rename(Value1: Any ) (3) Let’s take two examples one is to change Document No. of Sales Order Document & the second is to change …
DELETE and DELETEALL in D365 BC: (1) Introduction: When records are deleted in the tables via “AL” then the DELETE method is used. Note: recommended to delete any record in the table, specify filters on that record using “GET” or “SETRANGE” & “SETFILTER” for getting the records which you want to delete. (2) Syntax: DELETE. Record.DELETE() …
MODIFY and MODIFYALL in D365 BC: (1) Introduction: When records are modified in the tables via “AL” then MODIFY method is used. Note: recommended to modify any record in the table, specify filters on that record using “GET” or “SETRANGE” & “SETFILTER” for getting the records which you want to modify. (2) Syntax: Modify. Record.Modify() (3) …
INSERT and INSERT(TRUE) in D365 BC: (1) Introduction: When records enter in the tables via “AL” then the INSERT method is used. Note: when inserting records in a table, first initialize the table with method INIT. (2) Syntax: Record.Insert(]) (3) You can use this method in different types, as shown below- RECORD.INSERT: Only Insert record in …
FlowFilter in Dynamics 365: (1) “FlowFilter”: Use FlowFilter fields to set ranges on the calculations that are shown in FlowFields. FlowFilter fields are not saved in the database. Instead, they are stored for each window on an individual computer so users have their own filters. (2) Let’s take an example, if you open the Item table …
FlowField in Dynamics 365: (1) “FlowField” is used mainly for the calculation of data from other table fields based on the conditions applied on it. Data is displayed in these fields at runtime only. It increases the performance in activities such as calculating balance, count no. of records etc. (2) FlowField Type: There are seven types …
Define Custom Object Range in AL in D365 BC: Introduction: When developing any extension or object in AL environment, first we will define object range in “app.json” (Note: define object range according to the BC D365 License file. “.FLF”) Define object or extension id range in “app.json” –>“idRanges”. As shown- SchemaUpdateMode in AL in launch.json in …
