System Requirements for Microsoft Dynamics GP 2018

Microsoft has announced the system requirements for Microsoft Dynamics GP 2018 which is to be released on December 1 2017. 

The details are here: https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/system-requirements/MDGP2018_System_Requirements.

The requirements listing is very thorough, and, needs to be read carefully.

Client Requirements

image

image

image

Solving – WMI Provider Error Invalid Namespace in SQL Reporting Services Setup

image

Figure 1 – SSRS error during setup of SQL Reporting

You’ve installed SQL.  Everything went well and you have all the different tasks showing as being successful.  Then you go to install SSRS Reporting Services, and you get the message….

I keep getting ‘Cannot connect to SERVERNAME’, ‘Report Server WMI Provider Error: Invalid namespace

The answer to fixing this error, at least the answer that worked for me, is:

To install/reinstall/repair SSRS, run the SQL Server setup utility and choose the advanced or custom option which will allow you to choose only the components you wish to install.

Big question – what does the Utility Control Point do?

The SQL Server Utility is managed through a utility control point using Utility Explorer in SSMS. The UCP is configured on an instance of SQL Server. It provides the central reasoningpoint for the SQL Server Utility using SSMS to organize and monitor SQL Server resource health.

1. To create the SQL Server Utility begin with opening the SQL Server Management Studio.  I am using SQL 2014.

2. Then click on VIEW, and find UTILITY EXPLORER, as below.

image

3. Click on UTILITY EXPLORER to open up the next window, and click on CREATE UTILITY CONTROL POINT.

image

4. This opens up the window below which gives you very clear steps to follow to create the Utility Control Point.  

image

The process of creating and validating the SQL Server instance cleared up the issues that I had with WMI not distinguishing instance names, and solved my problem.  I was able to install Reporting Services, and to configure SSRS reporting to suit my requirements.

Update – Office 2007 support ends on October 10, 2017

image

Microsoft announced that the company’s support for Microsoft Office 2007 will end on October 10, 2017, a little over three months from now.

When Office 2007 reaches its End of Life on October 10, 2017, Microsoft will no longer provide:

  • Technical support for issues

  • Bug fixes for issues that are discovered

  • Security fixes for vulnerabilities that are discovered

In addition, as of October 31, 2017, Outlook 2007 will be unable to connect to Office 365 mailboxes, which means Outlook 2007 clients using Office 365 will not be able to receive and send mail.

Open Live Writer Version 0.6.2 Is Now Available

image

For those of you that missed it, Open Live Writer had an update in May 2017.  Remember, Open Live Writer works with many popular blog service providers such as WordPress, Blogger, TypePad, Moveable Type, DasBlog and many more.  This is my favorite blogging tool.

I have provided some information from the team’s release notes, but not everything that is changed is included.

From their website http://openlivewriter.org/

We’re happy to announce a new release of Open Live Writer. We hope you enjoy the new features as much as we enjoyed working on them. Read on to learn more about what issues have been fixed and what features have been added.

The next time you start Open Live Writer and are connected to the internet, it should get updated automatically. But if you can’t wait to try out the goodness, download the updated setup here.

Bug fixes

  • #562 Error: Can’t Publish Files- The remote server returned an error: (501) Not Implemented

This is the master issue for the Google Blogger image publishing problem. Other issues associated with this problem include #608, #600, and #564

  • #437 Blogger dynamic templates #438 Fixed WordCounter regex to support Hebrew/Arabic #521 Support atompub service link with relative url #487 Adding new intillesense db file to gitignore. Minor annoyance

Features

#450 Fix scaling of categories dropdown and options dialog #585 Implement per-monitor DPI Support #180 Add support to CSS3 templates

Sandbox Applications for Window 10

image

Figure 1 – Visual image of what a Sandbox environment looks like when a Sandbox is installed on a PC (Image from Comodo.com)

I have some testing that I want to do on my laptop, and I was looking for the safest way to create an environment for completing this testing.  I know that I can use the Hyper-V on my Windows 10.  However, I am finding that it is not so user friendly.  I wanted something really easy.

I found a great article on www.maketecheasier.com called “5 of the Best Sandbox Applications for Windows 10” https://www.maketecheasier.com/best-sandbox-applications-windows10/.

If you are wanting to create a Sandbox environment to test out software, take a look at the article.

Let me know which sandbox app that you choose with some feedback on how it works for you.

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?

Mark Polino’s 50 Free Tools And Add-ons for Dynamics GP

                               image

Tampa Summit 2016 was held from October 11 to 14. And, the organization allowed free access to many of the sessions via the Dynamics Community USTREAM channel.  The sessions are here:

http://www.ustream.tv/channel/3TF3LvpXVXN’’

There are some wonderful presentations included in the eighty some presentations.  Note that access to videos changes from time to time so I do not know how long this link  will be valid. 

I loved this session by Mark Polino and I thought that he did a fantastic presentation on the tools and add-ons available for Dynamics GP users.  Since there is 50 of them, I thought I would list out some of the tools that I think will benefit users and partners.  You can check out the rest of the tools on his session’s video. 

I have put in some of the references for downloading or for contacting.  Some you will need to look up.

  • Spell Check for GP –  from Willoware, a Microsoft ISV
  • Color Settings for Different Companies –  from Willoware
  • Consulting Toolkit Free Tools – from Willoware
  • Smart Sort – filtering – from Ethotech
  • Macro Command Reference –  Kevin Gross (download)
  • Ole Note Migration Utility  – from Microsoft (for Dynamics 2013 and 2015 for moving notes to Doc Attach in 2016
  • GP Build Numbers and Versions  – from Victoria Yudin (download from her website)
  • SQL Server Performance Dashboard  – from Microsoft
  • Dynamics Performance Analyzer – from Microsoft (https://dynamicsperf.codeplex.com)
  • Password Expiration Notification – from Michael Johnson (see his blog MBSGURU on BlogSpot)
  • GP Security Matrix – from FastPath – an Excel form for redoing security
  • Super User- to replace Power User – from Mark Polino (mpolino.com)
  • Default GP Roles –what permissions are in each role – Jivtesh Singh (https://app.box.com/v/Gproles)
  • Paste from EXCEL with Intercompany – from James Lyn (https://jamesdlyn.wordpress.com)
  • Multicurrency Setup – from Leslie Vale (http://dynamicsconfessions.blogspot.com)
  • Exchange Rate Feed – from Dynamics Innovations (http://di.jo)
  • RM Auto Apply – from Microsoft – need to get via your Microsoft Partner
  • Average Days to Pay (Customers) – – from Microsoft – need to get via your Microsoft Partner
  • SOP Sort Line Items (for moving SOP to POP) – from Microsoft – need to get via your Microsoft Partner
  • Copy to New SOP Batch – from Mariano Gomez (http://dynamicsblogster.blogspot.com)
  • Vendor/Customer Portal – cloud based – from Viewpost (http://www.viewpost.com/IBG)
  • Auto number Customer/Vendor/Items – from Dynamics Innovations (http://mohdaoud.blogspot.com)
  • Changer Scripts for Project Accounting – – from Microsoft – need to get via your Microsoft Partner
  • Jet Express for Excel – from Jet Express (http://jetreports.com)
  • Power BI – from Microsoft (https://powerbi.microsoft.com)
  • Excel Based Table Reference – from Mark Polino – (http://mpolino.com)
  • SmartList Quick Reference Guide – from Mark Polino – (http://mpolino.com)

Thanks Mark, for creating some cool tools and for putting together the listing of tools and add-ons.

Happy Thanksgiving, Canada

image

Today reminds me that I am grateful for all the companies and all the developers that make great software and machines and stuff that I can use to earn a living, do accounting, write blogs, and send emails.  I am also grateful for all the apps, gadgets, cameras, and things that make my life more fun.

And, yes, I am grateful for my family, friends, and for my wonderful husband and our home.