Transcript roberto-stefanetti-mvp-nav-blog-2014-2016

Roberto Stefanetti
NAV Blog
Roberto Stefanetti, MVP
Roberto Stefanetti NAV Blog
2014, 2016
Roberto Stefanetti, MVP
This file was generated by an automated blog to book conversion
system. Its use is governed by the licensing terms of the original
content hosted at
https://robertostefanettinavblog.wordpress.com/.
Powered by
Pothi.com
http://pothi.com
Contents
Dynamics NAV in Remote App Mode
1
Merry Christmas and happy New Year !
5
“How to” display picture from file in Item Picture Page
6
Announcing the Preview of Development Tools for
Dynamics NAV – Nice Christmas!
8
“ALL About” How To Boost Dynamics NAV Server
10
Cumulative Update 01 for Microsoft Dynamics NAV
2017 has been released
16
Microsoft AL: AL language code samples for
developing extensions #DYNDEV365
19
Dynamics NAV as SaaS …and 365 as IaaS
21
NAV 2017 vs Dynamics 365 “Battle Card” by Amol –
Dynamics NAV Users – DUG
25
WPC2016, Milano, 29-11 01-12
26
Dynamics NAV 2017 as an App in Azure Management
Portal – Dynamics NAV Team Blog
27
NAV 2017 “Task Scheduler”
28
NAV 2017 “Assisted Setup”
35
Welcome to Microsoft Dynamics 365 !
37
“ALL About” C/AL Coding Guidelines
39
NAV 2017 and “Microsoft Flow” integration: “Business
Notification Manager” reinvented in Cloud
42
NAV 2017 is available for download !
45
Welcome to the Developer and IT-Pro Help for
Microsoft Dynamics NAV 2017
46
NAV 2017, scheduled for October 28
48
Dynamics 365 Financials Preview (ex Project Madeira)
50
“New Development Environment Preview” at Christmas
time !
52
Directions EMEA 2016, “NAV 2017 What’s New” paths
53
Save the date: “Microsoft Dynamics 365 first look” –
Microsoft Dynamics Community
55
NAV 2017 “Notifications”
57
NAV 2017 WHAT’S NEW – ALL MY POSTS
59
Survey about NAV 2017 new\improved features
62
NAV 2017 LIMITED BETA & DIRECTIONS NA
SESSIONS
64
“How-to” manage NAV notifications by C/AL
66
Future Decoded with Community Days
72
Cumulative Update 11 for Microsoft Dynamics NAV
2016 has been released – Dynamics NAV Team Blog
74
Let NAV BEEP! (with .NET Interop “SystemSounds
Class”)
78
“Cached Web Service Calls” – Microsoft Dynamics
NAV Community
79
Dynamics 365 and more: What you need to know
82
Dynamics Profile: New Dynamics NAV MVP Roberto
Stefanetti Eager to Share More Broadly –
MSDynamicsWorld.com
84
SQL Server Migration Assistant for Datazen now
generally available
85
Word Layout reports data control by C/AL
86
Cumulative Update 10 for Microsoft Dynamics NAV
2016 has been released
88
NAV 2017 Roadmap
89
NAV TechDays 2016, Sessions @02-08-2016
91
A Visual SQL Query Designer – Code project (SQL
From NAV Part III)
93
How to Use MVC.Net on the Dynamics NAV Database
Structure
95
Let NAV Speak (with a Simple and Useful Client
Add-in)
96
“Scheduling Reports” option also available in
report.RUNMODAL instead of report.RUN
97
NAV 2013 SQL Query Codeunit Tool (SQL From NAV
Part II)
98
Load Data into NAV using C/AL and Powershell (SQL
From NAV Part I)
101
NAV Shortcuts & Filters | ArcherPoint, Inc.
105
Dynamics NAV: HR (Human Resources) module –
TechNet Wiki
106
Project “Madeira” topics & links
107
New Scrum guide @Scrumguides.org
108
NAV 2016 Italian Flyer
109
New NAV 2016 videos about “extensions”
110
Database Conversion for a Dynamics NAV database
stored in Azure
112
Announcing NAV 2017 @WPC 2016
113
Some links about Powershell “cmdlets” for NAV
118
Microsoft Dynamics 365 news
125
Automate backup on SQL Express and Send Mail
Powershell Script
128
Cumulative Update 9 for Microsoft Dynamics NAV
2016 has been released
130
Gestione Commesse in NAV (NAV Project
Management Module)
131
Directions EMEA 2016, the biggest NAV event
132
Business Solutions MVP Award 2016 (NAV)
133
Project “Madeira” my presentation on slideshare &
support page
136
Configuring Client Timeout in NAV 2016
CU 8 | Dynamics NAV Team Blog
139
PARAMETRI DI PIANIFICAZIONE IN NAV 2016
140
Introducing Microsoft Power BI – Free ebook from
SQLBI
193
HR (Human Resources) module in Dynamics NAV
195
Scaling Professional Scrum with “Visual Studio Team
Services”, Webcast June 27, 2016
198
“Microsoft Cloud”, Solutions for empowering business
199
Monitoring Microsoft Dynamics NAV 2015 Server
Using “Performance Counters”
200
Retrieve Data from .NET Dialog with .NET integration
202
SQL Server 2016 is generally available
209
New Youtube Playlist “NAV-lab #MSForum2016”
210
Cumulative Update 8 for Microsoft Dynamics NAV
2016 has been released
211
Welcome to Dynamics NAV and Dynamics C5 App
Update Version 2.2
213
NAV 2016 Managing Sending Documents Features
216
NAV TechDays 2016, Sessions @02-08-2016
223
Dynamics NAV 2016 Workflow – YouTube
225
Microsoft Dynamics Youtube Channel
226
GESTIONE ASSEMBLAGGI IN NAV (SIMPLE
“HOW-TO”)
227
Open Pages and Reports with filters using NAV
Command lines
239
RDLC Report and Performance in Microsoft Dynamics
NAV 2015 and 2016 | Dynamics NAV Team Blog
240
Scrum with Asana in 7 steps | Jose Barato
241
NAV 2015 Basic Flowsheets for dummies (IT-IT) –
TechNet Articles – TechNet Wiki
242
OnDemand NAS Codeunits Scheduling
243
Roberto Stefanetti’s Reviews: “Implementing Microsoft
Dynamics NAV – Third Edition”
248
NAV 2016 TESTING NOTIFICATION SYSTEM
252
Cumulative Update 7 for Microsoft Dynamics NAV
2016 has been released | Dynamics NAV Team Blog
257
ABOUT NAV 2016 NAS AND REPORTS
SCHEDULING
260
Comparing Dynamics NAV 2016 and SAP Business
One 9.1
266
“Gestione magazzino fiscale”, NAV Italian Localization
267
25 Best Dynamics NAV Blogs of 2016 – My blog is in
the list !
275
PRODUCTION ORDERS IN NAV
277
“Microsoft Flow” Preview
284
Le soluzioni che abbiamo presentato al
MSFORUM2016
285
Italy Local Functionality – NAV 2016
286
Microsoft Forum 2016
288
New Book – “Implementing Dynamics NAV 2016” – by
Alex Chow
289
How to limit multisessions logins in NAV (from NAV 4
to NAV 2009 R2 Classic)
290
Project Madeira “IS ON” – try public preview !
292
Cumulative Update 6 for Microsoft Dynamics NAV
2016 has been released | Dynamics NAV Team Blog
294
Microsoft SQL Server Developer Edition is now free |
SQL Server Blog
295
Dynamics NAV in Remote App Mode
December 29, 2016
Dynamics NAV in Remote App Mode
Some people have asked me information on how to use the NAV
Windows Client (ex RTC) in remote app mode.
This environment can be useful for those still using the NAV
Windows Client (in a few years I think that you will only use the Web
Client or NAV in SaaS Mode).
In various forums there are many posts about this topic, I bring my
personal experience about this topic.
About my Experience
I use it for many years and I must say that it works well, the
published NAV Windows Clients (ex RTC) in remote app is very
light and the band occupied is very low.
For example: it allows quickly to activate NAV in foreign branches
without installing anything and without worrying too much about
internet bandwidth etc. etc.
Points of Strenghts
– Don’t install anything on the client, just deploy the application icon
or to give access to a portal (gateway remote app like in the picture)
– is also usable on PCs with XP window (…), I don’t buy new PC if I
don’t need high performance
– The occupied bandwidth is really little, similar to other remote
application tools)
(when the local NAV Client is slow, via remote app however can be
1
fast…
– Compared to the standard terminal server is much less invasive,
user uses only what has been published, not everything a remote
desktop.
– I can also use it in VPN (if I do not want to publish on the internet)
– I can use all NAV versions starting at 4.0 SP1.
Points of Weakness
– if you are using Word Layout, Word must be installed on the
remote server or you cannot print (ex: errors with Post & Print
function)
– Sometimes the NAV session is not closed on the server (even if it
is closed on the client)
– Copy and Paste operations are more harder bur possible.
– If you don’t want to use a VPN , you need to use applications
published on the Internet Gateway (… is the same situation with
Azure and endpoints)
– Today is considered “old technology”, not web based and
oriented.
REMOTE APPS GATEWAY
LOGIN PAGE
2
NAV Windows Client on Remote App (remote execution).. you
are Welcome !
Some Links for you
Below are some useful links to understand the operational
mode of remote app and how to setupconfigure a new remote
app environment.
Overview of Remote App
http
s://technet.microsoft.com/en-us/library/cc755055(v=ws.11).aspx
Remote Desktop Services (RDS) Quick Start Deployment for
RemoteApp, Windows Server 2012 Style
3
http
s://blogs.technet.microsoft.com/yungchou/2013/02/07/remote-desktop
Publishing RemoteApps in Windows Server 2012 (GREAT !)
http
s://social.technet.microsoft.com/wiki/contents/articles/10817.publishi
NAV 2016 via Remote App
http s://community.dynamics.com/nav/f/34/t/185099
Dynamics NAV & TS RemoteApp
http s://community.dynamics.com/nav/f/34/t/25259
Publish Dynamics AX client as RemoteApp on Remote Desktop
Services
http
s://community.dynamics.com/ax/b/axfortechies/archive/2012/10/25/pu
Introducing Terminal Services Easy Print: Part 1
http
s://blogs.technet.microsoft.com/enterprisemobility/2007/04/26/introdu
Have a nice new Year 2017 !
4
Merry Christmas and happy New Year !
December 24, 2016
#dyndev365 #msdynnav #Merry Christmas #TomorrowNAV
“Dear readers, followers and friends,
wish you and your family a Merry Christmas and Happy New
Year 2017!”
Roberto Stefanetti
…and always “long life to Dynamics NAV !”
5
“How to” display picture from file in Item Picture Page
December 22, 2016
Below a short procedure to visualize a linked picture from a
picture file (example file with “.GIF” extension) into the “Item
Picture Page”.
The System load the image file in a BLOB field and after
displays it on the picture page; at the close of the page the
image is deleted from the item table in order to lighten the
System; same procedure can be used in reports and can also
be used in old versions of NAV… in this case NAV 2013.
NAV C/AL Code
On Image Button of Item Card
// CHECK DATA IN RECORDLINK TABLE
RecordLink.RESET;
RecordLink.SETCURRENTKEY(Company,”Refer to”);
RecordLink.SETRANGE(Company,COMPANYNAME);
RecordLink.SETRANGE(“Refer to”,”No.”);
IF NOT RecordLink.FINDSET THEN EXIT;
FileToUpload := RecordLink.URL4; //Custom field with link for
image
IF FileToUpload = ” THEN EXIT;
//IMPORT IMAGE FROM FILE USING FILE MANAGEMENT
FileManagement.BLOBImportFromServerFile(recTempBlob,FileMana
ItemPicture.RESET;
ItemPicture.SETRANGE(“No.”,”No.”);
6
IF ItemPicture.FINDSET THEN BEGIN
ItemPicture.Picture := recTempBlob.Blob;
ItemPicture.MODIFY;
ItemPicture.RESET;
ItemPicture.SETRANGE(“No.”,”No.”);
// OPEN PAGE 346 Item Picture > Visualize Item Image
PagePicture.SETTABLEVIEW(ItemPicture);
PagePicture.RUN;
END;
//Image Cleaning
Page 346 Item Picture
OnClosePage()
itemPicture.RESET;
itemPicture.SETRANGE(“No.”,”No.”);
IF itemPicture.FINDSET THEN BEGIN
IF itemPicture.Picture.HASVALUE THEN BEGIN
itemPicture.CALCFIELDS(Picture);
CLEAR(itemPicture.Picture);
itemPicture.MODIFY;
END;
END;
GitHub
http
s://github.com/rstefanetti/NAV_SQL/blob/master/LoadPictureFromFile
MSDN
TechNet
http
s://gallery.technet.microsoft.com/How-to-display-picture-f13019bb
7
Announcing the Preview of Development Tools for
Dynamics NAV – Nice Christmas!
December 20, 2016
“Tools are available in preview from today”! AWESOME !!
•
The in-client designer
•
Visual Studio Code
Start from here: http://aka.ms/navdeveloperpreview
In-Client Designer
Visual Studio Code
New Development Environment “What’s New” here:
Developing Extensions
Environment
Using
the
New
Development
http
s://msdn.microsoft.com/en-us/dynamics-nav/newdev-dev-overview
In-Client Designer
http
s://msdn.microsoft.com/en-us/dynamics-nav/newdev-inclient-designe
8
Differences in the Dynamics NAV Development Environments
http
s://msdn.microsoft.com/en-us/dynamics-nav/newdev-differences
Keyboard Shortcuts for the New Development Environment
http
s://msdn.microsoft.com/en-us/dynamics-nav/newdev-keyboard-short
Developer Reference
http
s://msdn.microsoft.com/en-us/dynamics-nav/newdev-reference-overv
Full Documentation here:
GitHub Bug Branch
Source: Announcing the Preview of Development Tools for
Dynamics NAV – Dynamics NAV Team Blog
Be Social !
#dyndev365 #msdynnav #code
9
“ALL About” How To Boost Dynamics NAV Server
December 12, 2016
Hi Guys,
another post of “ALL About” Series, in this case, some people
have asked me about NAV configuration and how to configure
NAV Server for better performance (Boosting
NAV..); also in Microsoft Forum there are several posts about
this topic, i searched and collected a variety of useful
information for a correct NAV Server configuration.
Documents and Posts
“Great White Paper” about typical questions around the
number of users or tenants, hardware requirements, scaling,
and upgrading
-> “…How to have a great configuration and “How-to Boost
NAV”!!
“This white paper provides detailed insight into the concepts
and principles that support performance testing in Microsoft
Dynamics NAV”.
By outlining some sample goals from the start, it explains how
you can use load testing to optimize your application and
hardware to meet the customer and user requirements –
addressing typical questions around the number of users or
tenants, hardware requirements, scaling, and upgrading”
Microsoft Dynamics NAV Performance Testing – White Paper
http://www.archerpoint.com/sites/default/files/docs/ms-dynamics-nav
Below some useful information about NAV Server
Configuration.
10
NAV Server Configuration Best Practices (from Whitepaper)
1) Number of Microsoft Dynamics NAV Service Tiers
When a client connects to Microsoft Dynamics NAV Server, the
load balancer will select a server and keep the connection
open throughout the lifetime of the client.
This means that setting up more servers behind a load
balancer will increase the capacity of the cluster of Microsoft
Dynamics NAV Service tiers.
2) Server Memory
Each Microsoft Dynamics NAV Service tier needs 500Mb of
memory to run.
On top of that, the Microsoft Dynamics NAV Service tier needs
memory for each active session, even if they are idle.
The more pages the user have opened, the more memory gets
allocated, but a good starting point for doing sizing
calculations is around 10Mb per active session.
Idle sessions are not terminated if they are running the
Windows client.
Server CPU (cores and speed) Faster CPU will get things done
faster, and more cores can run more things in parallel.
Idle sessions on the Microsoft Dynamics NAV Service tier don’t
use any CPU power, except for generic housekeeping, which
shouldn’t be counted.
3) Server CPU (cores and speed)
Faster CPU will get things done faster, and more cores can run
more things in parallel.
Idle sessions on the Microsoft Dynamics NAV Service tier don’t
use any CPU power, except for generic housekeeping, which
shouldn’t be counted.
11
Active sessions will use CPU power depending on what they
do, but it is hard to generalize how much.
For example, CPU power is used whenever the user is
performing a task that requires the Microsoft Dynamics NAV
Service tier to run some business logic or perform some UI
logic or setup server pages.
If the Microsoft Dynamics NAV Service tier does a lot of IO
(SQL calls or client callbacks), then the CPU will be waiting for
response and thus be loaded less.
4) Data Cache Size
This is a Microsoft Dynamics NAV Server setting, which
located in CustomSettings.config file. Sets the data cache size.
This is an abstract value with contextual meaning on the type
of the item being cached.
<add key=”DataCacheSize” value=”9″ />
The number you specify in DataCacheSize setting determines
how much memory is used for caching data.
The actual amount of memory (in MB) allocated is 2n, where n
is the value of the DataCacheSize setting:
Value Memor y 9 (default) 512Mb 10 1Gb 11 2Gb 12 4Gb 13 8Gb
14 16Gb 15 32Gb …
When running a single tenant system the default value of 9 is
probably good.
When running a multi-tenant system, the data cache is shared
between all tenants.
Set to 0 to disable cache.
5) Metadata Provider Cache Size
This is a Microsoft Dynamics NAV Server setting, which
located in CustomSettings.config file.
12
Sets the Metadata Provider cache size (in number in objects
cached).
Set to 0 to disable cache.
<add key=”MetadataProviderCacheSize” value=”150″ />
You can monitor the number of objects in the metadata cache
by monitoring the following performance counter on the
Microsoft Dynamics NAV Service tier.
There is really NO REASON not to set this to a high value (like
10000) if you are not pressed on memory on the Microsoft
Dynamics NAV Server.
6) Max Concurrent Calls
This is a Microsoft Dynamics NAV Server setting, which is
located in CustomSettings.config file.
Maximum number of concurrent client calls that can be active
on the Microsoft Dynamics NAV Server.
To disable this setting set the value to “MaxValue”.
<add key=”MaxConcurrentCalls” value=”40″ />
The number specified here determines how many concurrent
calls the Service Tier is able to handle. The more cores in your
server, the higher this value can be.
NAVPERF (On Github)
GitHub organization for performance testing Microsoft
Dynamics NAV
GitHub You will find a couple of projects on GitHub, which
contains some sample code on how to do performance tests.
The GitHub organization is used to store the sample
repositories and is available here:
http s://github.com/NAVPERF/NAV2017-Sample
13
Microsoft Dynamics NAV 2017 Load Test sample as references
from the Load Test WhitePaper
Enables you to create scenario tests for Microsoft Dynamics
NAV.
The solution consists of:
Microsoft.Dynamics.Nav.LoadTest : A sample test for NAV
Order
Processor
Scenarios
Microsoft.Dynamics.Nav.TestUtilities : Test utilities to help
build test scenarios Microsoft.Dynamics.Nav.UserSession :
Client Library for the NAV Client Services Web Service
On the Microsoft Dynamics NAV 2017 DVD, you will find a
folder called Test Assemblies. This folder contains one DLL,
which
is
needed
for
running
Load
Tests:
Microsoft.Dynamics.Framework.UI.Client.dll The DLL is also
included in this project.
Others nice links
Optimizing SQL Server Performance with Microsoft Dynamics
NAV
http
s://msdn.microsoft.com/en-us/dynamics-nav/optimizing-sql-server-pe
Blog about Performance
http s://navperformance.wordpress.com/
Performance Tuning Microsoft Dynamics NAV 2009 RTC and
NAV 2013
http://www.archerpoint.com/blog/Posts/performance-tuning-microsof
14
Videos
How Do I: Run NAV Performance Tests Using Visual Studio in
Microsoft Dynamics NAV
http s://www.youtube.com/watch?v=IG-y8DsXqaQ
Some my old posts here:
Monitoring Microsoft Dynamics NAV 2015 Server Using
“Performance Counters”
http
s://robertostefanettinavblog.wordpress.com/2015/07/06/monitoring-m
NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE
LOG
http
s://robertostefanettinavblog.wordpress.com/2015/06/09/nav-2015-trac
15
Cumulative Update 01 for Microsoft Dynamics NAV 2017
has been released
December 07, 2016
Cumulative Update 01 includes all application and platform
hotfixes and regulatory features that have been released for
Microsoft Dynamics NAV 2017.
The cumulative update is intended mainly for solutions that are
experiencing the problems described in the Knowledge Base
article linked to below. However, you are advised to always
keep your solution updated with the latest cumulative update.
For more information, see .
The cumulative update includes hotfixes that apply to all
countries and hotfixes specific to the following local versions:
•
AU – Australia
•
AT – Austria
•
BE – Belgium
•
CH – Switzerland
•
CZ – Czech Republic
•
DE – Germany
16
•
DK – Denmark
•
ES – Spain
•
FI – Finland
•
FR – France
•
IS – Iceland
•
IT – Italy
•
NA – North America
•
NL – Netherlands
•
NO – Norway
•
NZ – New Zealand
•
RU – Russia
•
SE – Sweden
•
UK – United Kingdom
Where to find Cumulative Update 01
You can download the cumulative update from – Cumulative
Update 01 for Microsoft Dynamics NAV 2017 (Build 14199).
17
Or you can download the cumulative update from the .
Source: Cumulative Update 01 for Microsoft Dynamics NAV
2017 has been released
18
Microsoft AL: AL language code samples for developing
extensions #DYNDEV365
November 29, 2016
#DYNDEV365 , Microsoft AL by Microsoft Modern Dev Team
As you likely know, “Microsoft is developing new tooling for
working with On Premise NAV and Dynamics 365 for
Financials“. Those tools will be available later in December
(announced some weeks ago @Directions Events) and in the
meantime, we’d like to share some code with you so you can
get familiar (and excited) about it.
We’ll add more code samples here but in the meantime, we’d
really like you to:
Have a look at the “Hello World code” -> Check out the
differences between classic C/AL txt format and the new .al
format.
http s://github.com/Microsoft/AL
FROM GITHUB PAGE “Microsoft /AL”
“Welcome to the code sample repo for developing extensions
to Dynamics NAV.”
This repo contains AL language code samples for developing
extensions on the Dynamics NAV platform. We’re not yet in
preview, so this repo is meant as a way for you to get familiar
with the new syntax and provide feedback.
19
This project has adopted the Microsoft Open Source Code of
Conduct. For more information see the Code of Conduct FAQ
or contact with any additional questions or comments.
Source
Great Job ! .. “AL” you are Welcome !
by Microsoft Modern Dev Team, #DYNDEV365
More Information About the Developer Preview for Dynamics
NAV – 13/12/2016
http
s://blogs.msdn.microsoft.com/nav/2016/12/13/more-information-abou
by NAV Team, #DYNDEV365
20
Dynamics NAV as SaaS …and 365 as IaaS
November 22, 2016
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:
21
• 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:
NAVmanagedservice (only available on Partnersource)
http
s://mbs.microsoft.com/partnersource/global/sales-marketing/marketin
CORE MODEL
http
s://mbs.microsoft.com/Files/partner/NAV/SalesMarketing/Product_Str
22
FAQ
http
s://mbs.microsoft.com/Files/partner/NAV/SalesMarketing/Product_Str
…some other useful links:
Microsoft Dynamics NAV 2016 now available, as is Microsoft
Dynamics NAV 2016 managed service for partners
http
s://blogs.microsoft.com/firehose/2015/10/07/microsoft-dynamics-navIntroducing Microsoft Dynamics NAV Managed Service for
Partners
http
s://community.dynamics.com/b/msftdynamicsblog/archive/2015/10/06
What Is A SAAS ERP Solution?
http
s://community.dynamics.com/gp/b/erpsoftwareblog/archive/2016/02/0
Cloud, SaaS and Hosted…What’s the difference?
http://www.erpsoftwareblog.com/2011/05/cloud-saas-and-hosted-wha
Directions EMEA Choosing the best possible Azure platform
for NAV
http://www.slideshare.net/AleksandarTotovic/directions-emea-choosi
ABOUT IAAS (Infrastucture as a service)
and now … “THE IaaS ERA”… (from NAV TechDays 2016Mibuso)
nice video here:
http
s://www.youtube.com/watch?v=hpQqWEiX0IE&feature=youtu.be
THE “NAVTechDays 2016 Playlist” (ALL VIDEOS)
23
http
s://www.youtube.com/playlist?list=PLI1l3dMI8xlBwVTJ9S3ZLs9g_gFG
24
NAV 2017 vs Dynamics 365 “Battle Card” by Amol –
Dynamics NAV Users – DUG
November 19, 2016
nice NAV 2017 vs Dynamics 365 “battle card” by Amol.
Source: NAV 2017 vs Dynamics 365 – NAV seen by Amol –
Dynamics NAV Users – DUG
25
WPC2016, Milano, 29-11 01-12
November 19, 2016
WPC2016, Milano, 29-11 01-12
“OverNet Education”, il principale Partner per la formazione e
la consulenza IT delle aziende Italiane, Enterprise e PMI, è lieta
di presentare la 23ma edizione di WPC (WPC 2016), la più
importante conferenza italiana sulle tecnologie Microsoft.
L’evento in cui una community di oltre 400 IT Professionals si
incontrano per trasformare il proprio business.
Sito
http://www.wpc2016.it/
presso NH Centro Congressi Assago
Agenda
http://www.wpc2016.it/Events/Agenda
…dato che sono stato invitato da OverNer Education, sarò
presente il 30-11 mattina in MVP Corner, passate a trovarmi !
http://www.wpc2016.it/Contents/Page/MVP
…you are welcome !
26
Dynamics NAV 2017 as an App in Azure Management
Portal – Dynamics NAV Team Blog
November 15, 2016
Source: Dynamics NAV 2017 as an App in Azure Management
Portal – Dynamics NAV Team Blog
27
NAV 2017 “Task Scheduler”
November 04, 2016
In this post i will write about “NAV 2017 Task Scheduler”, NAV
2017 Task Scheduler is an evolution of Job Queue Technology
(ex Process Queue, Microsoft returned to old name for name
for Job Queue..); Microsoft has reviewed\improved\extended
the old Job Queue Technology and now Task Sheduler is a
great new feature ready for “Complex Scheduling” useful in
various scenarios.
MSDN Definition: “The task scheduler enables you to control
when certain operations or processes (in other words tasks)
are run. Basically, a task is a codeunit or report that is
scheduled to run at a specific data and time. Tasks run in a
background session between the Microsoft Dynamics NAV
Server instance and database. Behind the scenes, the task
scheduler is used by the job queue to process job queue
entries that are created and managed from the clients.”
Source
http
s://msdn.microsoft.com/en-us/dynamics-nav/task-scheduler
How “New Task Scheduler System” works
Now we have a new option in NST: “Task Scheduler enabled”
option; when a task is executed, the task is not visible in
sessions list (is a background session).
28
“Task Scheduler enabled” option says to NST to start a
background session for each task that needs to be executed at
scheduled time. After the execution of task is completed, the
background session is closed (no more phantom\pending
sessions to kill by SQL jobs !)
Another useful option on NST permit to define how many
simultaneous tasks can be executed by NST at the same time
(parallel execution on NST). Killing a session will not stop all
other tasks that need to be executed (..a different pipeline for
each task execution)
“Task Scheduler Technology” Objects involved
•
Table 2000000175 Scheduled Task (Show list of scheduled
task)
•
Table 2000000111 Session Event
(Show list of active
background sessions started for each running task)
“Job queue” Codeunits
Below Some Details of New Task Scheduler Feature
C/AL Code and Task Scheduler
In C/AL code, you create and manage tasks by using the C/AL
functions that are available for the TASKSCHEDULER data
29
type.
Task Scheduler Data Type
The TaskScheduler data type is a complex data type for
creating and managing tasks in the task scheduler, which runs
codeunits at scheduled times.
“ALL” Task Scheduler Functions
Function
CREATETASK
SETTASKASREADY
TASKEXISTS
CANCELTASK
Description
Adds a task to run a codeunit at a specified date and time.
Sets a task to the Ready state. A task cannot run until it is
Ready.
Checks whether a specific task exists.
Cancels a scheduled task.
“How “ Task Scheduler Works
To set up a task, you create a codeunit that contains the logic
that you want to run at a scheduled time. Optionally, you can
create a second codeunit that contains the logic to handle the
task if an error occurs for any reason. This coduenit is referred
to as a failure codeunit. Once you have the codeunits, you can
add C/AL code to the application that calls the CREATETASK
function to schedule a task to run the codeunits. The
CREATETASK function can also specify the earliest date to run
the task, and whether the task is in the ready state.
Task Scheduling “Flow”
30
Here is an overview of the process that a task goes through:
1. After you add a task, the task is recorded in table
2000000175 Scheduled Task of the database.
2. If the task is in the ready state, when the scheduled time
occurs, a new background session is started and the task
codeunit is run.
You can view the session in the table 2000000111 Session
Event.
If an error occurs, the following happens:
•
If a failure codeunit is not specified, then the retry flow is
initiated.
•
If a failure codeunit has been specified, the error is passed
in a call to the failure codeunit, and the failure codeunit is
run.
•
If the failure codeunit does not handle the error or fails
itself, then the retry flow is initiated.
Error Conditions and Retry Process
A task can fail under the following conditions:
31
•
The company cannot be opened.
•
An SQL connection or transient error occurred with the
database.
•
The Microsoft Dynamics NAV Server instance restarted
while the task was being run. When an error occurs, unless
the task is interrupted by the failure codeunit, the Microsoft
Dynamics NAV Server instance will rerun the task according
to the following flow:
•
You can view these errors in the event log of the computer
that is running the Microsoft Dynamics NAV Server
instance.
•
Two minutes after the first failure
•
Four minutes after the second failure
•
Fifteen minutes after the third failure and subsequent
failures.
About Task Sessions and Permissions
The task runs in a background session, which means that there
is no user interface. The behavior is similar to that of the
STARTSESSION function, where any dialog boxes that would
normally appear are suppressed. For more information about
specific dialog boxes, see STARTSESSION Function
(Sessions).
32
The session runs by using the same user/credentials that are
used when calling C/AL code. The user must have appropriate
permissions to the codeunit and any other objects that are
associated with the operation of the codeunit.
Examples
Create Task Function
Adds a task to run a codeunit at a specific time.
Syntax
[Task
=:
]CREATETASK(CodeunitId,
FailureCodeunitId[,
IsReady][, Company][, NotBefore][, RecordID])
Example
The following example schedules a task to run the Job Queue
Dispatcher and uses codeunit Job Queue Error Handler as the
failure codeunit. The code requires that you create the
following C/AL variable.
Variable
JobQueueEntry
DataType
Record
SubType
Job Queue Entry
C/AL Statement
TASKSCHEDULER.CREATETASK(CODEUNIT::”Job
Queue
Dispatcher”, CODEUNIT::”Job Queue Error Handler”, TRUE,
COMPANYNAME,
CURRENTDATETIME
+
1000
+
33
RANDOM(3000), JobQueueEntry.RECORDID);
Source
http
s://msdn.microsoft.com/en-us/dynamics-nav/createtask-function
“JOB QUEUE” IMPROVEMENTS
SET STATUS TO “ERROR” FEATURE
NST Reporting Parameters (nice for SAVEAS function and for
reporting scheduling also)
Sample of Report Scheduling
My final considerations: New Task Scheduler is Great feature !
….now Task Scheduler is a real scheduling application like
windows task scheduler or Unix Crontab etc… a great step
beyond!!
Have a nice task scheduling !!
34
NAV 2017 “Assisted Setup”
November 03, 2016
in this short post, i will talk about a new feature of NAV 2017:
“Assisted Setup”.
“Assisted setup” is a nice feature (composed by a lot of
wizards ready to use..) useful to guide your users through
setup scenarios.
With this feature is possible:
– use a predefined set of data to setup main features (for
selected areas)
– have a great first setup configuration for your new company
(enhanche first-time experience)
List of some wizards ready to use:
– Setup Company (Configurator for first one access)
– Approval workflow
– Item Approval
– Power Bi embedded configutation (Azure directory)
– Setup Reporting
– Office 365 integration
– Dynamis CRM connection
– email logging
etc. etc.
My example: “Setup Reporting”
“Setup Reporting” is a nice feature (wizard) to configure OData
with fields selections, all in only “one shot” configuration.
35
Definition\Scope: “you can create data sets for building report
in excel, Power Bi, Odata..”
below some “step by step” pictures.
“item list” Data Set Configuration with fields mapping
“Item list” is published like Web Service & OData
“item list” json output from OData
you are welcome.
36
Welcome to Microsoft Dynamics 365 !
November 01, 2016
Evolve your business on your terms
“With intelligent business applications across CRM and ERP,
Microsoft Dynamics 365 gives you choice. Start with just what
you need to run your business—and delight your customers.
And then add apps as your needs change.”
Source http s://www.microsoft.com/en-us/dynamics365/home
Dynamics 365 Blogs & Communities
Dynamics 365 Blog
http s://community.dynamics.com/b/msftdynamicsblog
Dynamics 365 Documentation
http s://docs.microsoft.com/en-us/dynamics365/
Explore Dynamics
http s://explore.dynamics.com/
Dynamics Community “Business & Enterprise” new sections
http s://community.dynamics.com/business
37
http s://community.dynamics.com/enterprise
“How-to” support pages
http
s://community.dynamics.com/business/b/financials/archive/2016/11/0
Dynamics 365 Team Blog (from CRM to…)
http s://blogs.msdn.microsoft.com/crm/
“Welcome to Microsoft Dynamics 365 !” launch video
38
“ALL About” C/AL Coding Guidelines
November 01, 2016
hi guys, this is another short post of my “ALL About” posts
series (the first of this year); in this case i want to write about
“C/AL Coding Rules and Guidelines”.
below a short list of documents\pages about this topic,
First “ALL IN ONE” Document but “ALWAYS” useful is: “C/AL
Coding Guidelines used at Microsoft Development Center
Copenhagen” …”The Bible” for each C/AL Developer!
Source: C/AL Coding
Development Center
Guidelines
used
at
Microsoft
you
can
download
PDF
document
here:
cal-coding-guidelines-at-microsoft-development-center-copenhagen
“ALL IN ONE” Document Vs Wiki & Community Feedback
Philosophy
“CAL-Coding-Guidelines-at-Microsoft-Development-Center-Copenhag
is “all in one document”. In contrast, on this wiki, the
coding guidelines are published individually. The reason is:
give you the chance to comment and share your oppinion on
each one.
Question: Since we’re having the guidelines, how come there
is still C/AL code in NAV which doesn’t respect them?
39
Answer: all new C/AL code is bound to follow the guidelines
(else it cannot be checked-in). However, the code that existed
before the rules – it does not. We had done cleanup in a certain
degree. Now we’re gradually improving the old code base as
we visit various objects in order to add new functionality,
however chances are that code we didn’t touch in a long time
had remained in its old form.
“Microsoft Dynamics Community is looking forward to your
comments! Where you can, do provide concrete examples of
the alternatives, Good and Bad”
Wiki Page on Design Patterns
other nice resources:
nice
doc
on
record-variables”:
Mibuso
about
“How
to
work
with
http://mibuso.com/howtos/how-to-work-with-record-variables-version
Nice general sections on MSDN
General C/AL Programming Format
http
s://msdn.microsoft.com/en-us/library/ee414237(v=nav.10).aspx
Programming Best Practices
40
http
s://msdn.microsoft.com/en-us/library/ee414204(v=nav.90).aspx
C/AL Comments
http
s://msdn.microsoft.com/en-us/library/dd301180(v=nav.90).aspx
C/AL Coding Guidelines Video
41
NAV 2017 and “Microsoft Flow” integration: “Business
Notification Manager” reinvented in Cloud
October 29, 2016
Microsoft Flow Preview
Microsoft Definition: “Microsoft Flow is a “brand new” SaaS
offering, available today in preview, for automating workflows
across the growing number of applications and SaaS services
that business users rely on.”
Integrations: In the preview of Microsoft Flow Microsoft
provide native and Cloud Based integration both for NAV 2017
throughout the entire Dynamics 365 platform.
I consider it very interesting and useful because until not long
ago, there was a solution called “Business Notification
Manager” (available from NAV 4..NAV 2009, then abandoned as
then also happened to Employ Portal, Commerce Gateway,
etc.) which could be used to manage a small workflow
regarding only the “notification of events” without the need to
write one line of code to handle it.
“Business Notification Manager” : this feature Allows you to
automatically send emails to your employees and business
partners Informing them of business events.”
He was using the logic “IF Trigger Fired THE Action..” the
same used both NAV Workflow that Microsoft Flow (in this
case born in the Cloud world).
42
Business Notification for NAV 2009
http s://msdn.microsoft.com/en-us/library/dd354998.aspx
Business Notification for NAV 5
and now: “Microsoft Flow”
Integration Flow, NAV 2017 Suite Dynamics365 available today.
Actually you can choose two integration triggers:
– When record is created
– When record is modified
Microsoft Flow Plans – “How to get Flow” ?
Some pictures about integrations
some nice links:
nice post about architecture here:
Role of PowerApps, Flow and Common Data Model in
Dynamics 365
http
s://blogs.msdn.microsoft.com/rojythomas/2016/10/20/pa-flow-cdm/
nice slides here:
http
s://onedrive.live.com/embed?cid=6B7CF2BD5F47F487&resid=6B7CF2
http
s://onedrive.live.com/embed?cid=6B7CF2BD5F47F487&resid=6B7CF2
Sign up for Microsoft Flow
http s://flow.microsoft.com/
43
Enjoy.
44
NAV 2017 is available for download !
October 26, 2016
hi guys..good news: “NAV 2017 is available for download !” …
download it NOW !!!
Download links
http
s://mbs.microsoft.com/partnersource/global/deployment/downloads/p
http
s://mbs.microsoft.com/partnersource/denmark/deployment/download
have a great day (or night… it’s “00.37” time now!) and
downloads time !
45
Welcome to the Developer and IT-Pro Help for Microsoft
Dynamics NAV 2017
October 26, 2016
NAV 2017 MSDN Help Pages released today
some links:
Index Page
http s://msdn.microsoft.com/en-us/dynamics-nav/index
NAV 2017 System Requirements
http
s://msdn.microsoft.com/en-us/dynamics-nav/system-requirements-fo
NAV 2017 Product Overview
http
s://msdn.microsoft.com/en-us/dynamics-nav/product-and-architectur
Microsoft Dynamics NAV 2017 is a complete enterprise
resource planning (ERP) software solution for mid-sized
organizations that is fast to implement, easy to configure, and
simple to use. Right from the start, simplicity has guided—and
continues to guide—innovations in product design,
development, implementation, and usability. In this section,
you can find information about deployment and administration,
and you can find information about developing for Dynamics
46
NAV.
Note
“You also use Microsoft Dynamics NAV 2017 to develop for
Dynamics 365 for Financials.”
To
Learn how to install, deploy,
and configure Microsoft
Dynamics NAV 2017
Learn about development
options for Microsoft Dynamics
NAV 2017
Learn about administration
tools and processes for
Microsoft Dynamics NAV 2017
Find reference information,
including C/AL functions,
triggers, properties,
development environment
commands, and development
environment windows
Learn how to develop for
Dynamics 365 for Financials
nice reading….
47
See
NAV 2017, scheduled for October 28
October 25, 2016
Hi guys,
in Partnesource you can see that the NAV 2017 release date is
“scheduled for October 28” (in theory was was expected
Yesterday, October 24, but is now announced for this date:
October 28 …
… Meanwhile, the Partnersource site is updated with new
documents \ information .. you can already find interesting
documents example: NAV Licensing 2017, information about
SQL Server 2016 Runtime for NAV 2017 etc. etc.
Some nice links in development:
NAV 2017 Product Download Page
http
s://mbs.microsoft.com/partnersource/global/deployment/downloads/p
NAV 2017 NAV Geat Ready Page
http
s://mbs.microsoft.com/partnersource/northamerica/readiness-training
Microsoft SQL Server 2016 Runtime Microsoft Dynamics NAV
2017 Availablity
http
s://mbs.microsoft.com/partnersource/global/news-events/news/SQLS
we are waiting …
48
49
Dynamics 365 Financials Preview (ex Project Madeira)
October 19, 2016
hi Readers,
some people have asked me again If the preview of Dynamics
365 Financials is still available and if it is constantly updated
…of course, sure … you can access (or register) using the old
link about Project Madeira preview.
… For countries that can access the preview (testing countries)
you can sign up at this address:
Dynamics 365 Financials Preview (formerly Project Madeira)
http s://madeira.microsoft.com
try the preview button
http
s://portal.office.com/signup?sku=6a4a1628-9b9a-424d-bed5-4118f0ed
Dynamics
365
Financials
Preview
link
registration\authentication)
http s://msp882270.projectmadeira.com/MS/WebClient/
(after
… For countries rather than can not do, however, it has an
ability to register before a user uses to Office 365 USA and
then use it to sign up to the preview of Dynamics 365
Financials,.. to achieve this goal use this workaround by Waldo
(follow it step by step..)
50
Setting up the Project “Madeira” Preview (also when you’re not
from the US)
http://www.waldo.be/2016/04/15/setting-up-project-madeira-preview-a
..anf after this steps you can correctly sign-in to Dynamics 365
Financials Preview link
Extensions Management
..you can also “add” and “test” extensions available in
“AppsSource” store (example: try to add “Sales and Inventory
Forecast” extension by Microsoft.
nice feedback Page
http
s://ideas.projectmadeira.com/forums/350115-microsoft-project-madei
my old post about Project Madeira
…have a good testing time !
51
“New Development Environment Preview” at Christmas
time !
October 13, 2016
…good news from Directions EMEA: “New Development
Environment Preview” will be available at Christmas time !
…great gift for Christmas !!
52
Directions EMEA 2016, “NAV 2017 What’s New” paths
October 09, 2016
Directions EMEA 2016, “NAV 2017 What’s New” paths”
October 12-14, 2016 Prague, Czech Republic
“THE BIGGEST NAV EVENT!”
“Meet Microsoft Dynamics NAV partners and experts as well as
the
Microsoft
team
and ISVs in Prague on October 12-14, 2016!”
“NAV 2017 What’s New” paths:
DAY1
DAY2
DAY3
MOBILE APP:
Mobile app application suite
“The NAV Directions EMEA team has a full mobile application
suite available for attendees to use to build and manage your
personal Directions schedule, connect with fellow attendees,
and view general relevant event information. You can find the
apps in each of their respective stores at the following links
53
below.”
Source: http://www.directionsemea.com/
My
Old
Post
http
s://robertostefanettinavblog.wordpress.com/2016/07/02/directions-em
54
Save the date: “Microsoft Dynamics 365 first look” –
Microsoft Dynamics Community
October 03, 2016
“Get your first look at the next generation of intelligent
business applications”
Join us Tuesday, October 11, at 2:30 PM EST for a first look at
the next generation of intelligent business applications.
You can be one of the first to hear Executive Vice President
Scott Guthrie share Microsoft strategy for digital
transformation and unveil Microsoft Dynamics 365. This will be
an informative discussion on the next generation of intelligent
business applications designed to enable organizations to
grow, evolve, and transform.
Experience Dynamics 365 through live demos
Come experience Dynamics 365 in action—with live demos.
“You’ll learn how these applications unify CRM and ERP
capabilities into purpose-built applications that help manage
specific business functions seamlessly.”
Unique industry perspectives
This event will also include perspectives on digital
transformation from business leaders and industry experts.
Come hear insights on how they engage customers more
effectively, optimize operations, and are proactive and
competitive in the market.
55
Get a first look at Microsoft Dynamics 365
Source: Save the date: Microsoft Dynamics 365 first look –
Microsoft Dynamics Community
56
NAV 2017 “Notifications”
September 25, 2016
…some time ago i found this nice question\post on Dynamics
Community NAV Forum.
Question
Does anyone know how to create a new record of notification
by programming ? What table should you create the record ?
“If i look on pages, the part is a system part of notications id.”
i posted some solutions here:
“How-to” manage NAV notifications by C/AL
http
s://robertostefanettinavblog.wordpress.com/2016/09/07/how-to-mana
…AND NOW
NAV 2017 Notifications
…now we can use a “very powerful solution” to do this, nice
documents
about
technology
and
“How-to
Demo
for Customers” are available for download on Partnersource.
Download Links
NAV 2017 Notifications
http
57
s://mbspartner.microsoft.com/secure/whatsnew/NAV2017/Enhancing
NAV 2017 Smart Notifications “How-to Demo for Customers”
http
s://mbspartner.microsoft.com/secure/whatsnew/NAV2017/Enhancing
Samples of Implementations
…i found on Dynamics Community blog this nice post (by
Amol) about possible implementations…
“In the development environment, you can create notifications
in C/AL.”
“This will helpful during
1) Shortage on Inventory
2) Customer Balance is negative
3) Customer credit limit exceeded
and many more…….
Original Post Source link: Notifications in UI -NAV 2017 –
Microsoft Dynamics NAV Community
58
NAV 2017 WHAT’S NEW – ALL MY POSTS
September 24, 2016
NAV 2017 WHAT’S NEW
“WhatsNewNAV2017” flyer is available for partners on
Partnersource (..available from Yesterday , September 23,
2016)
…you can download now this document from link below (if you
are partner or customer…)
DOWNLOAD LINKS:
Partnersource Radiness training news PAGE
http
s://mbs.microsoft.com/Files/partner/NAV/Readiness_Training/Readin
or from “NAV 2017 GET READY PAGE”
http
s://mbs.microsoft.com/partnersource/northamerica/readiness-training
All links about NAV 2017 Launch:
Latest News and Information
– What’s New in Microsoft Dynamics NAV 2017
– Microsoft Dynamics NAV 2017 Beta Program
– Learning Plan Microsoft Dynamics NAV Extensions
– Get ready for Microsoft Dynamics 365 for Financials
Extensions
– Getting ready for Microsoft Dynamics NAV Extensions
59
NAV 2017 Product Overview and Capability Guide
http
s://mbs.microsoft.com/Files/partner/NAV/SalesMarketing/Product_Str
NAV 2017 WHAT’S NEW – MY DOCUMENTS COLLECTION
(POSTS AND PRESENTATIONS)
My last Presentation on Slideshare: “NAV 2017 WHAT’S NEW”
NAV 2017 What's New from Roberto Stefanetti
“ALL” MY POSTS ABOUT “NAV 2017 WHAT’S NEW”
NAV 2017 Task Scheduler
NAV 2017 Assisted Setup
NAV 2017 and “Microsoft Flow” integration: “Business
Notification Manager” reinvented in Cloud
NAV 2017 Notifications
Welcome to the Developer and IT-Pro Help for Microsoft
Dynamics NAV 2017
Directions EMEA 2016, “NAV 2017 What’s New” paths
60
NAV 2017 is available for download !
NAV 2017, scheduled for October 28
Survey about NAV 2017 new\improved features
NAV 2017 Limited Beta and Directions NA Sessions
have a nice reading !
61
Survey about NAV 2017 new\improved features
September 20, 2016
(..info taken from next event “Directions NA” : “NAV 2017
What’s new” topic
http://www.navdirections.com/agenda
NAV 2017 new\Improved features
Applications improvements in Finance, Jobs, CRM, Items and
more.. (several new Financials enhancements and Jobs
simplification functionality..)
In Office 365 Experience (Dynamics NAV 2017 has become
more fully embedded in Office 365, including Outlook,
Excel,and the new Bookings module. NAV processes can now
be performed directly in Office, where you are already doing
your work.)
Embedded Power BI (create your own impactful reports, and
how to make the content you created in Power BI visible within
Dynamics NAV 2017)
Extensions 2.0 (Extensions have been introduced to Dynamics
NAV with the 2016. They have been generously enhanced for
NAV 2017 and Dynamics 365 for Financials, and are still the
hottest spot in all of NAV and Microsoft AppSource.)
62
NAV on Sql Server 2016, new databases features (reporting, BI,
data science, performance and high availability, all in a NAV
context)
Microsoft Flow (Microsoft Flows using the Dynamics NAV
connector or the data gateway)
Power Apps (newest and hottest technological addition to
Microsoft Dynamics NAV and Microsoft AppSource)
Cortana Intelligence (real-life examples were Cortana
Intelligence is used in Dynamics NAV to improve the
productivity of users)
Smart Notifications (Smart Notifications and how to show
unobtrusive, contextual, and actionable messages directly on a
Dynamics NAV page)
Start Survey here:
http s://goo.gl/forms/CKnIr8kZ75BMzcUy2
63
NAV 2017 LIMITED BETA & DIRECTIONS NA SESSIONS
September 13, 2016
NAV 2017 LIMITED BETA
Nice document released before Directions NA (yesterday…)
and available for Partners; you can download this document
directly from Partnersource, on ReadinessTrainingNews
section.
Document Scope
“This document details new features and functionality that are
available in Microsoft Dynamics NAV 2017 Limited Beta and
have been added to the product since Microsoft Dynamics NAV
2016. More information will be made available online when
Dynamics NAV 2017 becomes generally available.”
Download link
NAV 2017 Limited Beta
http
s://mbs.microsoft.com/Files/partner/NAV/Readiness_Training/Readin
NAV 2017 New Features: i don’t write\post about NAV 2017 new
features because they are under NDA, if you are a partner, read
the limited beta document to have a first idea of NAV 2017,
read sessions arguments of Directions and of others next
events.
64
Dowload NAV 2017 limited beta from MS-Connect
link
http
s://connect.microsoft.com/site687/InvitationUse.aspx?ProgramID=92
NEXT NAV 2017 EVENT: DIRECTIONS NA
Directions North America, 28-28 September
You can find ALL NAV 2017 Sessions filtering
What’s New” on sessions page.
“NAV 2017
ALL Sessions
http://www.navdirections.com/agenda/2016-sep-28/all-sessions/
65
“How-to” manage NAV notifications by C/AL
September 07, 2016
“How-to” manage NAV notifications by C/AL
i found this nice question\post on Dynamics Community NAV
Forum.
Question
Does anyone know how to create a new record of notification
by programming ?
What table should you create the record ?
If i look on pages, the part is a system part of notications id.
Source Post\Question
How To Create a notification by programming ?
http s://community.dynamics.com/nav/f/34/t/198109
Microsoft links about Topic
Notification Entry Table
http
s://msdn.microsoft.com/en-us/library/dn951728(v=nav.90).aspx
66
Sent Notification Entry Table
http
s://msdn.microsoft.com/en-us/library/mt299614(v=nav.90).aspx
Solutions
by Saurav Dhyani
Refer Standard Codeunit 454 “Job Queue – Send Notification”.
-> This Codeunit creates Notification when you schedule
posting of your Documents (Sales, Purchase) in Background.
by Piero Giacomelli
Great C/AL FunctionSolution by Piero Giacomelli here:
Example:
“i need on the table NC header to create a notification
everytime the user generate a new non conformal product.
here is my piece of code that works like a charm into a
codeunit”
Codeunit
LenChar := STRLEN(_Note);
67
_RecRef.GETTABLE(pNCHeader);
NewID := _RecRef.ADDLINK(GETURL(CLIENTTYPE::Current,
COMPANYNAME, OBJECTTYPE::Page, PAGE::”NC Header”,
pNCHeader));
RecordLink.GET(NewID);
RecordLink.CALCFIELDS(Note);
RecordLink.Note.CREATEOUTSTREAM(OStream);
SystemUTF8Encoder := SystemUTF8Encoder.UTF8Encoding;
SystemByteArray := SystemUTF8Encoder.GetBytes(_Note);
x := SystemByteArray.Length DIV 128;
IF x > 1 THEN
y := SystemByteArray.Length – 128 * (x – 1)
ELSE
y := SystemByteArray.Length;
c1 := y;
OStream.WRITE(c1);
IF x > 0 THEN BEGIN
68
c2 := x;
OStream.WRITE(c2);
END;
FOR i := 0 TO SystemByteArray.Length – 1 DO BEGIN
c1 := SystemByteArray.GetValue(i);
OStream.WRITE(c1);
END;
RecordLink.Type := RecordLink.Type::Note;
RecordLink.Notify := _Notify;
RecordLink.”To User ID” := USERID;
RecordLink.Created := CURRENTDATETIME;
RecordLink.Company:= COMPANYNAME;
RecordLink.MODIFY;
The parameters are
Var Name DataType Subtype Length
No pNCHeader Record NC Header
69
No _Descritption Text 250
No _Note Text 127
No _Notify Boolean
No _USERID Code 20
The local variables are
Name DataType Subtype Length
LenChar Integer
NewID Integer
RecordLink Record Record Link
OStream OutStream
_RecRef RecordRef
SystemUTF8Encoder
DotNet
System.Text.UTF8Encoding.’mscorlib,
Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089′
SystemByteArray
DotNet
Version=2.0.0.0,
PublicKeyToken=b77a5c561934e089′
c1 Char
70
System.Array.’mscorlib,
Culture=neutral,
c2 Char
x Integer
y Integer
i Integer
The hard part for me was to add text into the Note field
because it is a blob field so I need to use the dot net library of
the 4.5 framework and to stream the text.
71
Future Decoded with Community Days
September 02, 2016
Future Decoded with Community Days
Milano, 06-07 ottobre 2016
2 giorni, 10 tracks, 66 sessioni, 46 speaker
“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.”
Future Decoded Site
http s://www.microsoft.com/italy/futuredecoded/
Community Days Site
http://www.communitydays.it/
http://www.communitydays.it/misc/Future-Decoded/
Agenda
http
s://www.microsoft.com/italy/futuredecoded/#schedule_anchor
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
72
http
s://www.microsoftevents.com/profile/form/index.cfm?PKformID=0x39
73
Cumulative Update 11 for Microsoft Dynamics NAV 2016
has been released – Dynamics NAV Team Blog
September 02, 2016
Cumulative Update 11 includes all application and platform
hotfixes and regulatory features that have been released for
Microsoft Dynamics NAV 2016.
The cumulative update is intended mainly for solutions that are
experiencing the problems described in the Knowledge Base
article linked to below. However, you are advised to always
keep your solution updated with the latest cumulative update.
If you are in doubt about whether this cumulative update
addresses your specific problem, or if you want to confirm
whether any special compatibility, installation, or download
issues are associated with this cumulative update, support
professionals in Customer Support Services are ready to
help you. For more information, see .
The cumulative update includes hotfixes that apply to all
countries and hotfixes specific to the following local versions:
•
AU – Australia
•
AT – Austria
•
BE – Belgium
•
CH – Switzerland
74
•
CZ – Czech Republic
•
DE – Germany
•
DK – Denmark
•
ES – Spain
•
FI – Finland
•
FR – France
•
IS – Iceland
•
IT – Italy
•
NA – North America
•
NL – Netherlands
•
NO – Norway
•
NZ – New Zealand
•
RU – Russia
•
SE – Sweden
•
UK – United Kingdom
75
Where to find Cumulative Update 11
You can download the cumulative update from – Cumulative
Update 11 for Microsoft Dynamics NAV 2016 (Build 46773).
Warning
Before you install a cumulative update in a production
environment, take the following precautions:
1. Test the cumulative
environment.
update
in
a
non-production
2. Make a backup of the system or computer where the
cumulative update is to be installed.
Additional Information
For information about how to install the cumulative update,
see .
Note that if you upgrade to this cumulative update from a
version older than Microsoft Dynamics NAV 2016 Cumulative
Update 6, you must run the development environment with
elevated rights (run as administrator).
For a list of all cumulative updates for this version, see .
Source: Cumulative Update 11 for Microsoft Dynamics NAV
2016 has been released – Dynamics NAV Team Blog
76
77
Let NAV BEEP! (with .NET Interop “SystemSounds Class”)
August 29, 2016
“It is known that in Role Tailored Based environment BEEP
C/AL
function
is
not
supported”
http
s://msdn.microsoft.com/en-us/library/dd301405.aspx?f=255&MSPPEr
… nice old post (but actual) with linked sample from NAV
TEAM about utilization of .NET Interop (in this case
with “SystemSounds Class from System.Media”) to simulate
the
obsolete
BEEP
Function)
ht
s://msdn.microsoft.com/en-us/library/ms143809.aspx
Source: Let NAV BEEP! (with .NET Interop and Microsoft
Dynamics NAV 2009 R2) – Dynamics NAV Team Blog
78
“Cached Web Service Calls” – Microsoft Dynamics NAV
Community
August 24, 2016
Cached web services calls
in this section you can find a nice post by NAV Team blog
about “cached web services calls”:
Abstract
In a service-oriented deployment, web services are used to
extend NAV’s functionality and reach. Depending on how
volatile this data is and the corresponding usage scheme, it is
expected to be up-to-date within a pre-defined period of time
(e.g. once a day).
Description
When NAV is integrated with external services, then the user
scenarios become dependent on the data and functions offered
by such services. Eventually, there are different approaches
through which the external data can be retrieved, stored and
used.
Dynamic: either exposed by the external service itself or by
a separate catalog that NAV can query.
79
•
Advantage: data is always up-to-date
•
Disadvantage: it requires constant connection to the
data source.
Static: hard-coded in the database for the user to benefit
from.
•
Advantage: data is promptly available when needed.
•
Disadvantage: if data changes at some point, it will
require a maintenance effort, which exposes the
business process to a risk of failure.
Cached: offered through an external service and gets pulled
according to a pre-defined refresh rate or manually.
•
Advantage: data is ‘up-to-date’ within the rules
acceptable by the business process, without extra load
on the network resources or the external service.
•
Disadvantage: if data changes while the auto-refresh did
not happen yet, the user may not have access to the
latest data; however, the user can manually force a
refresh of the data, if asked to do so.
When to Use It
Offer data in lookups that were cached from an external
service.
80
Diagram
Source with samples: Cached Web Service Calls –
Microsoft Dynamics NAV Community
Design Patterns Wiki
Read the “wiki page” on the Microsoft Dynamics Community!
81
Dynamics 365 and more: What you need to know
August 19, 2016
Dynamics 365 and more: What you need to know
Nice page with a lot of information about Microsoft Dynamics
Business & Cloud: “What you need to know”.
http://www.gacollective.com/Dynamics/Dynamics_Business_and_Clo
About Microsoft Dynamics 365
Satya Nadella Announces Microsoft Dynamics 365 at WPC
2016.
Microsoft Dynamics 365
Designed to help change the nature of digital work within
organizations of all sizes, Microsoft Dynamics 365 empowers
business users with built-in insights and intelligence within the
business applications they’re working in – applications like
field service, sales, finance, and operations.
“As a result, Microsoft Dynamics 365:
– Introduces a disruptive and customer centric business model
to build what you want and buy just the capabilities you need,
while ensuring all roles have access to all the data they need to
be successful in their jobs
– Helps organizations move from monolithic application suites
to purpose-built, SaaS applications with intelligence built-in
82
– Integrates Microsoft Office 365”
Latest video about Microsoft Dynamics Business Solutions
http s://www.youtube.com/user/msdyncomm/featured
“ALL” Social Links
Facebook http://www.facebook.com/msftdynamics
Linkedin
http
s://www.linkedin.com/company/microsoft-dynamics
Twitter http s://twitter.com/msftdynamics
Youtube http s://www.youtube.com/user/msdyncomm/playlists
83
Dynamics Profile: New Dynamics NAV MVP Roberto
Stefanetti
Eager
to
Share
More
Broadly
–
MSDynamicsWorld.com
August 19, 2016
Award-winning blogger Stefanetti says MVP status will help
him to share even more intelligence about Dynamics NAV.
Source: Dynamics Profile: New Dynamics NAV MVP Roberto
Stefanetti
Eager
to
Share
More
Broadly
–
MSDynamicsWorld.com
84
SQL Server Migration Assistant for Datazen now generally
available
August 17, 2016
A blog from the SQL Server Reporting Services product team
at Microsoft.
Source: SQL Server Migration Assistant for Datazen now
generally available | SQL Server Reporting Services Team Blog
85
Word Layout reports data control by C/AL
August 11, 2016
Some have asked me (both on Dynamics Community and
Mibuso) how to use in NAV Word Layout reports property to
hide the value 0 or other values in fields under conditions.
Sample of question: “I have made a report in NAV 2016 using
Word and XML. Everything is very well, but I have one problem.
When “quantity” is added to the report, writes NAV “0” in all
cells with no information. In the attached picture saying “with
error” you can see That the “quantity” cell with no information
is filled with “0”.”
Question
ref.
http://forum.mibuso.com/discussion/67111/nav-2016-word-report-is-g
Answer
“No, only in C / SIDE in this case (simple common solution),
the use in this way (no logic in Word, all in C (SIDE) .. but .. i
think That you can create functions in Word (macro) ,in word
template. you can modify XML an add also Javascript
support… an so on..”
Some functions can be used with C / AL
With these sample functions you can simulate what is done by
the visibility property of the RDLC report or by VBNET
Functions included in the report (Public Functions on CODE
section of reports).
86
Examples
Num2Str (IdecValue: Decimal) OtxtValue: Text [100]
0 THEN BEGIN ">IF IdecValue <> 0 THEN BEGIN
'); ">OtxtValue: = FORMAT (IdecValue, 0, ‘<Precision, 2: 2>
<Standard Format, 0>’);
END;
Num2Str2 (IdecValue: Decimal) OtxtValue: Text [100]
OtxtValue:=FORMAT(IdecValue,0,'<Precision,2:2><Standard
Format,0>’);
Int2Str (inValue: Integer) OtxtValue: Text [100]
0 THEN BEGIN ">IF inValue <> 0 THEN BEGIN
OtxtValue: = FORMAT (inValue);
END;
..
etc etc.
87
Cumulative Update 10 for Microsoft Dynamics NAV 2016
has been released
August 08, 2016
Source: Cumulative Update 10 for Microsoft Dynamics NAV
2016 has been released – Dynamics NAV Team Blog
88
NAV 2017 Roadmap
August 04, 2016
NAV 2017 Roadmap
Some nice “public pictures” from event “WPC 2016”
http s://resources.wpc.microsoft.com/session-resources.html#
..you can download official Microsoft videos and ppt slides
from here:
http s://resources.wpc.microsoft.com/session-resources.html#
nice post by Saurav Dhyani about event topics here:
http://saurav-nav.blogspot.it/2016/08/microsoft-dynamics-nav-2017-d
you are welcome !
89
90
NAV TechDays 2016, Sessions @02-08-2016
August 02, 2016
Roberto Stefanetti NAV Blog
NAV TechDays 2016 , 17 & 18
november 2016 , Antwerp (Belgium)
Sessions @ 02-08-2016
http s://www.navtechdays.com/2016/sessions
My Favorite Sessions
-Design Patterns in NAV ‘Madeira’
-Building extensions for NAV
-How to build your solution for PaaS
91
-Best Practices in developing Microsoft Dynamics NAV 2017
Extensions
-Building cool experiences with O365, Outlook, PowerBI and
more
Pre-conference sessions (15-16)
-PowerShell – Black Belt
-C# for C/AL Developers
-Troubleshooting Essentials for SQL Server and Dynamics
NAV
-Power-BI – Advanced
-Extending the Data Exchange Framework
Register Page
http s://www.navtechdays.com/2016/register
Speakers
http s://www.navtechdays.com/2016/speakers
Source: register | NAV TechDays 2016
View original post
92
A Visual SQL Query Designer – Code project (SQL From
NAV Part III)
August 01, 2016
A Visual SQL Query Designer – Code Project (SQL From NAV
Part III)
If some of your customers asks you to gain access to SQL data
directly from NAV (as other systems with integrated query
editors..) can use this nice tool to run SQL queries (or others
T-SQL statements…).
This tools recalls some typical features of SQL Studio
Management studio like Visual SQL Query Designer; currently
is available in 2 releases (VB.NET and C #), i tested the C#
solution that works well.
Tool is under “CPOL Licence”
“Source Code can be modified to create derivative works”, …
you can modify the solution’s source to create derivates. For
example you can create a class for NAV .NET integration or
create an addin for RTC Client, the tool also can be used
directly by calling him from Wshell in NAV (.EXE); you can
however also pilot the numbers of records extracted etc. etc. ..
nice tool anyway.
Tool features
93
“This
article
describes
the
implementation
of
a
QueryDesignerDialog class that allows users to create SQL
queries based on a given OLEDB connection string.
Code Download
Source
http://www.codeproject.com/Articles/43171/A-Visual-SQL-Query-Desi
94
How to Use MVC.Net on the Dynamics NAV Database
Structure
July 30, 2016
How to Use MVC.Net on the Dynamics NAV Database Structure
nice post about ASP MVC.Net integration with NAV (post by
Codeproject).
About ASP MVC.Net
ASP MVC.Net is an robust & good pattern-based way to build
dynamic websites; if you don’t like to use Web Services &
OData this is a valid alternative (old but actual). You can use to
build Website based on NAV database structure. “How you can
use the Entity Framework in an MVC.Net web application with
Dynamics NAV ?”
Tutorial
This tutorial will show you how you can use the Entity
Framework in an MVC.Net web application with Dynamics NAV.
Take a look to project.
Source:
http://www.codeproject.com/Articles/421643/How-to-Use-MVC-Net-on
95
Let NAV Speak (with a Simple and Useful Client Add-in)
July 30, 2016
nice old post by Duilio Tacconi.
“In this blog post you will find the source code (below) to “let
NAV speak.” You would have a wide range of possibilities to
use this simple Add-in and enlarge this project.
If you want to know more about Client Add-ins you can refer to
this MSDN link:
This simple Client Add-In is based on System.Speech
namespace:
Source: Let NAV Speak (with a Simple and Useful Client
Add-in) – Dynamics NAV Team Blog
96
“Scheduling
Reports”
option
also
report.RUNMODAL instead of report.RUN
available
in
July 29, 2016
Dynamics Product Suggestion | Microsoft Connect
“Scheduling
Report”
option
also
report.RUNMODAL instead of report.RUN
available
in
it would be useful to use the “report schedule” option also in
report.RUNMODAL mode (in this mode is inhibited by design).
i can change the codeunit that launchs reports from “report
selection” but i think isn’t a good idea, i dont’ know why this
feature is inhibited by design.
Source: “Scheduling Reports” option also available in
report.RUNMODAL instead of report.RUN | Microsoft Connect
97
NAV 2013 SQL Query Codeunit Tool (SQL From NAV Part
II)
July 27, 2016
NAV 2013 SQL Query Codeunit tool
i found this nice demo tool by Dynamic Manufacturing
Solutions on Mibuso.
Source
http://mibuso.com/downloads/nav-2013-sql-query-codeunit
nice tool, based on .NET integration (AD), usefull if you don’t
like Powershell.
Purpose of this tool
“Simple codeunit allows you to execute an SQL query to
populate any NAV (temporary) table using one call. Test page
is included to demonstrate functionality with a simple query.”
… Nice tool (with demo page & codeunit objects) tu run SQL
Statements directly from NAV using .NET integration (ADODB);
you can run SQL Select statements and any sql commands (if
you have rights).
Modifications
I did some modifications to load a generic table using
dynamics fields.. example field1. field2, fiels3 etc. and
possibility lo load a saved SQL Statement from “.SQL” Script
98
file or from BLOB field in “SQL Commands Table” etc. ..
Example of utilization
..you can retrieve Intercompany “Contacts” running a simple
“SELECT with UNION SQL statement”…
.. also you can publish this page “as a web service” to
retrive\expose data from multi-sources database using only a
web service connection!
SIMPLE QUERY
SELECT SUM(Quantity) AS QuantityTot, [Item No_], [Location
Code], [Lot No_], [Serial No_]
FROM dbo.[CRONUS Italia S_p_A_$Item Ledger Entry]
GROUP BY [Item No_], [Location Code],[Lot No_],[Serial No_]
HAVING ([Location Code]<>” AND (SUM(Quantity)) >0)
MORE COMPLEX QUERY WITH HAVING FILTERS
SELECT SUM(Quantity) AS Field1,
[Item No_] as Field2,
[Location Code] as Field3,
[Lot No_] as Field4, [Serial No_] as Fileld5 FROM dbo.[CRONUS
Italia S_p_A_$Item Ledger Entry]
GROUP BY [Item No_], [Location Code],[Lot No_],[Serial No_]
HAVING ([Location Code]<>” AND (SUM(Quantity)) >0)
SQL STATEMENT TO “CREATE A NEW TABLE”
CREATE ACTIVITY 2 TABLE
CREATE TABLE [dbo].[CRONUS Italia S_p_A_$Activity_2](
[timestamp] [timestamp] NOT NULL,
[Code] nvarchar NOT NULL,
[Description] nvarchar NOT NULL,
99
CONSTRAINT [CRONUS Italia S_p_A_$Activity$10] PRIMARY
KEY CLUSTERED
(
[Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ANY SQL COMMAND EX BACKUP…..
etc. etc.
Great tool!
Source
http://mibuso.com/downloads/nav-2013-sql-query-codeunit
100
Load Data into NAV using C/AL and Powershell (SQL From
NAV Part I)
July 24, 2016
Load Data into NAV using C/AL & Powershell
Sample Scenario
“Read distributed data from Sql Server and load a data
warehouse using NAV C/AL with Powershell integration”
If you need to retrieve (and aggregate) data from more than
ONE company or from more than ONE database , in NAV you
can use “SQL Server Views” objects mapped as “NAV linked
objects”.
… but if don’t want to use NAV Linked objects (SQL Tables or
SQL View because is complex and time consuming to
managing with many companies\many databases or because
you don’t’ want to consume NAV tables for linked objects) and
you don’t like “.net integrations” or utilization of external
applications, you can use Powershell in NAV (and outside NAV
certainly…)
You can achieve this goal using a Hybrid Methods to load data
into NAV from different sources
101
•
Read data from Powershell
•
Write Data\Processing in NAV with C/AL Coding
You can use two functions by Waldo to do this:
•
Powershell Wrapper for NAV C/AL function
•
Invoke-NAVSQL function
Scenario
•
Use good Waldo function to launch powershell fro NAV
(after this you can schedule on NAV NAS load data process)
– PowerShell Wrapper
•
Read Sql Views from
‘Invoke-NAVSQL’ function
•
Write into NAV table using C/AL logic & data validations
mixing C/AL and Powershell commands.
Powershell
using
Waldo
NB: Powershell consumes a concurrent user.
Details about these good functions by Waldo
“How-to” use powershell in NAV (NAV Powershell Wrapper)
102
•
look at Waldo Blog to achieve this functionality
http://www.waldo.be/2014/12/17/running-powershell-from-nav/
•
Download
module
here
http://mibuso.com/downloads/running-powershell-in-nav
•
“It’s
basically
a
wrapper
to
easily
use
“System.Management.Automation.Runspaces.Runspace”
and “System.Management.Automation.PowerShell”.
“How- to” load
(Invoke-NAVSQL)
data
into
NAV
with
Powershell?
•
You can use Waldo function “ Invoke-NAVSQL” (function is
similar to existing function part of the SQLPS module)
•
“Invoke-NAVSQL”: Execute SQL queries on NAV databases
with PowerShell
•
http://www.waldo.be/2016/06/08/invoke-navsql-execute-sql-queries
•
Download
function
here:
http
s://github.com/waldo1001/Cloud.Ready.Software.PowerShell/blob/
Example
Get all companies, and get the customers of the first company:
103
$Mycompanies
=
Invoke-NAVSql
-ServerInstance
‘dynamicsNAV90’ -SQLCommand ‘Select * From Company’
$Customers = $Mycompanies |
select -First 1 |
foreach{ Invoke-NAVSQL -ServerInstance ‘dynamicsNAV90’
-SQLCommand “select * from [$($_.Name)$(‘$Customer’)]”
-ShowWriteHost }
$Customers | select ‘No_’, Name, ‘Credit Limit (LCY)’ |
Format-Table –AutoSize
ALL Source links:
http://www.waldo.be/2014/12/17/running-powershell-from-nav/
http://mibuso.com/downloads/running-powershell-in-nav
http://www.waldo.be/2016/06/08/invoke-navsql-execute-sql-queries-on
http
s://github.com/waldo1001/Cloud.Ready.Software.PowerShell/blob/ma
104
NAV Shortcuts & Filters | ArcherPoint, Inc.
July 23, 2016
Great post about “NAV Keyboard Shortcuts & Filters” by
Archerpoint.
13 essential NAV Schortcuts
http://www.archerpoint.com/sites/default/files/docs/dynamics-nav-sh
NAV Filters
http://www.archerpoint.com/sites/default/files/docs/dynamics-nav-filt
Source: 13 Essential Microsoft Dynamics NAV Shortcuts |
ArcherPoint, Inc.
105
Dynamics NAV: HR (Human Resources) module – TechNet
Wiki
July 21, 2016
Source:
106
Project “Madeira” topics & links
July 19, 2016
Project “Madeira” topics & links – Short presentation of Project
Madeira with ALL existing links.
Project "Madeira" preview from Roberto Stefanetti
107
New Scrum guide @Scrumguides.org
July 17, 2016
New Scrum guide @Scrumguide.org
Scrum is a framework for developing and sustaining complex
products. This Guide contains the definition of Scrum. This
definition consists of Scrum’s roles, events, artifacts, and the
rules that bind them together. Ken Schwaber and Jeff
Sutherland developed Scrum; the Scrum Guide is written and
provided by them. Together, they stand behind the Scrum
Guide.
New Scrum guide (July 2016 release) here:
http://www.scrumguides.org
Source: Home | Scrum Guides
108
NAV 2016 Italian Flyer
July 15, 2016
NAV 2016 Italian Flyer
NAV 2016 What’s New Flyer, a short flyer (fast tracks) about
NAV 2016 new features.
Download
link:
http://www.soluzioniedp.it/admin/public/downloads/52cb0bfb7756a93
109
New NAV 2016 videos about “extensions”
July 14, 2016
New NAV 2016 videos about “extensions”
In the “NAV Videos” section of the Dynamics Community, new
videos have been added about use of extensions in NAV 2016.
You
can
find
them
at
this
link:
http
s://community.dynamics.com/nav/b/navvideos
New Videos:
How Do I Build a Basic Microsoft Dynamics NAV Extension
How Do I Build My Own Development Environment for Starting
to Develop Dynamics NAV Extensions
How Do I Get Started with Building Microsoft Dynamics NAV
Extensions on the Azure Demo
How Do I Set Prerequisites and Dependencies with Microsoft
Dynamics NAV Extensions
How Do I Include a Permission Set in a Microsoft Dynamics
NAV Extension
you can find other links about extensions in my previous post
(MSDN, HOW-TO, blog posts links etc.)
110
Some links about NAV 2016 “Extensions”
http
s://community.dynamics.com/nav/b/arounddynamicsnavworld/archiv
…good vision at all !
111
Database Conversion for a Dynamics NAV database
stored in Azure
July 14, 2016
Source: Database Conversion for a Dynamics NAV database
stored in Azure
112
Announcing NAV 2017 @WPC 2016
July 13, 2016
some public pictures from event “WPC 2016”
http
s://resources.wpc.microsoft.com/session-resources.html#
113
114
you can download videos and ppt slides here:
http
s://resources.wpc.microsoft.com/session-resources.html#
nice post by Saurav Dhyani about event topics here:
http://saurav-nav.blogspot.it/2016/08/microsoft-dynamics-nav-201
Mark Brummel Blog | Microsoft Dynamics NAV
Big news from WPC today. Paul White presented the future for
the Dynamics SMB space. Project Madeira will be launched this
fall as Dynamics 365 – Business Edition, divided into
Financials and Sales & Marketing
The launch will be US and Canada first and in 2017 four
(4) European countries.
115
Integration is key for Microsoft Dynamics 365. Integration with
PowerApps and Flow. PowerBI and Office 365.
Dynamics 365 Business Edition will be launched during
NAVUG Summit in Tampa. See you there.
116
View original post
117
Some links about Powershell “cmdlets” for NAV
July 11, 2016
Some links about Powershell “cmdlets” for NAV
“CMDLETS” IN NAV
The cmdlets are available in two Windows PowerShell
modules: Microsoft Dynamics NAV 2016 Administration Shell
and Microsoft Dynamics NAV 2016 Development Shell.
•
The Microsoft Dynamics NAV 2016 Administration Shell
includes cmdlets for administering the Microsoft Dynamics
NAV deployment, such as adding and configuring Microsoft
Dynamics NAV server instances, databases, and users.
Also included are cmdlets for administering extension
packages.
The
Microsoft
Dynamics
NAV
2016
Administration Shell is installed with the Microsoft
Dynamics NAV Server.
•
The Microsoft Dynamics NAV 2016 Development Shell
includes cmdlets for merging and modifying application
object files. Also included are cmdlets for creating
extension packages. The Microsoft Dynamics NAV 2016
Development Shell is installed with the Microsoft Dynamics
NAV Development Environment.
http
s://msdn.microsoft.com/en-us/library/hh166599(v=nav.90).aspx
118
“ALL” about CMDLETS LINKS
A list of bestlinks about cmdlets in NAV 2016 (MSDN)
Administration Cmdlets for Microsoft Dynamics NAV
http
s://msdn.microsoft.com/en-us/library/jj672916(v=nav.90).aspx
Development Cmdlets for Microsoft Dynamics NAV
http
s://msdn.microsoft.com/en-us/library/dn789712(v=nav.90).aspx
Microsoft Dynamics NAV Windows PowerShell Cmdlets
http
s://msdn.microsoft.com/en-us/library/hh166599(v=nav.90).aspx
Comparing and Merging Application Object Source Files
http
s://msdn.microsoft.com/en-us/library/dn789581(v=nav.90).aspx
Administration
Extensions
Cmdlets
for
Microsoft
Dynamics
NAV
http
s://msdn.microsoft.com/en-us/library/mt584148(v=nav.90).aspx
Development Cmdlets for Microsoft Dynamics NAV Extensions
119
http
s://msdn.microsoft.com/en-us/library/mt584152(v=nav.90).aspx
Changes to Microsoft Dynamics NAV Cmdlets From Previous
Release
http
s://msdn.microsoft.com/en-us/library/dn951485(v=nav.90).aspx
Exporting and Importing Companies and Other Data
http
s://msdn.microsoft.com/en-us/library/dn789595(v=nav.90).aspx
Others nice links below:
Guida introduttiva a Windows PowerShell
http
s://msdn.microsoft.com/powershell/scripting/getting-started/getting-s
Sample Windows PowerShell Scripts for Microsoft Dynamics
NAV
http
s://msdn.microsoft.com/en-us/library/dn271676(v=nav.90).aspx
Managing Dynamics NAV with PowerShell
http://www.softwareanswers.co.uk/software_answers/2014/09/manag
120
About Microsoft Dynamics NAV 2016 Development Shell
CMDLETS LIST
For a complete list of cmdlets:
•
Get-Command
Microsoft.Dynamics.Nav.Model.Tools,
Microsoft.Dynamics.Nav.Apps.Tools,
Microsoft.Dynamics.Nav.Apps.Management
-Module
Cms Type Name
Function Compile-NAVApplicationObject
Function Create-NAVDatabase
Function Delete-NAVApplicationObject
Function Export-NAVApplicationObject
Function Import-NAVApplicationObject
Function Invoke-NAVDatabaseConversion
Cmdlet Compare-NAVApplicationObject
Cmdlet Export-NAVApplicationObjectLanguage
Cmdlet Export-NAVAppPermissionSet
Cmdlet Get-NAVAppInfo
Cmdlet Get-NAVApplicationObjectProperty
Cmdlet Get-NAVAppManifest
Cmdlet Get-NAVAppTenant
Cmdlet Import-NAVApplicationObjectLanguage
Cmdlet Install-NAVApp
121
Cmdlet Join-NAVApplicationObjectFile
Cmdlet Join-NAVApplicationObjectLanguageFile
Cmdlet Merge-NAVApplicationObject
Cmdlet New-NAVAppManifest
Cmdlet New-NAVAppManifestFile
Cmdlet New-NAVAppPackage
Cmdlet New-NAVCrmTable
Cmdlet Publish-NAVApp
Cmdlet Remove-NAVApplicationObjectLanguage
Cmdlet Repair-NAVApp
Cmdlet Set-NAVApplicationObjectProperty
Cmdlet Set-NAVAppManifest
Cmdlet Split-NAVApplicationObjectFile
Cmdlet Split-NAVApplicationObjectLanguageFile
Cmdlet Test-NAVApplicationObjectLanguage
Cmdlet Uninstall-NAVApp
Cmdlet Unpublish-NAVApp
Cmdlet Update-NAVApplicationObject
MY FAVORITE COMMANDS: “JOIN & SPLIT”
JOIN
Join-navapplicationobjectfile
(SINGLE
FILE
CREATION
COMMAND (CREATION WITH FIRST CHECK SYNTAX IN
“JOIN” COMMAND)
System stops single “file merging procedure” if any error is
ecountered during converting process; system make a first
check objects structure during this process.
122
Command
PS C:> cd E:MERGEPages
PS E:MERGEPages> Join-navapplicationobjectfile -source
‘E:MERGEPages*.txt’
–destination
‘E:MERGEPagesPages_OutPages_OutMerged.txt’
SAMPLE OUTPUT
SAMPLE ERROR
“WARNING:
expected.”
E:MERGEPagesPAG12133.TXT
(252,28)
=
-a— 08/07/2016 10:28 147645 Pages_OutMerged.txt
IF FILE EXIST….
Overwrite?
E:MERGEPagesSplitFilesPagesPAG12190.TXT
[Y] Yes [A] Yes to All [N] No [L] No to All [S] Suspend [?] Help
(default is “Y”):a
Well done > File correctly created after syntax parsing.
SPLIT
123
Split-navapplicationobjectfile
(SPLIT
FILES
CREATION
COMMAND (WITH FIRST CHECK SYNTAX IN “SPLIT”
COMMAND)
System stops single “file merging procedure” if any error is
ecountered during converting process; system make a first
check objects structure during this process.
Command
PS
C:Windowssystem32>
Split-navapplicationobjectfile
–source
‘E:MERGEPagesMergedFilesPages_OutMerged_12000.txt’
–destination ‘E:MERGEPagesSplitFilesPages12000_Split’
SAMPLE OUTPUT
124
Microsoft Dynamics 365 news
July 06, 2016
Microsoft Dynamics 365 news
“Rethink what’s possible for your business with intelligent
business apps in the cloud“, “Helping customers transform
with a new approach to business process”
Dynamics 365 & AppSource
“Deep integration between Dynamics 365 and Office 365 will
connect the structured workflow of business apps with the
unstructured work of collaboration and Productivity.
Available this fall, Microsoft Dynamics 365 evolves our current
CRM and ERP cloud solutions into one cloud service with new
purpose-built apps to help manage specific business
functions, including: Financials, Field Service, Sales,
Operations, Marketing, Project Service Automation and
Customer Service.
Dynamics 365 apps are designed so they can be easily and
independently deployed. That means you can start small and
pay only for what you need. Yet they work together seamlessly
so, as your business demands, you can grow into additional
capabilities with ease. They include built-in insights, predictive
intelligence and workflow optimization, all of which will be
delivered through simple, easy-to-use, mobile experiences with
125
offline capabilities.
“Power BI and Cortana” Intelligence will be natively embedded
to help customers achieve their business goals with predictive
insights, prescriptive advice and actionable next steps.
Customers can learn more about Dynamics 365 and about
AppSource .
Source: Microsoft Dynamics 365 by Takeshi Numoto posted on
Official Microsoft Blog
Dynamics 365 best Images from presentations
Dynamics 365 best links from Microsoft
http s://www.microsoft.com/en-us/dynamics/dynamics-365
http
s://community.dynamics.com/b/msftdynamicsblog/archive/2016/07/13
http
s://community.dynamics.com/b/msftdynamicsblog/archive/2016/07/06
http
s://www.microsoft.com/en-us/dynamics/small-midsize-business.aspx
http s://www.microsoft.com/en-us/dynamics/erp.aspx
http
s://www.microsoft.com/en-us/dynamics/erp-small-midsize-business.a
126
http s://www.microsoft.com/en-us/dynamics/support.aspx
My opinion: … Madeira…Dynamics 365 & AppSource … lot of
changes scheduled in Autumn i think! … i will serch more
information about these topics asap! STAY TUNED !
127
Automate backup on SQL Express and Send Mail
Powershell Script
July 05, 2016
235 download on Technet…
Roberto Stefanetti NAV Blog
Sql Server Backup Automation and send-email
Solution to automate backup on SQL Express and send mail
based
on
first
Microsoft
SQL
BackupScript
“sp_SQLBackupDatabases”
Scheduling
NB: SQL Server Agent “is not available” on this SQL release
You can schedule jobs with standard “Windows Jobs“ !
How System Works:
3 Objectsd based procedure:
1) batch file > SQL-Backup.bat (Execute ALL Procedure)
2) backup procedure > SP_SQLBackupDatabase.sql (original
Microsoft SQL Backup Script)
128
3) Send mail > Send-email.ps1 (a send email routine based on
Powershell Script)
Example:
sqlcmd -U sa -P xxxx -S .SQL2012EXPRESS -Q “EXEC
sp_SQLBackupDatabases
@backupLocation
=
‘C:SQLBackups’, @backupType = ‘F’”
Original
Microsoft
Solution:
s://support.microsoft.com/en-us/kb/2019698
http
MSDN
Post
Link
http
s://gallery.technet.microsoft.com/Automate-backup-on-SQL-21eb452d
Download
link
http
s://gallery.technet.microsoft.com/Automate-backup-on-SQL-21eb452d
View original post
129
Cumulative Update 9 for Microsoft Dynamics NAV 2016
has been released
July 05, 2016
Source: Cumulative Update 9 for Microsoft Dynamics NAV 2016
has been released
130
Gestione Commesse in NAV (NAV Project Management
Module)
July 05, 2016
My Last Video on Youtube: “Gestione Commesse in NAV (NAV
Project Management Module)”
.. also available on Slideshare
Gestione commesse (pm) NAV 2016 from Roberto Stefanetti
131
Directions EMEA 2016, the biggest NAV event
July 02, 2016
Directions EMEA 2016, the biggest NAV event
October 12-14, 2016 Prague, Czech Republic
“THE BIGGEST NAV EVENT!”
Meet Microsoft Dynamics NAV partners and experts as well as
the Microsoft team and ISVs in Prague on October 12-14, 2016!
Top 10 Reasons for Attending !
Register
“Until July 31 (midday), you can take advantage of the Early
Bird pricing.”
Source:
actually… 1000 registered !
132
Business Solutions MVP Award 2016 (NAV)
July 01, 2016
Business Solutions MVP Award 2016 (NAV)
… stamattina mi è arrivata questa mail da Microsoft !!!
onorato del premio !
Salve Roberto Stefanetti,
Complimenti! Siamo lieti di presentarti l’edizione 2016 del
titolo MVP Microsoft.
Si tratta di un premio destinato ai leader delle community
tecniche con doti eccezionali che condividono attivamente con
altri la straordinaria qualità della propria competenza sul
campo. Apprezziamo davvero il tuo incredibile contributo,
relativamente a Business Solutions, all’interno delle
community tecniche durante lo scorso anno. Il Microsoft MVP
Award ci offre un’opportunità unica per celebrare ed onorare i
suoi contributi così significativi e per dirle “Grazie per la sua
leadership tecnica“.
Congratulazioni Roberto! , sei una delle poche centinaia di
persone nel Mondo che sono state insignite del Microsoft MVP
Award.
…after a lot of post on my new blog, TechNet articles and
reviews, NAV books reviews,
Dynamics NAV forum
133
moderation activies, some bugs, suggestions for product
change and improvement .. after many nominations, many
times in first five european contenders … finally i got !
…today is a GREAT day !!! …only one simple “word” to ALL
my readers & followers : THANKS !!! Thanks to Microsoft.
MY MVP PROFILE PAGE
http
s://mvp.microsoft.com/it-it/PublicProfile/5001957?FullName=Roberto%
MVP 2016 AWARD KIT
134
TECHNET PROFILE MVP, MCC
http
s://social.msdn.microsoft.com/Profile/v1/roberto%20stefanetti/
135
Project “Madeira” my presentation on slideshare &
support page
June 30, 2016
Project “Madeira” my presentation on slideshare
http://www.slideshare.net/RobertoStefanetti/project-mad
Project “Madeira” is a business management solution for small
and mid-sized organizations that automates and streamlines
business processes and helps you manage your business.
Signing up is easy, and you can migrate existing business data
from your legacy system. When you have signed up for the
Project “Madeira” preview, you have access to a
demonstration company. The demonstration company
contains sample data, but you can create your own sales
documents, for example, or set up a bank account.
In the preview, you can see visual guides that explain core
functionality. These guides let you try out daily tasks such as
making a sales invoice and viewing a report. When you want to
explore Project “Madeira” on your own, you can always go
back to the Getting Started tour by launching it from the Home
page.
136
The Home page is also where you will find the Assisted Setup
& Tasks action. Here you see a list of assisted setup that can
help you getting started. Once you have migrated data such as
vendors, customers, and items from your existing financial
system using the Migrate Business Data assisted setup you
are ready to begin. But depending on your needs, consider if
the other assisted setup can help you.
In the Assisted Setup window, you will find the following:
Assisted Setup
Set Up Company
Migrate Business Data
Set Up Sales Tax
Description
Creates a new trial company for
you to enter data and try our
Project “Madeira”. If you went
through the Getting Started
tour this is probably already
Completed.
Lets you import your existing
company data such as vendors,
customers, and items from
Excel or Quickbooks.
Gets you started with default
Tax groups and assigning Tax
area codes that you can assign
to customers and vendors in
order to automatically calculate
sales tax in sales or purchase
documents.
137
Set Up Email
Set Up Office Add-Ins
Set Up Email Logging
Gets you ready for sending
email messages directly from,
for example, sales orders or
contacts in Project “Madeira”.
Sets up the ability to use and
launch Project “Madeira” from
Outlook.
Sets up the capability to log
email correspondence in
Project “Madeira” to follow up
on interactions.
When you have run an assisted setup, it is marked as
Completed. To run the assisted setup, you choose the three
dots also called the context menu, and then you select Start
Setup.
Madeira
Help
Page
http
s://madeira.microsoft.com/en-us/documentation/madeira-get-started/
Source: Welcome to Project “Madeira” | Project “Madeira”
On Twitter http s://twitter.com/ProjectMadeira
138
Configuring Client Timeout in NAV 2016 CU 8 | Dynamics
NAV Team Blog
June 24, 2016
Configuring Client Timeout in NAV 2016 CU 8
“Finally, by popular demand, we changed this in Dynamics
NAV 2016 Cumulative Update 8: The “ClientKeepAlive” setting
has been moved from the user level to the service level, and is
no longer defined in number of seconds but as a time interval,
just like the Idle Client Timeout setting.
To configure the timeout for the Dynamics NAV Web client, it is
sufficient to configure the SessionTimeout setting in the
web.config file to the relevant interval – in our example it’s
00:10:00.
“We hope this clarifies the process for setting the timeout for
the Dynamics NAV Windows client and Dynamics NAV Web
client.”
Source
http
s://blogs.msdn.microsoft.com/nav/2016/06/24/configuring-client-timeo
Great !!!
139
PARAMETRI DI PIANIFICAZIONE IN NAV 2016
June 23, 2016
PARAMETRI DI PIANIFICAZIONE IN NAV 2016
Il processo di pianificazione di NAV 2016 considera diversi
elementi per gestire correttamente la pianificazione; saranno
sotto elencati i campi più significativi presenti in scheda
Articolo\Setup Manufacturing utilizzati da questo processo.
Sommario punti
1 PIANIFICAZIONE IN NAV 2016. 3
1.1 ELEMENTI IN GIOCO PRINCIPALI IN PIANIFICAZIONE.. 3
3 Setup CAMPI ARTICOLO PER PIANIFICAZIONE E COSTING..
3
3.1 Scheda Articolo. 3
3.2 Valutazione Magazzino NAV.. 4
3.3 Metodo di Costing in NAV.. 4
3.4 Metodo di Costing in NAV Dettaglio. 5
3.5 Valutazione Magazzino Fiscale Rif. Codice Civile. 6
3.6 Parametri di rifornimento. 7
140
3.7 Sistema di rifornimento. 7
3.8 Calcolo Lead Time. 7
3.9 Politica di produzione. 8
3.10 Motodo di consuntivazione. 9
3.11 % Scarto. 11
3.12 Dimensione Lotto (di Produzione) 12
3.13 Parametri generali pianificazione da Setup Manufacturing.
12
3.14 Quantità di smorzamento di default 12
3.15 Periodo di stabilizzazione di default 13
3.16 Assemblaggio. 13
3.17 Parametri di pianificazione. 14
3.18 Metodo di riordino. 14
3.19 Pianificazione delle ubicazioni senza utilizzare USK.. 16
3.20 Politica di tracciabilità. 16
3.21 Impegno. 16
141
3.22 Periodo di stabilizzazione. 17
3.23 Qtà di smorzamento (e di Default) 17
3.24 Articolo Critico. 18
3.25 Lead Time Sicurezza. 18
3.26 Scorta Sicurezza. 19
3.27 Parametri Lotto-Per-Lotto. 20
3.28 Periodo accumulo lotti 20
3.29 Periodo di riprogrammazione. 21
3.30 Parametri punti di riordino. 21
3.31 Qtà di riordino. 22
3.32 Giacenza massima. 22
3.33 Livello di overflow.. 23
3.34 Intervallo di tempo. 24
3.35 Moltiplicatori ordini (per tipologie “<> Ordine”) 24
3.36 Qtà minina ordine. 24
3.37 Qtà massima ordine. 25
142
3.38 Molteplicità ordine. 25
1 PIANIFICAZIONE IN NAV 2016
Il processo di pianificazione di NAV 2016 considera diversi
elementi per gestire correttamente la pianificazione; saranno
sotto elencati i campi più significativi presenti in scheda
Articolo\Setup Manufacturing utilizzati da questo processo.
1.1
ELEMENTI
INPIANIFICAZIONE
IN
GIOCO
PRINCIPALI
I principali elementi in gioco nel processo di pianificazione
sono:
•
Giacenze di Magazzino (da flag “Includi giacenza” per
riordino a MAKE-TO-STOCK)
Ordini di Vendita
Ordini di Vendita Programmati
Ordini di Acquisto
Ordini di Acquisto Programmati
143
Ordini di Trasferimento
Commesse in essere
Ordini di produzione in essere
Ordini di Assistenza
Gestione Scorta Minimaparametri di riordino articolo
SKU (Stock Keeping Units) con relativa parametrizzazione
(come per articolo)
Richieste di Approvvigionamento (queste non vengono
tenute conto nel calcolo MRP, sono cancellabili e ricreabili
al lancio)
3
Setup
CAMPI
ARTICOLO
PIANIFICAZIONE E COSTING
PER
Saranno ora documentati i singoli campi più significativi
utilizzati dal processo di pianificazione; la definizione della
funzionalità del singolo campo è quella presente nell’help
Online di NAV; le informazioni sono state aggregate per
144
presentarle in un solo blocco; utilizzando la funzionalità
standard “Online Help” di NAV sul campo è possibile
visualizzare le stesse analoghe informazioni.
3.1 Scheda Articolo
Scheda Articolo
3.2 Valutazione Magazzino NAV
“Specifica il metodo di valutazione magazzino utilizzata per
calcolare il costo dell’articolo. Le opzioni includono Medio
ponderato, Medio, FIFO, LIFO e LIFO discreto.
Sono gestiti i metodi classici di valutazione regolati dal codice
civile italiano
Ø Medio Ponderato, Medio, FIFO, LIFO, LIFO Discreto
3.3 Metodo di Costing in NAV
“Specifica come viene registrato il flusso del costo dell’articolo
e se un valore effettivo o a budget viene capitalizzato e
utilizzato nel calcolo dei costi.
Il metodo di costing che viene scelto determina la modalità in
cui viene calcolato il costo unitario tramite presupposizioni sul
flusso degli articoli nell’azienda. “
Ø Le opzioni includono FIFO, LIFO, Specifico, Medio, Standard
145
3.4 Metodo di Costing in NAV Dettaglio
“Il Metodo di costing sulla scheda articolo definisce come
viene registrato il flusso del costo dell’articolo e se un valore
effettivo o a budget viene capitalizzato e utilizzato nel calcolo
dei costi.”
Nella seguente tabella vengono fornite le procedure consigliate
sulla modalità di impostazione del campo Metodo di costing.
Opzione di setup
Procedura
consigliata
146
Commento
FIFO
Utilizzare quando il Il costo unitario di
costo del prodotto è un articolo è il valore
effettivo di tutto il
stabile.
carico dell’articolo,
Utilizzare per articoli selezionato secondo
con una durata a
la regola FIFO.
scaffale limitata,
poiché le merci più Nella valutazione di
vecchie devono
magazzino si
essere vendute
presuppone che il
prima della data di
primo articolo
scadenza.
posizionato nel
magazzino venga
venduto per primo.
Nota
Quando i prezzi
salgono, nei conti
patrimoniali viene
mostrato un valore
maggiore. Ciò
significa che la
soggettività
tributaria aumenta
mentre il punteggio
del credito e la
capacità di prendere
in prestito soldi
migliora.
147
LIFO
Utilizzare quando i Il costo unitario di un
articolo è il valore
livelli di inventario
effettivo di tutto il
vengono gestiti in
carico dell’articolo,
modo coerente o
selezionato secondo
aumentano nel
la regola LIFO.
tempo.
Nella valutazione di
magazzino si
presuppone che gli
ultimi articoli
posizionati nel
magazzino vengano
venduti per primo.
Nota
Quando i prezzi
salgono, il valore nel
conto economico
diminuisce. Ciò
significa che la
soggettività
tributaria diminuisce
mentre la capacità di
prendere in prestito
soldi peggiora.
Importante
Operazione non
consentita in molti
paesi, perché può
essere utilizzata per
ridurre il profitto.
148
Media
Specifico
Utilizzare quando il Il costo unitario di
costo del prodotto un articolo è il costo
esatto con la
non è stabile.
particolare unità è
Utilizzare quando gli
stata ricevuta.
inventari sono
impilati o mischiati e
non è possibile
differenziarli, ad
esempio con gli
agenti chimici.
Utilizzare nella
Il costo unitario di
produzione o nel
un articolo viene
commercio di
calcolato come il
articoli facilmente costo unitario medio
identificabili a costi in ogni momento
unitari abbastanza dopo un acquisto.
elevati.
Per la valutazione
Utilizzare gli articoli
magazzino si
che sono soggetti a presuppone che
regolazione.
tutte le giacenze
siano vendute
Utilizzare per articoli simultaneamente.
con numeri di serie.
149
Standard
Utilizzare quando il Il costo unitario di
controllo costi è
un articolo è
fondamentale.
prestabilito in base a
una stima.
Utilizzare nella
produzione ripetitiva Quando il costo
per stimare i costi di
effettivo viene
materiale diretto, di
realizzato
manodopera diretta successivamente, il
e i costi generali di costo standard deve
produzione.
essere rettificato
con il costo effettivo
Utilizzare quando
tramite i valori di
esiste una disciplina
scostamento
e del personale per
gestire gli standard.
3.5 Valutazione Magazzino Fiscale Rif. Codice
Civile
Le rimanenze di magazzino e la loro valutazione in bilancio
Secondo la classificazione del Codice civile, le rimanenze di
magazzino includono le materie prime, sussidiarie e di
consumo, i prodotti in corso di lavorazione e semilavorati, i
lavori in corso su ordinazione, i prodotti finiti e merci, gli
acconti.
Articoli 2424-2426
150
L’articolo 2424 del Codice, inoltre, classifica le rimanenze nella
macroclasse C) dell’attivo patrimoniale. Il Codice civile si
occupa della valutazione delle suddette rimanenze all’articolo
2426, mentre l’Oic ha elaborato il principio contabile Oic13, che
si occupa di illustrare la valutazione e rappresentazione della
stessa voce contabile
Punto di vista fiscale
Da un punto di vista fiscale, le rimanenze devono essere
raggruppate in categorie omogenee per natura e per valore e a
ciascun gruppo deve essere attribuito il valore che si ottiene
dall’applicazione del metodo adottato in bilancio e, cioè: del
“LIFO a scatti annuale”, del “FIFO” o, in alternativa, del “costo
medio ponderato”.
Se in un esercizio il valore medio dei beni determinato con uno
di questi tre metodi risulta superiore al valore medio di
mercato, tutti i beni potranno essere iscritti in bilancio al valore
normale. La svalutazione al valore normale e’ sempre
facoltativa. La valutazione al valore normale resta efficace
anche per gli esercizi successivi a meno che nel bilancio non
venga ripristinato un valore superiore.
Deroghe e cambiamenti – Art. 2423-bis
Una volta scelto il criterio di valutazione che si vuole adottare,
questo deve essere mantenuto negli esercizi successivi e,
dunque, si potranno cambiare i criteri di valutazione solo se
giustificati da particolari motivi preventivamente comunicati
151
all’agenzia delle Entrate (articolo 2423-bis del Codice civile). Le
deroghe devono essere obbligatoriamente descritte nella nota
integrativa, da cui si deve poter leggere anche l’influenza del
cambiamento
sulla
rappresentazione
della
situazione
patrimoniale e finanziaria del risultato economico.
Vedi questo post sul Magazzino Fiscale per L’Italia
http
s://robertostefanettinavblog.wordpress.com/2016/05/03/gestione-mag
3.6 Parametri di rifornimento
Saranno spiegati i parametri di rifornimento per gli articoli
Sezione TAB NAV > Rifornimento
3.7 Sistema di rifornimento
“Specifica il tipo di ordine di approvvigionamento che viene
creato dal sistema di pianificazione quando è richiesto il
rifornimento dell’articolo. Sono disponibili le seguenti opzioni:
•
Acquisto: fornire l’articolo con un ordine di acquisto.
•
Ordine prod. fornire l’articolo con un ordine di produzione.
•
Assemblaggio:
assemblaggio.
fornire
l’articolo
152
con
un
ordine
di
3.8 Calcolo Lead Time
“Specifica una formula di data per il calcolo del tempo
necessario per il rifornimento dell’articolo. Questa formula
verrà utilizzata per calcolare i campi delle date nelle righe degli
ordini e delle proposte d’ordine.”
I campi delle date nelle righe dell’ordine o della proposta
d’ordine sono calcolati come segue:
Ø In una riga dell’ordine di acquisto, Data ordine + Calcolo lead
time = Data carico pianificato.
Ø In un ordine di assemblaggio, Data inizio + Calcolo lead time
= Data fine.
Ø In una riga dell’ordine di produzione, Data inizio + Calcolo
lead time = Data fine.
NB:
Se un articolo prodotto utilizza un ciclo, tale ciclo verrà
utilizzato per calcolare la data di fine. Il calcolo del lead time
viene utilizzato soltanto nel caso in cui non sia definito un ciclo
per l’articolo.
Priorità di utilizzo
Se il campo Calcolo lead time viene compilato in diverse
finestre, le priorità verranno definite nel modo seguente:
153
1. Scheda del fornitore dell’articolo
2. Scheda unità di stockkeeping
3. Scheda magazzino
4. Scheda articolo
ES:
Se un acquisto viene ordinato il 20 dicembre (Data ordine:
20/12) e il lead time è due giorni (calcolo del lead time: 2D), la
consegna degli articoli acquistati dovrebbe avvenire presso
l’indirizzo di consegna il 22 dicembre (Data carico pianificato:
22/12).
3.9 Politica di produzione
“Determina se vengono calcolati ordini aggiuntivi per tutti i
componenti correlati. Questa impostazione include gli ordini di
produzione, creati manualmente o derivanti da ordini di
vendita, e le proposte d’ordine di produzione generate dai
calcoli di pianificazione.”
Opzioni
Ø Prod. Per Magazzino
154
Ø Prod. Per Ordine
DETTAGLIO
Politica di produzione
Descrizione
Prod. per Magazzino (Make to Considera il primo livello della
Stock)
distinta base (DB) e ogni
ordine di produzione può
contenere un solo articolo.
Un articolo di questo genere
viene prodotto per livelli di
magazzino. Tipicamente si
tratta di articoli standard con
un lead time di produzione
relativamente breve o articoli
che vengono utilizzati come
sotto assemblaggi necessari
per altri articoli.
Questa politica di produzione
in genere viene utilizzata con i
metodi di riordino Qtà riordino
fissa o Qtà massima.
155
Prod. su Ordine (Make to
Order)
La distinta base viene esplosa e
viene creata una riga aggiuntiva
nell’ordine di produzione o nella
proposta d’ordine di produzione
per ogni livello della struttura DB in
cui la politica di produzione di tale
articolo è stata definita come
produzione su ordine. Se si
emettono ordini di produzione
multilivello, la politica di
produzione per l’articolo padre e
per gli articoli componenti a tutti i
livelli deve essere produzione su
ordine.
Viene creato un impegno
automatico tra il fabbisogno e la
proposta d’ordine di rifornimento
corrispondente. In questo modo
vengono mantenute le informazioni
personalizzate sugli ordini rilevanti,
che verranno collegati a scopo di
inventario e costing.
Questa politica di produzione in
genere viene utilizzata con il
metodo di riordino Ordine o
Lotto-per-Lotto.
Nota
Un metodo correlato nella
scheda articolo che implica
l’associazione ordine-a-ordine
è il metodo di riordino Ordine.
156
3.10 Motodo di consuntivazione
“Specifica il metodo che è utilizzato per calcolare e gestire il
consumo dell’articolo come componente dei processi di
produzione.”
Quando le operazioni di produzione sono integrate con i
processi della warehouse, tramite collocazioni oppure
stoccaggi e prelievi guidati, la collocazione da cui i componenti
sono consumati è la collocazione definita in ogni riga del
componente ordine di produzione. Tutti i componenti
obbligatori devono essere disponibili in tale collocazione. In
caso contrario, la registrazione del consumo manuale o
automatico viene interrotta per tale componente.
Per ulteriori informazioni sul modo in cui i metodi di
consuntivazione incidono sul flusso dei componenti nelle
collocazioni di produzione, vedere il campo “Cod.
collocazione” nelle righe del componente dell’ordine di
produzione.
Opzioni
Ø Manuale
Ø Avanti
Ø Indietro
157
Ø Prelievo + avanti
Ø Prelievo + indietro
DETTAGLIO
Opzione
Manuale
Descrizione
Richiede di inserire
manualmente e registrare il
consumo nella registrazione di
consumo.
158
Avanti
Inserisce automaticamente il consumo in base alle righe
nelle righe del componente dell’ordine di produzione.
Per default, la registrazione del consumo di componenti
si verifica quando si modifica lo stato di un ordine di
produzione in Rilasciato. Tuttavia, se si utilizza il campo
Cod. legame ciclo-DB nelle righe del componente
dell’ordine di produzione, le registrazioni si verificano
per operazione quando inizia l’operazione.
Nota
Per la consuntivazione in
avanti, la registrazione
specifica per l’operazione che
è possibile ottenere con i
codici di legame tra ciclo e DB
si basa sulla quantità prevista
definita nella riga del
componente. Per informazioni
sulla consuntivazione
specifica per l’operazione
basata sull’output effettivo,
vedere la descrizione di Aut.
fine in questo argomento.
Se l’ubicazione o le risorse in cui il componente è
consumato sono impostate con una struttura di
collocazione di default, l’articolo viene consumato dalla
collocazione produzione aperta.
Attenzione
La consuntivazione in avanti si
verifica inoltre quando si fa
clic su Aggiorna in un ordine
di produzione rilasciato creato
da zero. In questi ordini di
produzione rilasciati creati
direttamente non è possibile
modificare le informazioni di
collocazione perché le righe
del componente ordine
produzione vengono generate
quando si aggiorna l’ordine,
che esegue
contemporaneamente la
consuntivazione in avanti dei
componenti. Di conseguenza,
se si desidera modificare le
informazioni di collocazione
nelle righe del componente
dell’ordine di produzione
prima della consuntivazione in
avanti, tale ordine dovrà
essere creato con lo stato
Pianificato o Confermato.
159
indietro
Calcola automaticamente e registra il
consumo in base alle righe nelle righe
del componente dell’ordine di
produzione.
Per default, il calcolo e la registrazione
del consumo di componenti si verifica
quando si modifica lo stato di un
ordine di produzione rilasciato in
Completato. Tuttavia, se si utilizza il
campo Cod. legame ciclo-DB nelle
righe del componente dell’ordine di
produzione, il calcolo e la
registrazione si verificano una volta
completata ogni operazione.
Nota
La consuntivazione a ritroso e
i codici di legame tra ciclo e
distinta base possono
combinarsi in modo che la
quantità di cui è stata
effettuata la consuntivazione
per operazione sia
proporzionale all’effettivo
output di tale operazione. Per
ulteriori informazioni, vedere
Procedura: Eseguire la
consuntivazione dei
componenti in base all’output
dell’operazione.
Se l’ubicazione o le risorse in cui il
componente è consumato sono
impostate con una struttura di
collocazione di default, l’articolo viene
consumato dalla collocazione
produzione aperta.
160
Prelievo+Aut.Inizio
Uguale al metodo di
consuntivazione in avanti, con
l’eccezione che funziona solo
per le ubicazioni che utilizzano
stoccaggi e prelievi guidati.
Il consumo viene calcolato e
registrato dalla collocazione
definita nel campo Cod. coll.
art. per produzione
nell’ubicazione o nel centro di
lavoro dopo che il componente
è stato prelevato dalla
warehouse.
Nota
Se un componente è impostato
con il metodo Prelievo +
Consuntivazione in avanti, non
potrà disporre di un codice
legame ciclo-DB per
un’operazione impostata con il
metodo di consuntivazione in
avanti. Il componente viene
quindi consuntivato
automaticamente quando
comincia l’operazione, che
rende impossibile richiedere
l’attività di prelievo.
161
Prelievo+Aut.Fine
Uguale al metodo di
consuntivazione a ritroso, con
l’eccezione che funziona solo
per le ubicazioni che utilizzano
stoccaggi e prelievi guidati.
Il consumo viene calcolato e
registrato dalla collocazione
definita nel campo Cod. coll.
art. per produzione
nell’ubicazione o nel centro di
lavoro dopo che il componente
è stato prelevato dalla
warehouse.
3.11 % Scarto
“Specifica la percentuale dell’articolo che si prevede verrà
scartata nel processo di produzione. Viene utilizzato per
calcolare i prezzi unitari e i fabbisogni netti.”
Se si tratta di un articolo padre, la percentuale di scarto
rappresenta l’output scartato prima dello stoccaggio in
magazzino. Se l’articolo è un componente, la percentuale di
scarto rappresenta il consumo scartato al momento del
prelievo da magazzino.
Se si definisce una percentuale di scarto di un articolo
componente, significa che saranno ritirati dal magazzino più
componenti di quanti siano richiesti dall’ordine di produzione.
162
Nota
Lo scarto definito negli articoli componenti aumenta la
quantità prelevata per il consumo. Non aumenta la quantità di
output prevista dell’articolo padre.
3.12 Dimensione Lotto (di Produzione)
“Specifica quante unità dell’articolo vengono elaborate, per
default, in un’unica operazione di produzione.”
È possibile modificare la dimensione lotto nelle singole righe
del ciclo o nelle singole righe del ciclo ordine di produzione
(operazioni).
La dimensione del lotto modifica il tempo di lavorazione
immesso nelle righe del ciclo moltiplicando il valore nel campo
Tempo lavorazione per la dimensione del lotto per riflettere, ad
esempio, che ci vuole il doppio del tempo per elaborare due
pezzi per operazione.
Nota
Si noti che, benché non sia un elemento temporale produttivo,
anche il valore nel campo Tempo di setup nelle righe del ciclo
di produzione viene moltiplicato per la dimensione del lotto.
Se il ciclo di produzione articolo include costi fissi, ad esempio
il tempo di setup, il valore di questo campo verrà utilizzato per
calcolare il costo standard e distribuire i costi fissi di
produzione dell’articolo.
163
3.13 Parametri generali pianificazione da Setup
Manufacturing
Esistono dei parametri generali di pianificazione da Setup
Manufacturing.
Sotto i principali:
3.14 Quantità di smorzamento di default
Per limitare la quantità di suggerimenti di pianificazione per le
modifiche non significative degli ordini esistenti, utilizzare il
campo Quantità di smorzamento di default, che è una
percentuale della dimensione di lotto.
NOTA: Questa impostazione si applica globalmente, ad
eccezione degli articoli che hanno un valore diverso nel campo
Quantità di smorzamento della scheda articolo.
3.15 Periodo di stabilizzazione di default
Specifica un periodo di tempo durante il quale non deve essere
proposta alcuna azione di ripianificazione in avanti degli ordini
di approvvigionamento esistenti.
Il periodo di stabilizzazione limita il numero di inutili
ripianificazione dell’approvvigionamento esistente a una data
successiva se la nuova data è compresa nel periodo di
stabilizzazione. La funzione del periodo di stabilizzazione viene
avviata
solo
se
l’approvvigionamento
può
essere
164
riprogrammato a una data successiva e non se può essere
riprogrammato in una data anteriore.
Di conseguenza, se la nuova data di approvvigionamento
suggerita è successiva al periodo di stabilizzazione, il
suggerimento di riprogrammazione non è bloccato.
3.16 Assemblaggio
Criteri di Assemblaggio
“Specifica il flusso dell’ordine di default utilizzato per fornire
questo articolo di assemblaggio. Di seguito sono elencate le
opzioni disponibili.”
Opzioni
Ø Assemblaggio per magazzino
Ø Assemblaggio su ordine
DETTAGLIO
Criteri di assemblaggio
Descrizione
165
Assemblaggio per magazzino Gli ordini di assemblaggio per
l’articolo vengono creati come
ordini di approvvigionamento
destinati al magazzino.
Vengono creati manualmente,
come la creazione di kit per
una campagna stagionale,
automaticamente tramite il
sistema di pianificazione per
l’approvvigionamento della
domanda o in base al
rifornimento di magazzino.
Nota
Benché non sia il flusso
dell’ordine di default, è
possibile impostare le
assemblaggio di un articolo
con assemblaggio per
magazzino direttamente a
fronte di un ordine di vendita,
ad esempio come combinare la
quantità con le quantità per
assemblaggio su ordine che
sono già nella riga ordine di
vendita.
166
Assemblaggio su ordine
Gli ordini di assemblaggio per
l’articolo vengono creati in
risposta a una riga di ordine di
vendita e sono collegati in
modo da consentire al gestore
ordini di personalizzare i
componenti e le risorse di
assemblaggio per l’ordine di
vendita.
Nota
Per default, l’ordine di
assemblaggio collegato è stato
creato per l’intera quantità
della riga di vendita perché è
presupposto che tutti gli
articoli debbano essere
assemblati. Tuttavia, è
possibile modificare la
quantità da assemblare, ad
esempio quando si è a
conoscenza che alcuni articoli
sono già disponibili,
diminuendo o aumentando il
valore nel campo Qtà per
assemblaggio su ordine sulla
riga dell’ordine di vendita.
3.17 Parametri di pianificazione
Saranno spiegati i parametri di pianificazione per gli articoli.
167
Sezione TAB Pianificazione
3.18 Metodo di riordino
“Specifica il metodo di riordino. Quando le quantità devono
essere rifornite, il metodo di riordino viene utilizzato per
calcolare la dimensione lotto per periodo di pianificazione
(intervallo di tempo).”
Opzioni
Ø Nessuna
Ø Qtà Riordino fissa
Ø Qtà Massima
Ø Ordine
Ø Lotto per Lotto
DETTAGLIO
Opzione
Descrizione
168
Qtà Riordino Fissa
Qtà Massima
Utilizzare la quantità
specificata nel campo Qtà di
riordino come dimensione del
lotto standard. È possibile che
questa quantità venga
modificata al fine di soddisfare
ulteriori fabbisogni o il livello
di magazzino specificato.
Il campo di Qtà di riordino
viene utilizzato per il calcolo
del livello di overflow.
Utilizzare la quantità
specificata nel campo
Giacenza massima per
determinare la dimensione del
lotto massima. È possibile che
questa quantità venga
modificata al fine di soddisfare
ulteriori fabbisogni o il livello
di magazzino specificato.
Il campo Giacenza massima
viene utilizzato per il calcolo
del livello di overflow.
169
Ordine
Genera un ordine per ogni
fabbisogno e non utilizza il
periodo di pianificazione. Viene
creato un impegno automatico
tra il fabbisogno e la proposta
d’ordine di rifornimento
corrispondente. In questo
modo vengono mantenute le
informazioni personalizzate
sugli ordini rilevanti, che
verranno collegati a scopo di
inventario e costing.
La creazione di un impegno
manuale è un altro metodo per
accantonare articoli in
magazzino e definirli per
l’utilizzo di un ordine specifico.
Nota
Il metodo correlate per gli
articoli di produzione a più
livelli è l’opzione Prod. su
Ordine nel campo di Politica di
produzione.
170
Lotto-per-Lotto
Vuoto
Viene generata una proposta
d’ordine con una quantità in
grado di soddisfare la somma
dei fabbisogni che scadono nel
periodo di pianificazione.
Nota
Utilizzando il punto di riordino
con questa opzione è possibile
creare proposte d’ordine di
rifornimento aggiuntive (in
surplus).
Non calcola le proposte
d’ordine per questo articolo.
Occorrerà pianificare
manualmente l’utilizzo di
questo articolo.
Le quantità finali della proposta d’ordine possono essere
rettificate in base ai seguenti campi che determinano una
modifica dell’ordine:
•
Quantità minima ordine
•
Quantità massima ordine
•
Molteplicità ordine
Nota
171
Si verifica quando si seleziona l’opzione relativa al metodo di
riordino Qtà Massima. Tuttavia, se il campo Giacenza massima
viene utilizzato come espressione restrittiva della capacità di
magazzino massima, i campi che determinano la modifica non
devono essere utilizzati.
Se si passa a un’opzione relativa al metodo di riordino diversa,
è possibile che vengano disattivati i campi di alcuni parametri
di pianificazione che in precedenza erano attivi e contengono
ancora gli ultimi valori utilizzati. I valori verranno ignorati dai
calcoli di pianificazione.
3.19 Pianificazione delle ubicazioni senza utilizzare
USK
Se si utilizza la pianificazione della domanda per un’ubicazione
diversa dal campo Componenti nell’ubicazione e non si
utilizzano unità di stockkeeping, verrà utilizzata l’opzione
relativa al metodo di riordino Lotto-per-lotto con parametri di
pianificazione vuoti. Gli articoli che utilizzano il metodo di
riordino Ordine continuano a utilizzare tale metodo di riordino.
3.20 Politica di tracciabilità
3 tipologie di tracciabilità possibile
Ø Nessuna
Ø Solo Tracciabilità
Ø Tracciabilità e messaggi d’azione
172
“Specifies if and how order tracking entries are created and
maintained between supply and its corresponding demand.”
Select one of the following options.
Option
None
Description
Specifies that neither tracking
entries nor action messages
are created.
Specifies that the system will
create tracking entries for this
item, but will not issue any
action messages.
Specifies that the system will
create and maintain tracking
entries and will also issue
action messages for this item.
Nota
This option is also referred to
as Dynamic Order Tracking.
Tracking Only
Tracking & Action Msg.
3.21 Impegno
3 tipologie di impegno possibile
Ø Mai
Ø Opzionale
Ø Sempre
173
Indica se l’articolo può essere impegnato. Sono disponibili le
seguenti opzioni:
Campo
Mai
Opzionale
Sempre
Descrizione
Non è possibile impegnare
l’articolo.
L’articolo non viene impegnato
automaticamente. È possibile
impegnare l’articolo
manualmente.
L’articolo viene sempre
impegnato automaticamente.
3.22 Periodo di stabilizzazione
Ø Input valore formula es: 7G
Specifica un periodo di tempo durante il quale non deve essere
proposta alcuna azione di ripianificazione in avanti degli ordini
di approvvigionamento esistenti.
Il periodo di stabilizzazione limita il numero di inutili
ripianificazioni dell’approvvigionamento esistente a una data
successiva se la nuova data è compresa nel periodo di
stabilizzazione.
La funzione del periodo di stabilizzazione viene avviata solo se
l’approvvigionamento può essere riprogrammato a una data
successiva e non se può essere riprogrammato in una data
anteriore. Di conseguenza, se la nuova data di
174
approvvigionamento suggerita è successiva al periodo di
stabilizzazione, il suggerimento di riprogrammazione non è
bloccato.
Informazioni aggiuntive
Nota
Se il periodo di accumulo lotti è inferiore periodo di
stabilizzazione, quest’ultimo viene impostato in modo
dinamico affinché corrisponda al periodo di accumulo lotti. Ciò
non è indicato nel valore immesso nel campo Periodo di
stabilizzazione.
La quantità richiesta nel periodo di accumulo lotti viene
utilizzata per determinare se la data di potenziale
approvvigionamento rientra nel periodo di stabilizzazione.
Nota
Se questo campo è vuoto, il viene applicato il valore nel campo
Periodo di stabilizzazione di default nella finestra Setup
manufacturing.
Il valore immesso nel campo Periodo di stabilizzazione deve
essere una formula relativa alla data in cui un giorno (1D)
corrisponde al periodo più breve consentito.
3.23 Qtà di smorzamento (e di Default)
Ø Valore
175
Specifica una quantità di stabilizzazione per bloccare i
suggerimenti di modifica non significativi per un
approvvigionamento esistente se la quantità di cui
l’approvvigionamento cambierebbe è inferiore a quella di
stabilizzazione.
Se la modifica di quantità suggerita è superiore alla quantità di
stabilizzazione, il suggerimento non è bloccato.
Se questo campo risulta vuoto, viene applicato il valore nel
campo Quantità di smorzamento di default nella finestra Setup
manufacturing.
Questa impostazione si applica globalmente, ad eccezione
degli articoli che hanno un valore diverso nel campo Quantità
di smorzamento della scheda articolo.
3.24 Articolo Critico
Ø SI/NO
Nel caso di componente specifica se l’articolo è da includere in
“Disponibilità Calcolata” per proporre una data di consegna
per l’articolo padre. Utilizzato nella procedura di promessa
d’ordine ATP e CTP.
Esempio se una lavorazione richiede un lungo tempo di
lavorazione (per semilavorati), gestire semilavorati di base o
materia prima critica per il padre.
176
3.25 Lead Time Sicurezza
Ø Definisce una formula di data per indicare un lead time di
sicurezza
Definisce una formula di data per indicare un lead time di
sicurezza che può essere utilizzato come margine di tempo in
caso di ritardi nel lead time di rifornimento di produzione, di
assemblaggio o di acquisto.
Ad esempio, se un fornitore consegna spesso in ritardo,
definire un lead time di sicurezza per gli articoli di questo
fornitore in modo che il sistema di pianificazione possa
compensare i ritardi.
Nel calcolo di righe ordine e righe di proposta d’ordine, il lead
time di sicurezza viene aggiunto al lead time per gli ordini
oggetto di programmazione in avanti e indietro.
I seguenti campi delle date vengono influenzati nelle righe
dell’ordine o della proposta d’ordine:
Linee
Riga dell’ordine di produzione
177
Calcolo
Data Fine + Lead time di
sicurezza + Tempo gest.
entrata in whse. = Data
scadenza
Riga ordine di assemblaggio
Data Fine + Lead time di
sicurezza + Tempo gest.
entrata in whse. = Data
scadenza
Riga dell’ordine di acquisto Data carico pianificato + Lead
time di sicurezza + Tempo
gest. entrata in whse. = Data
carico prevista
Nota
Il lead time di sicurezza viene ignorato tra gli articoli in un
ordine di produzione a più livelli.
Per gli ordini di trasferimento, il calcolo del lead time di
sicurezza di un articolo non è incluso direttamente nel calcolo
della data di carico dell’ordine di trasferimento. Il lead time di
sicurezza può tuttavia influire sulla data di carico di un articolo
trasferito, poiché può avere effetto su qualsiasi ordine di
rifornimento in fase di acquisto o di produzione nell’ubicazione
di provenienza prima dell’inizio del trasferimento.
Se nessun valore è specificato nel campo Lead time di
sicurezza, si applica qualsiasi valore definito nel campo Lead
time di sicurezza di default.
3.26 Scorta Sicurezza
Definisce la quantità di scorta che si desidera avere in
magazzino per proteggersi da eventuali fluttuazioni a livello di
domanda e fornitura che possono verificarsi durante il lead
time di rifornimento per l’articolo.
178
Il campo Scorta di sicurezza viene utilizzato nelle modalità
descritte di seguito per i calcoli di pianificazione quando la
disponibilità calcolata è inferiore alla scorta di sicurezza.
•
Viene creata una proposta d’ordine programmata
all’indietro a partire della data di scadenza del fabbisogno
che ha determinato il disavanzo nella disponibilità calcolata.
•
La quantità della proposta d’ordine riporta la disponibilità
calcolata almeno al livello specificato nel campo Scorta di
sicurezza.
Nota
La quantità della proposta d’ordine finale può essere rettificata
per effetto di fabbisogni aggiuntivi che possono verificarsi
all’interno dell’intervallo di tempo, per effetto del metodo di
riordino e dei campi che determinano una modifica della
quantità: Quantità minima ordine, Quantità massima ordine e
Molteplicità ordine.
NB: La quantità di scorte di sicurezza deve essere sempre
inferiore al punto di riordino.
Se il campo viene lasciato vuoto, la quantità della scorta di
sicurezza per l’articolo verrà impostata su zero. Se si immette
un valore negativo nel campo, verrà ignorato.
Sebbene esista una scorta di sicurezza per compensare le
fluttuazioni, il sistema di pianificazione potrebbe utilizzarla per
soddisfare una domanda che non potrebbe essere altrimenti
179
soddisfatta entro la data di scadenza. In tal caso, il sistema di
pianificazione assicura che la scorta di sicurezza sia
reintegrata suggerendo un ordine di approvvigionamento
eccezionale. La riga di pianificazione relativa a tale ordine
visualizza un avviso di eccezione indicante che la scorta di
sicurezza è stata parzialmente o completamente consumata e
deve essere ricostituita.
3.27 Parametri Lotto-Per-Lotto
Includi Giacenze
Ø Includi giacenze (SI/NO)
Include scorte nella disponibilità calcolata quando vengono
calcolati ordini di rifornimento (nettificazione giacenza)
Per default, questo campo è selezionato. Non è possibile
modificare il contenuto del campo. Il magazzino è utilizzato
normalmente per soddisfare i fabbisogni inevasi.
Le seguenti condizioni modificano il comportamento del
campo:
•
Se si specifica un metodo di riordino lotto-per-lotto del
lotto-per- lotto, è possibile modificare il contenuto di questo
campo.
180
•
Se si specifica un metodo di riordino ordine, il campo è
vuoto. Non è possibile modificare il contenuto del campo.
3.28 Periodo accumulo lotti
Ø Definisce un periodo di tempo in cui più domande sono
accumulate in un ordine di approvvigionamento quando si
utilizza il metodo di riordino Lotto-per-Lotto.
Il campo Periodo di accumulo lotti contribuisce a definire il
ciclo di riordino temporale della società nella pianificazione
lotto-per- lotto insieme al campo Periodo di riprogrammazione.
A partire dalla data della prima domanda, tutte le domande
sono accumulate nel successivo periodo di accumulo lotto in
un ordine di approvvigionamento, che viene inserito nella data
della prima domanda. Le domanda esterna al periodo di
accumulo
lotto
non
è
coperta
dall’ordine
di
approvvigionamento.
Il valore immesso nel campo Periodo di accumulo lotti deve
essere una formula relativa alla data in cui un giorno (1D)
corrisponde al periodo più breve.
Nota
181
In tutti i campi di formula di data viene automaticamente
incluso un giorno per coprire la data odierna come giorno di
inizio del periodo. Di conseguenza, se si immette, ad esempio,
1W, il periodo è effettivamente di otto giorni perché la data
odierna è inclusa. Per specificare un periodo di sette giorni
(una settimana) includendo la data di inizio del periodo, è
necessario immettere 6D o 1W-1D.
3.29 Periodo di riprogrammazione
Ø Definisce un periodo in cui qualsiasi suggerimento per
modificare la data di approvvigionamento consiste in un’azione
Riprogramma e mai in un’azione Annulla combinata con
un’azione Nuovo.
Il campo Periodo di riprogrammazione contribuisce a definire il
ciclo di riordino della società nella pianificazione lotto-perlotto insieme al campo Periodo di accumulo lotti.
Il periodo di riprogrammazione totale è un periodo di
riprogrammazione precedente alla data di approvvigionamento
esistente fino a un periodo di riprogrammazione successivo
alla data di approvvigionamento esistente. Se una nuova data
di approvvigionamento suggerita, in avanti o indietro nel
tempo, è all’interno del periodo di riprogrammazione, il
suggerimento viene riprogrammato. Se una nuova data
suggerita all’esterno del periodo di riprogrammazione, il
suggerimento può essere di annullare e creare un nuovo
ordine di approvvigionamento.
182
Il valore immesso nel campo Periodo di riprogrammazione
deve essere una formula relativa alla data in cui un giorno (1D)
corrisponde al periodo più breve consentito.
Nota
In tutti i campi di formula di dati, viene automaticamente
incluso un giorno per coprire la data odierna come giorno di
inizio del periodo. Di conseguenza, se si immette, ad esempio,
1W, il periodo è effettivamente di otto giorni perché la data
odierna è inclusa. Per specificare un periodo di sette giorni
(una settimana) includendo la data di inizio del periodo, è
necessario immettere 6D o 1W-1D.
3.30 Parametri punti di riordino
Parametri punto di riordino
Punto di riordino
Ø Specifica una quantità di scorta in modo da impostare un
livello di magazzino al di sotto del quale è necessario fare
rifornimento dell’articolo. È possibile equiparare la quantità del
punto di riordino con la domanda prevista durante il lead time
di rifornimento.
Il campo Punto Riordino svolge il ruolo descritto di seguito nei
calcoli di pianificazione quando la giacenza disponibile uguale
o minore del punto di riordino.
183
•
Verrà creata una proposta d’ordine programmata in avanti a
partire della data del fabbisogno che ha determinato il
disavanzo nella disponibilità calcolata, a meno che un
ordine di approvvigionamento sia già stato piazzato.
•
La quantità della proposta d’ordine riporterà la disponibilità
calcolata almeno al livello specificato nel campo Punto
riordino.
•
La quantità della proposta d’ordine finale può essere
ulteriormente rettificata per effetto di fabbisogni aggiuntivi
che possono verificarsi all’interno dell’intervallo di tempo,
per effetto del metodo di riordino e dei campi che
determinano una modifica della quantità: Quantità minima
ordine, Quantità massima ordine e Molteplicità ordine.
Nota
Il punto di riordino deve essere sempre superiore alla quantità
di scorte di sicurezza.
Se il campo viene lasciato vuoto, la quantità del punto di
riordino per l’articolo verrà impostata su zero. Si noti che il
campo è disabilitato se si selezionano i criteri di riordino
Ordine e Lotto-per-Lotto.
3.31 Qtà di riordino
Ø Specifica una quantità standard per la dimensione del lotto
da utilizzare per tutte le proposte d’ordine. Tale quantità verrà
utilizzata dal programma al minimo, sebbene è possibile che la
184
quantità dell’ordine finale venga aumentata per soddisfare
fabbisogni aggiuntivi o il livello di giacenza specificato.
Questo campo è utilizzato solamente con il metodo di riordino
Qtà riordino fissa. È disabilitato per tutte le altre opzioni di
metodi di riordino.
Per un risultato ottimale, impostare il campo in modo che il
punto di riordino sia superiore alla scorta di sicurezza e
inferiore alla quantità di riordino.
Il campo di Qtà di riordino ricopre un ruolo nel calcolo del
livello di overflow. Per ulteriori informazioni, vedere Dettagli di
progettazione: Al di sotto del livello di overflow.
3.32 Giacenza massima
Ø Specifica una quantità da utilizzare come livello di
magazzino massimo.
Specifica una quantità da utilizzare come livello di magazzino
massimo.
La giacenza massima al netto della quantità della scorta di
sicurezza viene utilizzata per calcolare le quantità delle
proposte d’ordine.
Nota
185
A seconda della giacenza corrente, è possibile che vengano
generate quantità di proposte d’ordine per effetto delle quali la
disponibilità calcolata può superare la giacenza massima
definita.
Questo campo è utilizzato solamente con il metodo di riordino
Qtà Massima. È disabilitato per tutte le altre opzioni di metodi
di riordino.
Nota
Per un risultato ottimale, impostare il campo in modo che il
punto di riordino sia minore della giacenza massima e
maggiore della scorta di sicurezza.
Il campo di Qtà di riordino ricopre un ruolo nel calcolo del
livello di overflow. Per ulteriori informazioni, vedere Dettagli di
progettazione: Al di sotto del livello di overflow.
3.33 Livello di overflow
Ø Specifica una quantità in base alla quale la giacenza
disponibile può superare il punto di riordino prima che il
sistema suggerisca di ridurre gli ordini di approvvigionamento
esistenti.
Ø Il campo risulta utile se si desidera che il piano di
approvvigionamento rimanga invariato dopo modifiche
secondarie, quali l’annullamento di quantità della domanda
non significative.
186
Il livello del overflow è ignorato se è più basso della quantità di
approvvigionamento suggerita.
Il livello di overflow funziona solo per gli articoli che utilizzano i
metodi di riordino Qtà massima o Qtà Riordino Fissa.
Metodo di riordino
Qtà Massima
Qtà Riordino Fissa
Descrizione
Livello di overflow = Giacenza
massima + (Quantità minima
ordine. + arrotondato alla
molteplicità ordine più vicina)
Livello di overflow = Qtà di
riordino + Punto riordino +
(Quantità minima dell’ordine +
arrotondato alla molteplicità
ordine più vicina)
3.34 Intervallo di tempo
Ø Specifica un periodo di tempo che definisce l’orizzonte di
pianificazione ricorrente dell’articolo quando si utilizzano i
metodi di riordino Qtà Riordino Fissa o Qtà Massima.
L’intervallo di tempo definisce la frequenza di controllo se il
magazzino previsto raggiunge o è inferiore al punto di riordino.
Il sistema di pianificazione utilizza l’intervallo di tempo nei
modi seguenti:
187
•
Per raggruppare i fabbisogni in scadenza nell’intervallo di
tempo.
•
Per ripianificare potenzialmente un ordine di rifornimento in
scadenza nell’intervallo di tempo per soddisfare un
determinato fabbisogno.
•
Per determinare quando il punto di riordinare è stato
superato.
Se il campo viene lasciato vuoto, i fabbisogni che presentano
la stessa data di scadenza verranno raggruppati.
Nota
Il campo non è disponibile se si selezionano i criteri di ordine
o il metodo di riordino Lotto-per-lotto. Ogni domanda viene
quindi gestita separatamente anche se altre domande
condividono la stessa data.
Il valore immesso nel campo Intervallo di tempo deve essere
una formula relativa alla data in cui un giorno (1D) corrisponde
al periodo più breve consentito.
Nota
188
In tutti i campi di formula di dati, viene automaticamente
incluso un giorno per coprire la data odierna come giorno di
inizio del periodo. Di conseguenza, se si immette, ad esempio,
1W, il periodo è effettivamente di otto giorni perché la data
odierna è inclusa. Per specificare un periodo di sette giorni
(una settimana) includendo la data di inizio del periodo, è
necessario immettere 6D o 1W-1D.
3.35 Moltiplicatori ordini (per tipologie “<> Ordine”)
3.36 Qtà minina ordine
Ø Definisce una quantità minima consentita per una proposta
d’ordine.
Utilizzare, ad esempio, se l’articolo è recapitato in un’unità di
trasporto fissa, come un contenitore, che si desidera utilizzare
completamente.
Una volta rilevata l’esigenza di un rifornimento e rettificata la
dimensione del lotto in modo da soddisfare il metodo di
riordino specificato, la quantità verrà aumentata per soddisfare
la quantità minima di ordine definita per l’articolo.
Utilizzare questo campo con una politica di produzione di tipo
produzione per magazzino.
3.37 Qtà massima ordine
189
Ø Specifica una quantità massima consentita per una proposta
d’ordine.
Utilizzare, ad esempio, se l’articolo è recapitato in un’unità di
trasporto fissa, come un contenitore, che si desidera utilizzare
completamente.
Una volta rilevata l’esigenza di un rifornimento e rettificata la
dimensione del lotto in modo da soddisfare il metodo di
riordino specificato, la quantità viene ridotta se è necessario
soddisfare la quantità massima di ordine definita per l’articolo.
Qualora dovessero rimanere fabbisogni aggiuntivi, verranno
calcolati nuovi ordini volti a soddisfarli.
NOTA: questo campo viene in genere utilizzato con una
politica di produzione di tipo “produzione per magazzino”.
3.38 Molteplicità ordine
Ø Definisce un parametro che è utilizzato dal sistema di
pianificazione per modificare la quantità ordine degli ordini di
approvvigionamento pianificati.
Ø La molteplicità ordine è un numero intero che definisce la
quantità in cui verrà arrotondata la quantità ordine. La quantità
ordine modificata è quindi divisibile per la molteplicità ordine.
190
Esempio
•
Molteplicità ordine: 5
•
Quantità ordine iniziale: 17
•
Quantità ordine modificata: 20
La quantità ordine iniziale di 17 viene arrotondata al numero al
più vicino divisibile per 5, ovvero 20.
Il campo di Molteplicità ordine è utilizzato nel calcolo del livello
di overflow.
Nice MSDN Pages Here:
NAV
2016
Operations
Planning
s://msdn.microsoft.com/en-us/library/hh173020(v=nav.90).aspx
NAV
2016
Perform
Master
Planning
s://msdn.microsoft.com/en-us/library/hh173769(v=nav.90).aspx
NAV 2016 Perform Material Requirements Planning
http
s://msdn.microsoft.com/en-us/library/hh173254(v=nav.90).aspx
NAV
2016
How
To
Run
MPS\MRP
http
s://msdn.microsoft.com/en-us/library/hh173804(v=nav.90).aspx
191
h
192
Introducing Microsoft Power BI – Free ebook from SQLBI
June 18, 2016
Introducing Microsoft Power BI is a book that covers the
basics of the tool and, at the same time, shows you what the
main capabilities of Power BI are. The first chapters are similar
to a step-by-step guide to start using the service, but the goal
is also to show you all available features and the business
scenarios covered by them.
This book is targeted to a variety of readers. There are
information workers and people who are totally new to the BI
world. For those readers, the book acts as a simple
introduction to the concepts that are the foundation of BI. Yet,
another target category is that of IT professionals and
database administrators who might need to drive the decisions
of the company in adopting Power BI, because their users are
asking for it. For them, this book acts as both a simple
introduction to the basic concepts, explaining why users are
so interested in Power BI, and as an overview of the
capabilities and tools available in Power BI, so that readers can
make educated choices in adopting it.
Book content:
•
Introducing Power BI
•
Sharing the dashboard
193
•
Understanding data refresh
•
Using Power BI Desktop
•
Getting data from services and content packs
•
Building a data model
•
Improving Power BI reports
•
Using Microsoft Power BI in your company
Download standard PDF http s://aka.ms/IntroPowBI/StndPDF
Mobile PDF release http s://aka.ms/IntroPowBI/MobPDF
Source:
194
HR (Human Resources) module in Dynamics NAV
June 18, 2016
HR (Human Resources) module in Dynamics NAV
Some people have asked me about the HR NAV module, below
some definitions and links.
HR Module’s Topics Details
The Human Resources feature lets you keep detailed records
of your employees.
You can register and maintain employee information, such as
employment contracts, confidential information, qualifications,
and employee contacts.
You can also use Human Resources to register employee
absences, which allows you to analyze registered absences as
necessary.
To start using Human Resources, you must set up employees
and other basic information. You can also associate various
codes to an employee, which allows you to filter information
and view specific employees.
Best Goals of Module
– Candidate profiling (skills matrix)
– Employees confidential information
– Managing employees absences
– Tracking of expensive equipments (assignements of
benefits..etc.)
– Possibile integration with NAV resources (ex: timesheets)
195
– Possibile integration with external payroll system (NAV
addons or Others..)
MSDN, NAV 2016 Human Resources Help Page
http
s://msdn.microsoft.com/en-us/library/hh167801(v=nav.90).aspx
nice PDF here
http://libertygrove.com/wp-content/uploads/2012/02/microsoft-dynam
nice yuoutube videos here
NAV Project Management Module with resources integration
Jobs & Projects
http
s://msdn.microsoft.com/en-us/library/hh172378(v=nav.90).aspx
Best Topics
The Jobs area supports common project management tasks,
such as configuring a job and scheduling a resource, as well
as providing the information needed to manage budgets and
monitor progress.
With the Jobs feature, you can manage long-term projects that
involve the use of man hours, machine hours, inventory items,
and other types of usage that you want to keep track of.
You can track machine and employee hours on the project by
using time sheets. Using the Jobs functionality will provide a
good overview, not only of individual jobs,
196
but also of the allocation of employees, machinery and other
resources being used in all projects. You can also use this
functionality for many types of services and consultancy tasks.
Task with resources
Create, schedule and manage resources
Integrate time sheets with job orders
Resource Planning Topics
http
s://msdn.microsoft.com/en-us/library/hh175161(v=nav.90).aspx
Create and price resources, both persons and machines
Set up time sheets and the approval process.
197
Scaling Professional Scrum with “Visual Studio Team
Services”, Webcast June 27, 2016
June 18, 2016
Scaling Professional
Services” with
Scrum
with
“Visual
Studio
Team
Webcast Date: June 27, 2016, 14:00 EST (18:00 UTC)
“In this interactive webcast, Visual Studio ALM MVP and
Ranger Martin Hinshelwood enlightens us on scaling
professional Scrum with Visual Studio Team Services.”
Tools don’t solve problems, but they can help reduce the
friction of Scaling Professional Scrum. The only way to
successfully scale across multiple teams, maybe in multiple
countries, is to create robust automation and orchestration for
minimising the risks, and time, of manual tasks. Visual Studio
Team Services allows you to create a robust, platform
agnostic, support structure that can start where you are, and
grow as your needs mature. One Scrum Team, One Nexus, or
many…See how it grows…
Source: Scrum Pulse
Webcast
Register
Page:
http
s://attendee.gotowebinar.com/register/5828311402116766723
198
“Microsoft Cloud”, Solutions for empowering business
June 12, 2016
“Microsoft Cloud”, Solutions for empowering business
“When
it
comes
are Paramount.”
to
the
cloud,
trust
and
security
We’re creating technology that becomes essential but invisible,
to help you build something amazing — whether you need
on-demand scalability, technology to connect your people, or
real-time data insights. The Microsoft Cloud is designed to
empower your business, so you can do more and achieve
more.
Source: Microsoft Cloud
199
Monitoring Microsoft Dynamics NAV 2015 Server Using
“Performance Counters”
June 12, 2016
Roberto Stefanetti NAV Blog
Monitoring Microsoft Dynamics NAV 2015 Server Using
“Performance Counters”
Nice page about NAV 2015 performance counters !
“Performance counters” provide information about how well
Microsoft Dynamics NAV Server is operating. By using
monitoring tools such as Windows Performance Monitor and
System Center Operations Manager, you can use the Microsoft
Dynamics NAV performance counters to collect data on
Microsoft Dynamics NAV Server instances, and then use the
data to identify conditions that are affecting performance and
make adjustments.
200
Microsoft Dynamics NAV also provides a Data Collector Set
template that you can use to easily create Data CollectorSets
that contain all the Microsoft Dynamics NAV performance
counters.
Source
MDSN
https://msdn.microsoft.com/en-us/library/dn414713(v=nav.80).aspx
How to: Set up Performance
Performance Monitor
Counters
in
Windows
http
s://msdn.microsoft.com/en-us/library/dn271687(v=nav.80).aspx
Working with “Data Collector” Sets
“A Data Collector Set organizes data collection points, such as
performance counters and event trace data, into a single
collection. Data Collector Sets enable…
View original post 68 altre parole
201
Retrieve Data from .NET Dialog with .NET integration
June 06, 2016
Retrieve Data from .NET Dialog with .NET integration
You can simply retrieve data from .NET Dialogs using NAV
.NET Integration.
Example: Object 50002 Get Value from .NET Input Dialog
On Page Action, declare .NET variables
DotNet
variables
are
System.Windows.Forms class.
linked
to
Open Page
Click on Button
Input Data > insert “TEST”
Retrieve Data from .NET Command Prompt
Source C/AL Code
OBJECT Page 50002 Get Value from .NET Input Dial
{
OBJECT-PROPERTIES
202
standard
{
Date=06/06/16;
Time=10.49.25;
Modified=Yes;
Version List=NAV9;
}
PROPERTIES
{
CaptionML=ENU=Get Value From .NET Input Dialog;
ActionList=ACTIONS
{
{ 1101340000; ;ActionContainer;
CaptionML=ITA=-;
ActionContainerType=NewDocumentItems }
{ 1101340001;1 ;Action ;
Name=Get Value From .NET Dialog Input;
203
Promoted=Yes;
PromotedIsBig=Yes;
PromotedCategory=Process;
OnAction=VAR
PromptInput@1101340000 : DotNet “‘System.Windows.Forms,
Version=2.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089’.System.Windows.Forms.Form”
RUNONCLIENT;
PageBordStyle@1101340001
:
DotNet
“‘System.Windows.Forms, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089’.System.Windows.Forms.Button
RUNONCLIENT;
PageStartPos@1101340002 : DotNet “‘System.Windows.Forms,
Version=2.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089’.System.Windows.Forms.FormS
RUNONCLIENT;
lblInputData@1101340004 : DotNet “‘System.Windows.Forms,
Version=2.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089’.System.Windows.Forms.Label”
RUNONCLIENT;
txInputData@1101340008 : DotNet “‘System.Windows.Forms,
Version=2.0.0.0,
Culture=neutral,
204
PublicKeyToken=b77a5c561934e089’.System.Windows.Forms.TextBo
RUNONCLIENT;
Confirmation@1101340011 : DotNet “‘System.Windows.Forms,
Version=2.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089’.System.Windows.Forms.Button
RUNONCLIENT;
DialogResult@1101340012 : DotNet “‘System.Windows.Forms,
Version=2.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089’.System.Windows.Forms.Dialog
RUNONCLIENT;
BEGIN
//Creating .NET Page
PromptInput := PromptInput.Form();
PromptInput.Width := 500;
PromptInput.Height := 300;
PromptInput.StartPosition := PageStartPos.CenterScreen;
//Creating Controls on Page
lblInputData := lblInputData.Label();
lblInputData.Text(‘Enter DataText:’);
205
lblInputData.Left(70);
lblInputData.Top(70);
PromptInput.Controls.Add(lblInputData);
//Adding Labels and text boxes
txInputData := txInputData.TextBox();
txInputData.Left(200);
txInputData.Top(70);
txInputData.Width(180);
PromptInput.Controls.Add(txInputData);
//Adding Confirmation Button
Confirmation := Confirmation.Button();
Confirmation.Text(‘OK’); //OK
Confirmation.Left(200);
Confirmation.Top(150);
Confirmation.Width(150);
Confirmation.DialogResult := DialogResult.OK;
206
PromptInput.Controls.Add(Confirmation);
PromptInput.AcceptButton := Confirmation;
// Getting data from prompt dialog
IF
(PromptInput.ShowDialog().ToString()
DialogResult.OK.ToString()) THEN
MESSAGE(txInputData.Text);
retrieved from prompt
//TEST
PromptInput.Dispose();
END;
}
}
}
CONTROLS
{
}
CODE
{
207
***
Print
=
message
BEGIN
{
//Retrieve Data from .NET Dialog Input
//with .NET integration
}
END.
}
}
208
SQL Server 2016 is generally available
June 05, 2016
Official News from Microsoft’s Information Platform
Best News
•
A new platform for intelligent applications
•
Benchmark leadership through efficient use of modern
hardware
•
Large performance improvements from prior versions
•
Unmatched security record
•
Unmatched value proposition
•
Gartner Magic Quadrant for Operational DBMS Leader
Datasheet
http://www.microsoft.com/it-it/server-cloud/products/sql-server-2016/
Source:
209
New Youtube Playlist “NAV-lab #MSForum2016”
June 04, 2016
New Youtube Playlist “NAV-lab #MSForum2016”
– #MSForum2016 Playlist
NAV-lab on Youtube
NAVlabDynamics Youtube Channel
http s://www.youtube.com/user/NAVlabDynamics
ALL NAV-lab Videos
http s://www.youtube.com/user/NAVlabDynamics/videos
“Follow” NAV-lab Group
http s://www.youtube.com/user/NAVlabDynamics
210
Cumulative Update 8 for Microsoft Dynamics NAV 2016
has been released
June 04, 2016
Cumulative Update 8 includes all application and platform
hotfixes and regulatory features that have been released for
Microsoft Dynamics NAV 2016.
The cumulative update includes hotfixes that apply to all
countries and hotfixes specific to the following local versions:
•
AU – Australia
•
AT – Austria
•
BE – Belgium
•
CH – Switzerland
•
CZ – Czech Republic
•
DE – Germany
•
DK – Denmark
•
ES – Spain
•
FI – Finland
211
•
FR – France
•
IS – Iceland
•
IT – Italy
•
NA – North America
•
NL – Netherlands
•
NO – Norway
•
NZ – New Zealand
•
RU – Russia
•
SE – Sweden
•
UK – United Kingdom
Where to find Cumulative Update 8
You can download the cumulative update from – Cumulative
Update 8 for Microsoft Dynamics NAV 2016 (Build 46045).
Source: NAV Team Blog Cumulative Update 8 for Microsoft
Dynamics NAV 2016 has been released
212
Welcome to Dynamics NAV and Dynamics C5 App Update
Version 2.2
June 01, 2016
An update to Dynamics NAV and Dynamics C5 for tablet and
phone is now available on the Windows Store and Google Play
with the App Store to follow shortly. If you already have the
Dynamics NAV or Dynamics C5 app installed, this will
automatically be updated to v.2.2 (unless you specifically
selected not to update automatically on your device). This is
what you get with the new update:
New in this version
•
Added support for iPad Pro.
•
Added support for Android 6 “Marshmallow”.
•
Added support for Windows 10 Mobile.
•
Added support for iOS 9.
Bug fixes in this version
•
Fixed issue when switching to and from Tablet Mode when
signing in with AAD.
213
•
Fixed issue where Service URL parameters are lost when
signing in with AAD.
•
Fixed security vulnerabilities on Android.
•
Other minor bug fixes.
Get Dynamics NAV today
Get Dynamics C5 today
Google Play is a trademark of Google Inc. Apple and the Apple
logo are trademarks of Apple Inc., registered in the U.S. and
other countries. App Store is a service mark of Apple Inc.
214
Source: Welcome to Dynamics NAV and Dynamics C5 App
Update Version 2.2
215
NAV 2016 Managing Sending Documents Features
May 30, 2016
NAV 2016 Managing Sending Documents Features
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, also you
can set a default “document sending template” for each
customer.
For this purpose new NAV objects have been introduced.
“Old” NAV 2015 > E-mail Dialog 9700
New Pages NAV 2016
New &Updated Codeunits
.. below some examples of NAV 2016 new possibilities
Document “Sending Profiles”
Ø You can define separate “Sending Profiles”, for example
EMAIL, PDF, EDI, FULL Sending : PRINT+EDF+EMAIL+EDI …
Page Detail Configuration
216
Ø With “Sendig Options” you can define each separate
configuration: PRINTER, EMAIL, ATTACH, DISK, EDI
“How-to” set-up a document sending profile
Field
Code
Description
Default
Description
Specify a code to identify the
document sending profile in
the system.
Describe the document
sending profile.
Specify if the document
sending profile will be used as
the default profile for all
customers.
The Default check box can only
be selected for one Document
Sending Profile record. To
deselect a check box, select
another check box.
217
Printer
Specify if the document is
printed when you choose the
Post and Send button. You can
choose between the following
options:
o No: The document is not
printed.
o Yes (Use Default Settings):
The document is printed
according to the default printer
setup.
o Yes (Prompt for Settings):
The document is printed
according to settings that you
make on the printer setup
dialog.
218
Email
Specify if the document is sent
by e-mail to the customer when
you choose the Post and Send
button. You can choose
between the following options:
o No: An e-mail is not created.
o Yes (Use Default Settings):
The document is attached to an
e-mail to the customer
according to the default
settings for e-mail sending.
o Yes (Prompt for Settings):
The document is attached to an
e-mail according to settings
that you make in the Send
Email window.
In the E-Mail Attachment field,
select the type of file to attach.
219
Disk
Specify if the document is
saved to a file location when
you choose the Post and Send
button. You can choose
between the following options:
o No: No file is saved.
o PDF: The document is saved
as PDF to the location that you
specify.
o Electronic Document: The
document is saved as an
electronic documernt to the
location that you specify.
In the Format field, select the
format of the electronic
document.
220
Electronic Document
Specify if the document is sent
as an electronic document that
the customer can import into
their system when you choose
the Post and Send button.
You can choose between the
following options:
o No: An electronic document
is not created.
Electronic Format
o Through Document
Exchange Service: The
document is sent as an
elekctronic document.
In the Electronic Format field,
select the format of the
electronic document.
Specify
EDI Format
Ø It’s possible to define EDI formats (PEPPOL 2.0 AND 2.1)
“Send a document”
Ø with “Send” Button (in this example on “Posted Sales
Invoice” List page) you can send your documents
Only Mail + PDF export
221
Full MAIL + PDF + EDI Export
Customer’s Default
On Customer Page you can set “Default Profile” for each
customer.
To specify a “sending profile” on a customer card
On the Communication FastTab, in the Document Sending
Profile field, select a profile that you have set up as described
in the previous procedure.
After you can retrieve Customer’s Default Sending Profile
during sending documents process.
222
NAV TechDays 2016, Sessions @02-08-2016
May 30, 2016
NAV TechDays 2016 , 17 & 18 november 2016 , Antwerp
(Belgium)
Sessions
@
02-08-2016
s://www.navtechdays.com/2016/sessions
My Favorite Sessions
-Design Patterns in NAV ‘Madeira’
-Building extensions for NAV
-How to build your solution for PaaS
-Best Practices in developing Microsoft Dynamics NAV 2017
Extensions
223
-Building cool experiences with O365, Outlook, PowerBI and
more
Pre-conference sessions (15-16)
-PowerShell – Black Belt
-C# for C/AL Developers
-Troubleshooting Essentials for SQL Server and Dynamics
NAV
-Power-BI – Advanced
-Extending the Data Exchange Framework
Register Page
http s://www.navtechdays.com/2016/register
Speakers
http s://www.navtechdays.com/2016/speakers
Source: register | NAV TechDays 2016
224
Dynamics NAV 2016 Workflow – YouTube
May 28, 2016
My NAV 2016 Workflow video on Youtube
225
Microsoft Dynamics Youtube Channel
May 27, 2016
Microsoft Dynamics Youtube Channel
http s://www.youtube.com/user/msdyncomm/
NAV
2016
Videos
http
s://www.youtube.com/user/msdyncomm/search?query=nav+2016
Source: Microsoft Dynamics
226
GESTIONE ASSEMBLAGGI IN NAV (SIMPLE “HOW-TO”)
May 25, 2016
GESTIONE ASSEMBLAGGI IN NAV (SIMPLE “HOW-TO”)
ASSEMBLY Vs MANUFACTURING
“assembly, light manufacturing, and kitting”
Nice post from NAV Team blog about these different features
http
s://blogs.msdn.microsoft.com/nav/2012/11/20/assembly-management
FAST & SIMPLE” HOW-TO” IN ITALIAN LANGUAGE
GESTIONE ASSEMBLAGGI IN NAV
In NAV è possibile utilizzare gli ordini di assemblaggio nelle
variazioni dei seguenti tipi di business.
Tipo
Produzione leggera
Descrizione
Spostare o differire le
operazioni leggere da reparti a
warehouse o centri di
distribuzione (Light
Manufacturing)
227
KittingAssembly
Prelevare e imballare articoli
vendibili come kit oppure
creare un assemblaggio di parti
per comporre
ESEMPIO\SCENARIO DI UTILIZZO
ES: utile per i KIT (es: vendita del cesto di frutta, vendita del
pigiama, Tavolo montato dal cliente)
ASSUNZIONI\LIMITAZIONI rispetto a gestione con Ordini di
Produzione (es: Fase di ASSEMBLAGGIO)
Ø Necessita di distinta base di assemblaggio
Ø Non gestisce ordini di produzione
Ø Non gestisce cicli di lavorazione
Ø Non gestisce codici legami
Ø Non gestisce conto lavorazione
Ø Non gestisce trasferimenti
Ø Minor controllo sui costiscostamenti
ORDINE DI
FUNZIONALE
ASSEMBLAGGIO
228
–
SPECIFICA
“Specifica quali e quanti articoli assemblare e quali
componenti (articoli o risorse) rientrano nell’articolo di
assemblaggio.”
Come gli ordini di produzione, gli ordini di assemblaggio sono
ordini interni non destinati a fornitori o clienti e vengono
utilizzati per gestire la creazione di articoli vendibili impostati
come articoli di assemblaggio. Gli ordini di assemblaggio
differiscono da altri tipi di ordine perché prevedono sia
l’output, o rettifica positiva, che il consumo, o rettifica
negativa, in fase di registrazione. A questo proposito, la testata
ordine di assemblaggio si comporta analogamente a una riga
ordine di vendita e le righe ordine di assemblaggio si
comportano in modo analogo alle righe registrazioni consumi.
SETUP ASSEMBLAGGIO
Ø Codificare
assemblaggio
numeratori
offerteordiniordinI
registrati
di
Ø Dimensioni
Ø Magazzino Default per ordini di assemblaggio
ARTICOLO DI ASSEMBLAGGIO
Ø Configurare l’articolo come di assemblaggio (Sistema
rifornimento e Politica di Produzione)
229
DIBA ASSEMBLAGGIO
Ø Configurare la DIBA di Assemblaggio
Ø È possibile inserire Articoli, Risorse, Note
Ø È possibile
Assemblaggio
calcolare
un
COSTO
STANDARD
di
ESPLOSIONE DB
Ø È possibile esplodere i livelli inferiori per articoli componenti
con DIBA
CALCOLO COSTO STANDARD ASSEMBLAGGIO
Ø È possibile utilizzare il calcolo del costo standard di
assemblaggio
COSTO STANDARD CALCOLATO SU ARTICOLO
DETTAGLIO COSTI ASSEMBLAGGIO (esplosione)
REPORT DETTAGLIO DISTTIBUZIONE DEI COSTI
230
ORDINE DI
“ORDER”
VENDITA
–
ASSEMBLAGGIO
AD
Ø In riga ordine inserire un “Articolo di Assemblaggio” es:
ART_ASS (in questo caso di tipo ASSEMBLAGGIO SU
ORDINE)
Ø Dopo aver inserito la qtà (nel caso “Assemblaggio su
Ordine”) > viene lanciato il calcolo della qtà assemblabile
Ø Sistema chiede nel caso di NON disponibilità dei componenti
se dichiarare comunque l’assemblaggio
RIGHE ORDINE
Ø Inserire la QTA’ Assemblaggio su ordine
Ø Cliccando sul campo “qtà per assemblaggio su ordine” è
possibile vedere i componenti della DIBA
STAMPA CONFERMA ORDINE
Ø È possibile stampare anche le righe relative all’assemblaggio
231
STAMPA ISTRUZIONI DI PRELIEVO
Ø Sono inseriti anche i componenti di assemblaggio
ORDINE DI ASSEMBLAGGIO
Ø L’ordine è stato generato in automatico dall’ordine di vendita
PAGINA ORDINE DI ASSEMBLAGGIO
STAMPA ORDINE DI ASSEMBLAGGIO
ANALISI DISPONIBILITA’ ARTICOLO PER LIVELLO
DB
Ø Utile per capire la fattibilità degli assemblaggi
232
REGISTRAZIONE ORDINI DI ASSEMBLAGGIO
Ø Rilascio
Ø Registra
Ø Registra Batch (più ordini assieme)
NB: è possibile registrare assemblaggi sono se NON LEGATI
ad ordine (cioè assemblaggi per magazzino)
SE PROVO CON ASSEMBLAGGIO SU ORDINE:
L’ASSEMBLAGGIO
VIENE
ALL’EVASIONE DELL’ORDINE
REGISTRATO
Ø Al momento dell’evasione dell’ordine (spedizione)
Ø Durante la registrazione da ordine,
Ø Da spedizione warehouse
Ø Da spedizione raggruppata
Ø L’ordine di assemblaggio è stato registrato (in questo caso
con Spedizione Parziale 2/10 > residuo 8)
233
MOVIMENTI CONTABILI ARTICOLI
A fronte di un assemblaggio da Odine I movimenti contabili
articoli generati sono di 3 tipi
Ø Output Assemblaggio > Carico prodotto finito
Ø Consumo per Assemblaggio > Consumo componenti per
produzione del finito
Ø Vendita > Spedizione da ordine – scarico prodotto finito
ORDINI DI ASSEMBLASGGIO REGISTRATI
Ø È possibile vederestampare gli ordini di assemblaggio
registrati
STATISTICHE
REGISTRATO
ORDINE
DI
ASSEMBLAGGIO
ASSEMBLAGGIO A “STOCK”
Ø Nel caso di assemblaggio a stock (per magazzino), l’ordine
viene creato slegato dall’ordine di vendita
234
Ø Viene dichiarata sia la Qta del documenti che la Qtà da
Assemblare
ANNULLAMENTO ASSEMBLAGGIO
Assemblaggi a Stock)
(solo
per
Ø Per gli assemblaggi a Stock è possibile utilizzare la funzione
“Annulla Assemblaggio”
Ø
MOVIMENTI CONTABILI ARTICOLI DI STORNO
Ø 1) Vengono generati movimenti contrari per stornare
assemblaggio e consumo
Ø 2) L’ordine di assemblaggio torna in ordini di assemblaggio
non registrato
PROSPETTO DI PIANIFICAZIONE
ARTICOLI DI ASSEMBLAGGIO)
Ø Prospetto di pianificazione
235
(MPS
PER
Ø Sistema estrae solo lo stock in quanto l’assemblaggio da
ordine è già stato creato
Es calcolo con articoli ART_ASS|ART_ASS_STOCK (da ordine
e da Stock)
RISULTATO DELLA PIANIFICAZIONE
TRACCIABILITA’ ORDINE
Ø Navigando nella tracciabilità sistema fa comuque vedere
l’ordine (ordini) generanti il fabbisogno, nessun legame con gli
ordino però è stato generato.
CREAZIONE ORDINI DI ASSEMBLAGGIO
PROSPETTO PIANIFICAZIONE
DA
Ø Funzione “Esegui Messaggi di Azione”
Ø L’ordine è stato creato dalla pianificazione e se vede in
“Lista Assemblaggi”
236
GESTIONE IMPEGNI PER ASSEMBLAGGIO
Ø È Possibile impegnare sia il prodotto finito che i componenti
utilizzando le procedure standard di NAV
Ø L’impegno può essere fatto manualmente dalle maschere di
assegnazione impegno
Ø Nel caso di Assemblaggio su Ordine l’impegno è automatico
(riserva per Ordine)
ESEMPI DI IMPEGNO
Ø Impegno su Prodotto finito
IMPEGNO AUTOMATICO (O DA RIGA CORRENTE)
SCELTA DA DISPONIBILE DA IMPEGNARE
Ø Impegno su componenti
Da funzione “Riga” > Impegno
Il concetto è lo stesso visto per i prodotti finiti
237
My video here:
On SlideShare
Gestione Assemblaggi in NAV from Roberto Stefanetti
238
Open Pages and Reports with filters using NAV Command
lines
May 23, 2016
You can have directs shortcuts (or hyperlinks in your emails)
to open directly pages & reports passing filters.
Example (page):
–
Base
Command
dynamicsnav://server.local:port/Db/Company/runpage?page=9307
–
Filter
$filter=%27Purchase%20Header%27.%27No.%27%20IS%20%27OF160
– View Mode mode=View
Sample Full Command
dynamicsnav://server.local:port/Db/Company/runpage?page=9307&$
Results
> in this case system runs on NAV Client Page “9307 Order
List” , the page is filtered on purchase Order No.’OF16000933‘
..you can build parametric strings to launch your pages\reports
from command line (like existing features in NAV Approval
Workflow).
239
RDLC Report and Performance in Microsoft Dynamics
NAV 2015 and 2016 | Dynamics NAV Team Blog
May 20, 2016
RDLC Report and Performance in Microsoft Dynamics NAV
2015 and 2016
Great post by Duilio Tacconi !
Source: RDLC Report and Performance in Microsoft Dynamics
NAV 2015 and 2016 | Dynamics NAV Team Blog
240
Scrum with Asana in 7 steps | Jose Barato
May 17, 2016
GREAT POST! SCRUM with ASANA.
In this post, in only seven steps, I will try to show how I use
Scrum with Asana, just by using lists. Here is a short video in
Spanish. When I start a Scrum Project, the first thing I do is to
create
Sorgente: Scrum with Asana in 7 steps | Jose Barato | LinkedIn
241
NAV 2015 Basic Flowsheets for dummies (IT-IT) – TechNet
Articles – TechNet Wiki
May 15, 2016
Technical articles, content and resources for IT Professionals
working in Microsoft technologies
Below some NAV 2015 Basic Flowsheets (ITA) … only simple
and basic mental schema for newbies (and dummies…)
Flowsheets Topics
•
Service
•
CRM NAV
•
Sales & Shipments
•
Purchase & Receiving
•
Manufacturing
Source: NAV 2015 Basic Flowsheets for dummies (IT-IT) –
TechNet Articles – United States (English) – TechNet Wiki
242
OnDemand NAS Codeunits Scheduling
May 12, 2016
OnDemand NAS Codeunits Scheduling
With a little modification of standard NAV “Scheduling Report
Page”, is possible to schedule also codeunits !
You don’t need IT department to schedule you applications
handled by codeunits (ex: interfaces, intercompany entries,
copy company functions etc.), user can schedule codeunits in
his NAS session without use of Process Queue management
console. Some standard codeunits have HideDialog functions
defined, you can use these functions to bypass client input
parameters (es: confirm messages etc.), you are in NOT
GUIALLOWED mode with NAS.
Examples of utilizations:
•
we use OnDemand schedule to launch OnDemand Web
Services synchronizations and multicompanies data
deployments, we won’t use reports to do this, and we need
to handle transactions with great rollback by design
(codeunits).
Example
OnDemand schedule of codeunit “99000853 Calc. Low-level
code”, that require user input confirmation (Confirm)
243
Modifications:
Codeunit 99000853 Calc. Low-level code
OnRun()
// Set Hidedialogs TRUE for NAS execution (NAV Service and
NAS for user sessions)
IF NOT GUIALLOWED THEN
SetHideDialogs(TRUE);
SetHideDialogs(NewHideDialogs : Boolean)
HideDialogs := NewHideDialogs;
//Standard HideDialogs Function
Custom Page 50001 “Schedule a Codeunit” (new page from
“Schedule a Report” Page 682)
Triggers and functions
OnOpenPage()
IF NOT FINDFIRST THEN BEGIN
INIT;
ReportEditable := TRUE;
244
OutPutEditable := TRUE;
Status := Status::”On Hold”;
VALIDATE(“Object
Run”::Codeunit);
Type
to
Run”,”Object
Type
to
INSERT(TRUE);
END ;
Object ID to Run – OnLookup(VAR Text : Text) : Boolean //
Show Codeunits List
IF LookupObjectID(NewObjectID) THEN BEGIN
Text := FORMAT(NewObjectID);
EXIT(TRUE);
END;
EXIT(FALSE);
ScheduleACodeunit(CodeunitId : Integer;RequestPageXml :
Text) : Boolean
ScheduleACodeunit.SetParameters(CodeunitId,RequestPageXml);
EXIT(ScheduleACodeunit.RUNMODAL = ACTION::OK);
245
SetParameters(ReportId : Integer;RequestPageXml : Text)
INIT;
Status := Status::”On Hold”;
VALIDATE(“Object
Run”::Codeunit);
Type
to
Run”,”Object
Type
to
VALIDATE(“Object ID to Run”,ReportId);
INSERT(TRUE);
Example
OnDemand Schedule for codeunit 99000853 “Low Level Code
Calculation”
•
Select codeunit from list
After Selection
•
Validate Codeunit
Insert Scheduling Timing
Check in Process Queue entries
246
•
You can find your OnDemand Schedule
Check NAS Log
•
Completed !
Download Txt Page from here: Page_50001
You are Welcome !
247
Roberto Stefanetti’s Reviews: “Implementing Microsoft
Dynamics NAV – Third Edition”
May 11, 2016
Roberto
Stefanetti’s
Reviews:
“Implementing
Dynamics NAV – Third Edition”, Goodreads
Microsoft
by
Amazon LInk
http
s://www.amazon.it/Implementing-Microsoft-Dynamics-NAV-Third/dp/1
248
‘s review
May 11, 2016
bookshelves: , ,
Read from May 03 to 10, 2016
Implementing Microsoft Dynamics NAV – Third Edition
“Explore the capabilities of Dynamics NAV 2016 and discover
all you need to implement it”Third Published: April 2016,
Actual Author: Alex Chow
My Opinion: “Nice book, for beginners & medium expertise
NAV users”
The book is suitable for those who want to start using NAV
2016, does not require a previous technical\functional
knowledge, even those who are new to the NAV environment
can learn a lot from this book; is a book for everyone.
“What’s New” in NAV 2016
“core” of the book … nice chapter about NAV 2016 new
features: Cue with colors indicator, Rapidstart, OCR Service,
CRM Native integration, Workflow, Deferreals, Approvals,
Posting Preview, Web, Tablet Clients, Universal App.
249
Nice chapter about Powershell cmdlets and upgrade
automation
it is explained how to perform a release upgrade automatically,
good!
..another good chapter about Project Management : difference
about Waterfall & Agile Approach Waterfall & Agile Approach,
use best of them ! , Microsoft Sure Steps > Waterfall & Agile on
Microsoft Vision.
Good chapter about “data migration”
Many methods described: by powershell, rapidstart, excel
templates, xmlports.. a nice section about “going live in middle
of fiscal year” !!
Upgrading Dynamics NAV
Upgrade process checklist … from 3.60 to NAV 2016
“ALL” about NAV Upgrade, reference to Merge Tools (nice tool
also for NAV 2016), Merge tools Section, nice section about
utilization of Merge tools, actually a good merging\versioning
system for NAV Uograde.
NAV 2016 Debugging Section
My favorite section, all aspects of debugging with NAV 2016
are illustrated, for me is the better part of the boook.
Popular reporting options
Good vision about NAV integrations (query, Charts, Web
Services OData , Power Pivot and Power BI, Jet Report
Express)
250
Positive notes
Many topics are covered, from the NAV history to NAV 2016
new features, some new features, however, are only listed.
A lot of arguments about Financials Management, Sales &
Marketing,
Purchase,Warehouse,
Manufacturing,
Jobs,
Resource Planning, Service.
Negative notes\suggestions
The section relating to NAV Administration could be more
substantial,
Workflow is just listed, the notification system is not treated,
are also references to multitenant management and NAV on
Azure DB.
Conclusions
In conclusion i would say that the overview of topics covered
in the book is good for novice\medium expert user who wants
to explore NAV’s world.
Rating: 3.8/5 stars, nice book anyway.
Roberto Stefanetti
you
cand
find
my
review
here:
s://www.goodreads.com/review/show/1633485542
251
http
NAV 2016 TESTING NOTIFICATION SYSTEM
May 11, 2016
Roberto Stefanetti NAV Blog
“Something about NAV 2016 Notification system”
BEST IMPROVEMENTS
•
Approvals: Approval Groups, Auto Delegation, Pool of
approvers, Skipping Sequence
•
Notifications:
Scheduling
•
FULL Integrated Solutions between Workflow & Notification
System
part
of
workflow
system,
notification
… IS NOT A GUIDE!!
You can find ALL detailed information on MSDN:
“How-to” Manage Notifications Templates
http
s://msdn.microsoft.com/en-us/library/hh179441(v=nav.90).aspx
Setting Up Workflow Notifications
252
http
s://msdn.microsoft.com/en-us/library/dn951472(v=nav.90).aspx
Walkthrough: Setting Up and Using a Purchase Approval
Workflow
http
s://msdn.microsoft.com/en-us/library/dd338778(v=nav.90).aspx
NAV 2016 NOTIFICATION MENTAL SCHEMA
NOTIFICATIONS MENU’ ELEMENTS
253
DOCUMENT APPROVAL MENU’ ELEMENTS
ACTIVATE JOBQUEUE TO SEND NOTIFICATIONS
•
For send notifications you need to activate “notification
manager” passing MAILNOTIFY parameter to Job queue (in
this case NAS runs on my NAV Session, not n NAS
Background Session)
254
NOTIFICATIONS SETUP AND SCHEDULING
•
Define “How to” notification system works: assigning
notification template and notification scheduling typology
(ex: Polling, Batch execution)
NOTIFICATIONS TEMPLATES
You can define notifications Delivery Model:…
View original post 43 altre parole
255
256
Cumulative Update 7 for Microsoft Dynamics NAV 2016
has been released | Dynamics NAV Team Blog
May 10, 2016
Cumulative Update 7 includes all application and platform
hotfixes and regulatory features that have been released for
Microsoft Dynamics NAV 2016.
The cumulative update is intended mainly for solutions that are
experiencing the problems described in the Knowledge Base
article linked to below. However, you are advised to always
keep your solution updated with the latest cumulative update.
If you are in doubt about whether this cumulative update
addresses your specific problem, or if you want to confirm
whether any special compatibility, installation, or download
issues are associated with this cumulative update, support
professionals in Customer Support Services are ready to
help you. For more information, see .
The cumulative update includes hotfixes that apply to all
countries and hotfixes specific to the following local versions:
•
AU – Australia
•
AT – Austria
•
BE – Belgium
•
CH – Switzerland
257
•
CZ – Czech Republic
•
DE – Germany
•
DK – Denmark
•
ES – Spain
•
FI – Finland
•
FR – France
•
IS – Iceland
•
IT – Italy
•
NA – North America
•
NL – Netherlands
•
NO – Norway
•
NZ – New Zealand
•
RU – Russia
•
SE – Sweden
•
UK – United Kingdom
258
Where to find Cumulative Update 7
You can download the cumulative update from – Cumulative
Update 7 for Microsoft Dynamics NAV 2016 (Build 45834).
Source: Cumulative Update 7 for Microsoft Dynamics NAV 2016
has been released | Dynamics NAV Team Blog
259
ABOUT NAV 2016 NAS AND REPORTS SCHEDULING
May 10, 2016
ABOUT NAV 2016 NAS AND REPORTS SCHEDULING
A little “how-to” post about NAV NAS Configuration and Report
Scheduling, below some info, links and some screens for
simple configuration.
NAV 2016 NAS
– “NAS services are a middle-tier server component that
executes business logic without a user interface or user
interaction. NAS services in Microsoft Dynamics NAV Server
support applications such as Microsoft Office Outlook
Integration and the NAV Job Queue.
– “NAS” stands for NAV Application Server, which was a
component in earlier versions of Microsoft Dynamics NAV.
NAS services replace the NAS component, and this requires
you to modify any use of server-side COM.”
…nice posts\pages about NAS below:
NAV Help on MSDN Online
“Configuring NAS Services”
http
s://msdn.microsoft.com/en-us/library/dd355183(v=nav.90).aspx
260
About Job Queues
http
s://msdn.microsoft.com/en-us/library/hh879489(v=nav.90).aspx
How to: Set Up Job Queues
http
s://msdn.microsoft.com/en-us/library/hh879053(v=nav.90).aspx
How to: Create Job Queue Categories
http
s://msdn.microsoft.com/en-us/library/hh179528(v=nav.90).aspx
Video: How Do I: Implement the Job Queue Entry Pattern
http s://msdn.microsoft.com/de-de/dynamics/nav/dn864863
“Background Posting and Job Queue in Microsoft Dynamics
NAV 2013” by NAV Team Blog, old but nice post about
background posting.
http://blogs.msdn.com/b/nav/archive/2012/08/31/background-posting…some screens about “NAS CONFIGURATION AND SETUP”
NAS SERVER SETUP
RETRY ATTEMPS PER DAY
261
RUN NAS WITH ADMIN RIGHTS
“Specifies whether NAS services run operations with
administrator rights instead of the rights granted to the
Microsoft Dynamics NAV Server service account.”
•
If you select this setting, NAS services will have full
permissions in Microsoft Dynamics NAV, similar to the
permissions that are granted by the SUPER permission set.
The Microsoft Dynamics NAV Server service account is not
required to be set up as a user in Microsoft Dynamics NAV.
•
If you clear this setting, the Microsoft Dynamics NAV Server
service account must be added as a user in Microsoft
Dynamics NAV and assigned the permissions that are
required to perform the operations.
STARTUP ARGUMENT
“Specifies a string argument that will be used when NAS
services start. The argument typically specifies an application
type, sometimes with additional configuration information.”
Example values: "OSYNCH" , "JOBQUEUE"
STARTUP CODEUNIT
Specifies the codeunit that contains the method that will be
called by the NASStartupMethod setting.
Example values:
262
0 > When NASStartupCodeunit is set to 0, NAS Services do
not start. This is the default value.
1 > When NAS services start, they run the trigger specified by
the NAS Startup Method in codeunit 1
450 > When NAS services start, they run codeunit 450 (Job
Queue – NAS Start Up), and call the method specified by
NASStartupMethod.
STARTUP METHOD
Specifies the method
NASStartupCodeunit.
that
will
be
called
in
the
Example values:
"" > If no start method is specified (null string), the OnRun
trigger is called.
StartNAS > NAS services runs the StartNAS method in the
NAS Startup Codeunit.
NB: NAV Help is incorrect
CODEUNIT\STARTUP METHOD
for
options
STARTUP
Microsoft: “The reason being change in NAV 2016, in the
Codeunit 1 there no NAShandler function anymore, it has
shifted to Codeunit 450. If you still define Codeunit 1, then
there has to be code defined in Codeunit 1, or if you define any
other codeunit then you provide it here as you know this
263
already. This is BUG in the documentation about configuration
parameters, will be fix soon.”
NAV NAS CONFIGURATION
LISTA CATEGORIE CODE PROCESSI
CODE PROCESSI
MOVIMENTI CODA PROCESSI
MOVIMENTI LOG CODA PROCESSI
DEFINE A NAS PROCESS QUEUE : “EX NOTIFICA”
EX: NOTIFICATION ENTRY DISPATCHER CARD
ABOUT REPORT SCHEDULING
•
You can send a report in process scheduling using
“ScheduleProgrammazione” option
Schedule option is available both for RDLC and Word
Layout Reports
EX: LISTA CLIENTI TOP 10
264
REPORTS ELABORATI IN “REPORT ELABORATI”
… to open a report > “Click on link” !
…my old post about NAV 2013 NAS configuration here:
http://blogs.dotnethell.it/dynamicsnav/Configuring-NAS-to-use-Job-Q
265
Comparing Dynamics NAV 2016 and SAP Business One
9.1
May 06, 2016
….nice post about NAV 2016 Vs SAP Bone 9.1 comparision.
“We have completed a comparison of Microsoft NAV with SAP
Business One, the comparison is based on public information
sourced between Nov 2015 and Jan 2016.”
Source: “Comparing NAV and SAP Bone”
http://www.advantage.co.uk/blog/dynamics-nav-2016-sap-business-o
266
“Gestione magazzino fiscale”, NAV Italian Localization
May 03, 2016
“Gestione magazzino fiscale”, NAV Italian Localization
In questo post sono fornite informazioni tecniche sui concetti e
sui principi utilizzati nelle funzionalità di magazzino fiscale
presente nella localizzazione italiana di NAV.
Il costing di magazzino, detto anche gestione costing riguarda
la registrazione e il reporting dei costi operativi business.
Valutazione magazzino fiscale (tipologia di costi gestibili)
“È necessario inviare un report annuale che mostra il valore
monetario degli articoli di magazzino per l’anno fiscale. In base
alle normative italiane per la valutazione fiscale di magazzino”,
è possibile calcolare le seguenti tipologie di costi:
· Costo medio annuale
· Costo medio ponderato
· Costo FIFO
· Costo LIFO
· Costo LIFO discreto
267
PROCESSI NAV MAGAZZINO FISCALE – MAPPA MENTALE
BASIC RS
MENU’ VALUTAZIONE MAGAZZINO FISCALE
SETUP MAGAZZINO
Setup della modalità e del periodo di aggiornamento costi
tramite registrazioni di aggiustamenti magazzino. In questo
esempio aggiornamento automatico dei costi al posting dei
documenti (SEMPRE) e gestione del costo medio giornaliero
per articolovariantemagazzino (giornaliero in questo caso)
CAMPO UBICAZIONE OBBLIGATORIA
Specifica se gli articoli devono avere un codice ubicazione per
essere registrati (soluzione consigliata). Inserire un segno di
spunta nel campo se si desidera che venga richiesta
l’immissione di un codice di ubicazione durante la
registrazione di transazioni relative agli articoli.
SETUP COSTING ARTICOLO
PERIODI DI MAGAZZINO
268
Specifica un periodo di tempo durante il quale è possibile
registrare modifiche ai valori di magazzino. Un periodo di
magazzino è definito dalla data in cui termina, ovvero la data di
fine. Quando si chiude un periodo di magazzino, non è
possibile registrare modifiche al valore di magazzino, previsto
o fatturato, né registrare nuovi valori nel magazzino precedenti
alla data di fine. Se nel periodo chiuso sono presenti
movimenti articoli aperti, ovvero quantità positive non ancora
consumate da, o collegate a, transazioni in uscita, è ancora
possibile collegare quantità in uscita a questi movimenti,
anche se il periodo è chiuso.
COSTO PRIMA DELL’INIZIO (BEFORE NAV COSTING)
Specifica le informazioni sui costi articolo presenti prima che
l’utente abbia iniziato a utilizzare Microsoft Dynamics NAV
nella propria organizzazione. Queste informazioni sono
necessarie per la valutazione di magazzino nel primo anno
dopo l’implementazione di Microsoft Dynamics NAV.
È possibile utilizzare questa tabella per immettere le
informazioni relative agli articoli di magazzino, ad esempio i
costi dei componenti, dei cicli di produzione e quelli generali.
NBA: Saranno usati dal report di valutazione magazzino (costi
di startup magazzino in NAV). I Valori sono globali (NON
distinti per singolo magazzino)
269
PERIODI CONTEGGIO INVENTARIO FISICO
Calcola la periodicità dell’inventario fisico
CALCOLO VALORE MAGAZZINO WIP (da Produzione)
Calcola il valore WIP della produzione utilizzando gli ordini di
produzione filtrabili per tipologiaperiodo analisi.
Calcola costi fine anno
In provvisorio è lanciabile per piu periodi e per più volte,
calcola il valore di magazzino; se lanciata in definitiva CHIUDE
l’anno fiscale di magazzino.
RISULTATO à CARICAMENTO TABELLA “STORICO COSTI
ARTICOLI”
Ogni volta che si calcola il magazzino viene alimentata la
tabella del costo storico
270
Se lancio in definitivo del calcolo
È sempre da lanciare a fine anno fiscale di magazzino es:
lancio al “31/12/15” (per chiudere l’anno 2015);
Se si lancia parziale segnala l’errore.
CHIUSURA PERIODO MAGAZZINO
Prima di chiudere occorre eseguire questa serie di attività:
1) Lanciare aggiornamento costi NAV (“Adjust Cost Entries”
report)
2) Stampare il “report di test”
Esempio di esito del report di test
271
3) Lanciare il “Chiudi Periodo”
PERIODI DI MAGAZZINO CHIUSI
Flag indica la chiusura del periodo
MOVIMENTI PERIODI MAGAZZINO
Movimenti relativi al periodo di magazzino
RIAPERTURA PERIODO CHIUSO
E’ possibile riaprire un periodo se necessario per sistemare
costigiacenze errate.
REGISTRI DI MAGAZZINO
Storico movimenti di magazzino (scritture raggruppate per
blocco data posting)
Storia delle transazioni con operatoredata
272
RISULTATO FINALE PROCEDURA à REPORT VALUTAZIONE
“MAGAZZINO FISCALE”
Si appoggia alle tabelle sopra se compilate per dare un “costo
certo” archiviato in dati storici.
OPZIONI STAMPA (tutte le tipologie)
STAMPA VALUTAZIONE
CALCOLATO”
MAG.
AL
“COSTO
FISCALE
“la data di competenza serve per recuperare il costo
fiscale calcolato e registrato nella tabella Storico costo
articolo, il filtro data è richiesto per calcolare la giacenza
del periodo richiesto”. Se non viene indicato il filtro
data il report restituisce un messaggio di errore tecnico
al lancio dello stesso.
NB: dato che non è ben documentata la gestione dei filtri
di lancio del report (e lo scopo\modo di utilizzo degli
stessi) è stata suggerita una modifica all’ help italiano di
NAV che dovrebbe, a detta di Microsoft, essere
modificato a breve.
RISULTATO DEL REPORT
Article is also available on TECHNET WIKI
http
s://social.technet.microsoft.com/wiki/contents/articles/36541.dynamic
273
274
25 Best Dynamics NAV Blogs of 2016 – My blog is in the
list !
May 03, 2016
Great Win ! My blog in TOP 25 NAV Sites of 2016 !
“We are proud to present you our annual list of the top
Dynamics NAV websites for 2016. Congratulations to the blogs
that made it and continue to support this business solution.
Microsoft Dynamics NAV has come a long way recently and
only continues to see further development from its
predecessor Navision. From the launch of NAV in 2006, to the
latest and greatest version Dynamics NAV 2016, this product’s
ever expanding versions just keep on getting better. ”
Source:
http
s://www.dynamics101.com/top-25-dynamics-nav-blogs-2016/
Top 25 Dynamics NAV Websites
Last Updated May 2nd, 2016
.. you are Welcome !!!
09-05-2016 Novita’
Intervista a Roberto Stefanetti: Miglior Blogger
Dynamics NAV!
275
My iterview on SEDP Site
http://www.soluzioniedp.it/articolo/novita/intervista-a-roberto-stefane
276
PRODUCTION ORDERS IN NAV
May 01, 2016
PRODUCTION ORDERS IN NAV
…a short guide about NAV Production Orders, based on MSDN
Online NAV help.
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.”
http s://en.wikipedia.org/wiki/Production_order
NAV PERSPECTIVE: “Production orders are the central
components of the Microsoft Dynamics NAV’s manufacturing
functionality. Production orders can be used to capture cost.
However, there are other ways to capture costs, it depends
upon business requirements.”
277
NAV PRODUCTION ORDERS FEATURES
Production orders contain the following information:
■■-Products planned for manufacturing
■■-Materials required for the planned production orders
■■-Products that have just been manufactured
■■-Materials that have already been selected
■■-Products that have been manufactured in the past
■■-Materials that were used in previous manufacturing
Production orders are the starting point for:
■■-Planning future manufacturing
■■-Controlling current manufacturing
■■-Tracking of finished manufacturing
Production orders go through five different statuses:
■■-Simulated
■■-Planned
■■-Firm Planned
■■-Released
■■-Finished
NB: is not possible to change the status of a production order
manually.
PRODUCTION ORDERS TYPES
Simulated Production Order – SPO
The Simulated Production Order (SPO) is unique based on the
following characteristics:
■■-It is not real.
■■-It does not influence order planning.
278
“As its name implies, it is not real and the main purpose is for
quoting and costing,”
SPO does not influence the planning of orders. Planning (MPS
and MRP, discussed in other chapters) neither considers nor is
affected by simulated production orders. Also, a simulated
production order cannot be used as a template because it
disappears when its status changes.
Planned Production Order – PPO
The Planned Production Order (PPO) has the following
characteristics:
■■-PPOs affect capacity requirements.
■■-PPOs serve as good workload estimates.
■■-PPOs need careful planning.
PPOs are similar to released production orders and provide
input to capacity
requirements planning by showing the total capacity
requirements by work center or machine center.
A PPO represents the best estimate of the future work center
or machine center load based on available information.
Typically, they are generated from planning, but can also be
created manually. Because they are erased during subsequent
planning generations, manual creation is not practical.
The PPO generation in planning results in a suggested
“planned order release” that includes quantity, release date,
and due date. The planning system logic is based on the
replenishment system, reorder policies, and order modifiers
that it encounters in the net requirements planning process.
279
Firm Planned Production Order – FPPO
The Firm Planned Production Order (FPPO) has the following
characteristics:
■■-FPPOs can be manually changed.
■■-FPPOs are placeholders.
■■-FPPOs are created from planning, manual creation, or
sales orders.
■■-FPPO creation results in a planned order release.
Planning cannot change an FPPO, but the Production Planner
can make changes manually to the production order. The
Production Planner can automatically create an FPPO from a
sales order.
An FPPO acts as a placeholder in the planning schedule for
some future job released to the floor.
An FPPO can be generated from planning or created manually
or from sales orders. They are not erased during subsequent
planning.
An FPPOs generation in planning results in a suggested
planned order release that includes quantity, release date, and
due date. The planning system logic is based on the
replenishment system, reorder policies, and order modifiers
that it encounters in the net requirements planning process.
To view an FPPOs impact in Microsoft Dynamics NAV 2009,
look at the load for each work center or machine center on the
firm planned production order’s routing.
Released Production Order – RPO
The Released Production Order (RPO) has the following
280
characteristics:
■■-RPOs do not indicate product removal.
■■-RPOs are not always created immediately after a sales
order.
■■-RPOs can record material consumption from a product
output.
“When a production order has been released, it does not
necessarily mean that materials have been picked or the job
has physically moved to its first operation.”
In an MTO (Make-to-Order) environment, it is not unusual to
create a released production order immediately after the entry
of the sales order.
Actual material consumption and product output can be
recorded manually with an RPO. In addition, automatic flushing
of consumption and product output only occurs for RPOs.
Finished Production Order – FPO
The Finished Production Order (FPO) has the following
characteristics:
■■FPOs are terminal. An FPO is an order that, for some
reason, has been terminated. Usually, the order has already
been manufactured.
■■FPOs can track back to other orders. FPOs are used for
statistical reporting and to maintain the ability to track back to
other orders (for example, sales, production, and purchase).
■■FPOs can never be changed. The ability to track back to a
finished production order allows you to review the detailed
history.
281
NB:Finished Production Orders cannot be posted to or deleted.
The status of a production order is changed to Finished to
maintain historical information and to complete accounting
and/or automatic flushing entries.
Production order: Source Types
Note that the Source Type for this order is Item. Three Source
Types are available for a production order:
■■-Item
■■-Family
■■-Sales Header
Item – An item production order is wanted when one
production order for each individual line of a sales order is
appropriate.
Family – A Family production order is needed when a group of
items always needs to be manufactured together.
Sales header – A sales header production order is appropriate
when you want to produce all items of a sales order from one
production order. This is useful in a large project environment
where there is a relatively long manufacturing leadtime.
Scheduling\Rescheduling a production order
–Backward scheduling begins from the ending date and
proceeds backward to the required starting date.
–Forward scheduling begins at the starting date and proceeds
forward to the finishing date.
282
“The program automatically schedules the order to be
completed one day before the due date.”
PRODUCTION SCHEDULING PROCESS FLOW
283
“Microsoft Flow” Preview
April 29, 2016
“Work less, do more with Microsoft Flow”
Create automated workflows between your favorite apps and
services to get notifications, synchronize files, collect data,
and more.
Automate tasks by integrating your favorite apps with
Microsoft Flow. Make repetitive tasks easy with workflow
automation.
…you are welcome !
Source http s://flow.microsoft.com/en-us/
284
Le soluzioni che abbiamo presentato al MSFORUM2016
April 28, 2016
Scopri le soluzioni che con il Consorzio NAV-lab abbiamo
presentato al #MSFORUM2016. TempoZero per Microsoft
Dynamics NAV 2016 e IEM Industrial Equipment Manufacturing,
soluzioni che aiutano le aziende…
Tempo Zero 2016
http://www.soluzioniedp.it/file/tempo-zero-defpptx/bd6d3106ba83448a
IEM Industrial Equipment Manufacturing
http://www.soluzioniedp.it/admin/public/articolo/abd875e9063acf13eb
Sorgente: Le
MSFORUM2016
soluzioni
che
285
abbiamo
presentato
al
Italy Local Functionality – NAV 2016
April 22, 2016
…some people have asked me about the “Italian localization of
NAV”, the features are explained in the help of NAV on MSDN
online.
“The following topics describe the local functionality in the
Italian version of Microsoft Dynamics NAV 2016.”
Page
Source:
NAV
on
MSDN
Online
s://msdn.microsoft.com/en-us/library/hh937837(v=nav.90).aspx
Below the sections with directs links:
See Also
Objects\Batch Detsils
http
s://msdn.microsoft.com/en-us/library/hh929872(v=nav.90).aspx
Example of functionalities, two links:
“Fiscal
Inventory
Valuation”
>
http
s://msdn.microsoft.com/en-us/library/hh937828(v=nav.90).aspx
“Italian
VAT”
>
http
s://msdn.microsoft.com/en-us/library/hh937826(v=nav.90).aspx
286
287
Microsoft Forum 2016
April 19, 2016
#MSForum2016, la prima volta di Microsoft
Un evento senza precedenti, oltre 2000 persone
hanno affollato il Mi.Co di Milano in occasione della
prima edizione del Forum firmato Microsoft.
http://www.microsoftforum.it
ALL Videos on Channel 9
http
s://channel9.msdn.com/Events/Microsoft-Forum/Microsoft-Forum-201
“Twitter Timeline” #MSForum2016
http
s://storify.com/MarcoLorux/msforum2016-la-prima-volta-di-microsoft?
… some pictures !!!..
Twitter Timeline
288
New Book – “Implementing Dynamics NAV 2016” – by
Alex Chow
April 15, 2016
Source: New Book – Implementing Dynamics NAV 2016 –
Confessions of a Dynamics NAV Consultant
Packtpub.com link
http
s://www.packtpub.com/big-data-and-business-intelligence/implement
289
How to limit multisessions logins in NAV (from NAV 4 to
NAV 2009 R2 Classic)
April 07, 2016
How to limit multisessions logins in NAV (from NAV 4 to NAV
2009 R2 Classic)
OnCompanyOpen_Trigger
Variables
Name DataType Subtype
recUser Record User
recSessions Record Session
CanLogin Boolean
//MultiLogin Check
IF recUser.GET(UPPERCASE(USERID)) THEN
BEGIN
recSessions.SETRANGE(“User ID”, UPPERCASE(USERID)) ;
//utente connesso
recSessions.SETRANGE(“Application
Name”,’Microsoft
Dynamics NAV Classic client’);
//controllo solo per classic
client
recSessions.SETRANGE(“Login Type”, recSessions.”Login
Type”::Database); //solo per utenti DB
IF recSessions.COUNT > 1 THEN
IF recUser.MultiLogin = FALSE THEN //se NO multilogin esce
BEGIN
290
//MESSAGE(‘Utente sta usando già 1 Licenza NAV, MultiLogin
NON Permesso per questo utente’);
CloseDB; //Chiude le session NAV con WSHELL Automation
END;
END;
Function CloseDB()
// Using WShell Automation
Variables
Name DataType Subtype Length
WSHell
Automation
‘Windows
Model’.WshShell
Script
CREATE(WSHell);
WSHell.Popup(‘Utente sta usando già 1 Licenza
MultiLogin NON Permesso per questo utente’);
WSHell.SendKeys(‘%{F4}’);
CLEAR(WSHell);
End Function
291
Host
NAV,
Ob
Project Madeira “IS ON” – try public preview !
April 05, 2016
http
s://lnkd.in/ejtwSYH
s://madeira.microsoft.com/en-us/
Business solution reinvented
“Microsoft is reinventing business productivity with Project
“Madeira.” Start the preview to see how easy it is to connect
business processes with familiar Microsoft productivity tools
to grow sales, manage finances, and streamline your
operations—in the office, or on the go.”
Run your business within Office 365
“Project “Madeira” offers an embedded experience within
Office 365 so you can create customers, vendors, quotes, and
invoices without leaving Outlook. Export data to Excel for
analyzing and create your outgoing documents in Word.”
Today we are proud to announce the public preview of code
name a completely reinvented business management solution
for small and midsize businesses (SMBs).
“Project Madeira” will be available in public preview over the
next several months as we collect feedback and fine-tune the
user experience. The “Project Madeira” team is looking forward
to hearing from you! Sign up in seconds now, and use the
292
feedback forums to let us know what you think.
http
s://community.dynamics.com/b/msftdynamicsblog/archive/2016/04/12
Let us know what you think of Project Madeira
Microsoft Project ‘Madeira’ – General Feedback
http
s://ideas.projectmadeira.com/forums/350115-microsoft-project-madei
Project Madeira “APP” Preview
“….Manage your sales, finances, billing, purchasing, and
inventory — all without leaving Outlook”! … great !
“Microsoft is on a mission to reinvent productivity with a
comprehensive business management solution that works
right within Office 365. Start your preview of Project “Madeira”
to see how easy it is to manage your sales, finances, billing,
purchasing, and inventory — all without leaving Outlook. This
Project “Madeira” for Windows app extends the experience to
your mobile and touch-enabled devices for productivity on the
go.”
Try Madeira @ .. http s://madeira.microsoft.com
293
Cumulative Update 6 for Microsoft Dynamics NAV 2016
has been released | Dynamics NAV Team Blog
April 04, 2016
Source: Cumulative Update 6 for Microsoft Dynamics NAV 2016
has been released | Dynamics NAV Team Blog
294
Microsoft SQL Server Developer Edition is now free | SQL
Server Blog
April 01, 2016
Official News from Microsoft’s Information Platform
Source: Microsoft SQL Server Developer Edition is now free |
SQL Server Blog
295