You Cannot Print An Unauthorized Purchase Order

Ian Grieve1 minute read2 Comments

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”

PrintFriendlyLinkedin

Area Page Error – Value Cannot be Null

Ian Grieve2 minute read2 Comments

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.

PrintFriendlyLinkedin

Microsoft Dynamics CRM 2011 Cookbook Released

Ian Grieve1 minute read1 Comment

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”

PrintFriendlyLinkedin

Customisation Import – Component Write Exception

Ian Grieve2 minute read1 Comment

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.

PrintFriendlyLinkedin

Error Granting Database Access In SQL Server Management Studio

Ian Grieve3 minute read5 Comments

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.

PrintFriendlyLinkedin

Offline Install Of dotNET 3.5 On Windows 8

Ian Grieve1 minute read1 Comment

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”

PrintFriendlyLinkedin

Offline Install Of dotNET 3.5 On Windows Server 2012

Ian Grieve2 minute read3 Comments

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”

PrintFriendlyLinkedin

Management Reporter 2012 Install Error – Invalid sa Password

Ian Grieve4 minute read0 comment

Microsoft Dynamics GPI was recently on site with a client doing an upgrade from Microsoft Dynamics GP 2010 to 2013 and implementing Management Reporter 2012 to replace FRx 6.7.

The upgrade of Dynamics GP to 2013 went through without issue, once I sorted out the overlapping periods which are no longer allowed (I hope Microsoft will be updating the exam question), but I ran into an issue with Management Reporter.

When I was entering the details for the SQL Server I got an error that the password provided was incorrect. I reentered it and got the same error and then entered it a third time very slowly and carefully. Again, it was rejected.

Now because I was onsite and therefore using a customer supplied password there was every possibility that I had entered it incorrectly. I verified the password with the customer and then copied and pasted it in from Notepad so that I was certain it was correct, but it was, again, rejected.

It was at this point a memory fired that someone had recently told me about this. I checked emails I’d received a few weeks ago and found the answer in one from Andrew Cooper, my former colleague. The problem is when Enforce password policy in Microsoft SQL Server is enabled for the user account.

This should not be a problem, but with Management Reporter 2012 RU4 it is because the password is verified against SQL Server as each letter is typed in order to populate the database selection box and if the password policy is being enforced then the user account gets locked out after the third letter. I haven’t had a change/remembered to test this against RU5.

After unlocking the user account via SQL Server Management Studio, I copied and pasted the password into the Management Reporter Configuration window and was able to progress with the installation.

PrintFriendlyLinkedin

Can’t Connect To The Management Reporter Server

Ian Grieve2 minute read0 comment

Microsoft Dynamics GPWe had a call logged by a new customer recently who has just had Managagement Reporter implemented. One of the IT team was trying to get into Report Designer and continually got the message below;

Management Reporter - CanManagement Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?

I’ve seen this error before and it has been one of two things:

  1. The Management Reporter 20123 Application Service isn’t running
  2. The logged in Windows user has not been given access to Management Reporter

In this instance the problem was the latter. The IT team member’s own domain account was configured as a Management Reporter Administrator, but he was logged onto the server as Domain\Administrator which was not a Management Reporter user. After logging out and back in under his own domain account he was able to access Management Reporter successfully.

PrintFriendlyLinkedin

Management Reporter 2012 Process Service Not Running

Ian Grieve1 minute read4 Comments

Microsoft Dynamics GPI was out on site a short time ago implementing Management Reporter 2012 for a client and ran into a problem with Management Reporter. I could log into Management Reporter, create reports and everything was fine; but I could not generate a report.

When I was investigating the problem I opened the Configuration Console and found that the Management Reporter 2012 Process Service was not running;

Management Reporter 2012 Configuration Console

Continue reading “Management Reporter 2012 Process Service Not Running”

PrintFriendlyLinkedin