Error opening Word templates from Microsoft Dynamics GP Workflow Action emails

Microsoft Dynamics GPA client reported a problem with workflow approvers opening the batch edit list on a Microsoft Dynamics GP General Ledger Batch Approval workflow action email this morning; only a few users are having problems while everyone else is working without problem. The users with the problem are getting this error when trying to open the Transaction Edit List report on the email:

Word experienced an error trying to open the file...

Microsoft Word

Word experienced an error trying to open the file.
Try these suggestions.
* Check the file permissions for the document or drive.
* Make sure there is sufficient free memory and disk space.
* Open the file with the Text recovery converter.
(C:...transaction Edit List.docx)

I did some research and found there was a recent post on the Dynamics GP Support and Services Blog where they covered this same issue. The blog post was only four days ago and they acknowledge the issue is ongoing and offer the workaround of downgrading Microsoft Office to work around the issue (I did this recently when sending emails using MAPI caused Dynamics GP to crash).

The problem does not just affect the Word template reports from Workflow Batch Approval emails, but also the Word templates used for sending purchase or sales orders, remittances and so on. For the non workflow Word templates, you could reconfigure the templates to use PDF, or one of the other formats, instead of Word, but, unfortunately, this option is not available for the batch edit lists.

Following the initial report, we’ve had a number of other clients report the issue, so it may be worth preempting problems and block Office updates for Dynamics GP users until a fix is in place from Microsoft.

Microsoft Dynamics GP crashes sending emails using MAPI

Microsoft Dynamics GPOn my Microsoft Dynamics GP demo environment I have Office Professional Plus 2019 installed and Dynamics GP configured for MAPI integration for the sending of emails (I sometimes have my demo environment used when I don’t have an Internet connection so have a hMaiLServer installed for emails instead of relying on the company Exchange). I got caught doing a demo last week when sending an email, Microsoft Dynamics GP crashed whenever I did anything involving integration with email.

I first encountered the crashes when trying to email a creditor remittance, but soon found that even trying to open the Email Settings window did the same thing; in fact any window which tries to connect with Outlook, caused Dynamics GP to crash. I did some investigation and repairs of Office, as well as rolling back a version or two to see if that resolved the problem. Unfortunately it didn’t resolve the problem so I opted to remove and reinstall Microsoft Office from the original media which I know had worked. And it worked again; the rollbacks should have worked, but I may ot have rolled back far enough.

As this old version worked fine, I have disabled automatic updates of Office to make sure I don’t have problems again.

Hands On with Microsoft Dynamics GP October 2019 Release: System Requirements

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP.

The October 2019 release of Microsoft Dynamics GP largely has the same system requirements as Microsoft Dynamics GP 2018 R2 with the addition of the following:

  • Windows Server 2019
  • SQL Server 2019
  • Office 2019

Remove Microsoft Word Index Entries

Microsoft WordI’ve written a few books over the last few years; I use Microsoft Word as it is easy to work in and easy to convert to PDF. Some of the books I have written have been self published. Doing it this ways means that I need to do all of the layout and formatting, such as creating the index.

On occasion, I have had a need to remove the index and re-add; this is most often when I am writing a new edition of a book. I’ve done a fair bit of searching for ways of doing this and have used a couple of different approaches.

One of the early approaches I came across was to use VBA to strip the index entries out, but more recently I found another, much simpler, way of doing it using find and replace.

Press Ctrl+H to open the Find and Replace dialog; in the Find what box, type ^d XE:

Find and replace

Continue reading “Remove Microsoft Word Index Entries”

Disable AutoSave OneDrive and SharePoint Online Files by Default on Excel

OneDriveI recently got a new laptop at work which meant getting all applications installed. Previously I’d had Microsoft Office 2016 installed; on the new laptop I got Microsoft Office 365 which came with AutoSave enabled by default in all of the applications, such as Excel and Word, for files opened from SharePoint Online:

Microsoft Excel autosave on

Continue reading “Disable AutoSave OneDrive and SharePoint Online Files by Default on Excel”

Creating An Outlook Item Shortcut

Microsoft OutlookEarlier this month I did a post on command line parameters to create an Outlook item (such as an email or appointment). In that post I mentioned it was easy to create a shortcut for them, but realised afterwards, that it might be beneficial to cover creating the shortcut.

To create a shortcut, right click on the Windows desktop, and click on New » Shortcut:

Windows right-clickcontext menu

Continue reading “Creating An Outlook Item Shortcut”

Shortcut Command Line Parameters For Outlook Email, Appointments, etc.

Microsoft OutlookI’m currently setting up a new laptop and re-creating all of the shortcuts I am used to having, which includes shortcuts not only for Outlook itself, but also for the types of items. For example, I want to use the Run window and type EMAIL and have a new email window open.

Creating the shortcuts is straight forward, but you need to know the command line parameters:

Appointment:
   /c ipm.appointment

Contact:
   /c ipm.contact

Email:
   /c ipm.note

Note:
   /c ipm.stickynote

Task:
   /c ipm.task

I wish the email one was email instead of note as I never remember it on first attempt.

Implementing SmartConnect: System Requirements

eOne SolutionsThis post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

Before starting to install SmartConnect, the following requirements should be checked to ensure compatibility; if procureing new servers or software, I’d generally advise to aim for the top of the requirements to ensure greatest longevity.

Processors:

  • 32 bit processor machines, 2 GHz or greater.
  • 64 bit processor machines, 2 GHz or greater.

Memory (RAM):

  • 1 GB of RAM is required, at least 4GB is recommended.

Continue reading “Implementing SmartConnect: System Requirements”

Microsoft Dynamics GP Crashes/Closes When Emailing After Microsoft Office Update

Microsoft Dynamics GPEarly last week, the Dynamics GP Support and Services Blog posted about a problem whereby Microsoft Dynamics GP will crash when emailing after the latest Microsoft Office update.

This officially effects all versions from Microsoft Dynamics GP 2013 RTM onward, but one comment on the above blog post says it also effects Dynamics GP 2010.

The Microsoft Office update which causes the problem is:

  • Office 365 – Version 1811 (Build 11029.20079) – Standard
  • Office 365 – Version 1811 (Build 11029.20045) – Insider Edition
  • Office 2019 – Version 1811 (Build 11029.20079)

To check your version of Office, launch Microsoft Outlook, click File then Office Account; on the right hand side of the screen is a section for About Outlook:

About Office section showing version number

There are two options to resolve the issue (you should only have to apply one of them):

  • Revert/Rollback Microsoft Office to the last build.
  • Rename Dynamics GP Code folder and run a Repair (this will remove 3rd Parties).

Instructions for both options are available on the Dynamics GP Support and Services Blog.

We’ve found that for clients with the problem, rolling back the version of Microsoft Office fixes the issue.

Find Unique Records in Microsoft Excel

Microsoft Excelnot very good with Microsoft Excel. People often think that I am becuae I can concatenate data and write if statements and other formula, but, beyond this, my knowledge is very shallow.

There are things that I know you must be able to do, but have no idea how. As such, I often default to loading data into SQL Server to manipluate. When dealng with large quantities of data, I think this is still the best thing to do, but for smaller datasets, using Excel makes more sense.

There may be a number of other posts, covering fairly simple functionality in Microsoft Excel, that I post in future as reminders for myself.

The first of these Excel tips, is identifying unique data. In Excel this is actually quite simple (once you know how).

If I wanted to identify how many unique vendor ids I had in a dataset, I can do this in only a small number of steps.

Select the columns containing the data I want to search; in this case, the Vendor ID and Vendor Name columns. Select the DataSort & Filter section, click Advanced:

Microsot Excel

Continue reading “Find Unique Records in Microsoft Excel”