Find Base Application Object in BC D365: Open Visual Studio and go to File>Open File as shown (let’s take an example to open Customer Table al)- After that select BC D365 setup folder, as shown- Open the folder and go to Applications>BasApp>Source and then copy the “Base Application Source” file and save it in a different …
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- …