Month: October 2021
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) …