Wednesday, February 14, 2018

List of System and Hidden Tables - Microsoft Dynamics NAV 2018

Below is the list of Virtual and System tables in Microsoft Dynamics NAV 2018. 

If properly used, some of these hidden tables save hours of work for developers. 

Click here to refer a complete blog post about Date table and how to use. 

10 New System tables added in NAV 2018

Object ID
Object Name
Object Caption
2000000081
Upgrade Blob Storage
Upgrade Blob Storage
2000000082
Report Layout
Report Layout
2000000176
NAV App Resource
NAV App Resource
2000000177
Tenant Profile
Tenant Profile
2000000178
All Profile
All Profile
2000000179
OData Edm Type
OData Edm Type
2000000182
Media Resources
Media Resources
2000000186
Profile Page Metadata
Profile Page Metadata
2000000187
Tenant Profile Page Metadata
Tenant Profile Page Metadata
2000000188
User Page Metadata
User Page Metadata

02 New Virtual and Hidden Tables added in NAV 2018
Object ID
Object Name
Object Caption
2000000192
Page Control Field
Page Control Field
2000000193
Api Web Service
Api Web Service

List of all Hidden / Virtual Tables in NAV 2018
Object ID
Object Name
Object Caption
2000000001
Object
Object
2000000007
Date
Date
2000000009
Session
Session
2000000020
Drive
Drive
2000000022
File
File
2000000026
Integer
Integer
2000000028
Table Information
Table Information
2000000029
System Object
System Object
2000000038
AllObj
AllObj
2000000039
Printer
Printer
2000000040
License Information
License Information
2000000041
Field
Field
2000000043
License Permission
License Permission
2000000044
Permission Range
Permission Range
2000000045
Windows Language
Windows Language
2000000048
Database
Database
2000000049
Code Coverage
Code Coverage
2000000055
SID - Account ID
SID - Account ID
2000000058
AllObjWithCaption
AllObjWithCaption
2000000063
Key
Key
2000000101
Debugger Call Stack
Debugger Call Stack
2000000102
Debugger Variable
Debugger Variable
2000000103
Debugger Watch Value
Debugger Watch Value
2000000135
Table Synch. Setup
Table Synch. Setup
2000000136
Table Metadata
Table Metadata
2000000137
CodeUnit Metadata
CodeUnit Metadata
2000000138
Page Metadata
Page Metadata
2000000139
Report Metadata
Report Metadata
2000000140
Event Subscription
Event Subscription
2000000141
Table Relations Metadata
Table Relations Metadata
2000000142
Query Metadata
Query Metadata
2000000154
Database Locks
Database Locks
2000000164
Time Zone
Time Zone
2000000167
Aggregate Permission Set
Aggregate Permission Set
2000000171
Page Table Field
Page Table Field
2000000172
Table Field Types
Table Field Types
2000000173
Finish Design Save Mode
Finish Design Save Mode
2000000178
All Profile
All Profile
2000000192
Page Control Field
Page Control Field
2000000193
Api Web Service
Api Web Service


Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Direction Asia 2018 : Richer integration with logic apps for Microsoft Dynamics NAV and Dynamics 365 (CRM)


I'll be speaking at #DirectionAsia 2018 this March in Bangkok together with Wagner Silveira. Join with me and other Dynamics expects at the Directions ASIA conference!

Topic: Richer integration with logic apps for Microsoft Dynamics NAV and Dynamics 365 (CRM).

Session Type: Technical.

Abstract: Precise, up-to-date Information is key to success, as it adds real value to the decision-making process, making it faster and more reliable.

Today, ERP and CRM systems are really entwined, making really hard to implement one without the other. But a reliable and conflictless integration is quite hard to achieve. Standard Microsoft Dynamics NAV CRM connector works perfectly when a point to point integration and data flow direction are unidirectional - “To Integration Table” or “From Integration Table”. 

But the Microsoft Dynamics NAV CRM Connector can’t cope well when integration requirements become multi-point or bi-directional. So what are the alternatives?

In this session, Tharanga Chandrasekara – Business Solution MVP (Dynamics NAV) -  and Wagner Silveira – Azure MVP - are going to discuss patterns to integrate Microsoft Dynamics NAV and Dynamics 365 (CRM) when multi-point of bi-directional integration is required, that goes beyond the Standard Microsoft Dynamics NAV connector, demoing the use of logic apps with Microsoft Dynamics NAV to achieve bi-directional, close to real time, multi-point integration.


Learn more about sessions on http://www.directionsasia.com/about/more-about-sessions/

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Tuesday, December 5, 2017

Configure Visual Studio Code with Dynamics NAV 2018 (Local Server Installation)

After installing Dynamics NAV 2018 I want to configure Visual Studio Code with Dynamics NAV to use new Development tool

I already had Visual Studio Code installed on my computer (Click to download Visual Studio Code) so I open up the application.

Do not follow Section 01 steps because you will run into issues. Read the Section 02 of the instructions to get it work.

Section 01 :

First thing I want to do is download AL Extention. In order to download AL extension follow below steps:

  1. Go to View Menu and click on Extensions. 
  2. Search for AL 
  3. Click Install


Once the Extention installation is complete I followed below steps:

  1. Press Alt+A, Alt+L to trigger the Go! command, 
  2. Choose "Your own server"
  3. Once you select the "Your own server" you will see a code like below in the "launch.json" file. 


I change the settings as below :


  "version": "0.2.0",  
   "configurations": [  
     {  
                "type": "al",  
                "request": "launch",  
                "name": "Local server",  
                "server": "http://localhost:7049",  
                "serverInstance": "DynamicsNAV110",  
                "tenant": "default",  
                "authentication": "Windows",  
                "startupObjectId": 22  
     }  
   ]  


Once I do that I got an error message, and I could not resolve it. (Could not download symbols. Please see the Visual Studio output log for more details)



Then I thought it is something to do with the Service tier config so I open up the config file and notice that "Enable loading application symbol reference at service startup" is disabled. I enabled it and restart the instance.



Even after that also I could not get to download symbols. Therefore I thought to use a different approach.

Section 02: 

I thought to install AL extension manually by using VSIX file.

  1. Uninstall AL extention from Visual Studio Code.
  2. Click View -> Extention.
  3. Click on ... to open the extension menu.
  4. Click on Install from VSIX



You can find VSIX file on the installation medium path: "ModernDev\program files\Microsoft Dynamics NAV\110\Modern Development Environment" or in the "C:\Program Files (x86)\Microsoft Dynamics NAV\110\Modern Development Environment"


This will install AL Language Version 0.12.15355

Once the Extention installation is complete I follow below steps

  1. Press Alt+A, Alt+L to trigger the Go! command.
  2. Choose "Your own server"
  3. Once you select the "Your own server" you will see a code like below in the "launch.json" file. 


   "version": "0.2.0",  
   "configurations": [  
     {  
       "type": "al",  
       "request": "launch",  
       "name": "Your own server",  
       "server": "http://localhost",  
       "serverInstance": "nav",  
       "authentication": "UserPassword",  
       "startupObjectId": 22  
     }  
   ]  

In my local installation, I use Windows Authentication and my NAV instance is different. Therefore I change the file values as below.

    "version": "0.2.0",  
   "configurations": [  
     {  
       "type": "al",  
       "request": "launch",  
       "name": "Your own server",  
       "server": "http://localhost",  
       "serverInstance": "DynamicsNAV110",  
       "authentication": "Windows",  
       "startupObjectId": 22  
     }  
   ]  

Once I update the values and save the file, it successfully downloads the symbols.

Please let me know if you use a different approach or if it workes with online extension installation for you.

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara