Cumulative Update 06 for Microsoft Dynamics NAV 2017 has been released

Cumulative Update 06 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2017.

Where to find Cumulative Update 06

You can download the cumulative update from KB 4021396  – Cumulative Update 6 for Microsoft Dynamics NAV 2017.

You can press one of the countries in list above for a direct download or you can download the cumulative update from the Microsoft Download Center.

To learn more about other Cumulative Updates already released for Microsoft Dynamics NAV 2017 please see KB  3210255.

Cumulative Update 31 for Microsoft Dynamics NAV 2015 has been released

Cumulative Update 31 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

You can download the cumulative update from KB 4021394  – Cumulative Update 31 for Microsoft Dynamics NAV 2015.

Or you can download the cumulative update from the Microsoft Download Center.

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

Cumulative Update 19 for Microsoft Dynamics NAV 2016 has been released

Cumulative Update 19 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.

You can download the cumulative update from the Microsoft Download Center.

You can see changes included in this cumulative update from KB 4021395 – Cumulative Update 19 for Microsoft Dynamics NAV 2016.

Windows 10 Creator Update Has Some Great Features

image

Every time that Microsoft does a Windows update, I check to see if there are features that I will actually use.  In the Creators Update, there are several processes that will make my life easier.  If you want to check out all the features, go the blog link listed below. https://blogs.technet.microsoft.com/windowsitpro/2017/04/05/whats-new-for-it-pros-in-the-windows-10-creators-update/?MC=Windows&MC=SysMagSof&MC=SecSys&MC=EntMobile 

Here are some of the cool things that I will use… note that these features are lifted from the blog noted above.   

1.  New Windows Defender Advanced Threat Protection (ATP) capabilities, including the ability to create custom threat intelligence alerts, investigate a specific user account, and take immediate actions on a machine or file to contain a breach. (Watch the demo for more insight.)

2.  Hyper-V improvements, including:

  • “Quick Create,” a new option to create virtual machines in Hyper-V.
  • Checkpoint and Save for nested Hyper-V
  • Hyper-V instances will now remember your zoom level for the next session.
  • You can now override the scaling in Hyper-V virtual machines.
  • You can now resize Hyper-V windows in Enhanced session mode.
  • Networking improvements (NAT)
  • Developer-centric memory management

You can see more in a blog from Windows, and see videos embedded in the blog that show off some of the features.

https://blogs.windows.com/windowsexperience/2017/04/11/whats-new-in-the-windows-10-creators-update/

Windows Vista Support Ends April 11 2017

Microsoft announced that Windows Vista users have a day left to update from Windows Vista.  Microsoft support for the Windows Vista product officially ends on Tuesday April 11, 2017.

Here is a line from the article about the end of Vista… from http://ca.ign.com/articles/2017/04/10/official-support-for-windows-vista-ends-april-11#-/

Windows Vista was replaced by Windows 7 in 2009. It’s survived by Windows 8, Windows 8.1, and a grandchild, Windows 10.

May Windows Vista rest in peace. 

Jet Reports New Release for Dynamics GP and NAV

                        clip_image002

Jet Reports Canada sent out a notice this morning announcing that Jet Reports has released a new build.  All the details are below.

Visual Studio 2017 Launch

image

March 7 and 8, beginning at 8am PST, join Microsoft for an exciting, two-day virtual event announcing the release of Visual Studio 2017 and celebrating 20 years of Visual Studio.

For more information, check out https://mva.microsoft.com/colleges/visual-studio-2017-launch.

Schedule:

March 7: Keynote and Demo Sessions 

March 8: Application Development

March 8: Web Development

Three Excel Tricks for Lining up Data for Import into Dynamics NAV, GP, AX

image

Recently, I have had to import lots of different data for clients.  They give me Excel worksheets that are full of names, numbers and telephone numbers.  If you are working with Dynamics NAV or GP, you know that some of the fields can be very fussy in the import.  Dynamics AX is more forgiving.  I clean up the data, and get it ready. 

Most clients ask me how I clean up columns, especially phone numbers. If you use Excel a lot, you will know these formulas or tricks.  This post is for those who do not have to do this very often, and need some help.

1. Using Excel to change Words from All CAP to All lowercase, or to PROPER

    • you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case.
    • First, insert a temporary column next to the column that contains the text you want to convert
    • In the temporary column, for example,  cell B2, type =PROPER(A2)
    • The other choices are  =UPPER(A2) or  =LOWER(A2)

Now, all of the names, countries, states, provinces, etc. can have standardized type.

2. Removing spaces and symbols in a phone number

    • Often we get a list of telephone numbers that look like this

image

    • To get rid of the (, ), –, Ext. 0000, use the find and replace function
    • To get rid of the space, use the find and replace, using the space bar
      1. Press Ctrl + Space to select all cells in a column.
      2. Press Ctrl + H to open the “Find & Replace” dialog box.
      3. Press Space bar in the Find What field and make sure the “Replace with” field is empty.

3.  Filling in the extension on a phone number

    • Now  you want to add trailing zeroes to make all the numbers with a fixed length, such as 14 digits for a telephone number in Canada and the US
    • Create a blank column right of the existing phone number
    • Use the EXCEL function =A2&REPT(“0”,14-LEN(A2)) where “A” represents the column with the telephone number in it
    • The results are

image

      And, the number now becomes easy to import.

Dynamics AX 2009 Support Ends in October 2018

 

image

There are several different articles in different blogs that talk about the looming date of October 2018 which brings the end of Dynamics AX 2009 support.

Well, lots of Microsoft software have pending dates when support will be ending. Windows 7 is one of the software packages that no longer has support. Yet people still use it.

You wonder, then, why there is so much concern over Dynamics AX 2009. The answer, for me, is in Henrik Marx Larsen’s article https://www.linkedin.com/pulse/dynamics-ax-2009-out-support-2018-you-ready-henrik-marx-larsen.

I think the main idea presented is that companies are going to need to start thinking about their short term and long term strategies for business infrastructure. The questions are:

Do we prepare for moving to the cloud now and get ready for the change before October 2018? Or, do we wait until into 2018, and see what the organizations in our industry are doing, and then make a decision?

It is a tough set of questions. What is your organization going to do?

Windows PowerShell Reference

 

image

In November of 2016, Windows PowerShell celebrated its ten year anniversary.  This is a major accomplishment.  Here is the computer definition of PowerShell.

PowerShell – Computer Definition

A comprehensive command line interface and scripting language for Windows. Introduced in 2006, PowerShell is a major upgrade from the Windows command line, which uses DOS commands – from www.yourdictionary.com

PowerShell is set to replace the Command Prompt still available in Windows. And, if you are a DOS user or a Command Prompt user, you will want to become familiar with all of the sweet features of PowerShell.  Some users say that if you know either Windows or Unix commands, you will have an easier time understanding and using PowerShell.

Here are different links to give you the information that you require to become familiar with PowerShell or go on to master PowerShell.

How To Install Windows PowerShell 4       http://social.technet.microsoft.com/wiki/contents/articles/21016.how-to-install-windows-powershell-4-0.aspx

How To Update PowerShell

http://social.technet.microsoft.com/wiki/contents/articles/8034.how-to-update-powershell-help.aspx

Windows PowerShell Portal

deals with Tool Releases, BizTalk server, Exchange Server, FIM, Office Products, SharePoint, Windows OS, SQL Server, Active Directory,

          http://social.technet.microsoft.com/wiki/contents/articles/24187.windows-powershell-portal.aspx

Windows PowerShell blog   https://blogs.msdn.microsoft.com/powershell/

Scripting with Windows PowerShell   https://technet.microsoft.com/en-us/library/bb978526.aspx

A Task-Based Guide to Windows PowerShell Cmdlets   https://technet.microsoft.com/en-us/library/dd772285.aspx

PowerShell   https://msdn.microsoft.com/en-us/powershell/mt173057.aspx

Using Windows PowerShell   https://msdn.microsoft.com/en-us/powershell/scripting/getting-started/fundamental/using-windows-powershell

There are many different blogs and on-line courses that you can take to learn PowerShell.  How deep will you choose to go?