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).

demiliani

… 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:

Amazon
http://amzn.to/2kANTZU

PacktPub
https://www.packtpub.com/application-development/building-erp-solutions-microsoft-dynamics-nav

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 !

Advertisements

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
https://robertostefanettinavblog.com/2015/07/23/all-about-deploying-microsoft-dynamics-nav-on-windows-azure/ ; 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

off-365-1

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.

office-3652

office-3651

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.

 

AZURE

About Azure Images
The Microsoft Dynamics NAV Image in the Azure Gallery
https://blogs.msdn.microsoft.com/freddyk/2016/11/05/the-microsoft-dynamics-nav-image-in-the-public-azure-gallery/

One NAV 2017 on Azure – Loaded please…
https://blogs.msdn.microsoft.com/freddyk/2016/11/19/one-nav-2017-on-azure-loaded-please/

Azure DEMO scripts Deployment Gallery Image NAV NAV 2017
navdemodeploy – under the hood https://blogs.msdn.microsoft.com/freddyk/2016/11/20/httpaka-msnavdemodeploy-under-the-hood/

Setup your NAV 2017 DEMO environment
https://blogs.msdn.microsoft.com/freddyk/2016/11/19/one-nav-2017-on-azure-loaded-please/#setup
http://aka.ms/navdemodeploy

Azure DEMO scripts Deployment
http://aka.ms/navdemodeploy – using PowerShell
https://blogs.msdn.microsoft.com/freddyk/2016/11/19/httpaka-msnavdemodeploy-using-powershell/

DYNAMICS NAV 2016 VM ON MICROSOFT AZURE
http://thinkaboutit.be/2015/10/dynamics-nav-vm-on-microsoft-azure/

 

OFFICE 365

About Office 365 Integration

off-365-3
GITHUB NAV 2017
https://github.com/NAVDEMO/NAV2017

Folder DEMO/O365 Integration

On Partnersource
Install O365 integration – DEMO Install Script (NAV 2016)
http://Aka.ms/DemoNAV
https://mbs.microsoft.com/partnersource/global/readiness-training/readiness-training-news/DemoNAV

Configure the Outlook/Office Add-in
https://blogs.msdn.microsoft.com/freddyk/2016/11/19/one-nav-2017-on-azure-loaded-please/#configuringoutlook

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

How Do I: Bring your Microsoft Dynamics NAV Demo Instance in Office 365
https://msdn.microsoft.com/en-us/dynamics/nav/dn921913

“How Do I” configure the outlook add in
https://community.dynamics.com/nav/b/navvideos/archive/2017/01/12/how-do-i-configure-the-outlook-add-in-for-microsoft-dynamics-nav-2017

“How Do I” Configure the Excel Add-in in Microsoft Dynamics NAV 2017
https://community.dynamics.com/nav/b/navvideos/archive/2016/11/17/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
https://community.dynamics.com/nav/b/navvideos/archive/2016/12/13/how-do-i-synchronize-my-microsoft-dynamics-nav-contacts-with-office-365

 

SHAREPOINT

About Sharepoint Integration
SharePoint and Microsoft Dynamics NAV – best topics

off-365-2

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.”

Links
Access NAV 2017 via a SharePoint Portal
https://blogs.msdn.microsoft.com/freddyk/2016/11/19/one-nav-2017-on-azure-loaded-please/#sharepoint

Integrating Microsoft Dynamics NAV in SharePoint Sites
https://msdn.microsoft.com/en-us/library/dn271706(v=nav.90).aspx

Developing and Installing a Microsoft Dynamics NAV Apps for SharePoint
https://msdn.microsoft.com/en-us/library/dn271653(v=nav.90).aspx

Troubleshooting: Microsoft Dynamics NAV and SharePoint
https://msdn.microsoft.com/en-us/library/dn414712(v=nav.90).aspx

Dynamics Navision 2015 Integration with SharePoint Online and office O365 – How to embed Dynamics Navision 2015 Pages into SharePoint Online
http://www.softwareanswers.co.uk/software_answers/2014/11/dynamics-navision-2015-integration-with-sharepoint-online-and-office-o365-how-to-embed-dynamics-navision-2015-pages-into-sh.html

OFFICE 365 INTEGRATION IN NAV 2015 – Word/Excel/SharePoint by ksdconsultancy
https://ksdconsultancy.blog/2015/07/08/office-365-integration-in-nav-2015-wordexcelsharepoint/

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 !

nav-books

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

https://www.amazon.com   https://www.packtpub.com/

NAV books

Books currently purchasable

Implementing Microsoft Dynamics NAV – Third Edition (by Alex Chow)
http://amzn.to/2jKcTNd

hi already talked about this book long ago, take a look to my old post.
https://robertostefanettinavblog.wordpress.com/2016/04/15/new-book-implementing-dynamics-nav-2016-by-alex-chow/

Microsoft Dynamics NAV 2016 Financial Management – Second Edition
by Anju Bala
http://amzn.to/2k5fxhv

Extending Microsoft Dynamics NAV 2016 Cookbook
by Alexander Drogin
http://amzn.to/2kAtgwG    at this time i’m writing a review of this book (Kindle)

Einstieg in Microsoft S Dynamics NAV: Microsoft® Dynamics(tm) NAV 2016
http://amzn.to/2k5HndM
Books that will be released soon (only bookable books)

Building ERP Solutions with Microsoft Dynamics NAV (available from August 2017)
by Stefano Demiliani
http://amzn.to/2kANTZU

Mastering Microsoft Dynamics NAV 2016 (avalialble from September 2017)
Rabindra Sah
http://amzn.to/2k52YTv

Programming Microsoft Dynamics NAV – Fifth Edition (available from November 2017)
http://amzn.to/2jK3eGM

Have a nice reading !

Azure Days – Milano, 26 gennaio


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

azure-days

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.”
TOPICS
azure-days1
Azure Days Short Link Evento  http://buff.ly/2iDNzcf

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).
saas
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:
CORE MODEL
FAQ
…some other useful links:
Microsoft Dynamics NAV 2016 now available, as is Microsoft Dynamics NAV 2016 managed service for partners
https://blogs.microsoft.com/firehose/2015/10/07/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
azure1
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.
** STARTUP VM **
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 ”
}
}
}
** SHUTDOWN VM **
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

“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 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).
https://msdn.microsoft.com/en-us/library/dn271679(v=nav.80).aspx

Deploying and Managing Microsoft Dynamics NAV on Microsoft Azure
https://msdn.microsoft.com/en-us/library/dn271710(v=nav.80).aspx

“How-to”

How to: Create a Windows Azure Virtual Machine Operating System Image for Microsoft Dynamics NAV
https://msdn.microsoft.com/en-us/library/dn169001(v=nav.80).aspx

How to: Get the Microsoft Azure Image Name
https://msdn.microsoft.com/en-us/library/dn271690(v=nav.80).aspx

How to: Create a Microsoft Azure Virtual Machine Operating System Image for Microsoft Dynamics NAV
https://msdn.microsoft.com/en-us/library/dn271689(v=nav.80).aspx

“Video”
…nice Videos by Aleksandar Totovic here:

How Do I Deploy Microsoft Dynamics NAV 2015 on One Microsoft Azure VM https://msdn.microsoft.com/en-us/dynamics/nav/mt147285

How Do I Deploy Microsoft Dynamics NAV 2015 on Two Microsoft Azure VMs
https://msdn.microsoft.com/en-us/dynamics/nav/mt147286

With “Powershell”

great post by Vjeko here…

http://vjeko.com/blog/creating-azure-vm-nav-2015-using-powershell

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

 STart

PURPOSE

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. http://blogs.msdn.com/b/nav/archive/2014/10/09/how-to-get-microsoft-dynamics-nav-for-tablets-to-connect-using-a-self-signed-certificate.aspx

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).

STEP 2: ELIMINATION OF CERTIIFICATES NOT ALREADY WORKING AND IMPORTED ON IPAD

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

step2

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

initalize

cert2

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” https://github.com/rstefanetti/Powershell/tree/Self-Signed-Certificate

 “POWERSHELL ISE” SAMPLES SCREENS

pw1

pw2

pw3

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)

step51

-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="https://navserver.cloudapp.net/DynamicsNAV80/WebClient">https://navserver.cloudapp.net/DynamicsNAV80/WebClient</a></li>
<li>Insert username e password User: NAV (DOMAIN\User) PWD:  PasswordBINGO !</li>

BINGO ! …. Have a nice Day !