Hands On With Microsoft Dynamics GP 2015 RTM: Installing the Microsoft Dynamics GP Add-in for Microsoft Word

Microsoft Dynamics GPNow 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:

Microsoft Dynamics GP 2015

Continue reading

System Requirements For Microsoft Dynamics GP 2015 Now Available

Microsoft Dynamics GPThe System Requirements for Microsoft Dynamics GP 2015 are now available from CustomerSource (login required).

The stand out items for me is that support has been dropped for several older versions of Windows, SQL Server and Office:

  1. Windows:
    • Windows XP all editions
    • Windows Vista all editions
    • Windows Server 2003 all editions
  2. SQL Server:
    • 2008 all editions (including R2)
  3. Office:
    • Office 2007

The only surprise on the above list is that some of the software listed as no longer supported was also listed as no longer supported with Dynamics GP 2013; in fact only SQL Server 2008 is new to the list.

Apart from the above retired software, the recommendations look pretty much the same as Dynamics GP 2013; Windows 8.1 and SQL Server 2014 have been added as supported.

Sales Analytics Dashboard Available Now From DynamicAccounting.net

In what looks to be the first in a set of analytics dahsboards, Mark Polino has released a Sales Analytics dashboard on his DynamicAccounting.net site.

The dashboard builds on the ideas covered in Mark’s recent Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 and can provide a really good shortcut to getting started using an Excel dashboard rather than rolling your own from scratch.

Continue reading

Outlook.com: Send Without Attachments?

I’ve been a bit quiet on the posting front recently because my second book is in the later stages of the publishing process and I need to review and respond to feedback from the editors at Packt Publishing.

To do this we’ve been emailing drafts of the chapters to and fro. And (again) this morning a feature of Outlook.com saved me from looking slightly silly when I replied to an email intending to send back an updated draft, but clicked Send without actually attaching the file;

Send without attachments?Send without attachments? Just checking. It looks like you’ve mentioned attachments but haven’t added any.

I was presented with the above message. Clicked Go back, added the file and sent the message.

I’ve talked to various people who dislike this type of message, but I really don’t see the problem with it. I’ve only ever been presented the message when I have meant to attach a file and forgotten; I’ve never received it for a false positive so I quite like it. I wish Outlook 2010 had it (or perhaps it does and I just don’t know where the setting is.

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino – A (short) Review

A few weeks ago Mark Polino, in conjunction with Packt Publishing published another book, the Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

I got a copy of Mark Polino’s Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 the other week with the intention of working through it following all of the examples. However, the reality is I don’t have the time to do this due to other commitments (both work and outside of work ones).

Continue reading

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Following on relatively quickly from Leslie Vail’s new Microsoft Dynamics GP book, , available from Packt Publishing, comes Mark Polino with Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013.

This book will teach you how to build a dashboard using Excel 2013 with information from Microsoft Dynamics GP 2013, how to make Excel a true business intelligence tool with charts, sparklines and slicers and show how to utilise PowerPivot’s full potential to create even more complex dashboards;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Continue reading

Consumer Preview Of New Microsoft Office Available

Microsoft Office PreviewMicrosoft have just announced the availability of the Consumer Preview of Microsoft Office which delivers Office as a cloud service using all the innovations of Windows 8.

Okay, that sounds like a press release because it is; it was quoted from Microsoft’s press release. The Consumer Preview is available here and offers lots of new functionality and integration with Windows 8.

Full details of the new features are here but there is no news on the eventual pricing. I am a little suspicious of pricing with the tie-in to the cloud and especially the Sky Drive service.

I’ve signed up and will be taking a look first thing tomorrow morning when I get to work (probably badly timed as the second thing I have tomorrow is a Microsoft Dynamics GP exam.

Extracting Images From Microsoft Word 2007/2010

Yesterday David Musgrave posted an article which outlines how you can extract images out of a Word 2007/2010 document quickly and easily by changing the extension from .docx to .zip and opening with WinZip.

Great idea, but it occurred to me that this could possibly be done with a little less work. Continue reading

Management Reporter Migration Wizard: ACE.OLEDB.12.0 Provider Is Not Registered On The Local Machine

Microsoft Dynamics GPThis particular problem is going to occur if you either do not have Microsoft Office installed or, on an x64 OS, you have installed the x86 version of Microsoft Office when you try to install the Management Reporter Migration Wizard (in particular Microsoft Access);

Management Reporter Migration Wizard: ACE.OLEDB.12.0 Provider Is Not Registered On The Local Machine

Continue reading

Microsoft Office 365 Launched

Microsoft Office 365Earlier today Microsoft launched their Microsoft Office 365 productivity suite which combines Office, SharePoint, Exchange and Lync in a cloud based version of their earthbound variant.

The service, which replaces Microsoft Business Productivity Online Suite, was launched today by Microsoft CEO Steve Ballmer in a live webcast with over 20 partners already signed up to resell the service alongside their own services.

Kurt DelBene, president, Microsoft Office Division said, “Our partners represent some of the best-known, most-trusted brands in their local markets. Our customers will be able to rest easy knowing their cloud services are backed by Microsoft and some of the greatest service providers in the world.”

Microsoft Dynamics GP and Office 365 work together now! Microsoft Dynamics GP leverages Office 365’s functionality, such as reporting and Excel-based analysis, presence and instant messaging, transaction initiation through Lync, and many of the other features of Office that you have come to enjoy when deployed on-premises, but now available through the Cloud with Microsoft Office 365.

With Microsoft Dynamics GP, you build a foundation for the future that goes beyond standalone applications to extend their traditional ERP systems throughout their organization and into the cloud.