After installing the Professional Services Tools Library earlier this week, I’m doing a series of posts on the different functions available, for free, within.
This post covers the Copy Shortcuts options. This function allows shortcuts to be copied from on user to another.
Now 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 () 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.
As 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”
Earlier 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'.](https://static.azurecurve.co.uk/images/posts/2012/04/PSTL_Registration_Error/PSTL_Registration_Error_1.png "Microsoft Dynamics GP - Unhandled script exception: [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'PI.dbo.smChangeAccountIndex2'.")
The 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.
At 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;
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”
I 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;
Last 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”
I’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.
On 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”