Category: D365 BC

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 …

Short Keys in AL Environment: Overview of shortcuts key in visual studio code (AL Environment D365 BC). Keyboard Shortcut Action Description Ctrl+Shift+P Show All Commands Alt+F6 Download source code Alt+A Alt+L AL Go! Ctrl+Shift+B Package F5 Publish & For Debugging (if debug is active) Ctrl+F5 Build and publish without debugging F6 Publish and open Designer Ctrl+F2 …

Fix WORK DATE issue in D365 BC: (1) When opening CRONUS Company, you notice that the WORK DATE is not matched with the current date, the reason behind this is that for CRONUS Company, Microsoft assigns WORK DATE according to the last “Posting Date” of G/L Entry. Refer to “Company Information Page” as shown- (2) If …