Author: ERP Consultors
Design Tiles view in Pages in Business Central: In BC D365 “Tiles” view option is added for a better User Interface. For configuring the list page with the tile option, we will follow the steps. By default, the tile view will display the first five fields that are defined in the page’s repeater control. This article describes …
Get Days from Month in D365 BC: (I) Create procedure or function in a object (like page, report, table and code unit). (II) Define parameters and return value in procedure as shown below- (III) When the above procedure or function is call then it will give total number of days in month. (IV) If GetMonth := …
Create and Apply Template Feature in D365 BC: This feature gives relaxation to end-user for entering the same data multiple times while creating masters (like Customer, Vendor, G/L Account etc.). This feature gives the flexibility to save mandatory data which is required while doing transactions against masters. In this feature, the system allows to create template …
Export to Excel Report in Business Central: For creating “Export to Excel Report”, follow the below steps. For example- (1) Export Sales Invoice Header data via report. (2) Create New report already explained. (3) Add “Sales Invoice Header” dataitem. (4) Create a Procedure for export data from the “Sales Invoice Header”. MakeHeader. MakeBody. CreatExcelBook. (5) After …
D365 Business Central Essentials vs Premium: The below features are common to both Dynamic 365 Business Central Essentials and Dynamic 365 Business Central Premium. Finance Management: General ledger. Dimensions. Multiple currencies. Budgets. Accounts schedules. Consolidation. Intercompany postings. Cash flow forecast. Fixed assets. Cost accounting. Deferrals. Bank account management. Electronic payments and direct debits. Customer payment process. Reconciliation of …
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 …
