Author: ERP Consultors

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 …

Use of INNER JOIN in SQL Server: (1) “INNER JOINS” is used to combine data from two or more tables, according to the related column similarity. It returns records having the same value in both tables. (2) Syntax of “INNER JOIN” statements are: SELECT Col1, Col2, …ColNFROM table_name1INNER JOIN table_name2ON table_name1.col1 = table_name2.col1; (3) Let’s take an …

Types of JOINS Statement in SQL Server: (1) “JOINS” is used to combine data from two or more tables, according to the related column similarity. (2) Different types of JOINS are- INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN SELF JOIN (3) INNER JOIN: Return records having the same value in both tables. (4) LEFT JOIN: …

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 …