NAV 2015 Virtual\Hidden Tables

If you need to read data from Virtual Tables in NAV 2013 and NAV 2015 My Best NAV Virtual Tables\Hidden Tables NAV Developer Environment Buld a new page on virtual table, run page, Filter Records with NAV Filters example : Table Information Post Views: 1,632

“Power BI”, You are welcome !

“Power BI is now Generally Available“ with a big list of new features and capabilities. Read from the blog. http://msft.it/6011BEby7 “Announcing Power BI general availability coming July 24th” http://blogs.msdn.com/b/powerbi/archive/2015/07/10/announcing-power-bi-general-availability-coming-july-24th.aspx#whatsnew Power BI “Topics” Power BI Desktop, Power BI web authoring and data exploration enhancements, Power BI visuals open source project,Team collaboration and enhanced Excel support, New Power BI mobile app for […]

Upgrading to NAV 2015 and automation with Powershell

Nice updated pages on MSDN about “Upgrading to NAV 2015 and automation with Powershell Scripts” Upgrade To upgrade to Microsoft Dynamics NAV 2015, you must complete the following main steps: 1) Convert the database, 2) Upgrade the code, 3) Upgrade the data  https://msdn.microsoft.com/en-us/library/dn271649(v=nav.80).aspx Convert the database https://msdn.microsoft.com/en-us/library/dn271650(v=nav.80).aspx Upgrading the Application Code https://msdn.microsoft.com/en-us/library/dn271652(v=nav.80).aspx Comparing and Merging Application Object Source Files https://msdn.microsoft.com/en-us/library/dn789581(v=nav.80).aspx […]

“ALL” about “Deploying Microsoft Dynamics NAV on Windows Azure”

“ALL” about “Deploying Microsoft Dynamics NAV on Windows Azure” “Preparing” Planning and Preparing https://msdn.microsoft.com/en-us/library/dn271683(v=nav.80).aspx Preparing a Microsoft Azure Virtual Machine Image for Microsoft Dynamics NAV https://msdn.microsoft.com/en-us/library/dn271692(v=nav.80).aspx Preparing for Deploying Microsoft Dynamics NAV on Windows Azure https://msdn.microsoft.com/en-us/library/dn271686(v=nav.80).aspx Scaling the Microsoft Dynamics NAV Network Topology https://msdn.microsoft.com/en-us/library/dn271671(v=nav.80).aspx “Deploying” Walkthrough: Deploying Microsoft Dynamics NAV on a Microsoft Azure Virtual Machine https://msdn.microsoft.com/en-us/library/dn271695(v=nav.80).aspx Deploying Microsoft Dynamics […]

Design Patterns Wiki: “Think NAV in design patterns”

Design Patterns Wiki: “Think NAV in design patterns” Design Patterns Wiki https://community.dynamics.com/nav/w/designpatterns NAV Design Patterns Repository https://community.dynamics.com/nav/w/designpatterns/105.nav-design-patterns-repository Get Involved !!!!    https://community.dynamics.com/nav/w/designpatterns/106.get-involved You have a pattern that you have used successfully? You have ideas on new patterns? You’ve found some existing design patterns which are used in the product but nobody (except a few) knows how it works, but you find […]

“Check NAS” Process execution and Send Mail (Batch control)

“Check NAS” Process execution & Send Mail (Batch control) How System Works > System every “X minutes” check Status of Scheduled Processes and send a mail with Status (batch control) Scheduling > You can schedule this codeunit in some or in another Process Category Queue of your NAS; you can use also another separate NAS Server if you need parallelasynchronous […]

NAV 2015, “How-to” solve “You are not authorized to sign in..” error

How to login in “any database” Follow this and you can login in any database (delete ALL existing configuration and can login) Source Waldo Blog  http://dynamicsuser.net/blogs/waldo/archive/2012/12/05/nav-2013-how-to-log-in-any-database.aspx By SQL Script > Grant SUPER to Role ID in Access control table There are 2 ways for your case, run SQL script on your database: 1. Come back to no user as before you create the user: […]

Check Objects “Modify Date” using “sys.all_objects”

If you need to check “Modify Date” for NAV Objects on SQL Server, you can use SQL Standard Function “sys.all_objects“; you don’t need to use standard NAV Objects Table.   Examples: USE [Demo Database NAV (7-1)]  GO — VIEWS SELECT * FROM sys.all_objects WHERE type_desc like ‘VIEW’ ORDER BY modify_date DESC — TABLES SELECT * FROM sys.all_objects WHERE type_desc like ‘USER_TABLE’ […]

NAV Services and Sessions: Counting, Killing, Timeout

NAV Services & Sessions: Counting, Killing, Timeout Understanding and Configuring Session Timeout “When you start the Microsoft Dynamics NAV Windows client or the Microsoft Dynamics NAV Web client, a connection is established with the Microsoft Dynamics NAV Server instance, and a corresponding session is added on Microsoft Dynamics NAV Server. Microsoft Dynamics NAV Server includes several timeout settings that determine […]

%d bloggers like this: