Remove PowerPoint animations from slides

Microsoft OfficePowerPoint is not something I have used very often, but I am now doing webinars on at least a monthly basis at work. I’ve inherited some PowerPoint slidedecks from other people with some features I don’t like; one of those is having to click to display elements on slides. This is something which I now know to be animations and their removal is actually quite straightforward.

To remove an animation, select the Animations tab and then select element with animations; the Animation section of the action pane will show the type of animation currently selected; click None to remove the animation:

PowerPoint animations

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.

Excel Snippet: Get first day and last day of month using an Excel formula

Microsoft ExcelIt doesn’t come up very often as I do a lot of work using SQL Server rather than Microsoft Excel, but every so often I do need to do some date manipulation in Excel.

The formula, below, can be used to get the first and last days of a month (typically used for accruals); I had to do some research to find the syntax for Excel only to be surprised that it was similar to that of SQL Server (although both are Microsoft products so I maybe should not have been surprised).

Get last day of month:

=EOMONTH(TODAY())

Get last day of last month (same as above but subtract 1 within the function parameters to step back a month):

=EOMONTH(TODAY() , -1)

Get first day of this month (again using the EOMONTH function, but plus 1 outside of the function to add a day):

=EOMONTH(TODAY(), – 1) + 1

There is an alternate way of getting the first day of this month which uses a different function, but I find using EOMONTH easier to remember:

=TODAY() – DAY(TODAY()) + 1

The TODAY() function could be replaced with a table reference to calculate the first or last day of a month using other dates other than todays.

Rollback Microsoft Office to a previous version

Microsoft OfficeIn the last post, I mentioned uninstalling and reinstalling an old version of Microsoft Office to stop Microsoft Dynamics GP crashing when sending emails using MAPI. However, you don’t need to uninstall Office to roll back the version.

There is a command you can run to roll Office back to a previous version. You can find out the version numbers for Office here and then run this command at an escalated Adminstrator prompt to roll back the version of Office (change the highlighted section to the version number to which you want to roll back):

“C:\Program Files\Common Files\Microsoft Shared\ClickToRun\OfficeC2RClient.exe” /update user updatetoversion=16.0.12730.20236

Once the roll back of Office is complete, launch one of the products and select File » Office Account and then click Update Options » Disable Updates to stop Office being automatically updated:

Stop Microsoft Office automatically updating

With this done, Microsoft Office is rolled back to an old version and will not automatically update.

There are other approaches discussed online, but I have tested the above and it worked correctly for me where the others didn’t.

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.

Replace Microsoft Word formatting with a style

Microsoft OfficeI was working on a new book recently and bolded a lot of important terms. I then remembered that I actually had a style created for key words and should have been using the style rather than simply using bold; I convert the Word document into a number of different formats and styles, rather than simple bold, works a lot better for the conversion process.

A 200 page book was going to be somewhat long-winded to go through and update, but then I remembered seeing some additional options in the Find and Replace window a while ago.

Hit Ctrl+H and then click the More >> button. Click the Format button and select Font…:

Find and Replace window

Continue reading “Replace Microsoft Word formatting with a style”

Bad Parameter in refreshable Excel report query

Microsoft Dynamics GPOver the last few months, I’ve been doing work with clients on creating some refreshable Excel reports. Working on one of them, we had parameters for dates and added one for Vendor ID, which is when I encountered an error:

Excel error message

Microsoft Excel

Bad parameter type. Microsoft Excel is expecting a different ind of value than what was provided.

Continue reading “Bad Parameter in refreshable Excel report query”

Creating an Office365 app password for emailing with Microsoft Dynamics GP

Microsoft Dynamics GPIn a post a couple of weeks ago on emailing from Microsoft Dynamics GP, I mentioned using Office365 Exchange integrationfor sending the emails. Usually this works fine, but, increasingly, clients are activating 2FA (Two-factor authentication) is being enabled, which means users cannot log on using their normal password as the Microsoft Dynamics GP doesn’t use 2FA.

You can however create an app password in Office365 which you can use to log in when emailing documents from Microsoft Dynamics GP.

To create an app password, log into your Office365 account and select My account by clicking on your avatar in the top right corner.

The on the left-hand navigation pane select Security & privacy and then, on the right, click Additional security verification:

Additional security verification

Continue reading “Creating an Office365 app password for emailing with Microsoft Dynamics GP”

Microsoft Dynamics GP 2015 R2 user cannot login into Exchange

Microsoft Dynamics GPI’ve recently been working on a project with a client to introduce emailing of remittences to suppliers. To do this, we switched them from using Outlook foe sending emails to using a shared Exchange mailbox which their IT created for them.

We discovered that while I could use by email address for logging into Exchange, they couldn’t use their shared mailbox. My initial thought was that while we were both using Office365 accounts, they were trying to use an ordinary password, whereas I was using an app password.

I checked that they were entering the credentials correctly, which for Office365 is to use the email address in both the Email Address and Login ID fields (as shown in the example below), and they were:

Exchange Logon window

Continue reading “Microsoft Dynamics GP 2015 R2 user cannot login into Exchange”

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