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 Users – Update on April 11, 2017

 

image

A new update for Windows 10 is available as of April 11, 2017.  This update addresses several issues that were major pains to users, such as:

  • Addressed issue that was not allowing users to access online help content when clicking the help icon in various Windows applications, such as File Explorer.
  • Addressed issue where displays turn off unexpectedly even when Turn off display and Screen saver are disabled in the power profile.
  • Addressed issue that causes virtual machines to fail during high I/O scenarios where the user may log in multiple times.

You can check out all of the update features at  April 11, 2017—KB4015217 (OS Build 14393.1066 and 14393.1083) https://support.microsoft.com/en-us/help/4015217/windows-10-update-kb4015217 

You can also see a list of all KB articles and Builds to date, on the sidebar of this article.

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.

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.”