Author: ERP Consultors
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 …
SchemaUpdateMode in AL in launch.json: Introduction: At the time of publishing the extension, in “launch.json”, there is setting “schemaUpdateMode”. By default value is “Synchronize” mode but they have two more settings, names are “Recreate” & “ForceSync”. (1) Synchronize: This mode is used when we want to synchronize the data with each publish. (2) Recreate: In this …
Import EXCEL data in Business Central D365: (1) In the post, we will explain how to import excel data in Microsoft Business Central D365. For this, developed a new report (already explained in the previous blog “Report Creation In Microsoft Dynamics 365 BC”). In BC D365 there is a “Configuration Package” feature that helps to import …
