Integration Manager Error – MSScriptControl

Microsoft Dynamics GPI’ve spent a fair bit of time recently importing data into Microsoft Dynamics GP using Integration Manager with which I have encounterd a few different error messages (ADO Field Is Nothing, All GP Windows Must Be Closed and Source Document Doesn’t Exist).

The latest error I’ve encountered related to the MSScriptControl;

Integration Manager - MSScriptControl Error

Continue reading “Integration Manager Error – MSScriptControl”

Problem With SOP Word Templates

Microsoft Dynamics GPI’ve recently been working on a Microsoft Dynamics GP 2010 implementation project for a client.

We created custom Word templates (Reports » Template Maintenance) for POP Purchase Order Blank Form, SOP Blank Quote Form, SOP Blank Order Form and SOP Blank Invoice Form without problems and granted access to the relevant companies.

To test the new Word templates we printed the documents to screen so we could quickly see the result. The POP Purchase Order Blank Form worked fine but when it came to the SOP documents we had a problem. When printing any of the SOP documents as Word Templates, instead GP printed the Standard Report Writer reports. Continue reading “Problem With SOP Word Templates”

Word Template Generator, Where Art Thou?

Microsoft Dynamics GPI’m currently doing some work for a client where we’re modifying some of the reports in Microsoft Dynamics GP and I’m trying to avoid using Report Writer as a) I don’t like it, b) Word template reports look better and c) I don’t want to spend time training a client on a module which can be avoiding and is being retired in the near future.

For some of the reports such as the Sales Orders and Invoices and the Purchase Order reports, there are Word templates already available for customising, but for some of the reports such as the Sales Picking Ticket or Dispatch Notes there are no Word templates available by default.

In Microsoft Dynamics GP 2010 this meant starting a template from scratch. In Microsoft Dynamics GP 2010 R2 you can use the Word Template Generator to convert a saved xml report into a Word template.

The only problem is, I can’t find it. None of the blog posts I read announcing the feature said where it would be; just that it would be available with 2010 R2. My first port of call was within GP itself. The I tried the installation media but no luck. I then tried a couple of Internet searches and came up dry. I asked a colleague but they hadn’t used it before.

I finally searched on PartnerSource (I don’t like the PartnerSource search so usually try general Internet searches first) and finally found the download link for the Word template Generator.

Missing Font Causes Crash In Management Reporter

Microsoft Dynamics GPI’ve recently been doing some work for a client where we’ve upgraded them from Microsoft Dynamics GP 10 to 2010 R2. Alongside this, we also migrated them from FRx to Management Reporter.

All looked fine after the upgrade until I opened one of the rows for editing and got the following warning message;

Management Reporter - Font 'Gill Sans' cannot be found.

Continue reading “Missing Font Causes Crash In Management Reporter”

Changing Open-Year In Financial Statement Reports

Microsoft Dynamics GPIf you’re using the Financial Statements (Reports » Financial » Financial Statements) in Microsoft Dynamics GP you may see a messagesililar to the following after doing a year end;

Cash Flows Screen Output: The year you

Continue reading “Changing Open-Year In Financial Statement Reports”

Integration Manager Error – You Must Close All Microsoft Dynamics GP Windows

Microsoft Dynamics GPI am in the process of implementing Microsoft Dynamics GP for a new client and am currently testing the static data integrations (chart of accounts, suppliers, customers, stock and so on) using Integration Manager.

I’d successfully run an integration of the chart of accounts which threw out a couple of warnings. After amending the file I realised that GP was no longer showing in the task bar and assumed that I had accidentally closed it. I restarted it and logged into the test company and tried to run the COA integration again and got the following error message;

Integration Manager - You must close all Microsoft Dynamics GP windows in order to run an integration.

Continue reading “Integration Manager Error – You Must Close All Microsoft Dynamics GP Windows”

Menus For Visual Studio Tools For Microsoft Dynamics GP 2010

Microsoft Dynamics GPAs I mentioned in a previous post, I’ve been taking a look at the Visual Studio Tools for Microsoft Dynamics GP. I started creating a form to store some additional details against a Creditor but wanted the form available in a similar way to the Creditor Addresses; available from both the Creditor form and from the Cards menu.

Getting the form to display a menu option on the Additional tab of the Creditor window was easy enough but I had trouble finding out how to make it display on the Cards menu.

After struggling with it for a while, I remembered reading a discussion between Mariano Gomez and David Musgrave about long module names and how Visual Studio Tools for Microsoft Dynamics GP 2010 wasn’t the longest but instead Menus for Visual Studio Tools for Microsoft Dynamics GP 2010 was the longest.

A quick search found the module, in the very obvious location, of David Musgrave’s Developing for Dynamics GP blog; Menus for Visual Studio Tools Build 9 Released which can be downloaded from either PartnerSource (login required) or CustomerSource (login required).

The module comes with full instructions on how to install and use it.

Extracting Images From Microsoft Word 2007/2010

Microsoft OfficeYesterday 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 “Extracting Images From Microsoft Word 2007/2010”