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

Dynamics NAV with Power BI


Dynamics NAV with Power BI

I spoke recently of using NAV with Power BI, currently this topic (NAV integration with Power BI) is current and widely discussed, many questions about “How-to” integrate new and old releases on NAV with Power BI. I have collected a series of posts videos on Power BI and about integration with NAV (the most interesting that I fond).

MICROSOFT POWER BI

Best Definition by Microsoft: “Microsoft Power BI is a Microsoft’s Business Analytics service for Visualizing, exploring and deriving insights from data!”

Power BI Portal

https://powerbi.microsoft.com

Power BI Features

https://powerbi.microsoft.com/it-it/features/

“HOW-TO “GET STARTED

Get Started

https://powerbi.microsoft.com/it-it/documentation/powerbi-service-get-started/

https://powerbi.microsoft.com/it-it/get-started/

Power BI Free ebook

https://robertostefanettinavblog.com/2016/06/18/introducing-microsoft-power-bi-free-ebook-from-sqlbi/

Power BI Developer

https://powerbi.microsoft.com/it-it/documentation/powerbi-developer-overview-of-power-bi-rest-api/

https://powerbi.microsoft.com/it-it/get-started/

Nice series of pages about power BI on EID Site (NAVlab Partner)

http://www.eid.it/microsoft-powerbi/

ABOUT DYNAMICS NAV CONTENT PACK & CONNECTOR

Power BI Integration

https://robertostefanettinavblog.com/2016/03/15/power-bi-integration-microsoft-dynamics-nav-microsoft-power-bi/

https://powerbi.microsoft.com/en-us/integrations/microsoft-dynamics-nav/

Microsoft Dynamics NAV with PowerBI.com

https://suvidhablogpost.wordpress.com/2015/10/13/microsoft-dynamics-nav-with-powerbi-com/

Dynamics NAV Content Pack

https://powerbi.microsoft.com/it-it/documentation/powerbi-content-pack-microsoft-dynamics-nav/

https://robertostefanettinavblog.com/2016/02/04/connecting-dynamics-nav-20132015-to-the-nav-content-pack-in-powerbi-com/

Microsoft Dynamics NAV and Power BI (with O365) – Schedule Report Refresh

https://suvidhablogpost.wordpress.com/2014/12/09/microsoft-dynamics-nav-and-power-bi-better-together/

BEST CONNECTORS FOR DYNAMICS USERS

BEST VIDEOS

Power BI Desktop for Beginners: Create your first Power BI report and dashboard in 10 minutes

https://www.youtube.com/watch?v=h6AIAxMEDiw

Webinar Basics of Power BI for NAV users

https://www.youtube.com/watch?v=v9VIfrXwAfo

Power BI and Microsoft Dynamics NAV by Steven Renders

https://www.youtube.com/watch?v=u_nWPvBkU9w

Power BI and Microsoft Dynamics NAV 2016

https://www.youtube.com/watch?v=Qbx0FdlZDBk

Enjoy!

NAV 2017 not documented options for “Credential Type”


In NAV 2017 there are two new options for “Credentials Type”: TaskScheduler and EchangeIdentity.

“Credential Type” -> “AS IS” Documentation
“Specifies the authentication mechanism for Microsoft Dynamics NAV users of this Microsoft Dynamics NAV Server instance.”
The options are “Windows, Username, NavUserPassword, and AccessControlService”.

But… What about others features ?  “TaskScheduler”, “EchangeIdentity”, “None” ?

In reality now there are three not documented options in the online help and also in NAV admin console help: “TaskScheduler”, “EchangeIdentity”, “None”   …the option “None” was already existing in 2016, undocumented.

NAV 2016

nav-2016-1

NAV 2017

nav-2017-2

nav-2017-3

I asked Microsoft to update the documentation on MSDN (not updated from NAV 2016), useful in explaining exactly the “scope” and the “ByDesign” concept of each option.  I’ll let you know!  .

I have the solution (23/03/2017..) !.. Thanks to Microsoft…  -> “These options are for Dynamics 365 for Financials” .. IASS applications !!!  .not for NAV.

MSDN – “Users and Credential Types”
https://msdn.microsoft.com/en-us/dynamics-nav/users-and-credential-types

 

Some old posts

I have already talked about the new task scheduler and new NAV Admin console options previously, below some links that can be useful.

NAV 2017 “Task Scheduler”
https://robertostefanettinavblog.com/2016/11/04/nav-2017-task-scheduler/

NAV 2017 – What’s new in the Administration Console
http://www.pakiki.info/2016/11/01/nav-2017-whats-new-in-the-administration-console/

How to force specific service instance in Task Scheduler in NAV 2017?
http://forum.mibuso.com/discussion/68576/how-to-force-specific-service-instance-in-task-scheduler-in-nav-2017

DIRECTIONS EMEA 2017


October 4-6, 2017 Madrid, Spain

“The future is Dynamics. Join the largest community of ERP and CRM partners.”

emea 2017.png

About Directions EMEA

Directions EMEA is the independent conference for Microsoft Dynamics partners focusing on SMB customers, it is organized for partners by partners. Directions EMEA brings together over 2000 developers, implementers, technical experts, sales and executive/owner representatives from Microsoft Dynamics Partners across Europe.

To receive information on the Super Early Bird and group discounts as well as Directions EMEA webinars, please sign up to the Directions EMEA newsletter on directionsemea.com.

Registration starts on February 15

http://www.directionsemea.com

“ALL About” Microsoft Dynamics 365 for Financials


Another post of “ALL About” Series (the most appreciated by my readers….), in this case i want to talk about Microsoft Dynamics 365 for Financials because some people asked me information about it; i would like to remember that in ITALY is not yet available and remember also that I’m not an MVP of Dynamics 365 (i don’t think they exist today, maybe they will exist in the future), only of NAV.
Below I have gathered many of the existing links related to Microsoft’s officials information, a lot of posts, links, videos and forums’s discussions.
When Microsoft Dynamics 365 for Financials will be launched in Italy of course I’ll take care about it with a dedicated post about released product.

Stay tuned !

365-for-finacicla-microsoft

LINKS

ABOUT MICROSOFT DYNAMICS 365
Welcome to Microsoft Dynamics 365 !
https://robertostefanettinavblog.com/2016/11/01/welcome-to-microsoft-dynamics-365/

Microsoft Dynamics 365 Roadmap
https://roadmap.dynamics.com/

Availability Guide
http://download.microsoft.com/documents/en-us/dynamics/Dynamics_365_International_Availability_Deck.pdf

365-for-financials

Dynamics 365 Documentation
https://www.microsoft.com/en-us/dynamics365/financials
https://docs.microsoft.com/en-us/dynamics365/

Launch Videos
Microsoft Dynamics 365 for Financials
https://www.microsoft.com/en-us/dynamics365/financials#hero-video-01

Microsoft Dynamics 365 Channel
https://www.youtube.com/channel/UCJGCg4rB3QSs8y_1FquelBQ

Dynamics 365 for Financials – Getting Started
https://www.youtube.com/watch?v=2D5tmAGxvc8

“Welcome to Microsoft Dynamics 365 !” launch video by Microsoft
https://youtu.be/LTJJEubW9iM

Connect Your Business with Dynamics 365 Financials – Mark Brummel
https://www.youtube.com/watch?v=q6ADHrDJW6M

Digital Transformation with Microsoft Dynamics 365, Microsoft
https://www.microsoft.com/en-us/dynamics365/first-look

ITALIAN LAUNCH LINKS (NOT AVAILABLE AT TODAY! …it’s coming)
https://www.microsoft.com/it-it/dynamics365/home?&WT.srch=1&WT.mc_id=AID[529538]_SEM_RGSTgANW

“Fai crescere la tua azienda in base alle tue esigenze Grazie alle applicazioni per ERP e CRM, Microsoft Dynamics 365 ti offre la possibilità di scegliere. Inizia con le componenti base necessarie alla tua attività e soddisfa i tuoi clienti, quindi aggiungi app a seconda delle esigenze.”

365-not-for-italy

MICROSOFT EVENTS
https://events.microsoft.com
Serch for events “dynamics 365”
example: “Enhance your business with Dynamics 365 – PowerApps and Flow”
Event Time,  12 Apr, 2017 9:00 AM – 10:00 AM

“Event Description, During this event we will introduction you to using Microsoft Flow and Using Power Apps with Dynamics 365 by presenting real live scenarios and demos. This session will help you better understand which are the integration possibilities and how to make the most out of the new functionalities which are part of Dynamics 365.

OTHERS LINKS\POSTS
Dynamics NAV 2017 Vs Dynamics 365 for Financials
Great post by Amol relinked to my blog: “NAV 2017 vs Dynamics 365, Battle Card”
https://robertostefanettinavblog.com/2016/11/19/nav-2017-vs-dynamics-365-battle-card-by-amol-dynamics-nav-users-dug/

365-battle-card

“How-to” support pages
https://community.dynamics.com/business/b/financials/archive/2016/11/01/how-to-get-support-for-dynamics-365-for-financials

Dynamics 365 Team Blog (from CRM to…)
https://blogs.msdn.microsoft.com/crm/

Save the date: “Microsoft Dynamics 365 first look” – Microsoft Dynamics Community
https://robertostefanettinavblog.com/2016/10/03/save-the-date-microsoft-dynamics-365-first-look-microsoft-dynamics-community/

Free Dynamics 365 Customisation Training
https://www.365talentportal.com/blog/free-dynamics-365-customisation-training/

Dynamics NAV 2017 vs Dynamics 365: Microsoft Executive Q&A at Directions EMEA 2016
https://community.dynamics.com/nav/b/russianerpexperience/archive/2016/10/14/dynamics-nav-2017-vs-dynamics-365-microsoft-executive-q-amp-a-at-directions-emea-2016

MS Dynamics NAV Guru – TAG 365
http://msdynamicsnav.guru/wp/?s=365

COMMUNITIES
Microsoft Communities
Dynamics Community “Business” new section
https://community.dynamics.com/business

PRICES AND LICENSING
About Dynamics 365 Pricing and Licensing

Dynamics 365 pricing
https://www.microsoft.com/en-us/dynamics365/pricing

Microsoft Dynamics 365 Pricing and Licensing info available on Partnersource
https://dynamicsuser.net/nav/b/mohana/posts/microsoft-dynamics-365-pricing-and-licensing-info-available-on-partnersource

SOME MY OLD POSTS
Microsoft Dynamics 365 News
https://robertostefanettinavblog.com/2016/07/06/microsoft-dynamics-365-news/

Ex Project Madeira Preview
https://www.youtube.com/watch?v=uEUK8bMNt-w
https://robertostefanettinavblog.com/2016/10/19/dynamics-365-financials-preview-ex-project-madeira/
https://robertostefanettinavblog.com/2016/04/05/project-madeira-preview/

OLD POSTS BY MICROSOFT
https://www.microsoft.com/en-us/dynamics/erp-small-midsize-business.aspx
https://community.dynamics.com/b/msftdynamicsblog/archive/2016/07/13/reinventing-business-processes
https://community.dynamics.com/b/msftdynamicsblog/archive/2016/07/06/insights-from-the-engineering-leaders-behind-microsoft-dynamics-365-and-microsoft-appsource

Stay Tuned !

“How to” print reports to PDF and send email


“How to” print reports to PDF and send email

Hi guys, another post about my “How to” posts series.

In this case, I want to talk about this topic: “How to” print reports to PDF and send mail; we can have some methods to achieve this goal, with NAV 2017, NAV 2016 and with old NAV releases.

First Scenario: “How to” print reports to PDF

Schedule a report to print to PDF Format

1) “HOW TO” PRINT REPORTS TO PDF FORMAT

WITH NAV 2016 and mailing & sending documents process

“In NAV 2016 managing mailing & sending documents process has been improved.
Compared to the NAV 2015 version, you can send documents to printer, via email and via EDI in a single operation; you can set a default “document sending template” for each customer.
For this purpose new NAV objects have been introduced.”

Look at my old post here: https://robertostefanettinavblog.com/2016/05/30/nav-2016-documents-sending-objects-features/

WITH NAV 2017 and NST Reports Parameters

With NAV 2017, we can use NST Reports Parameters to activate “SAVEAS” function to produce reports in PDF format, we can schedule a report with PDF Output using SAVEAS function in report scheduling.

To achieve this gold you need only to:

Activate SAVEAS function in NST report section

Schedule a report in task scheduler

Configure the Output Layout for report

Example:

Look at my old post here NAV 2017 Task Scheduler https://robertostefanettinavblog.com/2016/11/04/nav-2017-task-scheduler/

and look at section of post: “JOB QUEUE” IMPROVEMENTS

NST Reporting Parameters (nice for activate “SAVEAS” function for reporting scheduling)

Sample of Report Scheduling

WITH OLD NAV RELEASES

..but for older releases of NAV we need to produce a PDF Output using SAVEAS function after report printing, we haven’t report parameter optionrequest page available in older releases.

To achieve this gold you need only to:

Activate SAVEAS function in report

Schedule a report in task scheduler

NAV 2013 SAMPLE REPORT TO CREATE PDF IN BATCH MODE (in this case using report 206 Sales Posted Invoice)

Scenario

Generate PDF report with SAVEAS feature

Schedule this report on Job queue

SAVEASPDF Function (Report)
[Ok :=] REPORT.SAVEASPDF(Number, FileName[, Record]) OR

[Ok :=] ReportVariable.SAVEASPDF(FileName)

“When you call SAVEASPDF, the report is generated and saved to “FileName.” A Saving to PDF window shows the status of the process. Note that the request page will not be shown.

The FileName parameter specifies a location on the computer that is running Microsoft Dynamics NAV Server. “

Source MSDN: https://msdn.microsoft.com/en-us/library/dd301166(v=nav.70).aspx

Example

Filename := ‘C:MyReportsreport206Demo.pdf’;

ReturnValue := Report.SAVEASPDF(206, Filename, record);

Sample of PDF generator batch

Codeunit CreatePDFFromPostedInvoices()

CreatePDFFromPostedInvoices()

// READING ALL POSTED INVOICES TO PRINT PDF REPORTS

SalesInvoiceHeader.RESET;

SalesInvoiceHeader.SETRANGE(“PDF Generated”, FALSE);

IF SalesInvoiceHeader.FINDSET THEN BEGIN

REPEAT

Filename:= SalesInvoiceHeader.”No.” + ‘.PDF’;

Report.SAVEASPDF(206, Filename, SalesInvoiceHeader); //PDF CREATED BY SAVEAS FUNCTION

UNTIL SalesInvoiceHeader.NEXT = 0;

END;

2) “HOW TO” EMAILING PDF REPORTS

Second Scenario: “How to” emailing PDF reports

Ø Send generated PDF reports via email

Sendmail with NAV SMTP Sendmail Codeunit (NAV .NET integration)

To send email from NAV (OnDemand or Scheduled), you can use standard NAV SMTP Codeunit: Codeunit 400 SMTP Mail.

This codeunit use one .NET object with some functions

Mail DotNet Microsoft.Dynamics.Nav.SMTP.SmtpMessage.’Microsoft.Dynamics.Nav.SMTP’

Functions: CreateMessage, TrySend, Send

Example SMTP SENDMAIL TEST

Subject := ‘SUBJECT SAMPLE TEXT’ ;

Body := ‘BODY SAMPLETEXT’;

SMTP.CreateMessage(‘SENDER’, ‘info@Cronus.it’, ‘r.s@xxxxx.it’, Subject, Body, TRUE);

Body := Body + ‘ OTHER’;

SMTP.AppendBody(Body);

SMTP.Send;

MESSAGE(‘Mail Sended’);

Sendmail with external .NET Integration Solution

Some time ago I published a project solution on MSDN TechNet.

Solution: “Send e-mail with attachment and templates – My Script on MSDN Gallery,a short C# script to send e-mail with attachment and template, DLL .NET usable on Windows Systems.

Function: SetMail(string parfrom, string parto, string parcc, string parsubject, string partextmessage, string parpathattach, stringparpathtemplate)

https://robertostefanettinavblog.com/2015/07/13/send-e-mail-with-attachment-and-templates-my-script-on-msnd-gallery/

https://gallery.technet.microsoft.com/scriptcenter/0c32d24a-3651-4fe1-8d10-80f9c6440a70

MY NEW SENDMAIL 2.0 PROJECT WITH WS INTEGRATION

Sendmail 2.0 C# Project

New Features:

Complete package solution (PRINT REPORTS TO PDF+SEND EMAIL INTEGRATION)

NAV Web Services integration

Best mailing errors check and logging.

SOON AVAILABLE: look at MSDN Scripting gallery section or on my GitHUb page soon.

PRODUCTION ORDERS IN NAV


Roberto Stefanetti NAV Blog

PRODUCTION ORDERS IN NAV
…a short guide about NAV Production Orders, based on MSDN Online NAV help.

prodorder

PRODUCTION ORDER PURPOSE
General Definiton : “Production Order – an order that initiates the manufacturing process”

Wikipedia Defintion:
A production order is an order issued within a company to produce a specific quantity of material within a certain timeframe. A production order may be issued pursuant to a sales order, and its issuance triggers a number of events. If components in the bill of materials are in stock, reservations are generated for those items; if they are not in stock, then requisition orders may be generated. Requisition orders may also be generated for production that occurs externally to the firm. Planned costs for the order are also generated and capacity requirements are generated for the work centers.”
https://en.wikipedia.org/wiki/Production_order

NAV PERSPECTIVE: “Production orders are the central components of the Microsoft Dynamics…

View original post 927 altre parole

SCM (Source Control Management) with NAV


..most viewed post about SCM.,, “nice” to reblog.

Roberto Stefanetti NAV Blog

SCM (Source Control Management) with NAV

do you need to use NAV with SCM (Source control Management) integration ?

…you can use two applications to reach this goal.

– Visual Studio Online (and team foundation server) (free for 5 users)

https://www.visualstudio.com/en-us/products/visual-studio-team-services-pricing-vs.aspx

– GIT (free and open source)

https://www.git-scm.com/about/free-and-open-source

You can find a script on codeplex for using GIT and NAV (integration with TFS and GIT) …. and Others nice free scripts at links below (always on codeplex repository)

1) NAV Powershell scripts and TFS Build Template

https://navscripts.codeplex.com/

2) TFS Build Template for GIT repository

https://navscripts.codeplex.com/wikipage?title=TFS%20Build%20Template&referringTitle=Home

Some parts of the scripts are based on work (Waldo) see http://www.waldo.be/tag/powershell/

Some parts are based on PowerShell scripts from module “Microsoft.Dynamics.Nav.Ide” made by Microsoft people.

My GIT@  https://github.com/rstefanetti   https://github.com/rstefanetti/NAV_SQL

View original post

Microsoft Forum 2017


Microsoft Forum 2017

Mercoledì 8 marzoMiCo, Gate 3, Viale Scarampo, Milano

formum-2017-1

forum-2017

La 2Rivoluzione Industriale 4.0″ e i cambiamenti che sta generando sul mercato

La 2a edizione del più grande evento annuale di Microsoft rivolto ai decisori aziendali.
Dove l’industria italiana e l’innovazione convergono e danno vita a nuova conoscenza e nuove idee.”

Sessioni tematiche: cybersecurity, big data & analytics, intelligenza artificiale e cognitive services, IoT, smart working e smart collaboration, cloud computing, CRM & ERP, licensing.

Link  Evento https://www.microsoft.com/italy/microsoftforum/index.html

Registrazione Evento https://www.microsoftevents.com/profile/form/index.cfm?PKformID=0x12095982d53

Social  MSEventsITA@microsoft.com   #MSForum2017  #AccelerateBiz

 

navlab-foru-2017

LE SOLUZIONI INNOVATIVE DI NAV-lab al Microsoft Forum 2017

Anche quest’anno il gruppo NAV-lab partecipa attivamente all’evento e si pone tra i principali propositori di innovazione verso le PMI e verso la PA.

I nostri specialisti Dynamics vi accoglieranno nel nostro stand per ascoltare le vostre esigenze e fornirvi risposte concrete per la loro realizzazione:
Sempre nello stand vi presenteremo le nostre soluzioni specialistiche basate su Tempo Zero per Microsoft Dynamics NAV e Microsoft Dynamics 365 e vi mostreremo come abbiamo reso POSSIBILI progetti sofisticati sui nostri clienti.

Link  http://www.navlab.it/web11/news-Microsoft-Forum-2017.html

Vieni a trovarci !

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 !