Posted inDynamics NAV & BC Tips & tricks
Dynamics NAV Coffee Break – Creating Filtered Views
Learn how to create filtered views in Microsoft Dynamics NAV to be more efficient and productive with the software. Bron : ArcherPoint Lees meer...
Posted inDynamics NAV & BC Tips & tricks
SQL view – NAV
I just experienced a case where Client want to see a common list Page in NAV where he can see a data which is basically a combination of multiple Tables. Though it’s achievable in NAV but you need to write a bulky code on the page…
Posted inDynamics NAV & BC Tips & tricks
Add a relationship using Diagram View in Power Pivot
Open the Workbook which we prepared in the last exercise in our previous post. Add Excel Sheet/Table to the PowerPivot Data Model In the Power Pivot window, in the View section, click Diagram View. Use the slide bar to resize the diagram so that you can…
Posted inDynamics NAV & BC Tips & tricks
Viewing Page Data in Excel Using PowerPivot (OData)
Here I will discuss how you can use OData to expose a Microsoft Dynamics NAV 2015 page as a web service and then analyse the page data using Microsoft PowerPivot for Excel 2013. With OData and PowerPivot, you gain access to a powerful set of tools…
Posted inDynamics NAV & BC Tips & tricks
Apply custom filters and save those filters as a view in Microsoft Dynamics NAV
Microsoft Dynamics NAV allows you to filter a listview by using your own filters. How many times you have wondered if there is a facility to save these filtered views somewhere so we can use it again without going through the same process over and over…
Posted inDynamics NAV & BC Tips & tricks
Using Views and Linked Tables
There are always some cases where you would like to have external data available to Dynamics NAV. In cases where the data is available to the SQL Server hosting the Dynamics NAV database it is easy to create a view in the NAV database and a…
Posted inDynamics NAV & BC Tips & tricks
Localized views removed from NAV 2013 R2
In Dynamics NAV 2009 and older we had an option to maintain views in the database. Activating this caused NAV to create a view for each language and every table in the database. This is a useful thing if you are building BI on top of…