Category: D365 BC
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 …
Check Installed and Uninstalled Extension in D365 BC: Introduction of “Extension Management”: In Microsoft Business Central D365, all developments are deployed in the form of extensions. Microsoft provides the feature of installing and uninstalling the extensions in the “Extension Management List”. Let’s overview the functionality in the below steps: (1) Open D365 BC in the browser …
Usage of TESTFIELD in D365 BC: (1) “TESTFIELD” is used mainly for validations. (2) Syntax: Record.TestField(Field: Any, Value: Code) (3) Let’s take an example, “BudgetPrice” must not be zero at the time of entering a value in “BundleItem” as shown. (4) Second example, “BudgetPrice” must be 10 at the time of entering a value in “BundleItem” …
Usage of TRANSFERFIELDS in D365 BC: (1) “TRANSFERFIELDS” is used mainly to copy all same fields in one record to another. (2) “TRANSFERFIELDS” copies records on the basis of field number and the field must have the same datatype. (3) If field datatype is different then it will give a run time error. (4) Let’s take …
Usage of COMMIT in BC D365: (1) “COMMIT” is used mainly to end the write transaction in AL. It separates write transactions in AL. Actually COMMIT function tells the system that the first process has been completed and start the second process. (2) Let’s take an example. Go to the “Sales-Post” Codeunit, as shown. There are …
FilterPageBuilder in BC D365: (1) “FilterPageBuilder” is used for applying filters on a particular table. Pages are generated at runtime. (2) FilterPageBuilder is DATATYPE. You can define it in variables. (3) Let’s take an example. Create a Filter page and it’s open when “Item List Page” is open. (4) Create Item List Page extension and write …
Temporary Table in BC D365: (1) Temporary table is used as buffer storage or data compile in its own format. (2) The difference between Temporary Table and Normal Table is that the Temporary table is not stored in a database. It is only held in memory until the table is closed. (3) The advantage of the …