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.

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/

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.

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?

New Templates for Visual Studio 2015

image

 

Happy New Year to all the Visual Studio 2015 developers who create extensibility templates.

Mario Hsiao has provided many new templates out on https://marketplace.visualstudio.com/items?itemName=MarioHsiao.ExtensibilityTemplates.

All the templates are listed below and can be downloaded from the link above.

Extensibility Templates

New Project Templates:

  • C# VSIX Library
  • C# VSIX Project
  • Visual Studio Shell Isolated

New VSIX Templates:

  • Control
  • Dialog Window
  • WCF Service
  • Window
  • Wizard

New VSPackage Templates:

  • VSPackage
  • Command
  • Tool Window
  • Editor
  • Service
  • Dialog Page
  • Option Page

Miscellaneous:

  • EULA.rtf
  • LICENSE
  • README.md

Great job, Mario!

 

 

 

If You Cannot Find Your Windows 10 License Key, Try This

image

 

If you are having trouble finding your Windows 10 license key, know that you are not alone.  Sometimes, it feels like it is just hidden.

To find your product key, check out this great post at https://www.groovypost.com/howto/find-your-windows-10-product-key/.

The important paragraph is:

“When you purchase your Windows 10 license from the Microsoft Store, a copy of the product key is stored in your Microsoft Account. Microsoft will also send you a copy of the product key in a confirmation email. If you don’t see the confirmation email, check your junk mail folder. If you still don’t find it, log into the Microsoft Store > Downloads > Product Keys > Subscription page. Then click the Digital Content tab to see your previous purchases along with your product key.”

Dynamics NAV 2017 Cumulative Update 01

 

image

Picture from Groovypost.com

 

What would life be without updates?

To me, the answer is that it would be more frustrating and less fun.  Having said that, some exciting news!  As of December 7, Microsoft has release cumulative update 01 (CU01) for Dynamics NAV 2017.  You can read the entire blog at https://blogs.msdn.microsoft.com/nav/2016/12/07/cumulative-update-01-for-microsoft-dynamics-nav-2017-has-been-released/.

Where to find Cumulative Update 01

You can download the cumulative update from KB 3209071 – Cumulative Update 01 for Microsoft Dynamics NAV 2017 (Build 14199).

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

You will also find information on how to install the update – or at least a link to the article – on this blog.

Microsoft Now Has Quick Start Guides For Office 2016

image

I will be the first to admit that I like having manuals to read for specific information.  Microsoft has now authored documents called Quick Starts for Office 2016.   You can see the documents at https://support.office.com/en-us/article/Office-2016-Quick-Starts-25f909da-3e76-443d-94f4-6cdf7dedc51e.

Here are the different versions available.

Resources Online

Download in PDF

Read in Office Sway

For Mac users, the following Quick Start guides exist.  The Office 2016 guides are available to download in PDF.  They include Word, Excel, Outlook, PowerPoint, and OneNote. 

Skype for Business, Mac, and Mobile

Thinking about whether to upgrade to Office 2016?  Take a look at the resource guides to help you decide. 

Dynamics GP Update on Strategy At November 15, 2016

image

Figure 1 from Pam Misialek’s blog post of November 15 at https://community.dynamics.com/gp/b/gpteamblog/archive/2016/11/15/product-roadmap-and-strategy

If your company is using Dynamics GP, you can now plan your next update or upgrade based on the roadmap that “Inside Microsoft Dynamics GP” has released.  Here are the highlights:

  1. After the December 1 R2 release, Microsoft Dynamics GP will be updated annually in the late fall time frame.
  2. If you have new features that you want to see in a future release, enter them at Connect.Microsoft.com
  3. See the GP 2016 R2 Videos at https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/11/11/microsoft-dynamics-gp-2016-r2-new-feature-blog-series-schedule

 

GP 2016 R2 Release For Dec 1 2016

image

Figure 2 – Slide from the User Group presentation.  Slides are at https://docs.com/pam-misialek/9145/microsoft-dynamics-gp-roadmap-oct-2016?c=GFj46s

Here is the slide that announces the new features available in GP 2016 R2 which is being released on December 1.  You will notice that there are some features that users have been asking for.  This slide illustrates that Microsoft is listening to the requests from users and implementing them as new features.  You can see in the Figure 1 slide that the release in 2018 will be based on user requests.