Portable Kanban and Kanban for Outlook Addins

What is Kanban? Is it possible to use it for personal task management? … Sure !

Kanban Board:

Definition here: http://guide.agilealliance.org/guide/kanban.html#sthash.ipfukUPU.dpuf

Source: http://guide.agilealliance.org/guide/kanban.html

Nice book about Kanban: “Agile Project Management with Kanban (Developer Best Practices) 1st Edition” http://www.amazon.com/Project-Management-Kanban-Developer-Practices/dp/0735698953/

Nice Blog here: http://kanbanblog.com/explained/


Below some Applications and Outlook Addins to simulate “Kanban Boards” for personal planning, tracking & control; for teams management the better solution is Always an “Agile Integrated Online Solution” ex: “Kanbantools, Asana, Visual Studio Online and Others good solutions…)

“Portable Kanban” … a great tool by Dmitry Ivanov, free to use.

Visit the post for more:  Dmitry Ivanov

Direct Download link: https://drive.google.com/uc?export=download&id=0BwUfh6wcVgWKVHRDLWtKZy1HUGc

“Kanban for Outlook Addin (2013, 365) from Microsoft”

kanban oilook

Kanban Board is a visualizing tool for the Outlook, which splits tasks upon their status.”

.. a nice kanban addin for Outlook.

Direct Download link: https://store.office.com/kanban-for-outlook-WA104354490.aspx?assetid=WA104354490

my Best Choice !!!   “Kanban Task Manager for Outlook 2″

kanban ADDIN

kanbva 3

kanba excel

.. a great kanban addin for Outlook !! .. the best choice!

Direct Download link:  http://kanban-task-manager-for-outlook.windows10compatible.com/download

Kanban in Visual Studio Online e in Team Foundation Server


kanban animated

..another nice free solution is “personal kanban-with-google-spreadsheet”


Direct Download link: http://www.jellybend.com/2013/01/02/personal-kanban-with-google-spreadsheet-and-google-apps-script/

…the last tool.. “my-personal-kanban”… a great free tool with nice cloud support..  : “My Personal Kanban”

My Personal kanban: “This is a one page HTML/JavaScript application for people who would like to use simple and basic Kanban board for their personal stuff”

Direct Download link: http://greggigon.github.io/my-personal-kanban/

..you are welcome !



Roberto Stefanetti NAV Blog


A simple post about NAV 2015 Tracking Technology, based on MSDN NAV Online Help.


NAV 2015 Active Sessions Table

“Active Session”  Table

Specifies sessions that are currently active and are connected to a Microsoft Dynamics NAV Server instance. An active session can be in use or idle.

This table can contain sessions that are not active, before those are removed from the table. For example, if a Microsoft Dynamics NAV Server instance stops responding, then the table can contain sessions that are not active. When the Microsoft Dynamics NAV Server instance restarts, it deletes from the table the sessions that are not active. If the Microsoft Dynamics NAV Server instance never restarts, then other the Microsoft Dynamics NAV Server instances delete the sessions that are not active.”


Field Location
Session ID Field…

View original post 413 altre parole

Power BI Windows 10 universal app for desktops, tablets, and smartphones now available

Power BI is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of live data through easy-to-use dashboards, provides interactive reports, and delivers compelling visualizations that bring data to life. Power BI Desktop is a powerful new visual data exploration and interactive reporting tool. It provides a free-form canvas for drag-and-drop exploration of your data and an extensive library of interactive visualizations, while streamlining report creation and publishing to the Power BI service.

Native Windows 10 experience

The Power BI universal app is designed from the ground up to run on Windows 10 using the capabilities you already know and love, such as pressing and holding on your dashboard index to open the context menu, or gaining quick access to a dashboard simply by pinning it to your device home screen as a tile.

Continuum mode adapts to your display

The new Windows 10 continuum mode for phones brings a whole new experience to the Power BI app. When you connect your phone to a display dock, Power BI will adjust the presentation to best fit your screen size and resolution. This means you can take your data with you on the goand  seamlessly share it during a meeting without the need for a larger computer.

Get started with Power BI Universal app for Windows 10 mobile

Source: http://blogs.msdn.com/b/powerbi/archive/2016/01/26/power-bi-windows-10-universal-app-for-desktops_2c00_-tablets_2c00_-and-smartphones-now-available.aspx

Video: https://www.youtube.com/watch?v=K01B4MEV7e8&feature=player_embedded

Progress Indicator vs window

..nice old “but actual” post about NAV progress indicator !


Progress indicator based on Item DataItem
Create a report with Item as the dataitem.  
Put the code below in the prescribed triggers. 
Define the variables, Run the report  
The TotalCount will adjust per the filters you enter on the report so the 
progression bar is always on time.

Name         DataType
Window       Dialog  
TotalCount   Integer  
Counter      Integer  
Item - OnPreDataItem()
  Window.OPEN('Processing: @1@@@@@@@@@@@@@@@');
  TotalCount := COUNT;
Item - OnAfterGetRecord()
  Counter := Counter + 1;
  Window.UPDATE(1,ROUND(Counter / TotalCount * 10000, 1));
Item - OnPostDataItem()

How-to use Dialog Box with Progress Indicator
Try using a dialog box, but instead of using (ex. '#1######') you use 
(ex. @1@@@@@@@@@@@@@). The "@" sign signifies that you want to use 
progress bar indicator.

Source http://groups.yahoo.com/group/Navision-Knowledge-Village/

Sharing the knowledge on Navision > Visit www.frappr.com/navision for navison friends 

based on this question :
"When running a long processing report, I usually open a window & 
update it with the entry no I am processing. Instead of using this, is 
there a function that can create a progress indicator type bar instead 
with a % done (for example, like the one you see when importing a file)?"

Free ebook: “Enterprise Cloud Strategy” – Microsoft Press – MSDN Blogs

MICROSOFT PRESS publishes on Microsoft tools & technologies, plus programming best practices. Our blog offers book info, links to ebooks, & other good stuff. Enjoy!

Source: Free ebook: Enterprise Cloud Strategy – Microsoft Press – Site Home – MSDN Blogs

Eventing and Extensions in Dynamics NAV 2016, Webinar, Thu. Jan 28

NAV 2016 Webinar: “Eventing and Extensions in Dynamics NAV 2016”

Thu, Jan 28, 2016 4:00 PM – 5:00 PM CET

“These webinars will be hosted by NAV MVPs who are experienced in the subject. Over 100 NAV professionals registered for the first session, presented by Mark Brummel on December 10, 2015”

Webinar Details http://libertygrove.com/microsoft-dynamics-nav/webinar-extensions-eventing-dynamics-nav-2016-2/


old session video

NAV 2016 Webinar: “Eventing and Extensions in Dynamics NAV 2016”

Sending SMS from NAV

Sending SMS from NAV
two useful links about sending SMS from NAV.
Sending SMS from Dynamics NAV with 5 lines of code (Windows Mobile Automation)

What you need: Outlook 2010, Exchange 2010, NAV (any version supporting automations…), Mobile phone with Windows Mobile 6.1 (with some update) or 6.5 http://dynamicsuser.net/blogs/kine/archive/2011/01/18/sending-sms-from-dynamics-nav-with-5-lines-of-code.aspx

Using Web Service to send SMS from NAV  (Web Services)
method to send SMS notification through the Webservice using service provider interface protocols.

Some SQL date calculation scripts for NAV Linked Tables

Some SQL date calculation scripts for NAV Linked Tables

sql date

Dato che alcuni utilizzano le viste SQL come tabelle collegate in NAV, riporto alcuni script SQL relativi all’utilizzo delle date; inserendo un campo virtuale in una vista SQL e richiamando una “function” esistente o personalizzata nel campo (es: la uf_DaysDifference sotto indicata) è possibile creare delle viste SQL molto utili da utilizzare in NAV.

esempio di alcune viste da me utilizzate in cruscotti di avanzamento
– Avanzamento Ordini Vendita\Acquisto\Commesse\Timesheets
– Avanzamento Fasi di Produzione
– Avanzamento Shop Floor etc..

SQL Date Scripts

Calcolare l’ultimo giorno di un mese

SET @oggi = GETDATE()

SELECT CONVERT(varchar, DATEADD ( dd , -1 , CONVERT (VARCHAR(6), DATEADD( mm , 1 , @oggi ) , 112 ) + ’01’ ) ,103)

Se @oggi = 09/01/2016
La select ritorna = 31/01/2016

— Aggiungo 1 mese alla data odierna:
SELECT DATEADD( mm , 1 , getdate())

— Visualizzo la data senza il giorno:
SELECT CONVERT (VARCHAR(6), DATEADD( mm , 1 , getdate()) , 112 )

— Imposto il primo giorno del mese:
SELECT CONVERT (VARCHAR(6), DATEADD( mm , 1 , getdate()) , 112 ) + ’01’

— Tolgo 1 giorno dalla data ottenuta:
SELECT DATEADD ( dd , -1 , CONVERT (VARCHAR(6), DATEADD( mm , 1 , getdate()) , 112 ) + ’01’ )

— Formatto il risultato in italiano (gg/mm/aaaa):
SELECT CONVERT(varchar, DATEADD ( dd , -1 , CONVERT (VARCHAR(6), DATEADD( mm , 1 , getdate()) , 112 ) + ’01’ ) ,103)

Calcolare il numero giorni di un mese

declare @data datetime
set @data = getdate()

select day(dateadd(month,1,@data)-(day(@data)-1)-1) as NumGiorniMese

— Trovo la data da elaborare aumentata di un mese:
select dateadd(month,1,@data)
— Imposto la nuova data con giorno = 1:
select dateadd(month,1,@data)-(day(@data)-1)
— Tolgo un giorno alla data:
select dateadd(month,1,@data)-(day(@data)-1)-1
— Leggo il numero di giorni:
select day(dateadd(month,1,@data)-(day(@data)-1)-1)

Calcolare differenza giorni

/* Differenza in giorni */
CREATE FUNCTION uf_DaysDifference (@dataIniziale DATETIME, @dataFinale DATETIME)
DATEADD(DAY, DATEDIFF(DAY, @dataIniziale, @dataFinale), @dataIniziale) > @dataFinale
THEN DATEDIFF(DAY, @dataIniziale, @dataFinale) – 1
ELSE DATEDIFF(DAY, @dataIniziale, @dataFinale) END

/* Ad esempio: */
select dbo.uf_DaysDifference(‘20160109′,’20160114’) as NumGiorni
select dbo.uf_DaysDifference(‘20060109’,getdate()) as NumGiorni
select dbo.uf_DaysDifference(‘20060109’,CURRENT_TIMESTAMP) as NumGiorni

Funzione che converte 0 in altro numero, utile in viste o stored procedures.

@Number FLOAT,
@IsZeroNumber FLOAT

IF (@Number = 0)
SET @Number = @IsZeroNumber

RETURN (@Number)

es: isZero(<campo>; 1) –> converte o in 1

Cumulative Update 3 for Microsoft Dynamics NAV 2016 has been released | Dynamics NAV Team Blog

Cumulative Update 3 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 http://support.microsoft.com/contactus/.

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
  •   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 3

You can download the cumulative update from KB 3130298 – Cumulative Update 3 for Microsoft Dynamics NAV 2016 (Build 44365).


Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  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 How to Install a Microsoft Dynamics NAV 2016 Cumulative Update.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2016.


Source: Cumulative Update 3 for Microsoft Dynamics NAV 2016 has been released | Dynamics NAV Team Blog

Description of the Number of Databases You Are Allowed to Run with a Microsoft Dynamics NAV License – Microsoft Dynamics CustomerSource

Scenario: NAV with test & production environments using customer license in more databases. …many questions about this topic in Microsoft Dynamics Community.

look at this post: https://community.dynamics.com/nav/f/34/t/186285

db test

“Correct Answer” by Microsoft

Each Microsoft Dynamics NAV production database requires a separate Microsoft Dynamics NAV license file.

With one Microsoft Dynamics NAV license, you are allowed to run one Microsoft Dynamics NAV database. If you have multiple Microsoft Dynamics NAV production databases, you must purchase a Microsoft Dynamics NAV license for each database.

You are allowed to use a Microsoft Dynamics NAV license on copies of your Microsoft Dynamics NAV production database as long as the copies of the database are used for:


Storage of historical data


Internal use only development

The databases must not be used in production.

Directly from public Microsoft CustomerSource section: Description of the Number of Databases You Are Allowed to Run with a Microsoft Dynamics NAV License – Microsoft Dynamics CustomerSource