Skip to main content

Posts

Showing posts from May, 2020

Enable Code Analysis for AL In BC

How to use Code Analysis Tool for AL in BC Few days ago, the demo was given by me on the code analysis for AL among our team. I would like to share the same knowledge with you on the code analysis.

Follow the bellow steps in your project to enable code analysis in the business central.

Open command pallete ( Ctrl + Shift + P ) and choose either User Setting or Workspace settings.  Basic setting is al.enablecodeanalysis and make it to true. Now, set the al.codeanalyzer with the different values. Here, there are four values (AppSourceCop, CodeCop, PerTenantExtensionCop, UICop) available to use. Here, we will user CodeCop and PerTenantExtensionCop.  CodeCop is an analyzer that enforce the official AL coding guidelines.AppSourceCop is an analyzer that enforce rules that must be respected by extensions meant to be published to Microsoft App Source.PerTenantExtensionCop is an analyzer that enforce rules that must be respected by extensions meant to be installed for an individual tenant.UICop i…

Add page in menusuite in business central

Menusuite in business central Hi,

Today one of my colleague asked me to add page in department of the the role center in business central like we used to add page in menusuite in navision. However, menusite object was removed in business central. Previously when i checked i was unable to add pages there but today i found a way to add pages in the department of the role center in the business central.

We will use the same project that we used in the previous Import/Export excel files. So, we will add the student list page in the order processor's role center. For that we will extend that page and add our student list page in to it.



Now, we will build our project and check out the output.


Also, we can see this same section over here.


For this blog i have used microsoft business central wave 1 2020.
Read  microsoft docs for the better understanding ( Click Here ).
You can download source code from GitHub ( Click Here).

Regards,
Harshil Patel

Export Excel in Business Central Using Excel Buffer - Harshil Patel

Export Excel in Business Central Using Excel Buffer Hello,

Today we will export data using excel buffer in the business central. If you haven't check my previous blog then check out import excel in business central (Click Here!). Now we will create a report to export data using excel buffer in business central.


Now, we will add this report to the action of the list page.
OUTPUT Go to the student list page and click on the action to export data. Now, you can see the exported data in the excel file.
You can download source code from GitHub (ClickHere).

Regards,
Harshil Patel

Import Excel File in Business Central

Import Excel in Business Central Many times we need to import data through excel file in the business central / navision. We used to perform this kind of activity in the navision but we need to explore the thing in business central. So, i am trying to import data from excel file in the business central. I am using business central wave 1 2020 for the development. We will create a table called student and add some fields to test imported data from Excel in Business Central.

Now, We will add a new list page to view imported data from excel.

Now, We will create a new report to import data from the excel in business central. If you worked with the navision then you might be noticed that some of the functions are not working in the business central due to scope issue. So, we will replace those functions which we used in NAV and try some new available functions to import excel.




Now, we will add an action to the list page for import data.

Output
Go to the student list page and click on the action…