Wednesday, June 14, 2017

Types of Tables in Microsoft Dynamics Navision 2017

Summary of Tables in MS Dynamics NAV 2017



Hi,
These are the tables that are used in MS Dynamics NAV. It is a summary of the post for all tables present in MS Dynamics NAV. You will learn about these and hope you will enjoy too.

What are tables?

Tables are the collection of records and it is the heart of any database because it contains all the 

values and data for further manipulation of records.

To implement any solution you first need to learn how to store the data in an accurate way. So to get 

the logical output you must check this blog for bettter understanding.

1. Master Tables



2. Journal Tables



3. Document Tables



4. Document History Tables



5. Setup Tables



6. Supplemental Tables



7. Subsidiary Tables



8. Ledger Tables



9. Register Tables



Cumulative Update 07 for Microsoft Dynamics NAV 2017 Build 16996

CU 07 FOR NAV 2017

Microsoft has released its new cumulative update 07 for NAV 2017. You can download the link for 

Cumulative update from the below link.

Download CU 07 NAV 2017
Download CU 2017
The latest update have been released for Microsoft Dynamics NAV 2017 which includes hotfixes.

Note Implementing this cumulative update will require a database upgrade.

It may be necessary to update your license after implementing this hotfix.
For a list of cumulative updates released for Microsoft Dynamics NAV 2017.

Link to see the overview :-

 Overview Details of this Update
 Overview Details of this Update
You can check the list of all updates from here of MS Dynamics NAV 2017.
 List of Cummulative Updates for MS Dynamics NAV 2017
 List of Cummulative Updates for MS Dynamics NAV 2017

Hope you are enjoying it.

Monday, May 29, 2017

Grouping In Export To Excel Report Without Layout in MS Dynamics NAV 2017

Grouping In Report with Code in A/L


Hi All,

Today I Got a Requirement for Excel Buffer Report in Navision and with Grouping of Location 

Code in Item Ledger Entry.

Typically it was tough requirement , but thanks to MS Dynamics Community and Saurabh Dhyani Sir

for his valuable time which shared a most important thing and rarest blog of Navision.

Direct Link For Grouping of Reports via Coding in MS Dynamics NAV

I had used the same method  in MS Dynamics NAV 2017. I am Sharing my FOB with you all to 

download and understand the issue better.



Useful Points about this Report

1. We can use grouping via C/AL Code.

2. We can arrange the Function via boolean Field.

3. Use of Exit Function in MS Dynamics NAV.