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 …
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- …
Viewing Table data: For viewing table objects directly from the Web Client with data in all rows and columns of a specific table including additional fields added by AL extension, you have to follow the below steps- (1) Add “table=<TableID>” parameter to the client’s address. For example- table=18 (36 number is “Sales Header” table id). (2) …
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 …
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: 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 …
OnAfterValidateEvent of Table Field in Business Central: What is an Event? To handle events, you design event subscribers. Event subscribers determine what actions to take in response to an event that has been raised. An event subscriber is a method that listens for a specific event that is raised by an event publisher. There can be …
OnAfterInsertEvent (Table) Trigger Event via EventSubscriber: What is an Event? To handle events, you design event subscribers. Event subscribers determine what actions to take in response to an event that has been raised. An event subscriber is a method that listens for a specific event that is raised by an event publisher. There can be multiple …
