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.
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.
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.
March 7: Keynote and Demo Sessions
March 8: Application Development
March 8: Web Development
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
- 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
- Press Ctrl + Space to select all cells in a column.
- Press Ctrl + H to open the “Find & Replace” dialog box.
- 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
Posted in Dynamics AX, Dynamics GP, Dynamics NAV, Excel, How To, Microsoft, Working
- Tagged Dynamics AX, Dynamics GP, Dynamics NAV, Excel, How To, Tips and Tricks
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
Windows PowerShell Portal
–deals with Tool Releases, BizTalk server, Exchange Server, FIM, Office Products, SharePoint, Windows OS, SQL Server, Active Directory,
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
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?
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.
New Project Templates:
- C# VSIX Library
- C# VSIX Project
- Visual Studio Shell Isolated
New VSIX Templates:
- Dialog Window
- WCF Service
New VSPackage Templates:
- Tool Window
- Dialog Page
- Option Page
Great job, Mario!
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.”
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.
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.
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.
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:
- After the December 1 R2 release, Microsoft Dynamics GP will be updated annually in the late fall time frame.
- If you have new features that you want to see in a future release, enter them at Connect.Microsoft.com
- 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
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.