Download Evaluation Copy of Windows Server 2016

image

If you want to explore the many characteristics of the new Microsoft Windows Server 2016, without buying the software, you can download an evaluation copy from the TechNet Evaluation Center.  The evaluation copy is valid for 180 days.

Here is the site:  https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2016.

Here are some of the resources that are available:

•  Find details useful for installing, configuring, and deploying Windows Server 2016

•  Discover what’s new in Windows Server 2016 and find guidance on exploring important new features and capabilities

•  Read The Ultimate Guide to Windows Server 2016

You will have to sign in and you will have to provide your details to get the copy. 

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.

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.

File Transfer Manager will not Open to Download Dynamics GP and Related Files in Windows 10 and IE 11

If you are a customer or partner of Microsoft, you may be finding it difficult to download files for Dynamics GP 2016 and GP 2015 because the File Transfer Manger WILL NOT OPEN.

I tried to download some files today, and was getting nowhere when I suddenly remembered that WALDO’s BLOG http://www.waldo.be/2016/10/27/microsoft-dynamics-nav-2017-ready-for-download-and-how-to-do-it/ had instructions for downloading the Dynamics NAV 2017 files.

I went back to his instructions, followed the steps, and, after closing and reopening Internet Explorer 3 times, and putting the Microsoft sites into compatibility mode, the File Transfer Manager worked.

Thank you, Waldo, and keep writing those great blogs!

How To Fix Outlook and Office 365 Issues

image

I recently set up an Outlook 365 Business  account.  It was easy to set up and to get it going on my browser.

Then I set up the email address on my desktop Outlook 2013 Client.  It worked well for two days and then I started to get error messages:

   An unhandled win32 exception occurred in Outlook.exe [14592].

The number on the message would change from time to time when I was logging in.  Sometimes it was 14595, or 5672, or 5996.  And, using Visual Studio debugging tool did not help.

Microsoft Outlook would not open at all so I could not get into it to make changes.

I tried many things that did not work.

Here is what worked:

1. I found a site for Office Support, and it had a section on Office 365 Business Accounts.  You can find this information at https://support.office.com/en-us/article/Outlook-email-setup-6e27792a-9267-4aa4-8bb6-c84ef146101b

2. I clicked on the phrase “automatically diagnose and fix many Outlook setup issues

3. This took me to the “FIX OUTLOOK” page at https://portal.office.com/support/help.aspx?sid=sara#/330cfd4a-358a-47fc-a679-71c762039f09

4. I downloaded the Microsoft Support and Recover Assistant for Office 365, and installed it.

5. The process took about 45 minutes to run through all the possible issues. 

In the end, the RECOVER ASSISTANT did fix my client and get it to open.  And, it did tell me that my profile needed to be reset.  It is a good tool to use when you do not know what is wrong.

If you ever need to use the RECOVER ASSISTANT, let me know if it works for you.

Power BI Desktop Updates At October 31 2016

Amanda Cofsky, Program Manager at Microsoft, announced the new desktop release of Power BI on October 31.  You can read it at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/.

Here’s the complete list of October updates from Cofsky’s blog:

Report View

Analytics

Data Connectors

Query Editing Improvements

Other Improvements

The blog also contains simple instructions for using the DATE SLICER, REPORT GRIDLINES, DATA LABEL, and MAP FORMATTING OPTIONS.

GP 2016 R2- New Security Roles and Tasks are missing when upgrading to Microsoft Dynamics GP 2016 R2 and Year-End Update

Check out the blog from Derek Albaugh about the issue with missing security roles and tasks after upgrading to GP 2016 R2.  You can find the information at https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/10/14/new-security-roles-and-tasks-are-missing-when-upgrading-to-microsoft-dynamics-gp-2016-r2-and-year-end-update.

Some of the critical information about the scripts required is noted below, from Albaugh’s blog.

These scripts for Microsoft Dynamics GP 2016 / Microsoft Dynamics GP 2016 R2 missing security roles and security tasks records can be found here, and needs to be run against your DYNAMICS/security database:

MICROSOFT-DYNAMICS-GP-2016-R2-SECURITY-INSERT-SCRIPTS.txt

This set of scripts includes the security scripts for Microsoft Dynamics GP 2013 R2, Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2015 R2 from prior blogs, as well as Microsoft Dynamics GP 2016. You’ll need to run this script whether you’re upgrading from Microsoft Dynamics GP 2013 R2 or Microsoft Dynamics GP 2015/R2 to Microsoft Dynamics GP 2016/R2.

**NOTE: Because we’ve combined the INSERT scripts from the other blogs to be included in this one, you may see PRIMARY KEY errors referencing duplicated records trying to be inserted into the security tables. This can be ignored as it means that the record already exists in that table and the script will not overwrite anything that is already present.

Dynamics GP 2016 R2 has Table and Column Changes

image

 

Dynamics GP Support and Services team are spreading the word about changes in Dynamics GP 2016.  Sarah Purdy, Senior Technical Advisor, has written a blog highlighting some of the table changes and column changes in GP 2016 R2.  You can reference her blog at https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/10/21/table-and-column-changes-in-microsoft-dynamics-gp-2016-r2-and-year-end-update.

Here is the information from Sarah’s blog:


New tables that were added to Microsoft Dynamics GP 2016 R2

Table Physical Name Table Technical Name
System Tables

ADH00106                                                       ADH_Favorite_LookupAssignment
ASIEXP101                                                       ASI_FavoritePassword_SETP

Company Tables

APR_DIA_Mandatory_HIST                          
CM30200                                                        CM_Transaction_History
CM30300                                                        CM_Receipt_History
UPR30700                                                       uprEmployeeHistory

Data Type Change on an Existing Column:

The data type changed from ‘STR17_LBAU’ to ‘STR30_LBAU’ for the PAerdocnumber column in the following tables:
PA10502
PA30504
PA10504
PA30500
PA30501
PA30503
PA10500
PA10501
PDK10500
PTE10500
PTE30500

New columns added to existing tables (SYSTEM DB):

ASIEXP101 —   CMPANYID, SmartListPassword
SY40800 —       PowerBIWebClientID, PowerBIAppKey

New columns added to existing tables (COMPANY DB):

CM20200 –     VNDCHKNM
FA49900 —      IncludeTaxInAcqustCost
FA01300 —      IncludeTaxInAcqustCost, ORTAXAMT
IVC10500 —     TXDTLPCTAMT
SOP10105 —    TXDTLPCTAMT
RM30601 —     TXDTLPCTAMT
RM10601 —     TXDTLPCTAMT
FA01400 —      IncludeTaxInAcqustCost
FA01401 —      IncludeTaxInAcqustCost
FA01100 —      IncludeTaxInAcqustCost
FA00100 —      IncludeTaxInAcqustCost
POP10310 —    OriginatingPPTaxAmount
POP30310 —    OriginatingPPTaxAmount
APR_PIP40100 —         ACTINDX, ADRSCODE
PTO00101 —    USERID
Check back to the  Microsoft Dynamics GP 2016 R2 and Year-End Update Upgrade Blog Series Schedule page to review our blog posts related to Upgrading Microsoft Dynamics GP and other helpful resource links.

Thank you, Sarah, for letting us know about the table and column changes.