This 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
I’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
Continue reading “Remove Microsoft Word Index Entries”
I 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:
Continue reading “Disable AutoSave OneDrive and SharePoint Online Files by Default on Excel”
Earlier 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:
Continue reading “Creating An Outlook Item Shortcut”
I’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:
I wish the email one was
email instead of
note as I never remember it on first attempt.
This 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.
- 32 bit processor machines, 2 GHz or greater.
- 64 bit processor machines, 2 GHz or greater.
- 1 GB of RAM is required, at least 4GB is recommended.
Continue reading “Implementing SmartConnect: System Requirements”
Early 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:
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.
I’m not 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:
Continue reading “Find Unique Records in Microsoft Excel”
I recently had to read a large Word document which had apparently been written by someone who doesn’t know how to use Microsoft Word. Intead of using paragraph spacing they had inserted blank lines.
I know in the scheme of things, this is a relatively minor gripe, but in a large document it is still annoying.
However, there is a simple way in Word to remove blank lines.
Using the Find and Replace tool, in the Find what box type
^p^p and in the Replace with box type
^p; hit Replace All and all double line breaks will be replaced with single line ones:
To my eyes this makes the document far more readable which is important for a large one.
In this series I am taking a look at how macros can be used to update data in Microsoft Dynamics GP.
Over the last couple of posts, I’ve shown how data can be merged into the macro template using either mail merge or a SQL script. This post is going to show the final method I use for merging data into the macro template, which is to use an Excel formula.
I am using an Excel spreadsheet with two columns, USERID and PASSWORD. I am going to add a third column to the spreadsheet to hold the formula containing the macro.
Continue reading “Microsoft Dynamics GP Macros: Macro By Excel Formula”