Tag Archives: PSTL

How To Recreate SQL Objects Using PSTL

As well as rebuilding a corrupt GL00105, the Toolkit within the Professional Services Tools Library (PSTL) can be used to recreate SQL objects such as SQL Indexes or the Dex stored procedures.

Continue reading

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , | 3 Comments

Error Starting Microsoft Dynamics GP After Installing PSTL

I’m taking a slight detour away from posting the series of how to’s on the Professional Services Tools Library to highlight an installation error that I’ve recently seen when installing PSTL.

A client recently installed PSTL and reported receiving the below error message;

Microsoft Dynamics GP - A Get/Change Operation on Table 'gpAppEnabled' cannot find the table

I’d sent them the PSTL download along with the instructions on how to install it without realising that there was a missing part to me instructions (which has now been added).

When installing PSTL into a company for the first time, you must log into Microsoft Dynamics GP as the sa user as there are some tables which get created (covered in KB Article 861564 which is actually a retired article but does mention the issue and the resolution).

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , , | 1 Comment

How To Rebuild GL00105 Using PSTL

A while ago I posted a script that could be used to fix a corrupt Account Index Master (GL00105). However, the Toolkit within the Professional Services Tools Library (PSTL) can be used to do the same thing without resorting to a custom script.

Continue reading

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , | 2 Comments

How To Copy Shortcuts Using PSTL

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.

Continue reading

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , , | 2 Comments

How To Disable A Database Using PSTL

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 (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

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , , | 2 Comments

How To Install Professional Services Tools Library

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

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , | 5 Comments

PSTL Registration Error

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'.

Continue reading

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , | 2 Comments