#1 Dynamics NAV - Table Object

Table Object In NAV 2013 R2

Table Overview

         Tables are the most fundamental objects in Microsoft Dynamics NAV. They store records that are collected through pages. for example customers, sales, and inventories. These records are then presented to users through pages and reports.

About Table

       Records in Microsoft Dynamics NAV databases are stored in tables. A table can be visualized as a two-dimensional matrix, consisting of columns and rows. Each row is a single record, and each column is a field in that record.

    A table consists of table data and the table description. The table data contains the actual records and their fields. The table description specifies the layout and properties of the table and the fields.

     The table description is not directly visible to the user. When a developer creates a table, he or she assigns the table name, ID number, and fields. This establishes the table description.

      Field characteristics, such as field name, ID number, data type, and initial value together with the primary and secondary keys (used to sequence data) are also part of the table description.

    The table description contains properties, triggers, fields, and keys. The “Table Components and Their Relation” figure shows components of the table description and how they are related.

Table Description

Properties of Table

  Field No, Name, Caption, CaptionML, Datatype, Field Class, Min-Max Value, Table Relation, EDT(Extended data type), Width, etc
  this are important properties to work on table object.

Data Type

BLOB, Boolean, Code, Date, Decimal, Integer, Option, RecordID, Text, TableFilter, etc.

How to create Table in Object designer:

Steps:

1. Go-to tool menu: > Click Object Designer> Click table object> New table
2. In table window appears has fields that enters data in fields i.e

               1) Field No.

               2) field Name 

               3) Data Type & Length

               4) Description 

   and Save Table ID & Table Name.

Customer Table in Table Designer

Customer table and its Property 

Save the ID of table in between 50,000 to 90,000 any where save. this are customize tables & other table ID's are standard tables i.e parent level tables OR predefined tables.

Save the table and run it(Ctrl+R)

Its all About Navision !

About Microsoft Dynamics NAV...

Defination: NAV is an ERP software suit for midsize organization, The NAV system offers specialized functionality for manufacturing, Distribution, Government, Retail, & other industries.

Versions of Navision:

• Dynamics NAV 2009: 2009, 2009 R2

• Dynamics NAV 2013: 2013, 2013 R2

• Dynamics NAV 2015: 2015

• Dynamics NAV 2016: 2016

• Dynamics NAV 2017: 2017

• Dynamics NAV 2018: 2018

NAV 3- Tier Architecture:

1) Roletailored Client: RTC is the client tier, which includes a NAV windows client and web client.

2) Nav Server: Nav Server is the middle or server tier, which managing all bussiness logic and communication.

3) SQL Server: SQL server is the R2 database components, is the data tier. the database tier consists of an application database.

NAS (Navision Application Server)

   NAS is a .net-based windows service application that manages communication between NAV Client & NAV database is SQL Server.

C/SIDE and C/AL:

  C/SIDE - Client/Server Integrated Development Environment
        C/AL is the programming language that used within the development environment for Microsoft Dynamics NAV, and the development environment is called as C/SIDE.  

  C/AL - Client/Server Application Language 

        C/AL is a database specific programming language and it primarily used to retrieve, insert, and modify the records in the dynamics NAV Database.

Object Designer 

       Object designer area which contains 7 objects through development and access to all the application object.

There are 7 object in NAV

        1. Table                                          
        2. Page                                           
        3. Report                                       
        4. Codeunit
        5. Query
        6. XMLport
        7. Menusuit

RoilTailored Center | RTC Client Side 

Object Designer

Microsoft Dynamics NAV installation & Configuration

MS Dynamics NAV Installation & Configuration 

Installation Of NAV

few steps of NAV installation before that pre-requisite Software & Hardware 

Pre-Requisite of NAV 

• Supported OS: Windows server 2008 R2, Server 2012, Windows 7 service pack-1, Windows Ultimate, Windows 8 & 8.1, Windows 10 Professional.
• Hardware Resources: 1 GB- RAM & 30GB Hard disk.
• Report: RDLC, MS Visual Studio, SQL Server Builder for Creating & editing RDLC reports layouts, Word 2013 to create word report layouts. 

Installation Steps:

1. Verify that computer system H/W and S/W requirement.
2. Locate the NAV 2013 R3 setup.exe file in computer and double click on it.
3. Choose Next
4. Then to accept the License terms.
5. Choose an installation Options (Client, Server, Developer & Custom).
6. Choose Customize the installation.( Verify the errors & fix them, Click Next)
7. Choose Next to open the specify parameters page in this any field that has an asterisk(*) it is required parameter. after that click - OK.
8. Installing Dynamics NAV is in process.
9. When setup is finished, click Finish & close.

Configuring Microsoft Dynamics NAV Server in Setup: 

  You can configure Microsoft Dynamics NAV Server when running Microsoft Dynamics NAV 2009 Setup. You must first select Microsoft Dynamics NAV Server as a component to install. To do this, select one of the following Installation Options that includes Microsoft Dynamics NAV Server.

• Server Option installs Microsoft Dynamics NAV Server without any other components.
• Developer Environment Option installs Microsoft Dynamics NAV Server with other components that are used for developing client applications.

After you specify an installation option or customize your component list, the Specify parameters page is displayed. Click Server to open the Installation Parameters page. The underscore indicates that this component is configurable. 

Settings

The parameter list that you see in the Specify parameters pane depends on which components you have selected for configuration. The following parameters pertain to Microsoft Dynamics NAV Server.

Parameter	Description
Server Name	The computer running Microsoft Dynamics NAV Server.
Server Port	The listening TCP port for Microsoft Dynamics NAV Server, which becomes part of the server's URL. Default value: 7046 Valid range: 1-65535
SQL Server	The computer running SQL Server.
SQL Database	The SQL Server database.
Web Service Port	The listening HTTP port for Microsoft Dynamics NAV Web services. Default value: 7047 Valid range: 1-65535

Click Apply when you have finished entering values to return to the Specify parameters page in Setup.

After you finish running Setup, you can modify Microsoft Dynamics NAV Server settings by editing the CustomSettings.config file.

Configuring Microsoft Dynamics NAV Server After Installation

Settings in the CustomSettings.config File

The CustomSettings.config file is an .xml file that you can edit with any text editor. It contains the following settings. Quotation marks are required for all values.

Setting	Description
NetType	The network protocol used to access the database. Default value: Default Valid values: Default, NamedPipes, Sockets
DatabaseServer	The computer running SQL Server.
DatabaseInstance	The name of the SQL Server database instance to connect to.
DatabaseName	The name of the SQL Server database.
ServerInstance	A name that identifies the instance of Microsoft Dynamics NAV Server. Default: DynamicsNAV You may need to modify this value if you have more than one Microsoft Dynamics NAV Server instance installed on a single server computer. For more information, see Walkthrough: Accessing Multiple Microsoft Dynamics NAV Databases from a Single Microsoft Dynamics NAV Server Computer.
ServerPort	The listening TCP port for Microsoft Dynamics NAV Server, which becomes part of the server URL. Default value: 7046 Valid range: 1 - 65535
WebServicePort	The listening HTTP port for Microsoft Dynamics NAV Web services. Default value: 7047 Valid range: 1 - 65535
WebServiceSSLEnabled	The parameter for whether SSL (https) is enabled for the Web service port. Default value: false Values: true, false