Microsoft Dynamics NAV Development Environment is one of the main part of NAV , All developer use this for developing new functionalities or customize existing functions. Developer can create of modify page, codeunit, query, report… etc. we will discuss all this in detail below.Microsoft Dynamics Navision Development Environment have built up of an manly 7 object
a. Table :
In simple word TABLE is one type of 2 - dimensional container. Which have rows and columns, you all are aware about tables in SQL server database this table is same as SQL table, table is used to store the data. developer can modify the existing table or create new table, table can store any type of data, when you create table at that time you have to specify the its column with data type, as per data type you can store data in table, table is store the data permanently whenever you want you can retrieve the data from the table.
b. Page :
Page is same like form in over common developer language, which is use to insert data in table and also display data from the table. Page mainly provide the client user interface. Many type of page is there.
1. List Page
2. Card Page
3. Role Center Page
4. Card Part Page
5. List Part Page
6. Confirmation Dialog
7. Navigate Page
8. Standard Dialog
As per client requirement developer has to choose best page which satisfy the client requirement.
c. Report :
Report generally use to print or display the data from the database ,developer have to design report as per requirement, using report you can display data in various format like list details or display in tabular format etc.
Report is also use for only processing the data in database not displaying any thin on user side. This is call process only report.
Using report you can export and print the data in various formats like excel, PDF, word etc…
In NAV report we design using Microsoft RDLC report.
d. Codeunit :
Code unit is one type of code holder (container). Developer can make its code in codeunit and he can develop code, compile code and also save this code to codeunit. Codeunit have no user interface. codeunit is not visible to client. For modifying and creating the code unit you need license for this.
Generally codeunit is back ground process for the NAV application you can create function in codeunit and call it from anywhere from application its make re-usability of code.
In codeunit you can define functions, local variables, global variables, constants...etc., you have to use C/AL Editor editor for writing or modifying the code in codeunit.
e. Query :
Using query you can make group of multiple table and make single result data base on its relationship. Using Query you can retrieve the data from the database as per requirement, you can apply join, filtering method in query, Query also contains aggregate functions like sum, totals …etc., after creating query you have to use it in page or report for displaying data to user.
Query also use in exporting the data using web services, and also use in generating the Chart.
f. XMLPort :
XMLPort generally use in exporting and importing data to OR from Microsoft Dynamics Navision database. Using XMP port you can make proper data file in XML format and export to other user in XML port and same you can import any data to NAV database using XML file, XMLport also used in web service for data communication.
g. Menusuite :
Menusuite is use to add page and report to menu of NAV so user can easily access them. After creating report or page developer have to put is in proper section as per its functionality, Microsoft Dynamics Navision has as dynamic menu items you can customize the menu option as per your requirements.