A few weeks ago, Steve Endow retweeted about formatting a number in Microsoft Excel into a Microsoft Dynamics GP account number (I can’t find the tweet now, unfortunately). I had a fiddle around with this and it works fine for display, but the underlying data is still a number; it is just the display which has been changed to a formatted number.
However, with only a couple further steps, the account number can be correctly reformatted. I’m going to step through this one from the start; the basic premise is that we have some account strings which are not formatted; e.g. they do not have the segment separators or leading zeros:
Continue reading “Reformat Number into Dynamics GP Account Number”
Earlier this month I did a post on command line paramaters 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.
I’ve been using Outlook.com for email for a few years now and have had very few errors, but the other day, I encountered a problem whereby I was unable to send any emails:
Couldn't send the following message
Continue reading “Outlook.com Error Sending Emails”
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.
If you ever have problems activating Microsoft Office 2013 you might need to change the licence key, but this cannot be done through the front end.
Instead, there is a command you can run at the command line to change the key:
cscript "C:\Program Files (x86)\Microsoft Office\Office15\OSPP.VBS" /inpkey:officekey
Replace the highlighted section above to the new key you want to put in place; once done you can then log into Office and activate the software online.
Microsoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.
However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.
When using the Word Templates to replace the standard reports for printing reports such as invoices, remittances or purchase orders you can do changes to the format or layout using the standard functionality of Microsoft Word.
However, if you want to add additional fields then you need to install the Microsoft Dynamics GP Add-in for Microsoft Word. Do this by launching the Microsoft Dynamics GP setup utility from the downloaded installation media and, under Additional Products, click on Microsoft Dynamics GP Add-in for Microsoft Word:
Continue reading “Hands On With Microsoft Dynamics GP 2015 R2: Install GP Add-in For Microsoft Word”
Now that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.
One of the very useful additions in Microsoft Dynamics GP 2010 was the ability to create invoice, remittance and other types of documents in a Word Template rather than having to do it all in Report Writer (although Report Writer is still needed if you want to create a custom field or make other fields available to the Word Template). While much of the editing and changing of formatting can be done using Word as is, if you want to add any new fields then the Microsoft Dynamics GP Add-in for Microsoft Word is required on any machine which will be used for doing this.
To install the Microsoft Dynamics GP Add-in for Microsoft Word open the setup.exe from the Microsoft Dynamics GP 2015 installation media and, under Additional Products, select Microsoft Dynamics GP Add-in for Microsoft Word:
Continue reading “Hands On With Microsoft Dynamics GP 2015 RTM: Installing the Microsoft Dynamics GP Add-in for Microsoft Word”