Management Reporter – An Unknown Error Has Occurred

Microsoft Dynamics GPAfter dealing with an obscure and unhelpful Integration Manager error recently, I’ve also had a Management Reporter one; when trying to generate a report the following error was consistently produced;

An unknown error has occurred while processing reportAn unknown error has occurred while processing report

Continue reading “Management Reporter – An Unknown Error Has Occurred”

Microsoft Dynamics GP 2013 SP2 Announced for Q4

Microsoft Dynamics GPA few days ago, Errol Schoenfish on the Inside Microsoft Dynamics GP blog announced the forthcoming Microsoft Dynamics GP 2013 SP2 (or H2 as he named it) for Q4 of the 2013 calendar year.

The part of the announcement which surprised me was the announcement that there would be a “Feature of the Day” starting in September; I thought that, usually, “Feature of the Day” only occurred for major releases and not service packs. Let me say though: this is not a complaint!

In SP2 the Web Client will see the see releases for the Project, Manufacturing and Field Service series as well as the expansion of ISV Extensibility to allow Visual Studio forms to be presented in the Web Client in the same way as Dexterity forms.

Document Attach will be extended to allow attachments to be included in emails and to allow documents attached to cards to be rolled down to the transactions. So a terms and conditions file attached to a customer record could be rolled down to the sales invoices and attached to the email.

One really nice feature is the ability in SmartList to hide the navigation tree; here’s hoping this is a button on the toolbar to quickly expand and shrink the nav pane.

There are additional features so far announced in the blog post including an update to the Windows 8 Business Analyzer app to rewrite it in HTML5 and JavaScriptto allow, amongst other new features, the inclusion of reports from Management Reporter.

For full details of the announcment check the original blog post.

Integration Manager Error – Object Reference Not Set To An Instance Of An Object

Microsoft Dynamics GPSometimes I find Integration Manager to be very trying. It can be a very useful tool but it can also be incredibly frustrating.

A client we have taken over support for logged a call about an integration they couldn’t run and hadn’t been able to run for a couple of months after their upgrade to Microsoft Dynamics GP 2010. The error message they were receiving was this;

Integration Manager - Object reference not set to an instance of an objectIntegration Manager – Object reference not set to an instance of an object

Continue reading “Integration Manager Error – Object Reference Not Set To An Instance Of An Object”

You Cannot Print An Unauthorized Purchase Order

Microsoft Dynamics GPAs the title says, “you cannot print an unauthorized purchase order”. This is an error message which I encountered the other day on my demo system when I was trying to print a PO. Now, I’m largely not surprised to see errors occur on that VM and regularly either build a new one or, more often, redeploy the Fabrikam, Inc. sample company, but in this case I was a little surprised to see this message;

You cannot print an unauthorized purchase orderYou cannot print an unauthorized purchase order

Continue reading “You Cannot Print An Unauthorized Purchase Order”

Area Page Error – Value Cannot be Null

Microsoft Dynamics GPA client who upgraded to Microsoft Dynamics GP 2013 a few weeks ago began encountering a problem when switching between modules. In particular when they loaded the Purchasing area page they received the following message;

Value cannot be null. Parameter  name: contentValueValue cannot be null. Parameter name: contentValue

Fortunately, there are two solutions to this problem outlined in the Microsoft Support KB Article 2843273. The first is to upgrade to Microsoft Dynamics GP 2013 which at very short notice isn’t really an option, or to use the script in the KB article to both remove the corrupt entry in SY07140 and add a trigger to the table to prevent another corrupt entry being created.

As we needed the client up and running without the error quickly, we opted for the second approach and will look to schedule in the upgrade from 2013 RTM to SP1.

Microsoft Dynamics CRM 2011 Cookbook Released

Microsoft Dynamics CRMThis is not a book I have written, but rather one that, like the Microsoft Dynamics CRM 2011 Applications (MB2-868) Certification Guide, I have done some technical reviewing on behalf of the publisher, Packt Publishing. This is basically assisting the publisher to verify that the content of the book is technically accurate and can be successfully followed. Well, while I was working on the Microsoft Dynamics GP 2013 Cookbook I was also doing technical reviewing of the Microsoft Dynamics CRM 2011 Cookbook by Dipankar Bhattacharya;

Microsoft Dynamics CRM 2011 Cookbook

Continue reading “Microsoft Dynamics CRM 2011 Cookbook Released”

Customisation Import – Component Write Exception

Microsoft Dynamics GPWhile importing a customised Form with VBA I encountered a problem and received a Component write exception;

Component Write ExceptionComponent Write Exception

The form itself had imported but the VBA element had not.

Not having seen this error before I hit up Bing and soon found a blog post from Dex Master David Musgrave where he discusses this exact issue on GP9 (I was loading a customisation from GP9 to GP 2010 to upgrade).

The answer was not quite what I wanted. I was hoping for something nice and simple, but instead I needed to export all the customisations, delete the forms.dic, reports.dic and dynamics.vba files and then reimport all of the customisations.

After I did this the import worked fine.

Error Granting Database Access In SQL Server Management Studio

Microsoft SQL ServerI’m currently involved with a couple of projects where we have needed to migrate databases from one SQL Server to another and needed to do so more than once.

Prior to the first copy, we used a script to load the users into SQL Server and then restored the databases and had no problems.

Later on, after changing some of the permissions to databases we had need to remigrate some of them over. However, we found that users could not access some databases and when we tried to add them we got the following error;

Msg 15023, Level 16, State 1, Line 1
User, group, or role 'pidev' already exists in the current database.

It was looking very like we would need to go through each database and remove access and then regrant it all; a labourious process. A quick Google found me a page from Julian Kuiters which introduced me to the ALTER USER command. The following code will run against the selected database and tie together the SQL Server user with the user in the database without any other work;

USE [GPNL]
GO

ALTER USER pidev WITH LOGIN = pidev
GO

The first highlighted element needs to be changed to the database you want to update the user on and then the following two entries are the usernames which need to be linked (these should be set to the same value).

Update: if your usernames contain a space (e.g. I Grieve) then wrap them in square brackets: e.g.

Offline Install Of dotNET 3.5 On Windows 8

Windows ServerIn the last post I took a look at how to install the .NET Framework 3.5 while the server is not connected to the Internet. At the same time I installed the server I was also installing a Windows 8 client as well and needed to install the .NET Framework 3.5 on it as well. Being client software I expected the process to work, if not better than, then the same as the one on Windows Server 2012.

Continue reading “Offline Install Of dotNET 3.5 On Windows 8”

Offline Install Of dotNET 3.5 On Windows Server 2012

Windows ServerI recently encountered a problem trying to install the .NET Framework 3.5 in a virtual machine on my test server which is not connected to the Internet (I wish it was but I am currently renting and don’t have a broadband connection). I am used to dealing with Windows Server 2008 R2 where the install just happens, but in Windows Server 2012 the Add roles and features wants to download the install files from the Internet.

In this post I’m going to do a step by step guide to installing the .NET Framework 3.5 on Server 2012 when there is no Internet connection available; many to serve as a reminder to me next time I try to do this.

The first step is to open Server Manager and click on Add roles and features;

Server Manager

Continue reading “Offline Install Of dotNET 3.5 On Windows Server 2012”