Author: ERP Consultors

We are leading Giants in the ERP Industry. We are specialists in Microsoft Dynamics NAV, Microsoft Dynamics 365 Business Central, and Microsoft Azure.

Usage of Keys in Business Central

Usage of Keys in Business Central: Dynamics 365 BC application use SQL database. SQL database uses keys to identify records in the table. It also uses indexes to speed up the performance of table data. In AL, a key is a sequence of one or more field IDs from a table. There are two types of Keys …

How to Move fields in Page via AL Extension in D365 BC

Move fields in Page via AL Extension: Case I- Move Before: (1) Syntax : “movebefore(Anchor; Target1, Target2)”. Lets take an example, move field “Unit Price” before “HSN/SAC code”. Anchor: controls, actions, and groups. Target: list of actions or list of controls. (2) Source Code: pageextension 50001 SalesOrderSubFormExt extends “Sales Order Subform”{    layout    {               movebefore(“GST Group Code”; “Unit Price”)    }} (3) Publish the extension and see the effect in below image- …

Strengths and Weakness of the Dynamics 365 Business Central

Strengths and Weakness of the Dynamics 365: Strengths: (1) Look & Feel- Business Central has a new and improved UX/UI in efforts to deliver a high-quality consumer-grade experience.(2) LinkedIn Acquisition- Microsoft has a native connection between LinkedIn and CRM Sales providing all information on profiles directly into customer records.(3) Integration with Microsoft’s Ecosystem of Solutions- Beyond …

How to Link Main Page and Subform Page in d365 BC

Link Main Page and Subform Page in d365 BC: (1) For linking the subform page in the main page, the below syntax is used. Syntax: Part(PageCaption ; SourcePage) (2) For example- Adding “Sales BOQ” page in Sales Order page before Sales Order Line page. Source Code: pageextension 50002 SalesOrderFormExt extends “Sales Order”{    layout    {                addbefore(SalesLines)        {            part(SalesLinesBOQ; “Sales BOQ Subform”)            {                ApplicationArea = Basic, Suite;                SubPageLink = DocumentType = FIELD(“Document Type”),DocumentNo= FIELD(“No.”);                UpdatePropagation = Both;            }        }    } Comparison between D365 BC and SAP B1How to Call …

Comparison between D365 BC and SAP B1

Comparison between D365 BC and SAP B1: Business Central Background: In 1984, three young entrepreneurs in Denmark released the precursor application to Navision (which would later become Dynamics NAV) under the name PC&C (Personal Computing and Consulting). In 1987, the developers released Navigator 1.00, which took PC&C’s single-user application and turned it into a client/server-based accounting …

D365 BC Shows Error When Changes Made in Table Fields- Solved

D365 BC Shows Error When Changes Made in Table Fields: (1) The system show error when we did changes in the Table fields like Delete, Change Data Type and Rename in Dynamics 365 Business Central. (2) Error Message- Microsoft (R) AL Compiler version 7.4.7.43721Copyright (C) Microsoft Corporation. All rights reservedCompilation started for project ‘TNSProjectExtension’ containing ’25’ files at ’18:26:34.515′.e:\ABC Extensions\ABCProjectExtensions.vscode\Custom Object\ProjectBudgeting.Page.al(91,61): error AL0132: ‘Record “Sales Line”‘ does not contain a definition for ‘BudgetedMargin’Compilation ended at ’18:26:35.597′.Error: The package could not be created. (3) For solving the above error. Define “schemaUpdateMode“: “ForceSync” in “launch.json” file. And publish the extension again. …

How to make Field Editable & Non-Editable and Visible & Non Visible in D365 BC

Make Field Editable & Non-Editable and Visible & Non Visible in D365 BC: For making field “Editable” and “Visible” in Base Application object in Dynamics 365 Business Central. Use “Editable” and “Visible” syntax. Let’s take an example. Take the “Posting Date” field of the Sales Order. Example-01: Editable. modify(“Posting Date”){Editable = True;} Example-02: Non-Editable. modify(“Posting Date”){Editable …