New Book availabe: “Building ERP Solutions with Microsoft Dynamics NAV”

Hi Guys, a new book is available: “Building ERP Solutions with Microsoft Dynamics NAV”, by Stefano Demiliani (Author) and Duilio Tacconi (Reviewer).


… I spoke yesterday with these 2 guys (my colleagues and friends) during a workshop about “New Modern Development Experience“, i didn’t know that today would be released the book .. i thought later…  but today Amazon quickly provided me a copy (ebook) for review, i will read in next days….

About This Book

  • Integrate NAV with various offerings of the Microsoft stack to create enterprise-ready and service-oriented solutions
  • Use Power BI and Universal Windows Platform for effective data analysis and real-time tracking with NAV
  • Discover the services offered by Microsoft Azure and implement them in different industries using real-world case scenarios

This Book is for

“This book is for NAV developers and solution architects who need to implement real-world enterprise solutions based on Microsoft Dynamics NAV. Knowledge of the NAV programming language (C/AL) and C# language is recommended. Knowledge of ASP.NET and Visual Studio development would help, but is not necessary.”.

You can find this book on:



Fast first look: for now it seems very interesting, some nice topics (that were not included before in other books) are exposed, i recommend it.

Have a nice reading !


NAV 2017 with Office 365 and Sharepoint Integration

Recently i found some questions in Microsoft Dynamics Community about these two topics: Office 365 and Sharepoint Integration with NAV. Some time ago, i talked about Azure deployment, take a look at my old post “ALL” about “Deploying Microsoft Dynamics NAV on Windows Azure” NAV 2015 ; now i would like to talk about Dynamics NAV with Office 365 and Sharepoint Integration

Best goals:
Dynamics NAV with:
– Office 365 Integration
– Sharepoint Online Integration
– “Complete Demo Environment of Dynamics NAV 2017” – Azure


Image from Freddy Blog

Existing powershell scripts “ready to go”
Powershell Scripts are existing and ready to use, you can find these scripts in Dynamics NAV DVD Image folders or in c:\DEMO\ for Dynamics NAV Azure Images deployments (the folders will be created directly by images).
Example : Files are located in: “D:\Dynamics.100.W1.2087091.DVD\WindowsPowerShellScripts\NAVOffice365Administration\ or in  c:\DEMO\ for NAV 2017 Azure Images.



A List of “Suggested” Links
Below a list of suggested links to achieve correct installation\configuration for a complete NAV 2017 Demo Environment with Office 365 and SharePoint Integration. Best Links (from my opinion) are available on Freddy Blog, note that all links from Freddy are free to use (not under NDA or only for Partners…), very useful for ALL people.



About Azure Images
The Microsoft Dynamics NAV Image in the Azure Gallery

One NAV 2017 on Azure – Loaded please…

Azure DEMO scripts Deployment Gallery Image NAV NAV 2017
navdemodeploy – under the hood

Setup your NAV 2017 DEMO environment

Azure DEMO scripts Deployment – using PowerShell




About Office 365 Integration


Folder DEMO/O365 Integration

On Partnersource
Install O365 integration – DEMO Install Script (NAV 2016)

Configure the Outlook/Office Add-in

GREAT VIDEOS – “HOW DO I” NAV 2017 Office 365 Integrations

How Do I: Bring your Microsoft Dynamics NAV Demo Instance in Office 365

“How Do I” configure the outlook add in

“How Do I” Configure the Excel Add-in in Microsoft Dynamics NAV 2017

“How Do I” Synchronize my Microsoft Dynamics NAV contacts with Office 365



About Sharepoint Integration
SharePoint and Microsoft Dynamics NAV – best topics


From MSDN Online:

“If you set up a SharePoint site, you can add Microsoft Dynamics NAV as an app to the site so that the Microsoft Dynamics NAV Web client opens when the user chooses an icon. Then, you can add web parts that show Microsoft Dynamics NAV data, such as a list of sales invoices with overdue payments. Users can drill down into the data and the web parts will open the relevant page in the Microsoft Dynamics NAV Web client when the user chooses an icon or a link.”

Access NAV 2017 via a SharePoint Portal

Integrating Microsoft Dynamics NAV in SharePoint Sites

Developing and Installing a Microsoft Dynamics NAV Apps for SharePoint

Troubleshooting: Microsoft Dynamics NAV and SharePoint

Dynamics Navision 2015 Integration with SharePoint Online and office O365 – How to embed Dynamics Navision 2015 Pages into SharePoint Online

OFFICE 365 INTEGRATION IN NAV 2015 – Word/Excel/SharePoint by ksdconsultancy

Have a nice integration.

Dynamics NAV New Books

Many ask in the forum about books\ebooks\kindles on Dynamics NAV 2017; actually there are no books on Dynamics NAV 2017 (…the same for Dynamics 365 Business Edition), many books have been updated at least to Dynamics NAV 2016.

Good News: “New books on Dynamics NAV will be released soon”.
Below you can find the title and release date of each book, i must point them, the upcoming books look very interesting !


You can find books on Amazon or on PacktPub (also from other sites)

NAV books

Books currently purchasable

Implementing Microsoft Dynamics NAV – Third Edition (by Alex Chow)

hi already talked about this book long ago, take a look to my old post.

Microsoft Dynamics NAV 2016 Financial Management – Second Edition
by Anju Bala

Extending Microsoft Dynamics NAV 2016 Cookbook
by Alexander Drogin    at this time i’m writing a review of this book (Kindle)

Einstieg in Microsoft S Dynamics NAV: Microsoft® Dynamics(tm) NAV 2016
Books that will be released soon (only bookable books)

Building ERP Solutions with Microsoft Dynamics NAV (available from August 2017)
by Stefano Demiliani

Mastering Microsoft Dynamics NAV 2016 (avalialble from September 2017)
Rabindra Sah

Programming Microsoft Dynamics NAV – Fifth Edition (available from November 2017)

Have a nice reading !

Azure Days – Milano, 26 gennaio

“Azure Days”, 26 gennaio 2017 – 09:00 – 18:00


Fondazione Feltrinelli
Via Alessandro Volta 23, Milano (MI)
“Nell’era della Digital Transformation, il Cloud di Microsoft permette alle organizzazioni di realizzare il proprio percorso di innovazione garantendo sicurezza e scalabilità.
Azure è al centro di questo momento di trasformazione strategica grazie alle proprie caratteristiche in termini di compliance, funzionalità di sviluppo e di gestione della infrastruttura.
Partecipa agli Azure Days per approfondire tutti questi aspetti con l’aiuto di partners, ISV ed esperti del settore.”
Azure Days Short Link Evento

Dynamics NAV as SaaS …and 365 as IaaS

Dynamics NAV as SaaS (Software as a Service)
hi Guys,
some people have asked me information about this topic, below a little group of links about this topic (…old but actual).
ABOUT SAAS (Software as a service)
Introducing Microsoft Dynamics NAV Managed Service for Partners
Microsoft Definition:
“The Microsoft Dynamics NAV managed service enables Dynamics partners to easily offer SaaS solutions to their customers, deployed on Azure infrastructure and managed by Microsoft Cloud Engineers.  It reduces the operational, technical and administrative complexity of deploying and maintaining multi-tenant NAV solutions in the cloud while at the same time enables partners to leverage the latest and greatest Microsoft technology.”
“Following the launch of Microsoft Dynamics NAV 2016, we are pleased to announce general availability of the Microsoft Dynamics NAV managed service for partners, a significant new option for Microsoft partners  interested in providing multitenant Software-as-a-Service (SaaS) solutions built on Microsoft Dynamics NAV and deployed in the cloud on Microsoft Azure.”
The Microsoft Dynamics NAV managed service is a highly scalable and reliable platform-as-a-service offering that consists of:
Streamlined administration: A new management portal and web services API enable Microsoft partners to efficiently deploy, manage, upgrade and monitor Microsoft Dynamics NAV multitenant solutions on Microsoft Azure.
Simplified operations: Cloud-optimized licensing and billing helps partners deploy customers more quickly, manage users seamlessly, and receive a single bill from Microsoft for the service.
Microsoft Azure:  Auto-scaled, load-balanced and highly-available, the service utilizes Microsoft Azure, which includes many built-in benefits such as enterprise-class security, geo-replication, backup support, and point-in-time restore.
24×7 support from Microsoft: Microsoft Cloud Engineers monitor and maintain partner solutions, customers, and users, offering Microsoft partners a financially-backed SLA of 99.9% availability.
The Microsoft Dynamics NAV managed service has been in preview since April 2015, with partner solutions and customers live on the service today.
Partners interested in the Microsoft Dynamics NAV managed service can find more information at:
…some other useful links:
Microsoft Dynamics NAV 2016 now available, as is Microsoft Dynamics NAV 2016 managed service for partners
ABOUT IAAS  (Infrastucture as a service)
and now … “THE IaaS ERA”… (from NAV TechDays 2016- Mibuso)
nice video here:
THE “NAVTechDays 2016 Playlist” (ALL VIDEOS)

Future Decoded with Community Days

Future Decoded with Community Days
Milano, 06-07 ottobre 2016
2 giorni, 10 tracks, 66 sessioni, 46 speaker
futiure decoded 6-7 ottobre 2016
Community e user group italiani insieme per i dieci anni di Community Days, Microsoft in un grande momento di confronto e condivisione di esperienze.”
“2 giornate di approfondimento tecnico, piú di 50 sessioni, demo e conferenze.”
My Favorite Sessions (“Azure Path”)
– Come integrare architetture cloud e on-premise
– SQL Server 2016 e Azure SQL Database
– Ottimizzare le prestazioni di SQL con la configurazione
– Gestione degli scenari ibridi con Microsoft Azure
– Remote Desktop Services: novità e stato dell’arte con Azure e Windows Server 2016
Link Iscrizione

Azure “GoUp and Goto Sleep” Maintenance Scripts

Azure “GoUp and Goto Sleep” Maintenance Scripts
Below two simple scripts to Startup & Shutdown Azure Virtual Machines; you can use these samples scripts with “Azure Scheduler Agent” to reduce costs using “pay for use” Azure subscriptions.
workflow startup-vm
$Cred = Get-AutomationPSCredential -Name ‘My Scheduler’
Add-AzureAccount -Credential $CredInlineScript

    Select-AzureSubscription -SubscriptionName “My Subscription Name”

$VMS = Get-AzureVM

    foreach($VM in $VMS)
$VMName = $VM.Name
Start-AzureVM -ServiceName $VM.ServiceName -Name $VM.Name
Write-Output “Shutting down VM :  $VMName ”
workflow shutdown-vm
$Cred = Get-AutomationPSCredential -Name ‘My Scheduler’
Add-AzureAccount -Credential $CredInlineScript

    Select-AzureSubscription -SubscriptionName “My Subscription Name”

$VMS = Get-AzureVM

    foreach($VM in $VMS)
$VMName = $VM.Name
Stop-AzureVM -ServiceName $VM.ServiceName -Name $VM.Name -Force
Write-Output “Shutting down VM :  $VMName ”
you are welcome !

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

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

azure NAV 2015


Planning and Preparing

Preparing a Microsoft Azure Virtual Machine Image for Microsoft Dynamics NAV

Preparing for Deploying Microsoft Dynamics NAV on Windows Azure

Scaling the Microsoft Dynamics NAV Network Topology


Walkthrough: Deploying Microsoft Dynamics NAV on a Microsoft Azure Virtual Machine

Deploying Microsoft Dynamics NAV Using the Example Scripts
The Example-1VM.ps1 and Example-2VM.ps1 scripts are located in the
\WindowsPowerShellScripts\Cloud\HowTo folder on the Microsoft Dynamics NAV installation media (DVD).

Deploying and Managing Microsoft Dynamics NAV on Microsoft Azure


How to: Create a Windows Azure Virtual Machine Operating System Image for Microsoft Dynamics NAV

How to: Get the Microsoft Azure Image Name

How to: Create a Microsoft Azure Virtual Machine Operating System Image for Microsoft Dynamics NAV

…nice Videos by Aleksandar Totovic here:

How Do I Deploy Microsoft Dynamics NAV 2015 on One Microsoft Azure VM

How Do I Deploy Microsoft Dynamics NAV 2015 on Two Microsoft Azure VMs

With “Powershell”

great post by Vjeko here…

Powershell Script to create a “Self-Signed Certificate” that works on Dynamics NAV Ipad APP

Powershell Script to create a “Self-Signed Certificate” that works on Dynamics NAV Ipad APP



Automated scripts (with Powershell) to create a self-signed certificate usable for Dynamics NAV App on Ipad (if you haven’t a Real Commercial Verified Certificate)

This “Powershell automation Script” is based on manual procedure existing in this post How to get Microsoft Dynamics NAV for tablets to connect using a self-signed certificate” by NAV Team Blog and also based on some scripts by Duilio Tacconi of Microsoft Support Emea.

STEP 1: REQUIREMENTS FOR USE PRE-USE CERTIFICATE “SELF-SIGNED” – Best Practice Microsoft  suggest  to use a valid certificate (ex: Purchased from Verisign) – Suggested (but not mandatory) is to install at least the cumulative NAV Update 8 2015 (CU8), it needs to use better management of self-signed certificate (unofficial, not from Vendor).


  • First, if you have already created certificates for use with App and these don’t work, remove them all using the console:


STEP 3: PROCEDURE FOR CREATING A NEW SELF-SIGNED CERTIFICATE – This procedure must be used after the installation of Navision Server. CREATION (BUILD) OF NEW CERTIFICATE – This procedure creates / uses a new self-signed certificate – Unzip the file with everything you need (KIT PRE-EXISTING available to Deploy NAV on AZURE), put in the default example C:\Certificates\Initialize\Initialize\”

 Initialize Standard.ZIP File



This file has been modified to the case: “Self-Signed Certificate tested on iPad App” (was commented on what is not needed in our test case environment and changed the parameters)   Open the file with Powershell ISE as administrator (Run as administrator) and check the settings and make changes if necessary.

SCRIPT:  InstallCert.ps1 , SCRIPT :Certificate.Ps1

Download Powershell Scripts Form here:  POWERSHELL FILES CERTIFICATE  or from my GITHUB Branch “Self-Signed-Certificate”





STEP 4:  Running the file “InstallCert.ps1”

  • From line to line with F8 (debug) in powershell ISE so if there are errors you can understand and correct, or run the entire script with F5 if you are unsure.

STEP 5: INPUT PARAMETERS Two parameters are requested:

  • The first (Default Login)


-The second: (NAV Server: press enter taking one proposed)

step5 2

The script stops and restarts the services, once finished, take the certificate and send it on iPad (example à send to email) STEP 6: INSTALLATION CERTIFICATE ON IPAD -Click on the file in the mail and follow the installation procedure on Ipad. STEP 7: LAUNCH DYNAMICS NAV APP -Finished open “Dynamics NAV App” and enter the address

“To Run” Dynamics NAV Ipad App

  • Download Ipad App : Dynamics NAV from App Store
<li><b>Install Certificate on Ipad (Double Click on .CER File)</b><strong> </strong></li>
<li>Run Ipad App and set <strong>NAV Server Link</strong> : <strong>EXAMPLE </strong><a href=""></a></li>
<li>Insert username e password User: NAV (DOMAIN\User) PWD:  PasswordBINGO !</li>

BINGO ! …. Have a nice Day !