How To Disable A Database Using PSTL

Microsoft Dynamics GPNow that the Professional Service Tools Library (PSTL) has been installed it’s time to take a look at some of the functionality available.

The first one I’ll look at is how to disable a database so users cannot log in. Without using PSTL, to deactivate a database requires you to use the User Access window (Microsoft Dynamics GP menu » Tools » Setup » Administration » User Access) and select each user in turn and uncheck the company to be disabled. If you have more than a handful of users, this can take a long time to do but with PSTL all users can be disabled very quickly.

Continue reading “How To Disable A Database Using PSTL”

How To Install Professional Services Tools Library

Microsoft Dynamics GPAs I mentioned in the last post, Microsoft Dynamics GP Support Blog announced that the Professional Services Tools Library had been made free of charge and can be downloaded from here (PartnerSoruce login required; Customers will need to contact their partner). The free PSTL is only available for supported versions of Microsoft Dynamics GP so if you are not using 10 or 2010 you will need to upgrade.

I thought it might be useful to do a short series of posts highlighting some of the PSTL tools and what you can do with them, so to start with I thought a post on how to install the module.

Continue reading “How To Install Professional Services Tools Library”

PSTL Registration Error

Microsoft Dynamics GPEarlier this month the Microsoft Dynamics GP Support Blog announced that the Professional Services Tools Library had been made free of charge and can be downloaded from here (PartnerSoruce login required; Customers will need to contact their partner).

It’s a while since I did much with PSTL so I decided to download it and take a look. I got it installed correctly but when I tried to open it I got this error;

Microsoft Dynamics GP - Unhandled script exception: [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'PI.dbo.smChangeAccountIndex2'.

Continue reading “PSTL Registration Error”

Editing Standard SmartLists with SmartList Builder

Microsoft Dynamics GPThe Google-fu is weak with this one (this one being me). I read a post ages ago on the subject of SmartList wildcards which looked like it would be really useful, but then, after I’d forgotton the details, couldn’t find it again no matter what searches I tried.

On the Developing for Dynamics GP blog David Musgrave gives a reminder for those using SmartList Builder that there is in fact a way to modify standard SmartLists by downloading them from here (Customer Source login required) without having to manually recreate them.

When you download them, remember to think kind thoughts of the Microsoft Dynamics GP Support Team who created these SmartLists.

How To Install A Domain Controller In Windows 8 Server Consumer Preview

Windows ServerAt the start of this year I did a post on how to install a domain controller in Windows Server 2008 R2 (and I think the method would work back to 2003 as well). However, with the release, albeit of the Consumer Preview, of Windows 8 Server (Windows Server 2013 on release?) that post is out of date.

I say it is out of date because when I tried to run it I got the following message;

Active Directory Domain Services Installer - The Active Directory Domain Services Installation Wizard is relocated in Service Manager. For more information, see http://go.microsoft.com/fwlink/?LinkId=220921

So for those of you who, like myself, are preparing a test environment using Windows 8 Server Consumer Preview, SQL Server 2012, Management Reporter 2012 for Microsoft Dynamics GP 2013 (when it arrives) here is a walk through of creating a domain controller on Windows 8 Server Consumer Preview. Please note this is not a guide that should be used on a production environment; it is solely intended for creating a demo or test environment; I am a Microsoft Dynamics GP specialist, not a Windows Active Directory one.

Continue reading “How To Install A Domain Controller In Windows 8 Server Consumer Preview”

SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped

Microsoft SQL ServerI was doing some work with a custom table yesterday and at one point needed to make a change to the table layout via SQL Server Management Studio. However, when I tried, I got the below error message;

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can

Continue reading “SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped”

How To Install Management Reporter 2012 – Client Installation

Microsoft Dynamics GPLast week I posted the start of a series of posts on how to install Management Reporter 2012; how to install Management Reporter 2012 — Server Prerequisites, how to install Management Reporter 2012 – Server Installation and how to configure Management Reporter 2012.

Todays post is the final post in the series on how to install Management Reporter and covers the client installation.

The client installer is part of the same installation package as the server installation (download available here (PartnerSource or CustomerSource login required).

Continue reading “How To Install Management Reporter 2012 – Client Installation”

Microsoft Dynamics CRM 2011 MB2-866 Customization & Configuration Gained

Microsoft Dynamics CRMI’ve just returned from the test centre with my MB2-866 Microsoft Dynamics CRM 2011 Customization & Configuration certification giving me three certs for Dynamics CRM, three for Dynamics GP and the Managing Dynamics Implementations (SureStep) cert.

I had memory problems on Thursday when I left work for the weekend (I forgot to take the USB pen drive containing my blog home with me) so couldn’t get the Management Reporter client installation blog post completed and uploaded; I’ll do that at lunchtime today.

How To Configure Management Reporter 2012

Microsoft Dynamics GPOn Monday the new version of Management Reporter was released, on Tuesday I posted the first in a series of posts on how to install Management Reporter 2012 server prerequisites and yesterday I posted the second part of the series on how to install the server software. Today I’ll cover the configuration of Management Reporter 2012.

To quickly recap, the server configuration I am using is four separate servers, all running Windows Server 2008 R2, but could easily be installed on one machine, or virtual machine, for use as a test system;
Domain Controller (DC1) running the ideal domain (a slight departure from my usual azurecurve) on
SQL Server (SQL1)
Reporting Server (RPT1)
Terminal Server (TS1)

The configuration is done using the Configuration Console which is installed as part of the server installation, so in my case it is on the Reporting Server (RPT1).

Continue reading “How To Configure Management Reporter 2012”

How To Install Management Reporter 2012 – Server Installation

Microsoft Dynamics GPYesterday, I posted the first in a series of posts on how to install Management Reporter 2012; how to install Management Reporter 2012 — Server Prerequisites. Today I’ll cover the server side of the installation.

The first step is to download the installation package; Microsoft Dynamics Management Reporter 2012 (PartnerSource or CustomerSource login required).

One thing to note about the installation of Management Reporter 2012 is that it has been much simplified over that of Management Reporter 2; some parts have been removed (no separate provider to install) and some has been moved to the new Configuration Console.

Continue reading “How To Install Management Reporter 2012 – Server Installation”